Developing SQL Databases Training Course ( Exam 70-762)

Overview Schedule & Fees Course Benefits Student Feedback FAQ Course Modules

20762C: Developing SQL 2016 Databases Certification Training Course Overview

SQL Development training course imparts professionals with the skills and knowledge to design and develop an SQL Server 2016 database. 20762: Developing SQL 2016 Databases course puts emphasis on how SQL Server 2016 tools and features can be used to develop a robust database. This SQL Server 2016 certification encompasses design of logical tables, domain integrity, query plans, indexing, and data integrity. Candidates will learn to create database objects, functions, parameters, stored procedures, and views. Procedure coding such as triggers, indexes, SQL Server Spatial data, SQL CLR (Common Language Runtime) and binary large object (BLOB) data.

The SQL Server 2016 training is ideal for IT professionals or developers who wish to gain expertise on features and tools for developing a database platform of SQL Server 2016.

Test your current knowledge Qubits42

Developing SQL Databases Training Course ( Exam 70-762) (Duration : 40 Hours) Download Course Contents

Live Virtual Classroom

Group Training 1800 08 - 12 Nov GTR 09:00 AM - 05:00 PM CST (8 Hours/Day) 13 - 17 Dec 09:00 AM - 05:00 PM CST (8 Hours/Day)	1-on-1 Training (GTR) 2100 4 Hours 8 Hours Week Days Weekend Start Time : At any time 12 AM 12 PM Training Schedule: GTR=Guaranteed to Run

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Recording Available only $99

Customers who bought this course also bought

Querying Data with Transact-SQL Training Course (Exam 70-761) is recommended before.

Developing SQL Databases Training Course ( Exam 70-762) is recommended after.

Administering a SQL Database Infrastructure Certification Exam Course (70-764)

CompTIA A+ Certification Training Course - 220-1001/220-1002

Microsoft Power BI Certification Training Course : Exam DA 100

AZ-104: Microsoft Azure Administrator Training Course

PL-900T00-A: Microsoft Power Platform Fundamentals Training Course

Querying Data with Transact-SQL Training Course (Exam 70-761)

10% discount on 2nd course:

Course Modules

Module 1: An Introduction to Database Development

Lesson 1: Introduction to the SQL Server Platform
Lesson 2: SQL Server Database Development Tasks

Module 2: Designing and Implementing Tables

Lesson 1: Designing Tables
Lesson 2: Data Types
Lesson 3: Working with Schemas
Lesson 4: Creating and Altering Tables
Lab: Designing and Implementing Tables

Module 3: Advanced Table Designs

Lesson 1: Partitioning Data
Lesson 2: Compressing Data
Lesson 3: Temporal Tables
Lab: Using Advanced Table Designs

Module 4: Ensuring Data Integrity Through Constraints

Lesson 1: Enforcing Data Integrity
Lesson 2: Implementing Data Domain Integrity
Lesson 3: Implementing Entity and Referential Integrity
Lab: Ensuring Data Integrity Through Constraints

Module 5: Introduction to Indexes

Lesson 1: Core Indexing Concepts
Lesson 2: Data Types and Indexes
Lesson 3: Heaps, Clustered, and Nonclustered Indexes
Lesson 4: Single Column and Composite Indexes
Lab: Implementing Indexes

Module 6: Designing Optimized Index Strategies

Lesson 1: Index Strategies
Lesson 2: Managing Indexes
Lesson 3: Execution Plans
Lesson 4: The Database Engine Tuning Advisor
Lesson 5: Query Store
Lab: Optimizing Indexes

Module 7: Columnstore Indexes

Lesson 1: Introduction to Columnstore Indexes
Lesson 2: Creating Columnstore Indexes
Lesson 3: Working with Columnstore Indexes
Lab: Using Columnstore Indexes

Module 8: Designing and Implementing Views

