Course Duration: 30 Days
Mode of Training: Online
Certificate: YES
Course Content:
OVERVIEW OF MySQL
Introduction of MySQL
MySQL Features
MySQL Advantage
MySQL Installation
MySQL Data Types
MySQL Variables
User Management
MySQL Create User
MySQL Drop User
MySQL show Users
Change User Password
Databases
MySQL Create Database
MySQL Select Database
MySQL Show Database
MySQL Drop Database
Table & Views
MySQL Create Table
MySQL Drop Table
MySQL Alter Table
MySQL Show Table
MySQL Truncate Table
MySQL Temporary Table
MySQL Copy Table
MySQL Views
MySQL Queries
MySQL Queries
MySQL Constraints
MySQL insert Query
MySQL Update Query
MySQL Delete Query
MySQL Select Query
Insert On Duplicate Key Update
MySQL Indexes
MySQL Create Index
MySQL Drop Index
MySQL show Index
MySQL Clustered Index
MySQL Clustered vs Non-Clustered Index
MySQL Clauses
MySQL Where
MySQL AND
MySQL OR
MySQL LIKE
MySQL Limit
MySQL Order By
MySQL Group By
MySQL Having
MySQL Distinct
MySQL Union
MySQL Union All
MySQL Flow Function
MySQL IF()
MySQL IFNULL()
MySQL NULLIF()
MySQL CASE
MySQL IF Statement
MySQL Joins
MySQL Join
MySQL Inner Join
MySQL Outer Join
MySQL Cross Join
MySQL Self Join
MySQL Delete Join
MySQL Union vs Join
MySQL Keys
Primary Key
Foreign Key
Unique Key
Composite Key
Aggregate Functions
MySQL count()
MySQL sum()
MySQL avg()
MySQL max()
MySQL min()
MySQL first()
MySQL last()
MySQL GROUP_CONCAT()
MySQL Mics
MySQL Comments
MySQL Transaction
MySQL Cursor
MySQL Trigger