Welcome to MySQL Database Course Module

In this session we will learn the following using MySQL Database

• DDL commands (Create , alter and drop )
• DML Commands (insert,update and select)
• Constraints using Alter Table commands
• Primary Key
• Check Constraint
• Unique Key Constraint
• Default Constraint
• Not Null Constraint
• Foreign Key Constraint
• Joins in MySQL (Equi join , Left Join, Right Join, Cross Join)
• Aggregate Functions , Between Operator
• Group By, Having and Order By Clause