Lesson 1: Introduction to Views
Lesson 2: Creating and Managing Views
Lesson 3: Performance Considerations for Views
Lab: Designing and Implementing Views

Module 9: Designing and Implementing Stored Procedures

Lesson 1: Introduction to Stored Procedures
Lesson 2: Working with Stored Procedures
Lesson 3: Implementing Parameterized Stored Procedures
Lesson 4: Controlling Execution Context
Lab: Designing and Implementing Stored Procedures

Module 10: Designing and Implementing User-Defined Functions

Lesson 1: Overview of Functions
Lesson 2: Designing and Implementing Scalar Functions
Lesson 3: Designing and Implementing Table-Valued Functions
Lesson 4: Considerations for Implementing Functions
Lesson 5: Alternatives to Functions
Lab: Designing and Implementing User-Defined Functions

Module 11: Responding to Data Manipulation Via Triggers

Lesson 1: Designing DML Triggers
Lesson 2: Implementing DML Triggers
Lesson 3: Advanced Trigger Concepts
Lab: Responding to Data Manipulation by Using Triggers

Module 12: Using In-Memory Tables

Lesson 1: Memory-Optimized Tables
Lesson 2: Natively Compiled Stored Procedures
Lab: Using In-Memory Database Capabilities

Module 13: Implementing Managed Code in SQL Server

Lesson 1: Introduction to CLR Integration in SQL Server
Lesson 2: Implementing and Publishing CLR Assemblies
Lab: Implementing Managed Code in SQL Server

Module 14: Storing and Querying XML Data in SQL Server

Lesson 1: Introduction to XML and XML Schemas
Lesson 2: Storing XML Data and Schemas in SQL Server
Lesson 3: Implementing the XML Data Type
Lesson 4: Using the Transact-SQL FOR XML Statement
Lesson 5: Getting Started with XQuery
Lesson 6: Shredding XML
Lab: Storing and Querying XML Data in SQL Server

Module 15: Storing and Querying Spatial Data in SQL Server

Lesson 1: Introduction to Spatial Data
Lesson 2: Working with SQL Server Spatial Data Types
Lesson 3: Using Spatial Data in Applications
Lab: Working with SQL Server Spatial Data

Module 16: Storing and Querying BLOBs and Text Documents in SQL Server

Lesson 1: Considerations for BLOB Data
Lesson 2: Working with FILESTREAM
Lesson 3: Using Full-Text Search
Lab: Storing and Querying BLOBs and Text Documents in SQL Serve

Module 17: SQL Server Concurrency

Lesson 1: Concurrency and Transactions
Lesson 2: Locking Internals
Lab: Concurrency and Transactions

Module 18: Performance and Monitoring

Lesson 1: Extended Events
Lesson 2: Working with Extended Events
Lesson 3: Live Query Statistics
Lesson 4: Optimize Database File Configuration
Lesson 5: Metrics
Lab: Monitoring, Tracing, and Baselining

Download Course Contents

Request More Information

Request a call back?

Course Prerequisites

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

Upon Completion of this Course, you will accomplish following:-

Design and create tables and advanced table designs
Implement Data Integrity using Constraints
Apply indexing, using Columnstore and Optimized indexes
Design and create views, functions, stored procedures, In-memory tables
Apply triggers to respond to data manipulation
Employ managed code in SQL Server
Query and store XML Data, Blobs, and text documents
Work with Spatial Data in this SQL development training

Give an edge to your career with Microsoft certification training courses. Students can join the classes for Developing SQL 2016 Databases Training Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name	Country	Month	Feedback	Rating
Reswan Ismail	Mozambique	Oct-2020	A2. Koenig's professionalism is a great differentiator. Koenig lets students focus as much on their studies as possible, avoiding any kind of distractions. The assistance and support provided by the Training Coordinator - Mrs. Rini Watson and the Training Manager - Mrs. Danica Amor is truly essential. Congratulations for your engagement and professionalism.