Querying Data with Transact-SQL (MS-20761)

Seminarbeschreibung:

• 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
• Grouping and Aggregating Data
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Windows Ranking, Offset, and Aggregate Functions
• Pivoting and Grouping Sets
• Executing Stored Procedures
• Programming with T-SQL
• Implementing Error Handling
• Implementing Transactions

The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.