SQL for Data Analytics: Write Queries That Actually Scale (Full Course)

📥 Download the PowerPoint & All Queries: https://www.dondata.ai This is a complete SQL (T-SQL) course for data analytics — from basic SELECT queries to advanced indexing and performance optimization. In this 4+ hour course, you’ll learn how analysts, BI professionals, and data engineers actually use SQL to query, analyze, and optimize data in real-world scenarios. This course is designed for: • Data analysts • BI professionals • Aspiring analytics engineers • Anyone who wants to move beyond basic SQL syntax 📌 What you’ll learn in this course: • SELECT, WHERE, ORDER BY • Aggregations and GROUP BY • JOINs and set operations • Data types and conversions • Mathematical, string, and date/time functions • Subqueries and Common Table Expressions (CTEs) • INSERT, UPDATE, DELETE • Database design, tables, and constraints • Views, temporary and temporal tables • Stored procedures, functions, and triggers • Transactions and concurrency • Performance monitoring and execution plans • Indexing strategies and performance pitfalls 🧠 How to use this course: You can watch it end-to-end or jump to specific chapters using the timestamps. Each section builds on the previous one, but the video is also designed as a long-term reference. 📥 Setup Links: • Microsoft SQL Server Management Studio (SSMS) – free: https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16 • SQL Server Developer Edition – free: https://www.microsoft.com/en-us/sql-server/sql-server-downloads • Demo database used in the course: https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak ⚠️ This is not a 10-minute SQL crash course. This is a structured, in-depth SQL course focused on data analytics and real-world usage. Chapters are included to help you navigate the content. Chapters: 00:00:00 Intro: Course Overview & What is SQL? 00:03:01 Querying Data: SELECT, TOP, and ORDER BY 00:07:21 Querying Data: Column Aliases & Formatting 00:35:02 Grouping Data: Aggregations and GROUP BY 00:42:32 Joining Data: INNER, LEFT, and RIGHT Joins 01:04:07 Set Operators: UNION, INTERSECT, and EXCEPT 01:08:07 Data Types: Understanding Numeric, String and Date/Time Types 01:24:40 Mathematical Functions: Numeric Data Operations 01:30:21 String Functions: Concat and Text Manipulation 01:39:26 Date and Time Functions: Working with Offsets and UTC 01:48:07 Sub-Queries: Nested Queries & CTEs 02:02:08 Export Results 02:02:58 Modify Data: INSERT, UPDATE, and DELETE 02:10:24 Database Design: Relational Logic & Normalization 02:21:28 Creating Tables: Defining Schema and Structure 02:25:17 Constraints: Primary Keys, Foreign Keys, & Cascading 02:40:57 Temporary & Temporal Tables: Session Data & Versioning 02:45:58 Views: Simplifying Complex Queries 02:48:50 Procedural Control: Variables and Logic Flow 03:00:23 Functions: Scalar and Table-Valued Functions 03:05:05 Pivot and Unpivot: Data Transformation 03:09:36 Window Calculations: Rankings and Partitions 03:15:20 Stored Procedures: Reusable SQL Scripts 03:28:13 Triggers: Automating Database Actions 03:31:37 Transactions: Ensuring Data Integrity 03:39:45 Performance Monitoring: Statistics and Logical Reads 03:49:11 Indexes: Clustered vs. Non-Clustered Optimization 04:03:07 Performance Insights: Execution Plans and Comparison