More than 11 hours of contents
T-SQL is Microsoft’s dialect of SQL. SQL (Structured Query Language) is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements.
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.
7 modules with lessons, labs and demos:
Lab
Lab
Lab
Lab
About labs
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.
T-SQL is Microsoft’s dialect of SQL. SQL (Structured Query Language) is a standardized computer language that was originally developed by IBM for querying, altering and defining relational databases, using declarative statements.
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.