h264, yuv420p, 1280x720 |ENGLISH, aac, 44100 Hz, 2c channels | 6h 45 mn | 3.55 GB

Created by: CubeTech Academy, LLC.

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-761) exam.

A comprehensive and practical course designed to help you pass the Microsoft SQL 2016 (70-761) exam.

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