Master SQL Server in 1 Hour: Essential T-SQL Crash Course 🚀
Learn the six key SELECT clauses and build a strong T-SQL foundation in just 60 minutes. Perfect for quick upskilling and boosting your SQL skills!

Udemy
92.7K views • Apr 25, 2019

About this video
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:58 Save Queries with Views
1:07:32 Create & Run Stored Procedures
1:11:03 Exporting to Excel with a Live Connection
1:15:36 Final Tips, Course Links & Practice Advice
👨🏫 Check out Phillip’s full course: https://www.udemy.com/course/70-461-session-2-querying-microsoft-sql-server-2012
📚 Explore all his courses: https://www.udemy.com/user/aquaviola/
💻 Learn more T-SQL topics on Udemy: https://www.udemy.com/topic/t-sql/
👍 Like the video if you found it helpful
💬 Drop a comment with your SQL questions
🔔 Subscribe for more practical tech tutorials!
#SQLServer #TSQL #DataAnalytics #LearnSQL #UdemyInstructor
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:58 Save Queries with Views
1:07:32 Create & Run Stored Procedures
1:11:03 Exporting to Excel with a Live Connection
1:15:36 Final Tips, Course Links & Practice Advice
👨🏫 Check out Phillip’s full course: https://www.udemy.com/course/70-461-session-2-querying-microsoft-sql-server-2012
📚 Explore all his courses: https://www.udemy.com/user/aquaviola/
💻 Learn more T-SQL topics on Udemy: https://www.udemy.com/topic/t-sql/
👍 Like the video if you found it helpful
💬 Drop a comment with your SQL questions
🔔 Subscribe for more practical tech tutorials!
#SQLServer #TSQL #DataAnalytics #LearnSQL #UdemyInstructor
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
92.7K
Likes
1.4K
Duration
01:16:31
Published
Apr 25, 2019
User Reviews
4.7
(18) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now