COMPLETE SQL NOTEBOOK

LEVEL 01

What is Database?
Types of Databases
What is SQL?
SQL Database Structure
What is Table?
Creating 1st Database and Table
SQL Data Types
Types of SQL Commands
Database Related SQL Query
Table Related SQL Query
Practice Question 1
Primary and Foreign Keys
Constraints in SQL
Select Command in Detail
Where Clause with Conditions and Operators
Limit Clause
Order By Clause (Ascending and Descending)
Aggregate Functions
Group By Clause
Practice Question 2
Practice Question 3
Having Clause
General Order Sequence to Write the Query

LEVEL 02

Table Related SQL Query (Update and Delete)
Cascading
Table Related SQL Query (Alter and Truncate)
Practice Question 1

LEVEL 03

Joins in SQL
Inner Join
Outer Join

Left Outer Join
Right Outer Join
Union/Full Outer Join

Exclusive Join

Left Exclusive Join
Right Exclusive Join
Union/Full Exclusive Join

Self Join
Union and Union All Clause
SQL Subquery
MySQL Views