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