Microsoft SQL Server 2016 Certification (70-761)
4.1 (981 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.
3,357 students enrolled

Microsoft SQL Server 2016 Certification (70-761)

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-761) exam.
4.1 (981 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.
3,357 students enrolled
Last updated 8/2020
English
English [Auto]
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
  • 7 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • 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
  • Manage data with Transact-SQL
  • Query data with advanced Transact-SQL components
  • Program databases by using Transact-SQL
Requirements
  • A PC
  • Internet Access
Description

Welcome to this course: Microsoft SQL Server 2016 Certification (70-761) - Querying Data with Transact-SQL. This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

In this course, you'll learn:

  • Manage data with Transact-SQL 
  • Create Transact-SQL SELECT queries
  • Query multiple tables by using joins
  • Implement functions and aggregate data
  • Modify data
  • Query data with advanced Transact-SQL components 
  • Query data by using subqueries and APPLY
  • Query data by using table expressions
  • Group and pivot data by using queries
  • Query temporal data and non-relational data
  • Program databases by using Transact-SQL 
  • Create database programmability objects by using Transact-SQL
  • Implement error handling and transactions
  • Implement data types and NULLs

At the end of this course, you will have developed the knowledge and skills necessary to pass the Querying Data with Transact-SQL Exam. So let's get started.

Who this course is for:
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-761
Course content
Expand all 69 lectures 06:45:32
+ Getting Started With This Course
4 lectures 17:11
Introduction
04:09
Getting Started: MS SQL Server 2016 - Transact-SQL
04:49
Getting Started: The Certifications
05:04
Getting Started: Microsoft SQL Server Examples
03:09
+ Learn About Databases
5 lectures 27:11
Learning SQL Server Databases - Database Structure & Purpose
06:21
Learning SQL Server Databases - Database Terminology
05:55
Learning SQL Server Databases - Data Types
05:06
Learning SQL Server Databases - Statement Types
01:39
+ Learn About MS SQL Server 2016
5 lectures 31:31
Introduction
04:38
MS SQL Server 2016: Learn About Microsoft SQL Server 2016
05:01
MS SQL Server 2016: Learn How To Install SQL Server 2016
10:31
MS SQL Server 2016: Learn How To Install SQL Server Management Studio
07:01
MS SQL Server 2016: Microsoft SQL Server 2016 - Attaching The Sample Database
04:20
+ Microsoft SQL Server 2016 - Basic Select Statements
7 lectures 47:12
Introduction
08:32
Select Statements - Using The Where Clause
06:10
Select Statements - Column Aliasing
04:49
Select Statements - Using Distinct
05:42
Select Statements - Ordering Results
07:17
Select Statements - T-SQL Concatenation
07:32
Select Statements - Multipart Naming
07:10
+ Microsoft SQL Server 2016 - Advanced Select Statements
8 lectures 54:57
Introduction
08:36
Select Statements - Union
07:27
Select Statements - Intersect and Except
07:48
Select Statements - Paging Results
06:25
Select Statements - Understanding Case Expressions - 1
07:42
Select Statements - Understanding Case Expressions - 2
04:37
Select Statements - Using Pivot - 1
07:13
Select Statements - Using Pivot - 2
05:09
+ Microsoft SQL Server 2016 - Querying Multiple Tables
6 lectures 40:12
Introduction
07:38
SQL Server 2016 - Table Relationships
08:56
SQL Server 2016 - Using The Join Statement
07:04
SQL Server 2016 - Table Aliasing
06:25
SQL Server 2016 - Join Types
04:00
SQL Server 2016 - Join Types Examples
06:09
+ Microsoft SQL Server 2016 - Grouping Data
5 lectures 35:25
Introduction
05:43
Grouping Data - Understanding Group By
08:15
Grouping Data - Understanding Having
05:39
Grouping Data - Understanding Grouping Sets
08:01
Grouping Data - The Graphical Query Tool
07:47
+ Microsoft SQL Server 2016 - Modifying Data
8 lectures 47:48
Introduction
06:42
Modifying - Insert Demo
08:05
Modifying - Insert Select
06:55
Modifying - Select Into
05:46
Modifying - Updating Data
04:10
Modifying - Update Demo
06:45
Modifying - Deleting Data
03:31
Modifying - Delete Demo
05:54
+ Microsoft SQL Server 2016 - Programming Objects Using T-SQL
9 lectures 56:58
Introduction
08:37
Programming Objects - Stored Procedure Demo
06:24
Programming Objects - Using Input Parameters
07:33
Programming Objects - Using Output Parameters
07:09
Programming Objects - Understanding Table Variables
07:23
Programming Objects - Understanding CTEs - 1
05:56
Programming Objects - Understanding CTEs - 2
04:47
Programming Objects - Understanding Masking
05:48
Programming Objects - Masking Demo
03:21