Querying Data Using T-SQL

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.
Course info
Rating
(50)
Level
Beginner
Updated
Sep 19, 2019
Duration
2h 7m
Table of contents
Description
Course info
Rating
(50)
Level
Beginner
Updated
Sep 19, 2019
Duration
2h 7m
Description

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
About the author

Ami is a senior instructor and mentor with over 25 years of experience in data tier architecture, data modeling, database design, and SQL development.

More from the author
PostgreSQL Data Manipulation Playbook
Intermediate
2h 35m
Apr 25, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello future SQL master. You've come to the right place to begin your T-SQL adventure. My name is Ami, and I've been living, breathing, working, speaking, and teaching SQL data in databases for longer than I would like to admit. I'm honored to be your guide for this ride. SQL is one of very few technologies that manage to survive for five decades, and even today, is still one of the most widely-used and most loved programming languages. And there are very good reasons for that. SQL is math, SQL is science, and SQL is art. Join me on this magical exploration of the essence of SQL. It doesn't matter if you're taking your first steps on the SQL path, or if you're an experienced developer, you'll find this course extremely valuable. My goal for you is to understand how SQL works, rather than show you how to use the syntax. Syntax is much better spelled out than the documentation. I'll show you the real magic of SQL, that which you won't find online. I'll help you make the switch to thinking in sets and warn you of the logical challenges and common pitfalls you'll encounter. This is what this course is about, getting you on the right track to become a SQL master with a solid foundation and a deep understanding. We'll begin with an overview of the SQL jargon and the tools we'll need. Then we'll quickly dive into the intricacies of SQL. You will learn about the underlying concepts of SQL and their relational model counterparts. You will realize how data is processed by every clause of the select query. You'll understand how to prepare source data, how to filter it effectively, and how to handle the complications of missing data. You'll learn to appreciate the subtleties involved in combining multiple rows and about the capabilities of SQL in supporting presentation, ordering, and paging. I'll also point out when it is best to avoid these altogether. This course is like nothing you've ever taken before. Are you ready to take the red pill and jump into the SQL rabbit hole? What are you waiting for? Let's get started.