Language Basics

Lesson 1. Obligatory Hello World

Lesson 2. Code Comments With T-SQL

Lesson 3. Basic Syntax

Lesson 4. Your First Query

Lesson 5. Filtering Data

Lesson 6. Sorting Data

Lesson 7. Complex Data Filtering

Lesson 8. Aliases

Lesson 9. String Functions

Lesson 10. Creating New Columns From Existing Data (Calculated Fields)

Lesson 11. Displaying Data Based On Conditions (Case Statement)

Lesson 12. Aggregate Functions

Lesson 13. Grouping And Summarizing Data

Lesson 14. Querying More Than One Table

Lesson 15. Combining Queries

Lesson 16. Subqueries

Lesson 17. Creating Data

Lesson 18. Updating Data

Lesson 19. Deleting Data

Lesson 20. Common Table Expressions (CTEs)

Lesson 21. Derived Tables

Lesson 22. Putting It All Together