This is an awesome Microsoft practice lab course that can help you advance your knowledge and pass the 70-761 certification exam. This training is intended for those who want to know more about Transact-SQL. It is structured so that the initial segment of the substance can be educated as a course to the individuals requiring the additional learning for different courses in the SQL Server educational modules.

Description

Microsoft SQL Server is one the most well-known Relational Database Management System (RDBMS) utilized in the Microsoft universe. What's more, the 70-761: Querying Data with Transact SQL course is structured in a stage work. It begins with most major subjects like what is data and database. It goes to cutting-edge themes like working with triggers, put-away methods and files. This is a perfect start-up for those individuals who will discover their vocation in programming web or Windows applications utilizing C# or utilizing MSBI instruments for information exam and reports.
The principle aim of the course is to give the candidates a profound understanding of the Transact-SQL dialect used by all SQL Server-related controls, to be specific, Database Administration, Database Development, and Business Intelligence.

Prerequisites

The course comes with a basic and single requirement of having working knowledge regarding databases and basics of SQL Server Express. The understanding of Microsoft Windows for its basic functionality is also welcome. The system engineers, SQL Server database administrators, and developers who want to take the 70-761 exam must have at least two years of experience.

Course outline

• Portray key capacities and parts of SQL Server
• Make and actualize perspectives and table-esteemed capacities
• Compose a multi-table SELECT proclamation
• Portray T-SQL, sets, and predicate rationale
• Utilize set administrators to join question results
• Compose SELECT proclamations with separating and arranging
• Depict how SQL Server utilizes information types
• Compose DML explanations
• Compose a solitary table SELECT proclamation
• Compose subqueries
• Compose questions that utilization worked in capacities
• Compose inquiries that total information
• Change information by actualizing turn, 3D shape, UNPIVOT, and rollup 
• Make and actualize put-away strategies
• Include programming builds, for example, factors, conditions, and circles to T-SQL code

Course objectives

• Working with SQL Server 2016 Tools
• Querying Multiple Tables
• Using Table Expressions
• Using Built-In Functions
• Introduction to Transact-SQL Querying
• Implementing Error Handling
• Writing Basic SELECT Statements
• Using Subqueries
• Filtering and Sorting Data
• Using DML to Modify Data
• Using SET Operators
• Pivoting and Grouping Sets
• Programming with T-SQL
• Working with SQL Server 2016 Data Types
• Implementing Transactions 
• Grouping and Aggregating Data
• Using Windows Ranking, Offset, and Aggregate

Exam details

• The exam passing score is 700 marks out of 1000.
• The paper is possible to fill in the English language.
• The test leads to obtaining the MCSA and MCP certificates.

Exam topics

• Managing data with Transact-SQL 
• Querying data with advance Transact-SQL components 
• Programming databases with the usage of Transact-SQL

Target audience

• Database Administrators
• BI Professionals
• Database Developers

Conclusion

This Microsoft course is the excellent training that can increase your competence, highlight you among other specialists, and approve your insight and abilities.

Career path:

• Database Designers 
• Database Developers 
• Database Administrators 
• IT Managers 
• IT Directors 
• Systems Administrators 
• Sr. Systems Engineers

The certificate holder is capable of earning a basic salary from about $44,655 to $135,186 on yearly basis.