Querying Data with Transact-SQL
Format
Self-paced
Price
£199
About the course
Develop practical database querying and data manipulation skills through a series of self-paced, hands-on labs focused on Transact-SQL (T-SQL), the language used to interact with Microsoft SQL Server databases.
The course introduces learners to writing and executing SELECT queries, combining result sets with set operators, retrieving data from multiple tables using joins, and applying functions to transform and analyse information.
Learners will explore working with aggregate data, built-in functions, subqueries, APPLY operators, and table expressions to create more advanced queries.
Additional labs cover modifying data, pivoting and grouping results, working with temporal tables and non-relational data, and using stored procedures and views to organise reusable database logic.
The course also addresses error handling, data types, and NULL values to help learners write reliable queries and manage different data scenarios effectively.
The labs connect SQL concepts with practical database tasks, helping learners retrieve, filter, combine, summarise, and manipulate data efficiently.
Activities also reinforce query structure, data accuracy, reusable database objects, and appropriate handling of errors and missing values, supporting the development of robust database solutions.
By completing the labs, learners will develop foundational skills in T-SQL querying, joins, set operations, functions, aggregation, subqueries, table expressions, data modification, pivoting, temporal data, stored procedures, views, and error handling.
The course provides a practical foundation for further study in SQL development, database reporting, data analysis, and Microsoft SQL Server administration.
The course introduces learners to writing and executing SELECT queries, combining result sets with set operators, retrieving data from multiple tables using joins, and applying functions to transform and analyse information.
Learners will explore working with aggregate data, built-in functions, subqueries, APPLY operators, and table expressions to create more advanced queries.
Additional labs cover modifying data, pivoting and grouping results, working with temporal tables and non-relational data, and using stored procedures and views to organise reusable database logic.
The course also addresses error handling, data types, and NULL values to help learners write reliable queries and manage different data scenarios effectively.
The labs connect SQL concepts with practical database tasks, helping learners retrieve, filter, combine, summarise, and manipulate data efficiently.
Activities also reinforce query structure, data accuracy, reusable database objects, and appropriate handling of errors and missing values, supporting the development of robust database solutions.
By completing the labs, learners will develop foundational skills in T-SQL querying, joins, set operations, functions, aggregation, subqueries, table expressions, data modification, pivoting, temporal data, stored procedures, views, and error handling.
The course provides a practical foundation for further study in SQL development, database reporting, data analysis, and Microsoft SQL Server administration.
Course Lessons
