| Course Date | 21st May, 2026 |
|---|
| Duration | 2 Days |
|---|
| Location | Live Virtual Classroom |
|---|
QA Learning Fee
(for comparison) | £2,154
(qa.com: 10/01/2025) |
|---|
| Standard Fee | £695 (Automatically applied 10% saving for multiple attendees) |
|---|
View Course »
Make Enquiry »
Practical SQL Querying Course Learning Objectives
After completing this Practical SQL Querying Virtual 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
- Manage and execute queries using 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
IMPORTANT - Private Purchases Only (not relevant to business purchases): Online "Business to Consumer" ("B2C") transactions
legally require a 14 day "cooling off" period. In case you need your Product or Service before 14 days then you have the right to waive this.
Please view our
Terms and Conditions (opens in a separate window) or contact us for further information.