SQL Basics

1. Select
2. Select Distinct
3. Select Top
4. Where
5. Order By
6. Like
7. And, Or, Not
8. Operators
9. In
10. Between
11. Exists
12. Is Null
13. Wildcards
14. Case
15. Comments

Tables

1. Create Table
2. Alter Table
3. Drop Table
4. Data Types
5. Insert Into
6. Update
7. Delete
8. Select Into
9. Insert Into Select
10. Transactions

Constraints

1. Primary Key
2. Unique
3. Not Null
4. Auto Increment
5. Default
6. Check
7. Foreign Key
8. Create Index
9. B-Tree Index
10. Hash Index

Databases

1. Create Database
2. Drop Database
3. Backup Database
4. Database Schema

Aggregate Functions

1. Count, Avg, Sum
2. Min and Max
3. Group By
4. Having
5. Aliases

Joins

1. Inner Join
2. Left Join
3. Right Join
4. Full Outer Join
5. Self Join
6. Cross Join

Operators

1. Union
2. Except
3. Intersect

Additional Functions

1. Null Functions
2. Date Functions
3. String Functions
4. Partition By
5. Rank Functions
6. Window Functions

Storing Data

1. Subqueries
2. Views
3. Stored Procedures
4. Triggers
5. Temp Tables
6. Common Table Expressions

Resources