Introduction
If you are already familiar with SQL but want to delve deeper and write more complex queries, this training is for you.
You will learn how to perform joins between tables that do not have direct relationships using join criteria.
You will also learn how to create Sub Queries in an easy way using
Common Table Expressions.
Additionally, you will learn how to create database objects with T-SQL and how to manipulate the data in
tables.
Target Audience
This 1-day course is a continuation of the module “T-SQL Queries Introduction (1 day)” and is interesting for people who already have some experience with working with T-SQL and want to learn how to write more complex queries to extract even more from their data.
Prerequisites
The topics covered in “T-SQL Queries Introduction (1 day)” are assumed to be known.
Information
Interested in this training? Click here for more information.
Topics
- Join on multiple columns
- Common Table Expressions: Sub Queries + Recursive (Parent – Child)
- Ranking
- CRUD operations: INSERT, UPDATE + DELETE in combination with Queries
- CREATE/DROP: Tables, Views, Scalar Valued Functions
- Performance Tuning + Indexes
- Transactions + Locking