Unlock the power of SQL Server—fast! 🚀
In just one hour, you'll master the six key clauses of SELECT and gain a rock-solid foundation in T-SQL—perfect prep for your next data job interview.
Follow expert instructor Phillip Burton as he walks you through SQL Server Management Studio, how to create and query tables, use joins, write views and procedures, and even connect your data to Excel. Whether you're just starting out or need a refresher, this practical and instructive tutorial will get you querying like a pro.
Timestamps:
00:00 Intro & What You'll Learn
01:07 Opening SQL Server Management Studio
04:48 Creating Your First Database
06:01 Understanding Tables & Data Types
09:01 Populating a Table with Data
13:02 Writing Your First SELECT Query
25:33 Using SELECT with FROM and WHERE
34:00 Understanding JOINs (Product Table Example)
41:06 Filtering Rows with WHERE Clause
52:00 Summing Data with GROUP BY
56:27 Filtering Aggregates with HAVING
59:52 Sorting Results with ORDER BY
1:02:5...
Suggested Credits
Tags, Events, and Projects