2-day workshop
Basic training: Writing T-SQL Queries
This basic T-SQL training is intended for anyone who wants to learn how to write effective queries to retrieve and manipulate data from relational databases. The session starts with the fundamentals of SQL and relational databases and builds up step by step towards more advanced querying techniques.
Attendees learn how to select, filter, sort and modify data, but also how to perform more complex operations such as joins, aggregations and subqueries. In addition, attention is paid to more advanced topics such as functions, temporary tables and query performance.
The training is strongly practice-oriented: theory is continuously alternated with exercises so that attendees can immediately apply and deepen what they have learned.
Learning goals
- Explaining the basic principles of SQL and relational databases
- Retrieving data using SELECT statements
- Filtering and sorting query results with WHERE and ORDER BY
- Modifying data with INSERT, UPDATE and DELETE
- Performing calculations and grouping data with aggregate functions
- Combining tables with JOINs
- Working with subqueries and Common Table Expressions (CTEs)
- Applying functions in queries
- Working with dates, variables and temporary tables
Level
Beginner
Topics