This is an intensive 2-day online course running from August 24th – 25th inclusive.  MicroWarehouse trading partners can avail of our heavily discounted rate of €450 per candidate.  Please ensure you have cleared your calendar before registering as no refunds will be offered for cancellations made within 7 days of course commencement and places are limited.

Learn how to query and manipulate data by using Transact-SQL (T-SQL), the language used in Microsoft SQL Server and Azure SQL services. In this course you will gain the foundational knowledge required to write efficient queries, retrieve and filter data, and work with relational databases. The course is designed for data professionals, developers, and anyone working with data who wants to build core SQL skills and helps learners prepare for the DP-080: Querying Data with Microsoft Transact-SQL certification.

Target Audience

• Data professionals and analysts working with databases
• Developers working with SQL Server or Azure SQL
• IT professionals managing or querying data
• Professionals preparing for the DP-080 certification

Prerequisites

• Basic understanding of databases and data concepts
• Familiarity with basic computer operations
• Some exposure to data-related workloads is beneficial

Course Contents

1 – Introduction to Transact-SQL

• Understand relational database concepts
• Explore SQL Server and Azure SQL
• Write basic SELECT statements

2 – Querying tables

• Retrieve data from tables
• Filter results using WHERE clauses
• Sort and limit query results

3 – Querying multiple tables

• Understand joins and relationships
• Use INNER, LEFT, and RIGHT joins
• Combine data from multiple sources

4 – Using built-in functions

• Work with string and numeric functions
• Use date and time functions
• Apply logical and system functions

5 – Grouping and aggregating data

• Use GROUP BY and HAVING
• Calculate aggregates such as SUM and AVG
• Generate summarised reports

6 – Modifying data

• Insert, update, and delete data
• Understand data integrity principles
• Use transactions to manage changes

7 – Working with subqueries and views

• Use subqueries for complex queries
• Create and query views
• Simplify query logic

8 – Programming with T-SQL

• Use variables and control-of-flow logic
• Create stored procedures
• Implement error handling