Querying Data with Transact-SQL

Request more details:

submit request
Description:
This course - 20761B is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
Prerequisites:
Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of relational databases.
Introduction to Microsoft SQL Server 2016:
The Basic Architecture of SQL Server
SQL Server Editions and Versions
Getting Started with SQL Server Management Studio
Introduction to T-SQL Querying:
Introducing T-SQL
Understanding Sets
Understanding Predicate Logic
Understanding the Logical Order of Operations in SELECT statements
Writing SELECT Queries:
Writing Simple SELECT Statements
Eliminating Duplicates with DISTINCT
Using Column and Table Aliases
Writing Simple CASE Expressions
Querying Multiple Tables:
Understanding Joins
Querying with Inner Joins
Querying with Outer Joins
Querying with Cross Joins and Self Joins
Sorting and Filtering Data:
Sorting Data
Filtering Data with Predicates
Filtering Data with TOP and OFFSET-FETCH
Working with Unknown Values
Working with SQL Server 2016 Data Types:
Introducing SQL Server 2016 Data Types
Working with Character Data
Working with Date and Time Data
Using DML to Modify Data:
Inserting Data
Modifying and Deleting Data
Using Built-In Functions:
Writing Queries with Built-In Functions
Using Conversion Functions
Using Logical Functions
Using Functions to Work with NULL
Grouping and Aggregating Data:
Using Aggregate Functions
Using the GROUP BY Clause
Filtering Groups with HAVING
Using Subqueries:
Writing Self-Contained Subqueries
Writing Correlated Subqueries
Using the EXISTS Predicate with Subqueries
Using Table Expressions:
Using Views
Using Inline Table-Valued Functions
Using Derived Tables
Using Common Table Expressions
Using Set Operators:
Writing Queries with the UNION operator
Using EXCEPT and INTERSECT
Using APPLY
Using Windows Ranking, Offset, and Aggregate Functions:
Creating Windows with OVER
Exploring Window Functions
Pivoting and Grouping Sets:
Writing Queries with PIVOT and UNPIVOT
Working with Grouping Sets
Executing Stored Procedures:
Querying Data with Stored Procedures
Passing Parameters to Stored procedures
Creating Simple Stored Procedures
Working with Dynamic SQL
Programming with T-SQL:
T-SQL Programming Elements
Controlling Program Flow