Developing SQL Server 2016 Databases 70-762
As competing database platforms experience slow growth or even loss of marketshare, Microsoft's SQL Server 2016 database platform marketshare continues to expand. rnrnObtaining certification on the SQL Server 2016 data platform is a great way to get the attention of potential employers or to move to higher levels in your current career.rnrnSQL Server 2016 provides many new and enhanced functionalities that continue to change how database technologies are being used to capture, manage, and deliver data in today's data-centric environment.rnrnYou can achieve an MCSA: SQL 2016 Database Development certification by passing exams 70-762 which is covered in this course, along with exam 70-761, Querying Data with Transact-SQL, also available from VTC.rnrnIn this course, Mark Long brings over 20 years of experience with SQL Server along to help you get acquainted with SQL Server 2016 and help you get prepared to take the 70-762 exam.
Course content
Welcome/Intro5 lessons
SQL Server 2016 Essentials4 lessons
Installing SQL Server10 lessons
- Getting Hands on with SQL Server 2016 pt. 16:45Free
- Getting Hands on with SQL Server 2016 pt. 24:43Free
- Installing SQL Server 2016 pt. 17:00Free
- Installing SQL Server 2016 pt. 27:16Free
- Getting SSMS3:53Free
- Verifying the Installation5:42Free
- Attaching the Sample dB pt. 16:08Free
- Attaching the Sample dB pt. 24:30Free
- Getting Help7:00Free
- MMC6:24Free
SQL Server Design Basics14 lessons
- SQL Server Instances4:141 credit or ad
- SQL Server Management Studio7:391 credit or ad
- Refreshing Intelligense4:101 credit or ad
- Understanding Databases6:531 credit or ad
- Database Types7:021 credit or ad
- Database Files5:091 credit or ad
- Understanding Transaction Logs4:121 credit or ad
- Table Basics4:591 credit or ad
- Table Design Options6:291 credit or ad
- Understanding Data Types pt. 17:161 credit or ad
- Understanding Data Types pt. 27:251 credit or ad
- Choosing a Data Type7:301 credit or ad
- Understanding Schemas4:371 credit or ad
- Four Part Naming4:101 credit or ad
Ensuring Data Integrity8 lessons
- Understanding Normalization5:171 credit or ad
- Understanding Data Integrity6:221 credit or ad
- Constraints6:541 credit or ad
- Understanding Primary Keys5:011 credit or ad
- Understanding Foreign Keys5:501 credit or ad
- Denormalization5:141 credit or ad
- Virtual Denormalization pt. 17:111 credit or ad
- Virtual Denormalization pt. 23:261 credit or ad
Working with Tables12 lessons
- Database Diagrams3:511 credit or ad
- Working With Diagrams7:031 credit or ad
- Physical Tables5:091 credit or ad
- Understanding Table Partitioning7:311 credit or ad
- Understanding Temporary Tables5:501 credit or ad
- In Memory OLTP7:141 credit or ad
- Memory Optimized Table Requirements6:541 credit or ad
- Estimating Memory Requirements4:501 credit or ad
- In Memory OLTP Tools6:481 credit or ad
- In Memory OLTP Durability pt. 17:041 credit or ad
- In Memory OLTP Durability pt. 25:481 credit or ad
- Temporal Tables5:471 credit or ad
Indexes10 lessons
- Index Basics5:271 credit or ad
- Clustered Indexes6:071 credit or ad
- Non clustered Indexes7:051 credit or ad
- Pages and Extents6:311 credit or ad
- Understanding Fill Factor5:061 credit or ad
- Optimizing Indexes7:141 credit or ad
- Reorganizing and Rebuilding Indexes6:481 credit or ad
- Checking Index Fragmentation5:081 credit or ad
- Columnstore Indexes5:341 credit or ad
- Columnstore Index Characteristics4:591 credit or ad
Programming Objects15 lessons
- Understanding Stored Procedures pt. 16:471 credit or ad
- Understanding Stored Procedures pt. 25:001 credit or ad
- Creating Stored Procedures4:171 credit or ad
- Using Parameters With SPs5:451 credit or ad
- Using Output Parameters6:501 credit or ad
- Table valued Parameters7:331 credit or ad
- Natively Compiled Stored Procedures5:011 credit or ad
- Understanding Transactions4:401 credit or ad
- Explicit and Implicit Transactions4:331 credit or ad
- Transactions Example6:581 credit or ad
- Transactions and Locking6:431 credit or ad
- Understanding Views6:541 credit or ad
- Creating a View6:161 credit or ad
- Partitioned View pt. 16:591 credit or ad
- Partitioned View pt. 22:531 credit or ad
Triggers and UDFs8 lessons
- Understanding Triggers5:041 credit or ad
- Recursion and Nesting6:141 credit or ad
- Logon Triggers3:531 credit or ad
- AFTER or INSTEAD OF6:251 credit or ad
- User Defined Functions6:251 credit or ad
- Scalar valued Functions pt. 17:131 credit or ad
- Scalar valued Functions pt. 23:161 credit or ad
- Table valued Functions7:141 credit or ad