Microsoft SQL Server with Transact-SQL - 5 days Online Classroom

Microsoft SQL Server with Transact-SQL - 5 days Online Classroom

Build the practical SQL Server skills needed to work confidently with Microsoft databases. This hands-on course takes you from essential Transact-SQL (T-SQL) concepts to advanced querying techniques, enabling you to retrieve, transform, and manage data efficiently. Through live instructor-led training and practical labs using SQL Server Management Studio (SSMS), you'll learn how to write powerful queries, optimise performance, work with multiple tables, and create scalable database solutions for real-world business environments

Key Features

• Course and material in english
• Beginner - Intermediate level
• 5 days of live instructor-led virtual training (8 hours / day)
• Interactive hands-on live labs
• All relevant course materials
• 60+ recommended study hours
• Certificate included

Learning Outcomes

• Writing effective SQL queries: Learn how to retrieve, filter, and organise data using core SQL statements. You'll use SELECT, WHERE, ORDER BY, DISTINCT, and OFFSET-FETCH to produce accurate, well-structured results for reporting, analysis, and everyday database tasks.
• Joining data across multiple tables: Develop the skills to combine related data using INNER, OUTER, CROSS, and SELF joins. You'll also use table aliases to create clearer, more maintainable queries for working with complex relational databases.
• Working with subqueries and conditional logic: Enhance your SQL queries with subqueries and conditional expressions. You'll use standalone and correlated subqueries alongside CASE statements to filter data, apply business logic, and generate more dynamic query results.
• Advanced SQL for reporting and analysis: Master advanced SQL features including views, Common Table Expressions (CTEs), derived tables, pivoting, and window functions. These techniques enable you to build efficient queries, perform sophisticated data analysis, and create powerful business reports.

Target Audience

• Database Administrators (DBAs)
• SQL Developers and Database Developers
• Data Analysts and Business Intelligence professionals
• Software Developers working with SQL Server
• Business Analysts who need to query and analyse data
• IT professionals looking to strengthen their Microsoft SQL Server and T-SQL skills

Prerequisites

• A basic understanding of relational database concepts
• Familiarity with tables, rows, and columns
• Some experience using SQL or another database platform is helpful but not essential
• General computer literacy and basic Windows skills

Course Outline

Day 1: SQL Fundamentals and Querying

• Understand database concepts, schemas, tables, keys, indexes, and data types.
• Navigate and use SQL Server Management Studio (SSMS).
• Write, filter, sort, and customise SELECT queries.
• Combine query results using UNION, INTERSECT, EXCEPT, and APPLY.
• Summarise data with aggregate functions and GROUP BY.
• Filter grouped results using HAVING and advanced grouping techniques.

Day 2: Working with Data and Functions

• Query multiple tables using INNER, OUTER, CROSS, and SELF joins.
• Simplify complex queries with table aliases.
• Apply numeric and mathematical SQL functions.
• Manipulate text using character functions.
• Format and calculate dates and times.
• Perform date arithmetic and extract date components.

Day 3: Data Manipulation and Subqueries

• Convert data types and work with NULL values.
• Use CASE expressions for conditional logic.
• Create standalone and correlated subqueries.
• Query efficiently using the EXISTS predicate.
• Insert, update, merge, and delete database records.
• Manage transactions and maintain data integrity.

Day 4: Advanced SQL Techniques

• Create views, derived tables, CTEs, and table-valued functions.
• Use advanced grouping with GROUPING SETS, ROLLUP, and CUBE.
• Transform data with PIVOT and UNPIVOT.
• Analyse data using window aggregate functions.
• Apply ranking functions for ordered results.
• Use window offset functions for advanced reporting.

Day 5: Database Objects and Performance

• Create, modify, and manage tables, constraints, and temporary tables.
• Work with sequences, synonyms, and database metadata.
• Create and optimise indexes for faster queries.
• Understand filtered, included, and indexed views.
• Explore metadata using INFORMATION_SCHEMA and sys views.
• Analyse and optimise SQL query performance.

FAQ

When is the class held?

The majority of the class is a full-day online course from morning to afternoon CET with 8 hours / day straight. However, please contact us to confirm the final detailed schedules.

Is this course suitable for developers and data analysts?

Yes. The course is designed for developers, data analysts, and IT professionals who need to query, analyse, and manage data in Microsoft SQL Server. It provides practical T-SQL skills for reporting, application development, and database management.

Will I learn how to write SQL SELECT queries?

Absolutely. You'll learn how to create SELECT statements, filter and sort data, and write efficient queries to retrieve accurate information from SQL Server databases.

What tools are used during the course?

Training is delivered using SQL Server Management Studio (SSMS), the standard Microsoft environment for writing, testing, and managing SQL Server queries and databases.

Will I learn how to improve SQL Server query performance?

Yes. The course covers query optimisation techniques, including indexing strategies, performance analysis, and metadata tools to help you identify bottlenecks and improve database efficiency.