Microsoft 20761: Querying Data with Transact-SQL

This certification is a key requirement for following jobs:

• Database Designer
• Database Administrator
• Data Analyst

Basic Knowledge of Microsoft Operating System

There is no exam associate with this training course.

• Describing key capabilities and components of SQL Server
• Describing T-SQL, sets, and predicate logic
• Writing a single table SELECT statement
• Writing a multi-table SELECT statement
• Writing SELECT statements with filtering and sorting
• Describing how SQL Server uses data types
• Writing DML statements
• Writing queries that use built-in functions
• Writing queries that aggregate data
• Writing subqueries
• Creating and implementing views and table-valued functions
• Using set operators to combine query results
• Writing queries that use window ranking, offset, and aggregate functions
• Transforming data by implementing pivot, unpivot, rollup and cube
• Creating and implementing stored procedures
• Adding programming constructs such as variables, conditions, and loops to T-SQL code

This course is likely to add to the employment-related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

• University Students
• Database Designers
• Database Administrators
• Data Analysts

• Introduction to Microsoft SQL Server 2016
• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables
• Sorting and Filtering Data
• Working with SQL Server 2016 Data Types
• Using DML to Modify Data
• Using Built-In Functions
• MGrouping and Aggregating Data
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Offset, Windows Ranking, and Aggregate Functions
• Pivoting and Grouping Sets
• Executing Stored Procedures
• Programming with T-SQL
• Implementing Error Handling
• Implementing Transactions

Course 20762B Developing SQL Databases