Email: it@huph.edu.vn

Udemy - 4-in-1 bundle MySQL, PostgreSQL, Microsoft SQL & Oracle SQL 2025-5

0 students Last updated Sep 2025

About the course

Udemy - 4-in-1 bundle MySQL, PostgreSQL, Microsoft SQL & Oracle SQL 2025-5

Course content

Sections: 25

•

Activities: 1

•

Resources: 203

Announcements
1 Introduction

2 This is a milestone

1 Installing PostgreSQL and pgAdmin in your System

1 Installing and Setting up MySQL

1 Installing and Setting up MS SQL

1 Installing and Setting up Oracle SQL

1 CREATE in PostgreSQL
2 CREATE in MySQL
3 CREATE in MS SQL
4 CREATE in OracleSQL
5 Exercise 1 Create DB and Table
7 INSERT in PostgreSQL
8 INSERT in MySQL
9 INSERT in MS SQL
10 INSERT in Oracle SQL
11 Import data from File in PostgreSQL
12 Import data from File in MySQL
13 Import data from File in MS SQL
14 Import data from File in Oracle SQL
15 Exercise 2 Inserting and Importing data
16 SELECT statement in PostgreSQL
17 SELECT statement in MySQL
18 SELECT statement in MS SQL
19 SELECT statement in Oracle SQL
21 SELECT DISTINCT in PostgreSQL
22 SELECT DISTINCT in MySQL
23 SELECT DISTINCT in MS SQL
24 SELECT DISTINCT in Oracle SQL
26 WHERE in PostgreSQL
27 WHERE in MySQL
28 WHERE in MS SQL
29 WHERE in Oracle SQL
31 Logical Operators in PostgreSQL
32 Logical Operators in MySQL
33 Logical Operators in MS SQL
34 Logical Operators in Oracle SQL
36 Exercise 3 SELECT WHERE Logical
37 UPDATE in PostgreSQL
38 UPDATE in MySQL
39 UPDATE in MS SQL
40 UPDATE in Oracle SQL
42 DELETE in PostgreSQL
43 DELETE in MySQL
44 DELETE in MS SQL
45 DELETE in Oracle SQL
47 ALTER Part 1 in PostgreSQL
48 ALTER Part 2 in PostgreSQL
49 ALTER in MySQL
50 ALTER in MS SQL
51 ALTER in Oracle SQL
53 Exercise 4 Update Delete and Alter Table

1 Restore and Back up
2 Debugging restoration issues
3 Creating DB using CSV files
5 Exercise 5 Restore and Back up

1 Restoring and Back up in MySQL
2 Restore and Back up in MySQL

1 Restoring and Back up in MS SQL
2 Restoring and Back up in MS SQL

1 Creating Db using CSV files in Oracle SQL

1 IN in PostgreSQL
2 IN in MySQL
3 IN in MS SQL
5 BETWEEN in PostgreSQL
6 BETWEEN in MySQL
7 BETWEEN in MS SQL
8 IN BETWEEN in Oracle SQL
10 LIKE in PostgreSQL
11 LIKE in MySQL
12 LIKE in MS SQL
13 LIKE in Oracle SQL
15 Exercise 6 In Like Between

1 Side Lecture Commenting in SQL
2 ORDER BY in PostgreSQL
3 ORDER BY in MySQL
4 ORDER BY in MS SQL
6 LIMIT in PostgreSQL
7 LIMIT in MySQL
8 LIMIT in MS SQL
9 ORDER BY LIMIT in Oracle SQL
11 Exercise 7 Sorting

1 AS in PostgreSQL
2 AS in MySQL
3 AS in MS SQL
4 AS in Oracle SQL

1 COUNT in PostgreSQL
2 COUNT in MySQL
4 SUM in PostgreSQL
5 SUM in MySQL
7 AVERAGE in PostgreSQL
8 AVERAGE in MySQL
10 MIN MAX in PostgreSQL
11 MIN MAX in MySQL
13 Aggregate Functions in MS SQL
14 Aggregate Functions in Oracle SQL
15 Exercise 8 Aggregate functions

1 GROUP BY in PostgreSQL
2 GROUP BY in MySQL
3 GROUP BY in MS SQL
5 HAVING in PostgreSQL
6 HAVING in MySQL
7 HAVING in MS SQL
8 GROUP BY HAVING in Oracle SQL
10 Exercise 9 Group By

1 CASE WHEN in PostgreSQL
2 CASE WHEN in MySQL
3 CASE WHEN in MS SQL
4 CASE WHEN in Oracle SQL

