Видео курса

  • Урок 1. 00:09:34
    Welcome & Tech Check
  • Урок 2. 00:15:29
    Relational Algebra & Codds Relational Model
  • Урок 3. 00:06:47
    Using the Command Line & Simple SELECT queries
  • Урок 4. 00:08:20
    Project Overview
  • Урок 5. 00:04:35
    SELECTing Columns Exercise
  • Урок 6. 00:09:03
    SELECTing Columns Solution
  • Урок 7. 00:06:37
    Filtering via WHERE clauses
  • Урок 8. 00:03:06
    Filtering via WHERE Exercise
  • Урок 9. 00:16:19
    Filtering via WHERE Solution
  • Урок 10. 00:07:09
    LIMITing and ORDERing the result set
  • Урок 11. 00:03:54
    LIMIT and ORDER Exercise
  • Урок 12. 00:13:07
    LIMIT and ORDER Solution
  • Урок 13. 00:17:28
    Relationships & Joins
  • Урок 14. 00:02:44
    JOIN Exercise
  • Урок 15. 00:18:19
    JOIN Solution
  • Урок 16. 00:18:58
    Aggregate Functions and GROUP BY
  • Урок 17. 00:01:56
    Aggregate Functions and GROUP BY Exercise
  • Урок 18. 00:20:04
    Aggregate Functions and GROUP BY Solution
  • Урок 19. 00:07:30
    Creating & Deleting Records
  • Урок 20. 00:02:21
    Creating & Deleting Records Exercise
  • Урок 21. 00:10:08
    Creating & Deleting Records Solution
  • Урок 22. 00:24:07
    Transactions & Isolation
  • Урок 23. 00:01:19
    Transactions Exercise
  • Урок 24. 00:03:26
    Transactions Solution
  • Урок 25. 00:04:44
    Updating Records
  • Урок 26. 00:00:39
    Updating Records Exercise
  • Урок 27. 00:07:03
    Updating Records Solution
  • Урок 28. 00:09:02
    Migrations
  • Урок 29. 00:05:36
    Indices
  • Урок 30. 00:01:04
    Add Indices Exercise
  • Урок 31. 00:06:54
    Add Indices Solution
  • Урок 32. 00:13:13
    Column Constraints
  • Урок 33. 00:01:05
    Column Constraints Exercise
  • Урок 34. 00:10:23
    Column Constraints Solution
  • Урок 35. 00:03:21
    Wrap Up and Q&A