The main purpose of this 5 day instructor-led 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.

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused: report writers, business analysts, and client application developers.

Course will be held in English.

• Module 1: Introduction to Microsoft SQL Server 2016
• Module 2: Introduction to T-SQL Querying
• Module 3: Writing SELECT Queries
• Module 4: Querying Multiple Tables
• Module 5: Sorting and Filtering Data
• Module 6: Working with SQL Server 2016 Data Types
• Module 7: Using DML to Modify Data
• Module 8: Using Built-In Functions
• Module 9: Grouping and Aggregating Data
• Module 10: Using Subqueries
• Module 11: Using Set Operators

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

• Exam code: 70-761
• This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

Gregor Papež, MCT