SQL Training

1) Introduction of SQL

2) What is RDBMS?

3) Data Definition Commands

• SQL Create DatabaseStatemen
• SQL Drop DatabaseStatement
• SQL Create Table Statement
• SQLDescStatement
• SQL Drop Table Statement
• SQL Show Table Statement

3.1) SQL Constraints

• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• NOT NULL Constraint
• UNIQUE Constraint
• CHECK Constraint
• DEFAULT Constraint
• Advanced Data Definition Commands (SQL ALTER Statement)
• Adding a column
• Dropping a column
• Modifying acolumn
• Add Constraints Using ALTER Statement
• Drop Constraints Using ALTER Statement

4) Data Manipulation Commands

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

4.1) 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

4.2) 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

5) SQL Advanced

5.1) SQL Set Operator

• SQL UNION
• SQL UNION ALL
• SQL INTERSECT
• SQL MINUS
• SQL Create View
• SQL Drop View
• SQL Create Sequences
• SQL DropSequences
• SQL Cloning Tables

5.2) SQL Subqueries

• Subquery with SELECT Statement
• Subquery with INSERT Statement
• Subquery with UPDATE Statement
• Subquery with DELETE Statement

6) SQL EXISTS Operator

7) SQL Functions

• SQL String Functions
• SQL Date & Time Functions
• SQL Math Functions