Master Sql For Data Analysis: From Beginner To Advanced

Master Sql For Data Analysis: From Beginner To Advanced
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

Learn SQL from scratch for data analysis, BI, and data science. Write queries, optimize, and work with cloud databases!

What you’ll learn

Master SQL for Data Analysis – Follow a structured, hands-on approach to transform raw data into meaningful insights.

Solve Real-World Data Challenges – Work on practical, project-based problems that mimic real business scenarios.

Write Powerful SQL Queries for Data Manipulation – Learn to extract, filter, aggregate, and transform complex datasets efficiently.

Unlock the Power of Joins & Multi-Table Analysis – Master INNER, LEFT, RIGHT, FULL, SELF, and CROSS JOINs to combine data like a pro.

Analyze Trends with Window Functions – Use RANK, LAG, LEAD, NTILE, and more to perform advanced data analysis.

Optimize Performance for Big Data – Learn best practices for indexing, query tuning, and handling millions of records with ease.

Master Subqueries & Common Table Expressions (CTEs) – Break down complex problems into manageable, efficient queries.

Requirements

This course is suitable for all learners and no knowledge required and who want to strengthen their skills and prepare for Data Analysis.

Description

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Installation: Mac

Lecture 3 Installation: Windows
Section 3: Database & Schema

Lecture 4 Database Operations

Section 4: Tables

Lecture 5 Create Base Tables

Lecture 6 Insert into Tables

Lecture 7 Create and Drop Tables

Section 5: Basics

Lecture 8 Select Columns

Lecture 9 Experiments: Select

Lecture 10 Experiments: Select 2

Lecture 11 Experiments: Select (Without Tables)

Lecture 12 Experiments: Mathematical Expression

Lecture 13 Distinct

Lecture 14 Experiments: Distinct

Lecture 15 Key Takeaways: Distinct

Lecture 16 Aggregate Functions

Lecture 17 Key Takeaways: Aggregate Functions

Lecture 18 Customer and Orders: Select

Section 6: String Functions

Lecture 19 String Functions

Lecture 20 Sub-Strings

Lecture 21 Concat

Lecture 22 Key Takeaways: String Functions

Lecture 23 Length

Section 7: Limiting Records

Lecture 24 Limit & Offset

Lecture 25 Key Takeaways: Limit & Offset

Section 8: Alias

Lecture 26 Alias

Lecture 27 Key Takeaways: Alias

Section 9: Filters

Lecture 28 Filters with Numeric

Lecture 29 Key Takeaways: Numeric

Lecture 30 Filters with String

Lecture 31 Key Takeaways: String

Lecture 32 Filters with Date

Lecture 33 Key Takeaways: Date

Lecture 34 Filters with Boolean

Lecture 35 Key Takeaways: Boolean

Lecture 36 IN Clause

Lecture 37 Experiments: IN

Lecture 38 Key Takeaways: IN

Lecture 39 Between

Lecture 40 Key Takeaways: Between

Lecture 41 Like

Lecture 42 Experiments: Like

Lecture 43 Key Takeaways: Like

Section 10: Changing Data Types

Lecture 44 Cast: Decimal & Integers

Lecture 45 Key Takeaways: Cast

Section 11: Handling Data

Lecture 46 Default Values

Lecture 47 Handling Null

Section 12: Data Analysis

Lecture 48 Case: Conditional Functions

Lecture 49 Coalesce

Lecture 50 Null IF

Section 13: Keys & Constraints

Lecture 51 Keys: Primary, Foreign & Composite Key

Lecture 52 Constraints: Unique

Lecture 53 Constraints: Check

Section 14: Sub-Queries

Lecture 54 Inner Queries

Lecture 55 Experiments: Inner Queries

Section 15: Union & Intersect

Lecture 56 Union

Lecture 57 Experiments: Union

Lecture 58 Union All

Lecture 59 Experiments: Union All

Lecture 60 Intersect

Section 16: Group By

Lecture 61 Group By

Lecture 62 Group By with Having

Lecture 63 Group By with Filters

Lecture 64 Experiments: Group By

Section 17: Sorting: Order By

Lecture 65 Order By

Lecture 66 Order By with Filters

Section 18: Joins

Lecture 67 Introduction: Inner Join

Lecture 68 Example: Inner Join

Lecture 69 Introduction: Left Join

Lecture 70 Example: Left Join

Lecture 71 Example: Right Join

Section 19: Views

Lecture 72 Views

Lecture 73 Experiments: Views

Lecture 74 Materialized: Views

Section 20: Data Manipulation Language

Lecture 75 Insert Rows

Lecture 76 Update Rows

Lecture 77 Delete Rows

Lecture 78 Alter Tables

Section 21: Temporary Tables

Lecture 79 Temp Tables

Section 22: Functions – UDFs

Lecture 80 User Defined Functions

Section 23: SQL with Python

Lecture 81 Mac: Python Installation

Lecture 82 Python – SQL Connectivity

Aspiring Data Analysts & Business Analysts,Data Scientists & Machine Learning Enthusiasts,Marketing & Sales Professionals,Finance & Operations Analysts,Software Developers & Engineers