Developing SQL Databases - Exam 70-762 Certification

Video Description

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 locks
Mark 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.

Table of Contents

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

Product Information

  • Title: Developing SQL Databases - Exam 70-762 Certification
  • Author(s): Mark Long
  • Release date: April 2017
  • Publisher(s): Infinite Skills
  • ISBN: 9781491983713