Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Skillshare SQL for ABSOLUTE BEGINNERS

Video Introducing this tutorial

1. INTRODUCTION
2. Install SQL Server
3. Databases and Tables
4. A Basic Query
5. WHERE Clause
6. Schemas and Aliases
7. NOT Operator - its NOT bad!
8. Other Text Operators
9. NULL - it's important!
10. Prime Keys
11. Column Types
12. Text Operations
13. Working With Nulls
14. Working with Numbers, and Assignment 1
15. Data Type Conversion
16. More Text Operations
17. Joining Tables
18. Reasons for Left Joins
19. Cross Joins - Just don't do it !
20. CAST conversion, and Assignment 2
21. Making a CASE for smart queries
22. DATES, and Assignment 3
23. Recordsets - They Help a lot
24. The UNIONS make us strong!
25. Grouping, and Assignment 4
26. ROLLUP, ROLLUP! Automatic Totals
27. Sub Queries - "Sort Of" Joins !