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.
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
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.”
”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.”
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”.
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
Do you want more info about these courses?