Course curriculum

  1. 1

    • Google Subtitles Instructions

    • 1. What is SQL and where can I use it

    • 2. Installing SSMS and the AdventureWorks Database

    • 3. The SELECT Statement introduction
  2. 2

    • 4. Adding a WHERE clause to filter numeric and text fields

    • 5. Dealing with Date filters

    • 6. Sorting Data

    • 7. Grouping Data

    • 8. Combining multiple criteria

    • 9. Working with NULL empty values

    • 10. Using wildcards

    • 11. Joining tables in Select statements

    • 12. Text functions and concatenating

    • 13. Calculating Age

    • 14. Use of TOP and DISTINCT keywords
  3. 3

    • 15. Using the UPDATE statement

    • 16. Using the INSERT statement

    • 17. Careful with DELETE and TRUNCATE