1. Урок 1. 00:00:42
    Welcome
  2. Урок 2. 00:00:40
    Using the exercise files
  3. Урок 3. 00:00:37
    What you should know
  4. Урок 4. 00:03:15
    Install the sample database
  5. Урок 5. 00:04:31
    Table design in SQL Server
  6. Урок 6. 00:03:20
    Data types
  7. Урок 7. 00:07:28
    Create and alter tables
  8. Урок 8. 00:06:21
    Implement table schemas
  9. Урок 9. 00:06:40
    Calculate table columns
  10. Урок 10. 00:09:03
    Partition large data tables
  11. Урок 11. 00:04:38
    Create temporary tables
  12. Урок 12. 00:04:41
    Use table variables
  13. Урок 13. 00:07:09
    Understand column collation
  14. Урок 14. 00:03:57
    Data compression fundamentals
  15. Урок 15. 00:03:40
    Compress data tables
  16. Урок 16. 00:05:04
    Go back in time with temporal tables
  17. Урок 17. 00:02:18
    What are views
  18. Урок 18. 00:07:19
    Create a view of the data
  19. Урок 19. 00:04:53
    Enhance view performance
  20. Урок 20. 00:02:04
    Understand data integrity
  21. Урок 21. 00:02:45
    Implement domain integrity
  22. Урок 22. 00:02:26
    Enforce referential integrity
  23. Урок 23. 00:04:49
    Use DML triggers to verify data
  24. Урок 24. 00:03:56
    Define user roles and permissions
  25. Урок 25. 00:04:49
    Add a user to a role with T-SQL
  26. Урок 26. 00:05:21
    Create loginless and contained users
  27. Урок 27. 00:04:03
    Implement schema security
  28. Урок 28. 00:06:12
    Store spatial data
  29. Урок 29. 00:04:03
    Add GUID data to a table
  30. Урок 30. 00:04:50
    Implement the XML data type
  31. Урок 31. 00:03:19
    Store BLOB data in a table
  32. Урок 32. 00:06:48
    Implement FILESTREAM access
  33. Урок 33. 00:06:22
    Implicit and explicit data conversions
  34. Урок 34. 00:02:55
    Introduction to stored procedures
  35. Урок 35. 00:04:37
    Write a stored procedure with T-SQL
  36. Урок 36. 00:04:35
    Add parameters to a stored procedure
  37. Урок 37. 00:02:13
    Recompile a stored procedure
  38. Урок 38. 00:02:01
    Why use in-memory tables
  39. Урок 39. 00:06:11
    Create a memory-optimized table
  40. Урок 40. 00:05:17
    Write a native compiled stored procedure
  41. Урок 41. 00:03:00
    Table index fundamentals
  42. Урок 42. 00:02:18
    Clustered indexes
  43. Урок 43. 00:02:19
    Non-clustered indexes
  44. Урок 44. 00:05:24
    Single column and composite indexes
  45. Урок 45. 00:02:45
    Design spatial and XML indexes
  46. Урок 46. 00:05:06
    Improve queries with covering indexes
  47. Урок 47. 00:04:11
    Obtain index statistics
  48. Урок 48. 00:03:43
    Filtered indexes
  49. Урок 49. 00:02:00
    Create columnstore indexes
  50. Урок 50. 00:02:06
    Introduction to sparse columns
  51. Урок 51. 00:03:24
    Implement sparse columns
  52. Урок 52. 00:04:16
    Defragment indexes
  53. Урок 53. 00:04:27
    Analyze execution plans and tune queries
  54. Урок 54. 00:03:34
    Leverage the SQL Tuning Advisor
  55. Урок 55. 00:01:37
    SQL Server function overview
  56. Урок 56. 00:06:02
    Return values with scalar functions
  57. Урок 57. 00:03:01
    Create a table-valued function
  58. Урок 58. 00:01:43
    Use Dynamic Management Views
  59. Урок 59. 00:05:38
    Record extended event sessions
  60. Урок 60. 00:02:20
    Find bottlenecks with Activity Monitor
  61. Урок 61. 00:00:46
    Next steps