Language Basics
Lesson 1. Obligatory Hello WorldLesson 2. Code Comments With T-SQLLesson 3. Basic SyntaxLesson 4. Your First QueryLesson 5. Filtering DataLesson 6. Sorting DataLesson 7. Complex Data FilteringLesson 8. AliasesLesson 9. String FunctionsLesson 10. Creating New Columns From Existing Data (Calculated Fields)Lesson 11. Displaying Data Based On Conditions (Case Statement)Lesson 12. Aggregate FunctionsLesson 13. Grouping And Summarizing DataLesson 14. Querying More Than One TableLesson 15. Combining QueriesLesson 16. SubqueriesLesson 17. Creating DataLesson 18. Updating DataLesson 19. Deleting DataLesson 20. Common Table Expressions (CTEs)Lesson 21. Derived TablesLesson 22. Putting It All Together
Last updated