facebook pixel
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...

 94.3k

 1.4k

 60

 94.3k

    Suggested Credits
    Tags, Events, and Projects