SQL Training

• 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

SQL Set Operator

• SQL UNION
• SQL UNION ALL
• SQL INTERSECT
• SQL MINUS

SQL Create View

SQL Drop View

SQL Create Sequences

SQL Drop Sequences

SQL Cloning Tables

SQL Subqueries

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

SQL EXISTS Operator

SQL Functions

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