Basics of SQL
  • Introduction to SQL
  • Demonstartion of Live SQL (Cloud Platfrom to exceute SQL Commands)
  • Performing Basic Operations with SQL
  • Introduction to SQL
Creation of Tables with Constraints
  • Need of Constraints
  • Not Null, Unique and Primary Key Constraint
  • CHECK constraint
  • FOREIGN KEY Constraint
  • Demonstration of Foreign Key constraint
  • DEFAULT Constraint and Accessing Constraint information
  • Creation of Table with constraints
Table Alteration
  • Alter Table Add Option
  • Alter Table: Modify and Drop Option
Joining of Tables
  • Joining of tables and Its Types
  • OUTER JOIN
  • SELF JOIN
  • Table Alteration and SQL joins
Grouping of Data
  • GROUP BY Clause
  • GROUPING on more than one column
  • HAVING Clause
  • Inbuilt Functions of SQL
  • Grouping of Data