Microsoft Data & Power BI
Querying Data with Transact-SQL 55366
Five days to confident T-SQL.
5 daysIntermediate16 modules
About this course
Five days to confident T-SQL. You will write single and multi-table queries, join and filter, use data types, insert, update and delete data, use functions, subqueries, table expressions, set operators, window functions and programming constructs.
What you'll learn
- Write single-table and multi-table SELECT queries with filtering and sorting
- Use JOINs, subqueries, and table expressions to combine and structure data
- Apply built-in, aggregate, and window functions for analysis
- Work with stored procedures, parameters, and transactions
- Implement error handling and best practices for reliable query execution
Curriculum
16 modules
- What is Transact-SQL
- The SELECT statement
- The WHERE clause
- Sorting results
- Calculations and CASE expressions
- The JOIN clause
- Inner, outer, self, and cross joins
- ORDER BY clause
- WHERE clause filtering
- Limiting rows returned
- NULL handling
- String and temporal data types
- Data type usage best practices
- Insert new records
- Update existing data
- Delete data safely
- Function types in SQL Server
- Data conversion functions
- Logical functions
- Handling NULL s
- Aggregation methods
- GROUP BY and HAVING clauses
- Filtering aggregated results
- Scalar, multi-valued, and correlated subqueries
- Using EXISTS with subqueries
- Views
- Table-valued functions
- Derived tables
- Common table expressions (CTEs)
- UNION , INTERSECT , and EXCEPT
- APPLY operator
- Understanding and implementing window functions
- Data pivoting
- Grouping sets for advanced aggregations
- Executing stored procedures
- Input/output parameters
- Creating simple procedures
- Using dynamic SQL
- Loops and conditions
- SQL Server error handling methods
- Structured exception handling
- Transaction concepts
- Implementing transactions in T-SQL
Who it's for
Database professionals, developers and analysts.
Before you start
- Basic understanding of relational databases.
- Basic Windows knowledge.
Related courses
More in Microsoft Data & Power BI →IntermediateDP-080T00
DP-080T00 Query and modify data with Transact-SQL
Microsoft Data & Power BI
View course →Foundation
SQL Fundamentals - Part 1: Essential Querying Skills
Microsoft Data & Power BI
View course →Foundation
SQL Querying Fundamentals Part 2
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.