Microsoft SQL Server 2016 Certification (70-762)
4.2 (390 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,786 students enrolled

Microsoft SQL Server 2016 Certification (70-762)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-762) exam.
Bestseller
4.2 (390 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,786 students enrolled
Last updated 2/2020
English
English [Auto-generated]
Current price: $104.99 Original price: $149.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Design and implement database objects
  • Implement programmability objects
  • Manage database concurrency
  • Optimize database objects and SQL infrastructure
Requirements
  • A PC
  • Internet Access
Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-762) - Developing SQL Databases. This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

In this course, you'll learn:
  • Design and implement database objects 
  • Implement programmability objects 
  • Manage database concurrency 
  • Optimize database objects and SQL infrastructure 

At the end of this course, you will have developed the knowledge and skills necessary to pass the Developing SQL Databases Exam. So let's get started.

Who this course is for:
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-762
Course content
Expand all 80 lectures 08:38:09
+ Getting Started With This Course
4 lectures 21:02
Introduction
06:36
Getting Started - Overview: MS SQL Server
05:53
Getting Started - The Certifications
04:36
Getting Started - Microsoft SQL Server Examples
03:57
+ Learn About SQL Server
5 lectures 32:20
Introduction
08:41
Learn About SQL Server - Learn About Editions
04:53
Learn About SQL Server - SQL Server Databases
05:42
Learn and Understand Database Structures
06:54
Learn About SQL Server - Transact-SQL
06:10
+ Learn About MS SQL Server 2016
5 lectures 31:57
Introduction
06:57
MS SQL Server 2016: Learn How To Install SQL Server Management Studio
03:44
MS SQL Server 2016: Attaching The Sample Database
06:24
MS SQL Server 2016: Verifying The Installation
05:18
+ Microsoft SQL Server 2016: Table Design & Implementation
15 lectures 01:49:41
Introduction
08:27
SQL Server 2016: Database Options
09:44
SQL Server 2016: Database Options - Learn and Understand Tables
06:06
SQL Server 2016: SQL Server Data Types
09:10
SQL Server 2016: Choosing A Data Type
05:24
SQL Server 2016: Database Options - Learn about Normalization
10:13
SQL Server 2016: Database Options - Learn and Understand Relationships
06:51
SQL Server 2016: Schemas
09:36
SQL Server 2016: Table Design Basics
06:50
SQL Server 2016: Creating Tables Using T-SQL
07:39
SQL Server 2016: Creating Tables Graphically
06:32
SQL Server - Using Identity Columns - 1
06:28
SQL Server - Using Identity Columns - 2
04:36
SQL Server - Altering Tables - 1
08:44
SQL Server - Altering Tables - 2
03:21
+ SQL Server 2016 - Advanced Table Design
13 lectures 01:29:22
Introduction
06:48
Table Design: Constraints
09:14
Table Design: Primary and Foreign Keys
06:00
Table Design: Adding Constraints - 1
06:59
Table Design: Adding Constraints - 2
05:11
Table Design: Understanding Filegroups
07:39
Table Design: Table Partitions
08:02
Table Design: Temporal Tables
07:37
Table Design: Working With Temporal Tables - 1
07:50
Table Design: Working With Temporal Tables - 2
04:57
Table Design: In-Memory Tables - 1
08:32
Table Design: In-Memory Tables - 2
03:03
Table Design: Generating Scripts
07:30
+ SQL Server 2016: Indexes
8 lectures 51:43
Introduction
08:26
SQL Server Indexes - Clustered Or Nonclustered - 1
08:31
SQL Server Indexes - Clustered Or Nonclustered - 2
04:40
SQL Server Indexes - Covered Indexes
05:07
SQL Server Indexes - Creating Indexes
05:24
SQL Server Indexes - Columnstore Indexes
08:32
SQL Server Indexes - Managing Indexes
05:52
SQL Server Indexes - Rebuilding and Reorganizing
05:11
+ SQL Server 2016: Views
4 lectures 26:00
Introduction
08:42
SQL Server 2016 - Creating A View
06:27
SQL Server 2016 - Updateable Views
04:10
SQL Server 2016 - Indexed Views
06:41
+ SQL Server 2016: Transactions
6 lectures 40:01
Introduction
09:03
SQL Server 2016 - Understanding Transactions
04:48
SQL Server 2016 - Transaction Log
09:24
SQL Server 2016 - Using Explicit Transactions
06:27
SQL Server 2016 - Savepoints - 1
07:29
SQL Server 2016 - Savepoints - 2
02:50
+ SQL Server 2016: Stored Procedures
9 lectures 59:36
Introduction
07:37
SQL Server 2016 - Creating Stored Procedures
05:55
SQL Server 2016 - Using Input Parameters
05:28
SQL Server 2016 - Using Output Parameters
07:17
SQL Server 2016 - Table-Valued Parameters - 1
07:56
SQL Server 2016 - Table-Valued Parameters - 2
06:42
SQL Server 2016 - Return Status - 1
07:46
SQL Server 2016 - Return Status - 2
04:07
SQL Server 2016 - Natively Compiled Stored Procs
06:48