1. Урок 1. 00:06:50
    START HERE: Introduction Lecture
  2. Урок 2. 00:11:27
    How to Install Microsoft SQL Server Express
  3. Урок 3. 00:04:46
    How to Attach the AdventureWorks Sample Database
  4. Урок 4. 00:04:14
    Introduction to T-SQL and Database Concepts
  5. Урок 5. 00:06:39
    Literal SELECT Statements - Part 1
  6. Урок 6. 00:03:39
    Literal SELECT Statements - Part 2
  7. Урок 7. 00:08:43
    Basic SELECT Statements - Part 1
  8. Урок 8. 00:08:11
    Basic SELECT Statements - Part 2
  9. Урок 9. 00:06:30
    Basic SELECT Statements - Part 3
  10. Урок 10. 00:05:34
    Using the WHERE Clause - Part 1
  11. Урок 11. 00:05:12
    Using the WHERE Clause - Part 2
  12. Урок 12. 00:05:35
    Using the WHERE Clause - Part 3
  13. Урок 13. 00:08:17
    Using the WHERE Clause - Part 4
  14. Урок 14. 00:08:04
    Using the WHERE Clause - Part 5
  15. Урок 15. 00:08:30
    Using the WHERE Clause - Part 6
  16. Урок 16. 00:07:28
    Using the WHERE Clause - Part 7
  17. Урок 17. 00:07:49
    Sorting with the ORDER BY Clause - Part 1
  18. Урок 18. 00:06:24
    Sorting with the ORDER BY Clause - Part 2
  19. Урок 19. 00:08:16
    Using the INNER JOIN - Part 1
  20. Урок 20. 00:08:07
    Using the INNER JOIN - Part 2
  21. Урок 21. 00:07:54
    Using the LEFT OUTER JOIN - Part 1
  22. Урок 22. 00:10:26
    Using the LEFT OUTER JOIN - Part 2
  23. Урок 23. 00:03:35
    Using the LEFT OUTER JOIN - Part 3
  24. Урок 24. 00:07:54
    Aggregate Functions - Part 1
  25. Урок 25. 00:04:36
    Aggregate Functions - Part 2
  26. Урок 26. 00:06:46
    Grouping with the GROUP BY Clause - Part 1
  27. Урок 27. 00:08:10
    Grouping with the GROUP BY Clause - Part 2
  28. Урок 28. 00:07:17
    Filtering Groups with the HAVING Clause - Part 1
  29. Урок 29. 00:07:11
    Filtering Groups with the HAVING Clause - Part 2
  30. Урок 30. 00:03:18
    Using SQL Server Functions - Part 1
  31. Урок 31. 00:01:24
    Using SQL Server Functions - Part 2
  32. Урок 32. 00:04:14
    Using SQL Server Functions - Part 3
  33. Урок 33. 00:02:33
    Using SQL Server Functions - Part 4
  34. Урок 34. 00:01:53
    Using SQL Server Functions - Part 5
  35. Урок 35. 00:01:26
    Using SQL Server Functions - Part 6
  36. Урок 36. 00:01:23
    Using SQL Server Functions - Part 7
  37. Урок 37. 00:02:47
    Using SQL Server Functions - Part 8
  38. Урок 38. 00:02:48
    Nesting Functions - Part 1
  39. Урок 39. 00:05:08
    Nesting Functions - Part 2
  40. Урок 40. 00:01:58
    Using Date Functions - Part 1
  41. Урок 41. 00:03:43
    Using Date Functions - Part 2
  42. Урок 42. 00:04:00
    Using Date Functions - Part 3
  43. Урок 43. 00:02:54
    NULL Handling Functions - Part 1
  44. Урок 44. 00:03:17
    NULL Handling Functions - Part 2
  45. Урок 45. 00:05:55
    The Basics of SQL Server Data Types and Type Casting Functions
  46. Урок 46. 00:03:51
    Using Derived Tables - Part 1
  47. Урок 47. 00:04:12
    Using Derived Tables - Part 2
  48. Урок 48. 00:03:30
    Using Derived Tables - Part 3
  49. Урок 49. 00:04:39
    Using Derived Tables - Part 4
  50. Урок 50. 00:08:51
    Using Derived Tables - Part 5
  51. Урок 51. 00:04:24
    Working with CTEs - Part 1
  52. Урок 52. 00:02:00
    Working with CTEs - Part 2
  53. Урок 53. 00:08:01
    Working with CTEs - Part 3
  54. Урок 54. 00:04:10
    Working with CTEs - Part 4
  55. Урок 55. 00:03:54
    Using CASE Statements - Part 1
  56. Урок 56. 00:08:00
    Using CASE Statements - Part 2
  57. Урок 57. 00:04:51
    Using CASE Statements - Part 3
  58. Урок 58. 00:03:59
    Using CASE Statements - Part 4
  59. Урок 59. 00:02:55
    Using CASE Statements - Part 5
  60. Урок 60. 00:08:50
    Using CASE Statements - Part 6
  61. Урок 61. 00:04:44
    Creating a Table
  62. Урок 62. 00:06:24
    Insert Data into a Table
  63. Урок 63. 00:03:04
    Updating Data in a Table