Course Content
Introduction
- Introduction of SQL
- What is RDBMS?
Data Defination Commands
- 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
Advanced Data Defination Commands(SQL ALTER Statement)
- Adding a column
- Dropping a column
- Modifying acolumn
- Add Constraints Using ALTER Statement
- Drop Constraints Using ALTER Statement
Data Manipulation Commands
- 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
