T-SQL Queries Advanced (1 day)

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.

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

Target Audience

This 1-day course is a continuation of the module "T-SQL Queries Advanced (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 Advanced (1 day)" are assumed to be known.

Information

Interested in this training? Click here for more information.