Developed in-house by SolidQ, this T-SQL Fundamentals course is intended for T-SQL developers, DBAs, data scientists and power users who work with SQL Server or Azure SQL Database and need to write queries and develop code using Transact-SQL—SQL Server’s dialect of the standard ANSI-SQL language. 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 topics covered in the course include: Background to T-SQL Querying and Programming; Single-Table Queries; Joins; Subqueries; Table Expressions; Set Operators; Window Functions, Pivot, Unpivot and Grouping Sets; Data Modification; Temporal Tables; Transactions; 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.
This course is intended for:
- T-SQL Programmers and DBAs, Data Scientists, Architects, Analysts and Power Users
- Those who need to write or review code in SQL Server 2012 – 2019, Azure SQL Database
Before attending this course, it is recommended that students have the following skills:
- Familiarity with basic relational database concepts and SQL
Upon completion of this course, the student will be able to:
- Understand the logic behind T-SQL and thinking in terms of sets
- Write T-SQL code to create tables and define data integrity
- Write queries against single and multiple tables
- Write T-SQL statements that modify data
- Get familiar with T-SQL programmable objects
This course was developed by Itzik Ben-Gan, a mentor and one of the founders of SolidQ, author of award winning books about T-SQL, a columnist in SQL Server Pro magazine, a Microsoft Data Platform MVP since 1999, and a regular speaker in SQL Server related events.