Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

MOD+DMOC: Developing SQL Databases (M20762)

Learn to design and develop a Microsoft SQL Server 2016 database.

GK# 4948

Course Overview

TOP

In this course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20762: Developing SQL Databases.

Redeem four SATVs for an individual On-Demand course plus digital Microsoft Official Courseware (dMOC). For more information on Microsoft SATVs click here.

 

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Design and implement tables
  • Advanced table designs
  • Ensure data integrity through constraints
  • Indexes, including optimized and columnstore indexes
  • Design and implement views
  • Design and implement stored procedures
  • Design and implement user-defined functions
  • Respond to data manipulation using triggers
  • Design and implement in-memory tables
  • Implement managed code in SQL Server
  • Store and query XML data
  • Work with spatial data
  • Store and query BLOBs and text documents

Outline

TOP
Viewing outline for:

On-Demand Outline

1. Introduction to Database Development

  • Introduction to the SQL Server Platform
  • SQL Server Database Development Tasks

2. Designing and Implementing Tables

  • Designing Tables
  • Data Types
  • Working with Schemas
  • Creating and Altering Tables

3. Advanced Table Designs

  • Partitioning Data
  • Compressing Data
  • Temporal Tables

4. Ensuring Data Integrity through Constraints

  • Enforcing Data Integrity
  • Implementing Domain Integrity
  • Implementing Entity and Referential Integrity

5. Introduction to Indexes

  • Core Indexing Concepts
  • Data Types and Indexes
  • Single Column and Composite Indexes

6. Designing Optimized Index Strategies

  • Covering Indexes
  • Managing Indexes
  • Execution Plans
  • Using the DTE

7. Columnstore Indexes

  • Introduction to Columnstore Indexes
  • Creating Columnstore Indexes
  • Working Columnstore Indexes

8. Designing and Implementing Views

  • Introduction to Views
  • Creating and Managing Views
  • Performance Considerations for Views

9. Designing and Implementing Stored Procedures

  • Introduction to Stored Procedures
  • Working with Stored Procedures
  • Implementing Parameterized Stored Procedures
  • Controlling Execution Context

10. Designing and Implementing User-Defined Functions

  • Overview of Functions
  • Designing and Implementing Scalar Functions
  • Designing and Implementing Table-Valued Functions
  • Implementation Considerations for Functions
  • Alternatives to Functions

11. Responding to Data Manipulation via Triggers

  • Designing DML Triggers
  • Implementing DML Triggers
  • Advanced Trigger Concepts

12. Using In-memory Tables

  • In-memory Tables
  • Native Stored Procedures

13. Implementing Managed Code in SQL Server

  • Introduction to CLR Integration in SQL Server
  • Implementing and Publishing CLR Assemblies

14. Storing and Querying XML Data in SQL Server

  • Describe XML and XML schemas
  • Store XML data and Associated XML schemas in SQL Server
  • Implement XML indexes with SQL Server
  • Use the Transact-SQL FOR XML statement
  • Work with basic XQuery queries

15. Storing and Querying Spatial Data In SQL Server

  • Introduction to Spatial Data
  • Working with SQL Server Spatial Data Types
  • Using Spatial Data in Applications

16. Storing and Querying BLOBs and Text Documents in SQL Server

  • Considerations for BLOB Data
  • Working with FileStream
  • Using Full-Text Search

17. SQL Server Concurrency

  • Concurrency and Transactions
  • Locking Internals

18. Performance and Extended Events

  • Working with extended Events
  • Live Query Statistics
  • Optimize Database File Configuration
  • Metrics

Labs

TOP
Viewing labs for:

On-Demand Labs

Lab 1: Designing and Implementing Tables
Lab 2: Using Advanced Table Designs
Lab 3: Ensuring Data Integrity through Constraints
Lab 4: Implementing Indexes
Lab 5 Optimizing Indexes
Lab 6: Using Columnstore Indexes
Lab 7: Designing and Implementing Views
Lab 8: Designing and Implementing Stored Procedures
Lab 9: Designing and Implementing User-defined Functions
Lab 10: Responding to Data Manipulation via Triggers
Lab 11: In-memory Database Capabilities
Lab 12: Implementing Managed Code in SQL Server
Lab 13: Storing and Querying XML Data in SQL Server
Lab 14: Working with SQL Server Spatial Data
Lab 15: Storing and Querying BLOBs and Text Documents in SQL Server
Lab 16: SQL Server Concurrency
Lab 17: Monitoring, Tracing, and Baselining

Prerequisites

TOP
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases

Who Should Attend

TOP
  • IT professionals who want to become skilled on SQL Server 2016 product features and technologies for designing a SQL Server 2016 database platform
  • Developers from other product platforms or previous versions of SQL Server who want to become skilled in designing and developing a SQL Server 2016 database platform

 

Vendor Credits

TOP

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

  • Redeem five SATVs for an individual On-Demand course

Follow-On Courses

TOP
Training Exclusives

This course comes with three months, 24x7 access to: 

  • HD-quality streaming videos that adapt to your connection speed and device
  • Hands-on live labs with integrated lab steps and ability to save and resume labs
  • Knowledge checks for comprehensive assessments
  • 24x7 mentoring via chat, email and phone
  • Digital Microsoft Official Courseware (dMOC)
Course Delivery

This course is available in the following formats:

On-Demand

Train at your own pace with 24/7 access to courses that help you acquire must-have technology skills.

Duration: 42 hours

Request this course in a different delivery format.
Enroll