Next Dates
Please contact us for a private delivery!
5 days / 40 hours | online / onsite
Developed by Lucient-co-founder Itzik Ben-Gan, the T-SQL Fundamentals course focuses on an fundamental understanding of T-SQL and its usage in SQL Server as well as in Azure SQL Database.
Developed and delivered by Itzik Ben-Gan, this T-SQL Fundamentals course is intended for T-SQL developers, DBAs, data scientists, analysts, and power users. Those who work with SQL Server or Azure SQL and need to write queries and develop code using Transact-SQL—SQL Server’s dialect of the ISO/IEC and ANSI standards for the language SQL. The course covers querying topics, including retrieving and modifying data, and also provides an overview of programmable objects supported by SQL Server.
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 focuses on the foundations of T-SQL explaining the logic behind the language and its elements.
There are many aspects of SQL that are very different than in other programming languages. This course will help you adopt the right state of mind and get a true understanding of the language elements. You will learn how to think in terms of sets and follow good SQL programming practices.
The course is not version specific; it does, however, cover language elements that were introduced in recent versions of SQL Server. For recently added elements, the instructor will specify the version in which the element was introduced.
The course covers core SQL topics, which are delivered in lecture and discussion format. Those include: Background to T-SQL Querying and Programming; Single-Table Queries; Joins; Subqueries; Table Expressions; Set Operators; T-SQL for Data Analysis; Data Modification. The course also provides SQL-supporting topics as self-study units. Those include: Temporal Tables; Transactions and Concurrency; SQL Graph Overview; Overview of Programmable Objects.
To complement the learning experience, students will be provided with exercises that will enable them to practice what they’ve learned.
Note: If you are an experienced T-SQL practitioner and are looking for an Advanced T-SQL course that dives deeply into the complexities of T-SQL Querying and Programming including coverage of performance and query tuning aspects, please see the course Advanced T-SQL Querying, Programming and Tuning for SQL Server by Itzik Ben-Gan.
Lab 01
Lab 02
LAB 03
LAB 04
LAB 05
LAB 06
LAB 07
LAB 08
LAB 09
LAB 10
LAB 11
Co-Founder & T-SQL Trainer
Itzik Ben-Gan is a T-SQL Trainer and Co-Founder of Lucient. A Microsoft Data Platform MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including T-SQL Fundamentals, T-SQL Querying and T-SQL Window Functions. He has a monthly column at sqlperformance.com. Itzik’s speaking activities include PASS summit, SQLBits and various user groups around the world. Itzik is the author of Lucient’s Advanced T-SQL and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
Each student will receive:
• A course Workbook
• A digital copy of Itzik Ben-Gan’s award-winning book T-SQL Querying (MSPress)
• A copy of the course’s source code
This course is intended for:
It is recommended that students are familiar with basic relational database concepts and SQL.
Upon completion of this course, the student will: