Developing SQL Databases - Exam 70-762 Certification

Developing SQL Databases - Exam 70-762 Certification

by Mark Long
Released April 2017
Publisher(s): Infinite Skills
ISBN: 9781491983706

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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
    2. About The Author
    3. Course Overview
    4. Microsoft's SQL Server
    5. SQL Server 2016 Certifications
    6. Examples And Code
  2. SQL Server Basics
    1. SQL Server Platform
    2. SQL Server Editions
    3. Understanding Databases
    4. Database Structures
    5. Transact-SQL
  3. Getting And Installing SQL Server 2016
    1. Getting SQL Server 2016
    2. Installing SQL Server 2016
    3. Installing SQL Server Management Studio
    4. Attaching The Sample Database
    5. Verifying The Installation
  4. Table Design And Implementation
    1. Creating The Database
    2. Database Options
    3. Understanding Tables
    4. SQL Server Data Types
    5. Choosing A Data Type
    6. What Is Normalization?
    7. Understanding Relationships
    8. Schemas
    9. Table Design Basics
    10. Creating Tables Using T-SQL
    11. Creating Tables Graphically
    12. Using Identity Columns Part - 1
    13. Using Identity Columns Part - 2
    14. Altering Tables Part - 1
    15. Altering Tables Part - 2
  5. Advanced Table Design
    1. Understanding Data Integrity
    2. Constraints
    3. Primary And Foreign Keys
    4. Adding Constraints Part - 1
    5. Adding Constraints Part - 2
    6. Understanding Filegroups
    7. Table Partitions
    8. Temporal Tables
    9. Working With Temporal Tables Part - 1
    10. Working With Temporal Tables Part - 2
    11. In-Memory Tables Part - 1
    12. In-Memory Tables Part - 2
    13. Generating Scripts
  6. Indexes
    1. Index Basics
    2. Clustered Or Nonclustered Part - 1
    3. Clustered Or Nonclustered Part - 2
    4. Covered Indexes
    5. Creating Indexes
    6. Columnstore Indexes
    7. Managing Indexes
    8. Rebuilding And Reorganizing
  7. Views
    1. View Basics
    2. Creating A View
    3. Updateable Views
    4. Indexed Views
  8. Transactions
    1. Understanding Transactions Part - 1
    2. Understanding Transactions Part - 2
    3. Transaction Log
    4. Using Explicit Transactions
    5. Savepoints Part - 1
    6. Savepoints Part - 2
  9. Stored Procedures
    1. Stored Procedure Basics
    2. Creating Stored Procedures
    3. Using Input Parameters
    4. Using Output Parameters
    5. Table-Valued Parameters Part - 1
    6. Table-Valued Parameters Part - 2
    7. Return Status Part - 1
    8. Return Status Part - 2
    9. Natively Compiled Stored Procs
  10. Triggers
    1. Understanding Triggers
    2. Instead Of Triggers
    3. After Triggers
    4. Inserted And Deleted Tables
  11. User-Defined Functions
    1. Understanding Functions
    2. Scalar Functions
    3. Table-Valued Functions
  12. Conclusion
    1. Wrap Up

Product information

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