Simple play icon Course

Querying Data Using T-SQL

by Ami Levin

Whether you are just starting with SQL Server, or an experienced SQL developer looking to make a switch to T-SQL, this course will provide solid foundations and essential understanding of how SQL\T-SQL work, to query data and troubleshoot effectively.

What you'll learn

SQL can seem simple enough to the unsuspecting eye, but without a solid grasp on its core concepts, you can quickly get lost. In this course, Querying Data Using T-SQL, you will gain the ability to query data with T-SQL. More importantly, you will understand exactly how the database processes your queries. This will allow you to write elegant queries, troubleshoot code effectively, and save you months of frustration as you advance on your SQL path. First, you will learn what SQL and T-SQL are, where they came from, and where they are heading. Next, you will discover query execution processing and how everything in SQL revolves around it. Finally, you will explore how to use every clause of the SELECT query, and you will be able to quickly query data yourself, understand exactly how your queries work, and therefore be able to troubleshoot and optimize them. When you’re finished with this course, you will have the skills and knowledge to query data effectively in T-SQL and feel right at home with it!

About the author

Ami has been teaching, consulting, and mentoring data professionals for over 20 years. Ami's broad theoretical knowledge in data management is complemented by extensive hands-on experience working as a data tier architect, performance tuning expert, and a SQL developer, while at the same time directing and teaching others how to get the most value from their data. Ami owns a US patent for an automatic solution for optimizing database performance. Ami has been highly involved in the SQL communit... more

Ready to upskill? Get started