fbpxl

Private Onsite | On-demand

T-SQL Fundamentals

Do you want to write accurate, effective, and robust T-SQL code? If you want to learn T-SQL the right way, understanding the logic behind the language by learning not only the how but also the why, do not miss these courses!

This is your chance to learn T-SQL using practical cases with our mentors!

Main Benefits

Understand the logic behind T-SQL and thinking in terms of sets.

l

Write queries against single and multiple tables.

Get familiar with T-SQL programmable objects.

~

Write T-SQL code to create tables and define data integrity.

+

Write T-SQL statements that modify data.

Expert Mentors.

Upcoming Dates

There are no scheduled classes for this course at the moment. Please, send us an information request to find out more.
ON-DEMAND.

Course Delivery Options

Private Onsite.

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity.

On-demand.

Learn whenever you want, wherever you want, at your own pace. Study the topics chosen by MVPs and experts.

Pre-requisites

This course is intended both for people who just started working with SQL Server, as well as those with some experience. If you are self-taught, and gained your knowledge “by the seat of your pants,” this course can fill the gaps in your knowledge and teach you how to think correctly in SQL terms. This course doesn’t get into performance discussions and advanced problems* rather focuses on the logical aspects of T-SQL. Note though that it is not merely a step-by-step course. It doesn’t just focus on syntactical elements of T-SQL, rather explains the logic behind the language and its elements. It’s recommended to be familiar with basic relational database concepts and SQL.

After this course

This on-demand course provides you with strong foundations, teaching you both about the many T-SQL elements that you need to use when writing queries, and also how to think in SQL, set-based terms. It helps you write accurate, effective, and robust code.

Many SQL intro/fundamentals classes only teach you about the language elements and how to use them, but not about their mathematical roots or why the language elements were designed the way they were designed. This course teaches you both. It emphasizes the unique elements of SQL and the mindset you need to adopt, like thinking in relational terms; thinking of a set as a whole, with no ordering; what the language guarantees and what it doesn’t; common pitfalls and bugs, and best practices to avoid them.

Following this T-SQL Fundamentals course, you will be ready to take our Advanced T-SQL course, if you want to go deeper in this path.

“Itzik’s course opened my eyes and helped me re-discover the passion I have for solving problems using creative and efficient methods.”

John Smith

DBA

”Excellent. I never thought what else I need to learn more in T-SQL.I never realized there is such a deeper world of SQL.”

“I can see why people love T-SQL. Being able to learn from Itzik has been a pleasure.”

Jason Harris

DBA

Instructors

Itzik Ben-Gan

Itzik Ben-Gan is a mentor and one of the founders of SolidQ, author of award-winning books about T-SQL (which are considered the standard go-to resource on the topic), a columnist at SQLPerformance.Com, a Microsoft Data Platform MVP since 1999, and a regular speaker in SQL Server-related events.

Herber Albert

Herbert Albert is a Mentor and Managing Director of SolidQ’s Central and Eastern Europe subsidiary. Herbert co-authored “SQL Server Upgrade Technical Reference Guide” for SQL Server 2008 and 2012 and the Microsoft Press book “SQL Server 2005 Step-by-Step Applied Techniques”.

Public Class Outline

Module 1. Background to T-SQL Querying and Programming.
  • Theoretical Background 
  • SQL Server’s Architecture 
  • SQL Server Management Studio 
  • Creating Tables 
  • Defining Data Integrity 
  • Sample Database

Lab 01

Module 2. Single Table Queries.
  • Elements of SELECT Statement 
  • Predicates and Operators 
  • CASE Expressions  
  • NULLs 
  • All-At-Once Operations 
  • Working with Character Data 
  • Working with Date and Time Data 
  • Querying Metadata

Lab

Module 3. Joins.
  • Joins 
  • Cross Joins 
  • Inner Joins 
  • Further Join Examples 
  • Outer Joins

Lab

Module 4. Subqueries.
  • Self-Contained Subqueries 
  • Correlated Subqueries 
  • Scalar Subqueries 
  • Multi-Valued Subqueries 
  • EXISTS 
  • Beyond the Fundamentals of Subqueries

Lab

Module 5. Table Expressions.
  • Derived Tables 
  • Common Table Expressions 
  • Views 
  • Inline Table-Valued Functions 
  • APPLY

Lab

Module 6. Set Operators.
  • Set Operators, Described 
  • UNION 
  • INTERSECT 
  • EXCEPT 
  • Precedence 
  • Circumventing Unsupported Logical Phases

Lab

Module 7. Beyond the Fundamentals of Querying.
  • Window Functions 
  • Pivoting Data 
  • Unpivoting Data 
  • Grouping Sets

Lab

Module 8. Data Modification.
  • Inserting Data 
  • Deleting Data 
  • Updating Data 
  • Merging Data 
  • Modifying Data through Table Expressions 
  • Modifications with TOP / OFFSET-FETCH 
  • OUTPUT

Lab

Module 9. Temporal Tables.
  • Temporal Tables, Described 
  • Creating Tables 
  • Modifying Tables 
  • Querying Temporal Tables

Lab

Module 10. Transactions and Concurrency.
  • Transactions 
  • Locks and Blocking 
  • Isolation Levels 
  • Deadlocks

Lab

Module 11. Programmable Objects.
  • Variables 
  • Batches 
  • Flow Elements 
  • Cursors 
  • Temporary Tables 
  • Dynamic SQL 
  • Routines 
  • Error Handling

On-Demand Course Outline

Module 1. Introduction and agenda.
Module 2. Single Table Queries.
  • Elements of SELECT
  • Predicates and Operators
  • CASE Expressions
  • NULLs
  • All-At-Once Operations
  • Working with Character Data
  • Querying Metadata

Lab

Module 3. Joins.
  • Cross Joins
  • Inner Joins
  • Further Join Examples
  • Fundamentals of Outer Joins
  • Beyond the Fundamentals of Outer Joins

Lab

Module 4. Subqueries.
  • Self-Contained Subqueries
  • Correlated Subqueries
  • Beyond the Fundamentals of Subqueries

Lab

Module 5. Table Expressions.
  • Derived Tables
  • Common Table Expressions
  • Views and Inline Table – Valued Functions
  • APPLY

Lab

Module 6. Set Operators.
  • Set Operators
  • Precedence and Circumventing Unsupported Logical Phases

Lab

Module 7. Beyond the Fundamentals of Querying.
  • Window Functions
  • Pivoting Data
  • Unpivoting Data
  • Grouping Sets

Lab

Contact us

Do you want more info about these courses?

  • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.

Invite & Earn

X
Signup to start sharing your link
Signup