Email: it@huph.edu.vn

Data Science Courses

Udemy - Complete SQL for Data Analytics and Business Intelligence 2025-1

0 students Last updated Aug 2025

About the course

Udemy - Complete SQL for Data Analytics and Business Intelligence 2025-1

Course content

Sections: 22

•

Activities: 1

•

Resources: 149

Announcements
1 Data Roles and Responsibilities

1 Section Introduction
2 Database Servers and Clients
3 Local Set up Mac
4 Local Set up Windows
5 Getting Familiar with pgAdmin

1 Database and Schema
2 Tables
3 Multiple databases and schemas
4 Creating a Database

1 Section Introduction
2 Numeric Data Types
4 Character Data Types
5 Date and Time Data Types
6 Boolean Data Type
7 Other Important Data Types
8 Creating a Table
9 Inserting Data into Table

1 Section Introduction
2 The SELECT statement
3 Common String Operators and Functions
4 Using Comments in SQL

1 Section Introduction
2 The WHERE Clause
3 Comparison operators in WHERE Clause
4 Using WHERE with a List of Values
5 Using WHERE within a specified range
6 Using WHERE with pattern matching
7 Compound WHERE Clause

1 Section Introduction
2 Updating Records in a Table
3 Deleting Records from a Table
4 Dropping a Table from Database

1 Section Introduction
2 One to Many and Many to One Relationships
3 One to One and Many to Many Relationships
4 Primary Keys
5 Foreign Keys
6 Foreign Key Constraint on Delete
7 Foreign Key Constraint on Insert
8 Other Column Constraints
9 Getting Table Schema Information

1 Section Introduction
2 Preparing Dataset
3 Why do we need Joins
4 Inner Join
5 Left Outer Join
6 Right Outer Join
7 Full Outer Join
8 Exercise 1
9 Table and Column Alias
10 Exercise 2
11 Exercise 3
12 Exercise 4
13 Join with Filter

1 Section Introduction
2 Aggregate Functions
3 Why do we group records
4 Visualizing GROUP BY Operation
5 Combining Grouping and Aggregation
6 Exercise Using Aggregation with Grouping
7 Filtering Groups
8 Using WHERE and HAVING Together

1 Section Introduction
2 Sorting Records
3 Limiting and Skipping Records

1 Section Introduction
2 What is a Subquery
3 Where is a Subquery Used
4 Subquery in SELECT Clause
5 Subquery in FROM Clause
6 Subquery in JOIN Clause
7 Subquery in WHERE Clause
8 Correlated Subquery

1 Quick Recap
2 Section Introduction
3 Analytics Data Setup
4 Exercise 1 Calculate the total revenue
5 Solution Exercise 1
6 Exercise 2 Identify the top selling products
7 Solution Exercise 2
8 Exercise 3 Calculate the Average Order Value AOV
9 Solution Exercise 3
10 Exercise 4 Calculate the Customer Lifetime Value CLV
11 Solution Exercise 4
12 Exercise 5 Identify customers who have not made a purchase in a while
13 Solution Exercise 5
14 Exercise 6 Show the most recent review for each product
15 Solution Exercise 6
16 Exercise 7 Identify the top rated products
17 Solution Exercise 7
18 Exercise 8 Calculate discount based on order value
19 Solution Exercise 8

1 Section Introduction
2 Explicit Type Casting
3 Implicit Type Casting

1 Section Introduction
2 Current Date and Time
3 Time Zone Conversions
4 Truncating Date and Timestamp
5 Example Truncating Date and Timestamp
6 Extracting Parts of Date and Timestamp
7 Formatting Date and Timestamp
8 Date Math

1 Section Introduction
2 What is an Array
3 Adding Columns of Array Data Type
4 Inserting Data into Array Columns
5 Filtering Records Based on Array Values
6 Array Indexing
7 Array Functions
8 Array Aggregation
9 Exercise Array Aggregation
10 Flattening of Arrays

1 Section Introduction
2 What is JSON
3 Adding Columns of JSON Data Type
4 Inserting Data into JSON Columns
5 Accessing JSON Fields
6 Filtering Records Based on JSON Fields
7 Constructing JSON Objects
8 JSON Aggregation

1 Section Introduction
2 Data Setup
3 The RANK Window Function
4 The DENSE_RANK Window Function
5 The ROW_NUMBER Window Function
6 The LAG and LEAD Window Function
7 LAG Function A Practical Use Case

1 Section Introduction
2 Common Table Expressions CTEs In Detail

1 Section Introduction
2 Data Setup
3 Handling Missing Values
4 Handling Duplicates
5 Handling Outliers
6 Standardizing Values in Categorical Columns
7 Standardizing Text Data
8 Consistent Format for Numeric Data

1 Section Introduction
2 Importing Data From CSV to PostgreSQL Database
3 Exploratory Data Analysis EDA
4 Identifying Sales Trends
5 Date Dimension Table and Fact Table
6 A Generic and Reusable Date Dimension Table
7 Top Business Categories By Sales
8 Year over Year YoY Sales Analysis
9 Quick Recap of the Key Concepts

1 Data Analyst Data Scientist Roadmap

Instructors

Enrolment options

Udemy - Complete SQL for Data Analytics and Business Intelligence 2025-1

Udemy - Complete SQL for Data Analytics and Business Intelligence 2025-1

Course modified date: 27 Aug 2025

Udemy - Complete SQL for Data Analytics and Business Intelligence 2025-1

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

Guests cannot access this course. Please log in.