by Mark Long | Released April 2017 | ISBN: 9781491983706

Microsoft exam 70-762 is one of two exams you must pass to earn a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Development certification. This comprehensive course covers the material included in the 70-762 exam, moving you one step closer to the goal of becoming a true database professional. Taught in a friendly, easy-to-understand style by long time database development expert Mark Long, this course works for those new to the world of SQL databases, as well as those just needing a review. Understand how to design and operate on-premise and cloud-based SQL databases Gain the skill required to build and implement databases across an enterprise Learn about database file creation, data types, and tables Discover how to plan, create, and optimize indexes See the proper methods used for ensuring data integrity and data availability Learn about implementing views, stored procedures, and functions Understand how to manage transactions and locksMark Long is a long term contributor to O'Reilly Media having authored more than a dozen book and video titles including CompTIA Security+ SY0-401 (2014 Objectives), Windows Presentation Foundation Basics, Learning Windows PowerShell, and Securing Windows Networks. Mark holds many certifications including Microsoft's MCSE, MCDBA, and MCT; and as the head of his own consulting company, he solves IT issues for numerous Fortune 500 companies. Show and hide more Publisher resources Download Example Code

1. Introduction
   • Welcome To The Course 00:01:25
   • About The Author 00:03:43
   • Course Overview 00:06:34
   • Microsoft's SQL Server 00:05:51
   • SQL Server 2016 Certifications 00:04:35
   • Examples And Code 00:03:57
2. SQL Server Basics
   • SQL Server Platform 00:08:39
   • SQL Server Editions 00:04:52
   • Understanding Databases 00:05:42
   • Database Structures 00:06:52
   • Transact-SQL 00:06:09
3. Getting And Installing SQL Server 2016
   • Getting SQL Server 2016 00:06:55
   • Installing SQL Server 2016 00:09:31
   • Installing SQL Server Management Studio 00:03:44
   • Attaching The Sample Database 00:06:22
   • Verifying The Installation 00:05:17
4. Table Design And Implementation
   • Creating The Database 00:08:24
   • Database Options 00:09:40
   • Understanding Tables 00:06:05
   • SQL Server Data Types 00:09:07
   • Choosing A Data Type 00:05:23
   • What Is Normalization? 00:10:10
   • Understanding Relationships 00:06:50
   • Schemas 00:09:34
   • Table Design Basics 00:06:49
   • Creating Tables Using T-SQL 00:07:37
   • Creating Tables Graphically 00:06:30
   • Using Identity Columns Part - 1 00:06:27
   • Using Identity Columns Part - 2 00:04:35
   • Altering Tables Part - 1 00:08:41
   • Altering Tables Part - 2 00:03:20
5. Advanced Table Design
   • Understanding Data Integrity 00:06:47
   • Constraints 00:09:11
   • Primary And Foreign Keys 00:05:59
   • Adding Constraints Part - 1 00:06:56
   • Adding Constraints Part - 2 00:05:09
   • Understanding Filegroups 00:07:37
   • Table Partitions 00:08:01
   • Temporal Tables 00:07:35
   • Working With Temporal Tables Part - 1 00:07:47
   • Working With Temporal Tables Part - 2 00:04:55
   • In-Memory Tables Part - 1 00:08:29
   • In-Memory Tables Part - 2 00:03:03
   • Generating Scripts 00:07:28
6. Indexes
   • Index Basics 00:08:24
   • Clustered Or Nonclustered Part - 1 00:08:28
   • Clustered Or Nonclustered Part - 2 00:04:39
   • Covered Indexes 00:05:06
   • Creating Indexes 00:05:23
   • Columnstore Indexes 00:08:29
   • Managing Indexes 00:05:52
   • Rebuilding And Reorganizing 00:05:09
7. Views
   • View Basics 00:08:40
   • Creating A View 00:06:26
   • Updateable Views 00:04:09
   • Indexed Views 00:06:39
8. Transactions
   • Understanding Transactions Part - 1 00:09:01
   • Understanding Transactions Part - 2 00:04:48
   • Transaction Log 00:09:21
   • Using Explicit Transactions 00:06:26
   • Savepoints Part - 1 00:07:26
   • Savepoints Part - 2 00:02:49
9. Stored Procedures
   • Stored Procedure Basics 00:07:35
   • Creating Stored Procedures 00:05:53
   • Using Input Parameters 00:05:27
   • Using Output Parameters 00:07:15
   • Table-Valued Parameters Part - 1 00:07:53
   • Table-Valued Parameters Part - 2 00:06:40
   • Return Status Part - 1 00:07:44
   • Return Status Part - 2 00:04:06
   • Natively Compiled Stored Procs 00:06:46
10. Triggers
    • Understanding Triggers 00:07:11
    • Instead Of Triggers 00:06:49
    • After Triggers 00:06:42
    • Inserted And Deleted Tables 00:05:52
11. User-Defined Functions
    • Understanding Functions 00:07:19
    • Scalar Functions 00:07:35
    • Table-Valued Functions 00:07:16
12. Conclusion
    • Wrap Up 00:06:07
Show and hide more