Email: it@huph.edu.vn

Udemy – The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero 2025-3

0 students Last updated Jul 2025

About the course

Udemy – The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero 2025-3

Course content

Sections: 28

•

Activities: 1

•

Resources: 291

Announcements
1 Introduction
2 Course Roadmap Structure
3 What is SQL and Databases
4 What is DBMS and SQL Server
5 Types of Databases
6 Types of SQL Commands
7 Why Learn SQL
8 Setup Install SQL Server SSMS Databases

1 Components of SQL
2 What is SQL Query
3 SELECT FROM
4 WHERE
5 ORDER BY
6 GROUP BY
7 HAVING
8 DISTINCT
9 TOP
10 Coding Execution Order
11 Cool SQL Stuff

1 CREATE
2 ALTER
3 22 DROP

1 INSERT
2 UPDATE
3 DELETE

1 Comparison operators
2 AND Operator
3 OR Operator
4 NOT Operator
5 BETWEEN Operator
6 IN Operator
7 LIKE Operators

1 Introduction to JOINs
2 NO JOIN
3 INNER JOIN
4 LEFT JOIN
5 RIGHT JOIN
6 FULL JOIN
7 LEFT ANTI JOIN
8 RIGHT ANTI JOIN
9 FULL ANTI JOIN
10 CROSS JOIN
11 How to Choose The Correct Join
12 Multiple Table Joins

1 Introduction to SET Operators
2 SET Rules Syntax
3 UNION
4 UNION ALL
5 EXCEPT
6 INTERSECT
7 Use Case Combine Information
8 Use Case Delta Detection
9 SET Operators Summary

1 Introduction to SQL Functions
2 CONCAT
3 UPPER LOWER
4 TRIM
5 REPLACE
6 LEN
7 LEFT RIGHT
8 SUBSTRING
9 Number Functions

1 What is Date Time
2 Overview Date Time Functions
3 DAY MONTH YEAR
4 DATEPART
5 DATENAME
6 DATETRUNC
7 EOMONTH
8 Use Cases Date Extraction
9 Compare Extract Functions
10 Intro to Formatting Casting
11 FORMAT
12 CONVERT
13 CAST
14 DATEADD
15 DATEDIFF
16 ISDATE
17 Date Time Summary

1 Introduction to NULLs
2 COALESC vs ISNULL
3 Handling NULL Data Aggregation
4 Handling NULL Mathematic Operations
5 Handling NULL Joining Data
6 Handling NULL Sorting Data
7 NULLIF
8 IS NULL IS NOT NULL
9 NULL vs Empty vs Blank
10 Handling NULL Data Policies
11 NULL Summary

1 Introduction to CAST Statements
2 Use Case Categorizing Data
3 CASE Rules
4 Use Case Mapping Values
5 Use Case Handling Nulls
6 CASE Statement Summary

1 Aggregate Functions
2 Window Functions vs Group By
3 Syntax of Window Functions
4 Window Partition By
5 Window Order By
6 Window Frame
7 Window Function Rules
8 Window Basic Summary

1 Introduction to Window Aggregate Functions
2 Window COUNT
3 Window SUM
4 Window AVG
5 Window MIN MAX
6 Use Case Rolling Running Total
7 Use Case Moving Average
8 Window Aggregate Functions Summary

1 Introduction to Ranking Functions
2 Window ROW_NUMBER
3 Window RANK
4 Window RENSE_RANK
5 ROW_NUMBER vs RANK vs DENSE_RANK
6 Use Cases TopBottom N Analysis
7 Use Cases Assign Unique IDs
8 Use Cases Identify Duplicates
9 Window CUME_DIST
10 Window PERCENT_RANK
11 Window NTILE
12 Window Ranking Function Summary

1 Introduction to Window Value Functions
2 Window MIN MAX
3 Use Case Month Over Month MoM
4 Use Case Customer Retention
5 Window FIRST LAST
6 Window Value Functions Summary

1 Challenges in Complex Projects
2 Introduction to Subquery
3 Why Subquery
4 Subquery Categories
5 Subquery Result Types
6 Subquery in FROM
7 How DB Executes Subquery
8 Subquery in SELECT
9 Subquery in JOIN
10 Subquery in WHERE
11 Subquery using IN Operator
12 Subquery using ALL ANY Operators
13 Correlated Subquery
14 Subquery using Exists
15 Subquery Summary

1 Introduction to CTE
2 Why CTE
3 How DB Executes CTE
4 CTE Types
5 Standalone CTE
6 Multiple Standalone CTE
7 Nested CTE
8 CTE Best Practices
9 Recursive CTE
10 CTE Summary

