Tutorials
Practical T-SQL
Practical T-SQL
Hands-On Python
Code Tutorials
More
Search
Ctrl + K
Language Basics
Previous
Section VI. Supplementary Material
Next
Lesson 1. Obligatory Hello World
Last updated
2 years ago
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