Load Sample Database

SQL Server Data Types

Constraints (Part 1)

Constraints (Part 2)

CREATE, ALTER, DROP (Part1)

CREATE, ALTER, DROP (Part 2)

SQL Server Indexes

Querying Data

Sorting Data

Limiting Rows - Part 1

Limiting Rows -Part 2

Filtering Data (Part 1)

Filtering Data (Part 2)

Joining Tables

Grouping Data

Subquery (Part 1)

Subquery (Part 2)

Set Operators

Common Table Expression (CTE)

Pivot

Modifying Data Insert - Part1

Modifying Data Insert (Part 2)

Modifying Data - Update

Modifying Data - Delete

Expressions

Useful Tips

Server Views

Stored Procedures - Functions

Triggers

Aggregate Functions

Date Functions

String Functions

System Functions

Window Functions

Adventure Works Diagrams (Part1)

Adventure Works Diagrams (Part2)

Adventure Works Purchasing (Part1)

Adventure Works Purchasing (Part 2)

Adventure Works Sales (Part 1)

Adventure Works Sales (Part 2)