SQL Syllabus
Part-1
- Introduction To SQL
- SQL Syntax Rules
- SQL Select Statement
- SQL Select Distinct Statement
- SQL Where Statement
- SQL And, Or, Not Keywords
Part-2
- SQL Order By Statement
- SQL Insert Into Statement
- SQL NULL Values
- SQL Update Statement
- SQL Delete Statement
- SQL Select Top Statement
Part-3
- SQL Min and Max Functions
- SQL Count(), Avg(), Sum() Functions
- SQL Like Keyword
- SQL Wild Card Characters
- SQL In Keyword
- SQL Between Operator
- SQL Aliases
Part-4
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Self Join
Part-5
- SQL Union
- SQL Group By
- SQL Having
- SQL Exists
- SQL Any, All Keywords
- SQL Case Keyword
Part-6
- SQL Select Into Statement
- SQL Insert Into Statement
- SQL Null Functions
- SQL Stored Procedures
- SQL Comments
- SQL Operators
Part-7
- SQL Create DB
- SQL Drop DB
- SQL Backup DB
- SQL Create Table
- SQL Drop Table
- SQL Alter Table
Part-8
- SQL Constraints
- SQL Not Null
- SQL Unique
- SQL Primary Key
- SQL Foreign Key
- SQL Data Types