70-761 Module 1: Manage data with Transact-SQL
4.0 (1 rating)
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 students enrolled

70-761 Module 1: Manage data with Transact-SQL

The first of three modules to teach you everything you need to know for the 70-761 exam Querying Data with Transact-SQL!
4.0 (1 rating)
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 students enrolled
Last updated 3/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 10 articles
  • 14 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
  • The first of three modules to teach you everything you need to know for the SQL Server 2016 MCSA 70-761 Querying Data with Transact-SQL exam!
Requirements
  • This is not an entry level course. You will need some experience working with SQL Server and Transact-SQL. Also, to follow along with the examples, and perform the exercises, you will need access to your own testinst
Description

This is the first of three modules. Together, they will teach you everything you need to know to pass the Microsoft SQL Server 2016 70-761 exam Querying Data with Transact-SQL. This course provides full coverage of all the exam topics. We will demonstrate all the SQL code in action, with detailed explanation of the SQL statements. We will also provide the SQL code, so you can follow along.

Who this course is for:
  • SQL Server database developers and database administrations with at least a few years of experience working with SQL Server.
Course content
Expand all 40 lectures 03:28:06
+ Course overview
3 lectures 02:24

This is an overview of the material we are going to cover in this module. Plus, the Transact-SQL code we are going to use in downloadable SQL files.

Preview 00:28
Course requirements
00:57
Exam objectives
00:59
+ Create Transact-SQL SELECT queries
10 lectures 51:38
Identify proper SELECT query structure
00:55
The FROM clause
11:51
The SELECT clause
02:04
The ORDER BY clause
03:52
Write specific queries to satisfy business requirements
01:30
Construct results from multiple queries using set operators
09:18
Distinguish between UNION and UNION ALL behavior
06:23
Identify the query that would return expected results based on provided table st
00:09
Section quiz
7 questions
Exercises
00:03
+ Query multiple tables by using joins
5 lectures 21:15
JOIN overview
00:36
Construct multiple JOIN operators using AND and OR
05:58
Write queries with NULLs on joins
04:08
Section quiz
4 questions
Exercises
00:03
+ implement functions and aggregate data
10 lectures 58:03
Functions overview
02:57
Scalar valued and table valued functions
09:05
Identify the differences between deterministic and non-deterministic functions
02:46
Use built-in aggregate functions
04:15
Date-related functions
05:25
Arithmetic functions
01:58
String functions
07:43
System functions
16:07
Section quiz
10 questions
Exercises
00:03
+ Modify data
10 lectures 01:14:41
Overview
02:00
Dynamic SQL
09:02
Cursors
09:54
The UPDATE statement
13:21
The DELETE statement
04:34
Load data to a table based on its structure and constraints
01:54
The OUTPUT clause
12:26
The effect of DDL statements on supplied tables and data
13:22
Section quiz
7 questions
Exercises
00:03