O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server 2014 (Exam 70-464)

Video Description

SQL Server is the foundation of Microsoft's comprehensive data platform. SQL Server 2014, the latest version, introduces new in-memory capabilities and other improvements are gaining a lot of attention in the database world. SQL Server 2014 will continue the explosive growth in this product, create more and more opportunities for those holding certifications on the Microsoft Data Platform. In this course, Mark Long brings his 20+ years of experience with SQL Server to you as he helps you prepare for Microsoft's 70-464 Developing Microsoft SQL Server Databases certification exam.

Table of Contents

  1. Welcome/Intro 00:01:15
  2. Welcome/Intro 00:01:15
  3. Course Overview 00:04:28
  4. Understanding SQL 00:04:38
  5. Understanding TSQL 00:04:00
  6. Microsoft SQL Server Certifications 00:04:04
  7. SQL Server 2014 Essentials 00:04:08
  8. What's New in 2014 00:04:08
  9. SQL Server 2014 Editions 00:03:01
  10. Installing SQL Server 00:03:55
  11. Getting SQL Server 2014 00:03:55
  12. Installing SQL Server 2014 pt. 1 00:06:06
  13. Installking SQL Server 2014 pt. 2 00:06:03
  14. Validating a SQL Server Installation pt. 1 00:04:06
  15. Validating a SQL Server Installation pt. 2 00:04:40
  16. Uninstalling SQL Server 2014 00:03:42
  17. SQL Books Online Goes Online 00:04:11
  18. Downloading Books Online 00:04:43
  19. Attaching Adventureworks Sample dB pt. 1 00:04:22
  20. Attaching Adventureworks Sample dB pt. 2 00:02:37
  21. Where's the TSQL Reference 00:06:22
  22. SQL Server Basics 00:03:55
  23. SQL Server Instances 00:03:55
  24. SQL Server Configuration Manager 00:03:21
  25. SQL Server Management Studio 00:06:37
  26. Understanding Databases 00:04:41
  27. Table Basics 00:04:40
  28. Understanding Primary Keys 00:04:22
  29. Understanding Data Types pt. 1 00:06:09
  30. Understanding Data Types pt. 2 00:06:00
  31. Understanding Normalization 00:04:54
  32. Understanding Foreign Keys 00:04:34
  33. Database Types 00:05:45
  34. Understanding Transaction Logs 00:04:34
  35. System Databases 00:05:57
  36. Understanding Schemas 00:04:20
  37. Four Part Naming 00:03:55
  38. Understanding Synonyms Part One 00:03:35
  39. Understanding Synonyms Part Two 00:03:51
  40. Refreshing Intellisense 00:03:24
  41. Table Basics 00:05:00
  42. Table Design Basics 00:05:00
  43. Creating a Database 00:04:51
  44. Creating a Tables Graphically 00:06:14
  45. Creating Tables with TSQL 00:06:47
  46. Temporary Tables 00:06:56
  47. Table Variables 00:05:28
  48. Temp Table vs Table Variable 00:03:41
  49. Advanced Table Functionalities 00:05:28
  50. Calculated Columns 00:05:28
  51. Column Collation pt. 1 00:06:25
  52. Column Collation pt. 2 00:04:46
  53. Understanding Filegroups 00:04:38
  54. Understanding Table Partitioning 00:06:57
  55. File Stream Basics 00:05:20
  56. Enabling FileStream 00:06:33
  57. File Table Basics 00:02:56
  58. In Memory OLTP 00:06:23
  59. In Memory OLTP Demo 00:07:42
  60. Next Steps on In Memory OLTP 00:05:47
  61. Indexes 00:04:20
  62. Nonclustered Indexes 00:04:20
  63. Pages and Extents 00:05:36
  64. Understanding Fill Factor 00:04:33
  65. Creating Indexes 00:07:25
  66. Checking Index Fragmentation 00:06:51
  67. Index Basics 00:05:22
  68. Reorganizing and Rebuilding Indexes 00:07:09
  69. Aligning Indexes on Partitioned Tables 00:05:23
  70. Clustered Indexes 00:04:55
  71. Identifying Index Usage pt. 1 00:06:07
  72. Identifiying Index Usage pt. 2 00:03:15
  73. Columnstore Indexes pt.1 00:06:02
  74. Columnstore Indexes pt 2 00:04:19
  75. Columnstore Index Characteristics 00:04:30
  76. Programming Objects 00:05:51
  77. Stored Procedures 00:05:51
  78. Natively Compiled Stored Procedures 00:06:29
  79. Using Parameters with Sps pt. 1 00:06:23
  80. Using Parameters with SPs pt. 2 00:06:37
  81. Error Handling in SPs pt. 1 00:06:14
  82. Error Handling in SPs pt. 2 00:06:11
  83. OFFSET and FETCH 00:06:46
  84. Creating Views 00:05:42
  85. Partitioned Views 00:05:12
  86. Indexed Views 00:05:26
  87. Concurrency and Locking 00:05:33
  88. Understanding Concurrency 00:05:33
  89. Pessimistic and Optimistic Locking 00:05:27
  90. Normalization and Concureency 00:04:34
  91. Transaction Isolation Levels 00:06:23
  92. Snapshot Isolation 00:06:01
  93. Understanding Transactions 00:04:21
  94. Explicit and Implicit Transactions 00:04:22
  95. Using Explicit Transactions 00:04:21
  96. Design for Minimal Locking 00:06:10
  97. Monitoring and Managing Locking 00:06:14
  98. Optimization 00:05:19
  99. SQL Server Profiler 00:05:19
  100. Creating a Trace pt.1 00:05:49
  101. Creating a Trace pt. 2 00:05:55
  102. Extended Events 00:06:57
  103. Performance Monitor and Profiler pt. 1 00:02:20
  104. Performance Monitor and Profiler pt. 2 00:03:07
  105. Performance Profiler pt. 3 00:06:42
  106. Monitoring In-Memory OLTP 00:04:30
  107. Execution Plans 00:04:54
  108. Working with XML Data 00:06:08
  109. XML in SQL Server 2014 00:06:08
  110. Retrieving XML from Relational Data 00:02:34
  111. For XML 00:06:46
  112. For XML Path 00:04:12
  113. Course Wrap Up
  114. About the Author 00:06:17
  115. Course Wrap-up 00:06:17
  116. About the Author 00:03:47