Querying Data with Transact-SQL (SQL 2016)

This course 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 and 5 teach the remaining skills required to take exam 70-761.

Before taking this course, students should have basic knowledge of the Microsoft Windows operating system and its core functionality, and working knowledge of relational databases.

5 Days/Lecture & Lab

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.

• Introduction to Microsoft SQL Server

• Introduction to T-SQL Querying

• Writing SELECT Queries

• Querying Multiple Tables

• Sorting and Filtering Data

• Working with SQL Server 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

Tanfolyam hossza:

Tanfolyam nettó ára:

Tanfolyam azonosító: