SQL Querying Course Leeds Classroom

Practical SQL Querying Leeds Course | Introduction to SQL Querying

Learn practical SQL querying skills in Central Leeds, Yorkshire, UK

Practical SQL Querying Course in Central Leeds

This Leeds City Centre located course will provide you with the core knowledge and skills to create queries using Structured Querying Language (SQL).

Winter Deals - Exceptional Offers - VIEW NOW!

Topics ADDED FREQUENTLY include: Agile | PRINCE2 | .NET / C# | SQL | Train the Trainer

Practical SQL Querying Leeds Classroom Schedule

Need other locations? Scroll down for further delivery options or Contact Us to discuss your requirements.

Date (DMY) *1DurationLocationQA Fee*Fee - Discounts Available
27/03/2024 2 Days Central Leeds £2274 £895 Book Now »
19/06/2024 2 Days Central Leeds £2274 £895 Book Now »
*1 Event Start 9:00 | End 17:00. Time Zone Information: UK Local Time unless Time Zone indicated for event. Part-time sessions typically 3 hours duration
Symbols: W/E = Weekend Course MORN = Morning Session AFT = Afternoon Session EVE = Evening Session

* QA pricing from their website 15/10/2023. QA class sizes up to 16 possibly mixed Virtual and In-Person attendees on the same event. Prices INCLUDE VAT.

Practical SQL Querying Course - Additional Locations and Deliveries

Practical SQL Querying Virtual Course »

Practical SQL Querying Bristol Course »

Practical SQL Querying Edinburgh Course »

Practical SQL Querying London Course »

Practical SQL Querying Manchester Course »

Practical SQL Querying Sheffield Course »

Practical SQL Querying Leeds Course Introduction

Achieve your next career step by attaining skills in this sought-after data querying language!

This course will provide you with the core knowledge and skills to create queries using Structured Querying Language (SQL). The course syntax is primarily that of ANSI / ISO SQL so the majority of the content is relevant to Microsoft, Oracle, MySQL and other database systems.

It will teach you how to select, filter and sort data from multiple tables and how to use views, functions and stored procedures. Additionally it introduces intermediate techniques to create efficient queries relevant to most businesses.

Each learner is provided with access to the full SQL Server product and utilises SQL Server Management Studio (SMSS) to progress through the exercises.

The course delivery includes discussions, presentations and a high ratio of hands-on exercises to build your knowledge, skills and confidence in data querying.

Certification and Related Examinations

The course is designed to provide practical concepts and skills for querying SQL databases and as such this will help build skills for certification programs without covering the breadth of any particular certification.


The audience for this course is very wide as databases are used by the vast majority of organisations and querying skills are beneficial to businesses and employees alike. This course is designed for anyone with a requirement to query SQL data either to produce reports or as part of a developer role. It is aimed at an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.

Example audience roles include:

  • Human Resources employees requiring Data Querying and Report Writing skills
  • Software Developers new to SQL
  • Project Managers - SQL skills are a common requirement on projects
  • Development Team Managers
  • Professionals with data related roles
  • Business Analysts
  • Report Writers

Contact us for an informal chat about the value of learning SQL.

At Course Completion

After completing this Practical SQL Querying Leeds Course, students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server
  • Understand at a practical level the concepts that underpin SQL Queries
  • Have working knowledge of SQL Server Management Studio
  • Write SELECT queries - including ORDER BY
  • Query multiple tables - Joins and Subqueries
  • Sort and filter data - using WHERE and HAVING
  • Describe the use of key data types in SQL Server
  • Use key built-in functions
  • Group and aggregate data - including key Aggregate Functions
  • Use Subqueries
  • Use Table Expressions - including Views, TVFs, Derived Tables and CTEs
  • Use Set Operators - UNION, EXCEPT and INTERSECT
  • Understand Windowing Functions including ROWNUMBER, RANK, NTILE
  • Understand Pivoting and Grouping Sets
  • Execute Stored Procedures
  • Modify data using Transact-SQL

Contact us to discuss the course objectives.


The course is designed for an entry level audience and also to refresh and build skills for those who already have some SQL querying experience.

To attend you'll simply need basic PC literacy and Business English.

Please contact us for further information and an informal discussion about how SQL querying skills will be of use to you.

Course Materials

Materials include courseware, hands-on learning environment and related subject matter.

Course Outline - Two Days Duration

The public course duration is two days - for onsite, part-time and weekend courses this may vary.

Module 01: Introduction to Querying with Microsoft SQL Server

The first module provides the necessary background to allow understanding of the key concepts and associated terminology required to achieve core SQL querying skills. Once these are attained, the technical documentation provided with SQL Server will become more accessible and a further benefit will be ease of communication with persons holding technical roles.

Lessons and Labs

  • Simplified Introduction to Sets, Relations and Normalisation
  • Simple Entity Relationship Modelling
  • The Concepts of Keys: Primary, Surrogate, Unique and Foreign Keys
  • The Concept of NULL
  • SQL Server’s Architecture
  • SQL Server Management Studio (SSMS)

Module 02: Basic Single-Table Queries

This module covers the core concepts and skills for using the SELECT Statement. The WHERE clause and predicate logic are examined as is ORDER BY. Column level aliases and logical processing order are introduced.

Lessons and Labs

  • Simple SELECT Statements with Column Level Aliases
  • Computed Columns Column Level Aliases
  • WHERE clause with logical operators and common predicates
  • ORDER BY clause and collations
  • Logical Order Processing
  • Simple and Searched CASE Expressions
  • Overview of the LIKE operator
  • Introduction to UNION and UNION ALL

Module 03: Exploration of Basic Data Types, Functions and NULL

This module explores the more common data types and functions.

Lessons and Labs

  • Numerics Exact and Approximate
  • Character String Data Types and String Functions
  • Aggregate – Common Aggregate Functions including AVG, COUNT, MAX, MIN and SUM
  • Date and Time Data Types and Functions
  • Querying data with NULL values using IS NULL

Module 04: Comprehensive Single-Table Queries

This module introduces comprehensive usage of the SELECT Statement and its main clauses.

Lessons and Labs

  • Queries using GROUP BY with Aggregate Functions and HAVING
  • Using Table Level Aliases and Examining Logical Processing Order
  • Querying VIEWs
  • SQL Server’s TOP Operator to Limit Rows Presented - Time Permitting

Module 05: Joining Multiple Tables

This module introduces joining tables using the SQL 92 JOIN syntax.

Lessons and Labs

  • Table and Column Level Aliases with Multiple Tables

Module 06: Understanding Subqueries

This module covers additional querying strategies where joins are not sufficient.

Lessons and Labs

  • Self-Contained, Scalar and Multi-Valued Subqueries – using WHERE and IN
  • Correlated Subqueries

Module 07: Using Table Expressions

This module explores the concepts of Table Expressions. These include Views, Table Valued Functions (TVFs), Derived Tables and Common Table Expressions (CTEs).

Lessons and Labs

  • Creating Simple Views
  • Querying a VIEW including ORDER BY
  • Creating Simple Table Valued Functions (TVFs)
  • Querying a Table Valued Function with a Parameter
  • Querying from a Derived Table
  • Querying from a Common Table Expression
  • Querying using APPLY (Time Permitting)

Module 08: Additional Set Operators and Further NULL Data Querying

This module introduces the remaining Set Operators which allow the combining and comparison of queries and further strategies for querying NULL values.

Lessons and Labs

  • Review of Querying with UNION and UNION ALL
  • Querying with INTERSECT and EXCEPT
  • Querying with NULLIF, COALESCE and ISNULL

Module 09: Pivoting and Grouping Sets

This module discusses more advanced manipulations of data.

Lessons and Labs

  • Introducing PIVOT and UNPIVOT
  • Introducing GROUPING SET
  • Introducing ROLLUP and CUBE

Module 10: Stored Procedure and Dynamic SQL Overview

This module introduce Stored Procedures are typically encapsulated SQL statements that are stored within the database. Dynamic SQL, queries generated from text or parameters, is also introduced.

Lessons and Labs

  • Simple Stored Procedures and Stored Procedures with Parameters
  • Dynamic SQL using EXECUTE and ‘sp_executesql’

Module 11: Window Functions Introduction

This module provides a high-level introduction to the SQL Windowing Functions.

Lessons and Labs

  • Introducing Queries with ROWNUMBER, RANK, DENSE_RANK and NTILE

Module 12: Maintaining Data – Optional Content

This module introduces the key concepts of maintaining data.

Lessons and Labs

  • Considerations for NULL data
  • The IDENTITY Function to generate unique values (Time Permitting)
  • Using MERGE to maintain data (Time Permitting)

© 2023 TrainX Limited | Privacy Policy | Practical SQL Querying Leeds Course | Introduction to SQL Querying Course