SQL

• Introduction of SQL
• What is RDBMS?

• SQL Create Database Statement
• SQL Drop Database Statement
• SQL Create Table Statement
• SQLDescStatement
• SQL Drop Table Statement
• SQL Show Table Statement

SQL Constraints

• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• NOT NULL Constraint
• UNIQUE Constraint
• CHECK Constraint
• DEFAULT Constraint

• Adding a column
• Dropping a column
• Modifying acolumn
• Add Constraints Using ALTER Statement
• Drop Constraints Using ALTER Statement

• Adding Table Rows
• Listing Table Rows
• Updating Table Rows
• Deleting Table Row
• SQL WHERE Clause
• SQL IN Operator
• SQLBETWEEN Operator
• SQL LIKE Operator
• SQL WILDCARD Operators
• SQL Aliases

SQL Logical Operators

• SQL AND Operator
• SQL OR Operator
• SQL NOT Operator

SQL Distinct
SQL Order By Clause
SQL Aggregate Functions
SQL Group By Statement
SQL Having Clause
SQL Top/Limit& Null Values
SQL Joins

• SQL Inner Join
• SQL Left Join
• SQL Right Join
• SQL Full Join
• SQL Cross Join
• SQL Natural Join
• SQL Join by USING Clause
• SQL Group By with Join