course
Querying Data with Transact-SQL
Learn the Transact SQL language to query SQL Server
Description
You will gain the technical skills required to write Transact-SQL queries for Microsoft SQL Server. What you learn is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
At the end of the course, you will be able to:
Describe the uses of the Transact-SQL language; Write queries to retrieve, modify and summarize data; Join data from multiple tables; Use advanced features of Transact-SQL; Consider different solution strategies to solve business questions;
This training is a combination of two other trainings: the first 3 days contain the basic features corresponding to the training 'Core Querying Data with Transact-SQL' (MSDP080). The last 2 days the advanced features correspond with the training 'Advanced Querying Data with Transact-SQL' (ADVQDTSQL).
Please note: we recommend participants with little experience to take this course in two parts. First MSDP080 and later ADVQDTSQL. Please don't hesitate to contact us when in doubt.
Check out 'Related courses' for more details!
Prior Knowledge
Basic knowledge of data and tables is recommended
Subjects
Core Querying Data:
- Introduction to Microsoft SQL Server
- Introduction to T-SQL Querying
- SELECT queries
- Combining data from multiple tables: JOINs
- Sorting and filtering data
- SQL Server data types
- Updating data with DML
- Using built-in functions
- Grouping and aggregating data
- Using subqueries
Advanced Querying Data:
- Table Expressions such as Views and Common Table Expressions
- Using set operators
- Using Window Ranking, Offset and Aggregate Functions
- Pivoting and Grouping Sets
- Executing Stored Procedures
- Programming with T-SQL
- Implementing Error Handling
- Implementing Transactions
Schedule
| Start date | Duration | Location | |
|---|---|---|---|
November 25, 2024November 26, 2024November 27, 2024November 28, 2024November 29, 2024 | 5 days | Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
March 10, 2025March 11, 2025March 12, 2025March 13, 2025March 14, 2025 | 5 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Trainers
Follow-up courses
"Extremely good teacher"Sander
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten