FORGOT YOUR DETAILS?

MySQL

MySQL Training in Delhi NcrIndexing & Engine

RGC MySQL Training Module:-

 

Phase-I

1Week

  • Manipulate a MySQL Database / Constraints in Database
  • Basics of Relational Databases
  • Access a MySQL database with PHP code
  • Feature and benefits of Mysql
  • Adding records
  • Data types and Mysql Database structure
  • Create a Table using SQL
  • Connecting to and Disconnecting from the Server
  • Updating & Deleting the records

Phase-II

2Weeks

  • Retrieve, insert, update and delete the records
  • Setting up the Database
  • Using WHERE to limit the data returned
  • Connecting to and disconnecting from the server
  • Primary Keys
  • Table creation,drop and delete
  • Not NULL Constraint
  • Altering existing Table structure
  • Unique Constraint
  • Referential Integrity Constraint

Phase-III

2Weeks

  • Constraint Check
  • Indexing & Engine
  • MySQL Substring
  • What is index?
  • SQL Concatenate Functions
  • Creating a MySQL Index – Existing Table
  • MySQL replace function and LAST_INSERT_ID
  • Merits and demerits of indexing on a table
  • View about aggregate functions

Phase-IV

2Weeks

  • MySQL Index – Speed and Extra Overhead
  • What is Join ?
  • Overview of MySQL Storage Engine Architecture
  • Using Joins at Command Prompt and in PHP script
  • About Memory storage engine,CSV storage engine, Archive storage engine,Federated storage engine
  • Right Join and Left Join
  • How can we change a table engine?
  • Inner Join and Full join
  • ALTER Command to add and drop PRIMARY KEY

 

TOP