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