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