1 Database Structure Views
2 3 Levels Architecture
3 What is View
4 Views vs Tables
5 Use Case Central Logic
6 Views vs CTEs
7 CREATE ALTER DROP Views
8 How DB Executes View
9 Use Case Hide Complexity
10 Use Case Data Security
11 Use Case Flexibility
12 Use Case Multi Language
13 Use Case Data Warehouse
14 View Summary

1 Introduction to Tables
2 CTAS vs CREATEINSERT
3 CTAS vs Views
4 CTAS Syntax
5 Use Case Optimize Performance
6 How DB Executes CTAS
7 Use Case Snapshots
8 Use Case Data Warehouse
9 Introduction to TEMP Tables
10 TEMP Syntax Example
11 How DB Executes TEMP Tables
12 TEMP Table Use Cases
13 My opinion about TEMP Tables
14 Table Summary
15 Compare All Methods

1 Introduction to Stored Procedures
2 Basics of Stored Procedures
3 Parameters
4 Multi Queries in Stored Procedure
5 Variables
6 Control Flow IF ELSE
7 Error Handling TRY CATCH
8 Styling Stored Procedures
9 What are Triggers
10 Triggers Use Case

1 Introduction Indexes
2 Types of Indexes
3 Heap Structure
4 Clustered Index
5 NonClustered Index
6 Clustered vs NonClustered Index
7 How to Create INDEX
8 Composite Index
9 What is Columnstore Index
10 Process of Building Columnstore Index
11 Columnstore vs Rowstore Index
12 How to Create Coluimnstore Index
13 Unique Index
14 Filter Index
15 Choose Right Index
16 Monitor Usage
17 Monitor Missing Indexes
18 Monitor Duplicate Indexes
19 Update Statistics
20 Fragmentations
21 Execution Plan
22 SQL hints
23 Indexing Strategy

1 Introduction to Partitions
2 The Process of Partitions
3 Create Partitioned Tables
4 The Performance of Partitions

1 Introduction to Performance Tips
2 Performance Tips for Fetching Data
3 Performance Tips for Filtering
4 Performance Tips for Joining
5 Performance Tips for Aggregation
6 Performance Tips for Subquiers
7 Performance Tips for Table DDL
8 Performance Tips for Indexing
9 Performance Tipcs Summary

1 Introduction to AI SQL
2 What is ChatGPT Copilot
3 ChatGPT vs Copliot
4 How to Use Copilot
5 ChatGPT Prompt Structure
6 ChatGPT Prompts for SQL Developers
7 ChatGPT Prompts for SQL Learning

1 SQL Project Types
2 Intro to Data Warehouse DWH
3 What is ETL
4 ETL Methods
5 Get Project Resources
6 Notion for Project Management
7 Understand Project Requirements
8 Data Architecture Approaches
9 Design the Data Warehouse Layers
10 Draw DWH Architecture
11 Refine the Project Plan
12 Define The Naming Conventions
13 Prepare Your GIT Repo
14 Create The Database
15 Bronze Layer Analyze Source Systems
16 Bronze Layer DDL Create Tables
17 Bronze Layer Load Scripts
18 Bronze Layer Build Stored Procedure
19 Bronze Layer Document The Work
20 Silver Layer Exploring Data
21 Silver Layer DDL Create Tables
22 Silver Layer Load Script 1
23 Silver Layer Load Script 2
24 Silver Layer Load Script 3
25 Silver Layer Load Script 4
26 Silver Layer Build Stored Procedure
27 Silver Layer Document The Work
28 Gold Layer Data Modelling
29 Gold Layer Analysis
30 Gold Layer Build Dimension Customers
31 Gold Layer Build Dimension Products
32 Gold Layer Build Fact Sales
33 Gold Layer Draw The Data Model
34 Gold Layer Create Data Catalog
35 Gold Layer Document The Work

1 Introduction to EDA
2 Get Project Resources
3 Dimensions vs Measures
4 Database Exploration
5 Dimensions Exploration
6 Date Exploration
7 Measure Exploration
8 Magnitude Analysis
9 Ranking Analysis

1 Introduction to the Project
2 Change Over Time Analysis
3 Cumulative Analysis
4 Performance Analysis
5 Part to Whole Analysis
6 Data Segmentation
7 Build Customers Report
8 Build Products Report
9 Document Your Work in GIT

1 Congratulations THANK YOU Video

Instructors

Enrolment options

Udemy – The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero 2025-3

Udemy – The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero 2025-3

Course modified date: 6 July 2025

Udemy – The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero 2025-3

Enrolled students: There are no students enrolled in this course.

Guests cannot access this course. Please log in.