Module 1
- Database
- Create DB
- Drop DB
- Create Table
- Drop Table
- Alter Table
- Constraints
- Not Null
- Unique
Module 2
- Intro
- Syntax
- Select
- Select Distinct
- Where
- And, Or, Not
- Order By
- Insert Into
- Null Values
- Update
- Delete
- Select Top
- Min and Max
- Count, Avg, Sum
- Like
- Wildcards
- In
- Between
- Aliases
Module 3
- Joins
- Inner Join
- Left Join
- Right Join
- Full Join
- Self Join
Module 4
- Union
- Group By
- Having
- Exists
- Insert Into Select
- Null Functions
- Comments
Module 5
- Primary Key
- Foreign Key
- Composite Key
- Alternate Key
- Candidate Key