Advanced Querying SQL Databases using T-SQL Training

Training Calendar

Training

Date

Training Time

Delivery Methods

Advanced Querying SQL Databases ...

<h3>About Training</h3><p>This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.</p><br /><h3>Who Should Attend</h3><p>IT Professionals who will be writing queries for use with Microsoft SQL Server from SQL 2005 to 2016. Non-technical &#39;power users&#39; will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.</p><p>The course is aimed at both non-technical &#39;power users&#39; and IT Professionals who will be writing queries for use with Microsoft SQL Server.</p><br /><h3>Outline</h3><ul><li>Module 1: Using Table Expressions</li><li>Module 2: Using Set Operators</li><li>Module 3: Using Window Ranking, Offset, and Aggregate Functions</li><li>Module 4: Pivoting and Grouping Sets</li><li>Module 5: Programming with T-SQL</li><li>Module 6: Implementing Error Handling</li><li>Module 7: Implementing Transactions</li></ul><br />

<h3>About Training</h3><p>This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.</p><br /><h3>Who Should Attend</h3><p>IT Professionals who will be writing queries for use with Microsoft SQL Server from SQL 2005 to 2016. Non-technical &#39;power users&#39; will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.</p><p>The course is aimed at both non-technical &#39;power users&#39; and IT Professionals who will be writing queries for use with Microsoft SQL Server.</p><br /><h3>Outline</h3><ul><li>Module 1: Using Table Expressions</li><li>Module 2: Using Set Operators</li><li>Module 3: Using Window Ranking, Offset, and Aggregate Functions</li><li>Module 4: Pivoting and Grouping Sets</li><li>Module 5: Programming with T-SQL</li><li>Module 6: Implementing Error Handling</li><li>Module 7: Implementing Transactions</li></ul><br />

Training Details

Training Time

Capacity

Prerequisites

Documents

About Training

This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.

Who Should Attend

IT Professionals who will be writing queries for use with Microsoft SQL Server from SQL 2005 to 2016. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.

The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.