MCSA 70-761 Querying Data with Transact-SQL
- 2.9
Brief Introduction
A Detailed practical course designed to help you pass the Microsoft SQL 2016 (70-761) exam.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.
Requirements
- Requirements
- Sql server 2016