1 Introduction to Joins
2 Concepts of Joining and Combining Data
3 Preparing the data
4 Inner Join in PostgreSQL
5 Inner Join in MySQL
6 Inner Join in MS SQL
7 Inner Join in Oracle SQL
9 Left Join in PostgreSQL
10 Left Join in MySQL
11 Left Join in MS SQL
13 Right Join in PostgreSQL
14 Right Join in MySQL
15 Right Join in MS SQL
17 Full Outer Join in PostgreSQL
18 Full Outer Join in MySQL
19 Full Outer Join in MS SQL
21 Left Right Full Outer Join in Oracle SQL
22 Cross Join in PostgreSQL
23 Cross Join in MySQL
24 Cross Join in MS SQL
25 Cross Join in Oracle SQL
27 Intersect and Intersect ALL in PostgreSQL
29 Intersect in MySQL
30 Except in PostgreSQL
32 Except in MySQL
33 Union in PostgreSQL
35 Union in MySQL
36 Intersect Except Union in MS SQL
37 Intersect Except Union in Oracle SQL
38 Exercise 10 Joins

1 Subqueries Subquery in WHERE clause in PostgreSQL
3 Subqueries Subquery in FROM clause in PostgreSQL
5 Subqueries Subquery in SELECT in PostgreSQL
7 Subqueries in MySQL
8 Subqueries in MS SQL
9 Subqueries in Oracle SQL
10 Exercise 11 Subqueries

1 VIEWS in PostgreSQL
2 VIEWS in MySQL
3 VIEWS in MS SQL
4 VIEWS in Oracle SQL
6 INDEX in PostgreSQL
7 INDEX in MySQL
8 INDEX in MS SQL
9 INDEX in Oracle SQL
12 Exercise 12 Views

1 LENGTH in PostgreSQL
2 LENGTH in Oracle SQL
4 UPPER LOWER in PostgreSQL
5 UPPER LOWER in Oracle SQL
7 REPLACE in PostgreSQL
8 REPLACE in Oracle SQL
10 TRIM LTRIM RTRIM in PostgreSQL
11 TRIM LTRIM RTRIM in Oracle SQL
13 CONCATENATION in PostgreSQL
14 CONCATENATION in Oracle SQL
16 SUBSTRING in PostgreSQL
17 SUBSTRING in Oracle SQL
19 LIST AGGREGATION in PostgreSQL
20 LIST AGGREGATION in Oracle SQL
21 String Functions Part 1 in MySQL
22 String Functions Part 2 in MySQL
23 String Functions in MS SQL
24 Exercise 13 String Functions

1 CEIL FLOOR in PostgreSQL
3 RANDOM in PostgreSQL
4 SETSEED in PostgreSQL
5 ROUND in PostgreSQL
7 POWER in PostgreSQL
9 Mathematical Functions in MySQL
10 Mathematical Functions in MS SQL Part 1
11 Mathematical Functions in MS SQL Part 2
12 Mathematical Functions in Oracle SQL
13 Exercise 14 Mathematical Functions

1 CURRENT DATE TIME in PostgreSQL
3 AGE in PostgreSQL
4 EXTRACT in PostgreSQL
5 Date Time Functions in MySQL
6 Date Time Functions in MS SQL
7 Date Time Function in Oracle SQL
8 Extract in Oracle SQL
9 Exercise 15 Date time functions

1 Data Type conversion to string in PostgreSQL
3 Data Type conversion to Number and Date in PostgreSQL
5 Data Type conversion in MySQL
6 Data Type conversion in MS SQL
7 Data Type conversion in Oracle SQL

1 PATTERN MATCHING BASICS
3 Advanced pattern matching Part 1 REGULAR EXPRESSIONS
4 Advanced pattern matching Part 2 REGULAR EXPRESSIONS
5 Pattern matching in MySQL
6 Pattern matching in MS SQL
7 Pattern matching in Oracle SQL
8 Exercise 16 Pattern Matching
15 The final milestone

Instructors

Enrolment options

Udemy - 4-in-1 bundle MySQL, PostgreSQL, Microsoft SQL & Oracle SQL 2025-5

Udemy - 4-in-1 bundle MySQL, PostgreSQL, Microsoft SQL & Oracle SQL 2025-5

Course modified date: 9 Sept 2025

Udemy - 4-in-1 bundle MySQL, PostgreSQL, Microsoft SQL & Oracle SQL 2025-5

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

Guests cannot access this course. Please log in.