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
(13)
Level
Beginner
Updated
Sep 19, 2019
Duration
2h 7m
Table of contents
Description
Course info
Rating
(13)
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
[Autogenerated] Hello, Future sequel Master, you've come to the right place to begin your tea sequel adventure. My name is Amy, and I've been living, breathing, working, speaking and teaching sequel data and databases for longer than I would like to admit I'm honored to be. Your guide for this right sequel is one of very few technologies that managed 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. Sequel is Math Sequel is Science and Sequel is Art. Join me on this magical exploration off the essence of sequel. It doesn't matter if you're taking your first steps on the sequel path, or if you're an experienced developer, you'll find this course extremely valuable. My goal for you is to understand how sequel works rather than show you how to use this in text. Syntax is much better spelled out in the documentation. I'll show you the real magic of sequel, that which you won't find online. I'll help you make the switch to thinking in sets and warn you off 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 sequel master. With a solid foundation and a deep understanding, we'll begin with an overview of the sequel jargon and the tools will need. Then we'll quickly dive into the intricacies of sequel. You learn about the underlying concepts of sequel and their relational model counterparts. You'll realize how data is processed by every claws. Off 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 learn to appreciate the subtleties involved in combining multiple rows and about the capabilities of sequel in supporting, presentation, ordering and paging. I 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 sequel Rabbit Hope? What are you waiting for? Let's get started