Email: it@huph.edu.vn

Udemy - The Complete Oracle SQL Bootcamp (2025) 2025-8

0 students Last updated Sep 2025

About the course

Udemy - The Complete Oracle SQL Bootcamp (2025) 2025-8

Course content

Sections: 25

•

Activities: 1

•

Resources: 222

Announcements
1 What is a Database
2 Why Oracle Database
3 What is a Table
4 UDEMY 101 How to Use Udemy Some Useful Tips Do not Skip
7 What is a Relational Database RDBMS
8 Entity Relationship Logic in Databases
9 What is Pluggable Database
10 Introduction to Database Objects
11 The Sample HR Schema Used in This Course
12 What is SQL

1 About the Database Installation
2 The Ways to Get a Database
3 Option 1 Installing VMware and VirtualBox on Windows
6 Option 1 Downloading Virtual Machine ImageIf the previous lecture didnt work
7 Option 1 Configuring the VMware Virtualization Software
8 Option 1 Configuring the Oracle VirtualBox Virtualization Software
9 Option 1 Configuring SQL Developer inside of the Virtual Machine
11 Option 2 Downloading And Installing Oracle Database
12 Option 2 Unlocking the HR Schema
13 Option 2 Configuring and Using the SQL Developer
14 Option 2 Installing Sample Schemas in Oracle Database
16 Option 3 Using Oracle Live SQL
18 SQL Statements Used in This Course

1 Oracle Data Types
2 What is a NULL Value
3 DESCRIBE Command
4 INFORMATION Command
6 SQL Statement Basics
8 Oracle Error Messages
10 Using SELECT Statements
12 Using Column Aliases
14 Quote Q Operator
16 DISTINCT and UNIQUE Operator
20 Concatenation Operators
22 Arithmetic Expressions and NULL Values

1 Using WHERE Clause
4 Comparison Operators
6 BETWEEN AND Operator
8 IN Operator
11 LIKE Operator
14 IS NULL Operator
16 Logical Operators AND OR NOT
19 Rules of Precedence

1 ORDER BY Clause
3 ASC and DESC Operators
6 NULLS FIRST and NULLS LAST Operators
8 ROWNUM ROWID in SQL
10 Oracle FETCH Clause

1 What is a Substitution Variable
3 Double Ampersand and DEFINE UNDEFINE Commands
5 ACCEPT and PROMPT Commands
7 SET VERIFY ON SET VERIFY OFF Commands

1 Single Row Functions
2 Character Functions Case Conversion LOWER UPPER INITCAP Functions
4 Character Functions Character Manipulation Functions Part 1
6 Character Functions Character Manipulation Functions Part 2 INSTR Function
8 Character Functions Part 3 TRIM LTRIM RTRIM Functions
10 Character Functions Part 4 REPLACE LPAD RPAD Functions
12 Numeric Functions
14 Nested Functions
16 Date Values Date Formats in Oracle
17 Date Functions Arithmetic Operations on Dates
19 Date Manipulation Functions in SQL

1 Conversion Functions
3 TO_CHAR TO_DATE TO_NUMBER Functions Part 1
5 TO_CHAR TO_DATE TO_NUMBER Functions Part 2
7 Null Related NVL NVL2 NULLIF COALESCE Functions

1 Oracle Conditional Expressions CASE Expressions
3 Oracle Conditional Expressions DECODE Function

1 Group Functions
2 AVG Function
4 COUNT Function
7 MAX Function
9 MIN Function
11 SUM Function
13 LISTAGG Function
15 Overview Of Group Functions

1 GROUP BY Clause Part 1
4 GROUP BY Clause Part 2
6 HAVING Clause
9 Nested Group Functions

1 What is a Join Oracle SQL Join Types
2 Creating a Join
3 Natural Join
5 Join with the USING Clause
7 Handling Ambiguous Column Names
9 Inner Join Join with the ON Clause
12 Multiple Join Operations
14 Restricting Joins
16 Self Join
18 Non Equijoins Joining Unequal Tables
20 OUTER JOINS
22 LEFT OUTER JOIN LEFT JOIN
24 RIGHT OUTER JOIN RIGHT JOIN
26 FULL OUTER JOIN FULL JOIN
28 Cross Join Cartesian Product Cross Product
30 Oracles Old Style Join Syntax ANSI vs Non ANSI Joins Part 1
31 Oracles Old Style Join Syntax ANSI vs Non ANSI Joins Part 2
32 Oracles Old Style Join Syntax ANSI vs Non ANSI Joins Part 3
34 The Differences Between The Inner Joins Outer Joins Equijoins Non Equijoins
36 Which Join Type Should You Use
37 Entity Relationship Models in DBMS How to Use Them with Joins

1 Using Subqueries
4 Single Row Subqueries
6 Multiple Row Subqueries
8 Multiple Column Subqueries
10 Using Subqueries as a Table
12 SCALAR Subqueries
14 Correlated Subqueries
16 EXISTS Operator Semijoins
19 NOT EXISTS Operator

1 Introduction to SET Operators in Oracle SQL
2 UNION and UNION ALL Operators
4 INTERSECT Operator
6 MINUS Operator
8 Matching Unmatched Queries in SET Operations
10 Using the ORDER BY Clause with SET Operators
12 Combining Multiple Queries Using the SET Operators

1 Data Definition Language DDL
2 Naming Rules Naming Conventions in Oracle
3 CREATE TABLE Statement
5 CREATE TABLE AS SELECT CTAS Statement in Oracle
7 ALTER TABLE Statement
9 Marking Columns Unused Using The SET UNUSED Clause
11 READ ONLY Tables in SQL
13 DROP TABLE Statement
15 TRUNCATE TABLE Statement
17 COMMENT Statement
19 RENAME Statement

1 Data Manipulation Language DML
2 INSERT Statement Part 1
4 INSERT Statement Part 2
6 Multitable Insert Statements
7 Unconditional Insert Statements INSERT ALL Statements
9 Conditional INSERT ALL Statements
11 Conditional INSERT FIRST Statements
13 Pivoting Insert
15 UPDATE Statement
17 DELETE Statement
19 MERGE Statement
21 TCL Transaction Control Language TCL Commands
23 COMMIT and ROLLBACK Statements
25 Row Lock in Oracle
27 SAVEPOINT Statement
29 FOR UPDATE Statement

1 FLASHBACK Operations Part 1
2 FLASHBACK Operations Part 2
4 PURGE Operations
6 Tracking Changes In Data In a Particular Time

1 What is a Constraint Oracle Constraint Types
2 NOT NULL Constraint
4 UNIQUE Constraint
6 PRIMARY KEY Constraint
8 FOREIGN KEY Constraint Part 1
9 FOREIGN KEY Constraint Part 2
11 The ON DELETE CASCADE ON DELETE SET NULL Clause
13 CHECK Constraint
15 Adding Constraints via ALTER TABLE Statements
17 Dropping Removing Constraints
19 Cascading Constraints in Oracle
21 Renaming Constraints
23 Disabling Constraints
25 Enabling Constraints
27 Status of Constraints
29 Deferring Constraints Part 1
30 Deferring Constraints Part 2

1 What is a View and What is it Used for
2 View Types in Oracle
3 Creating Simple Views
5 Creating Complex Views
7 Modifying Views
9 Performing DML Operations with Views
11 Using the WITH CHECK OPTION Clause in SQL
13 Using the WITH READ ONLY Clause on Views
15 Dropping Views

1 What are Data Dictionary Views in Oracle
2 The Dictionary View
4 Difference Between USER ALL DBA and V Prefixes
5 USER_OBJECTS ALL_OBJECTS and DBA_OBJECTS Views
7 USER_TABLES Data Dictionary View
9 USER_TAB_COLUMNS Data Dictionary View
11 USER_CONSTRAINTS Data Dictionary View
13 USER_CONS_COLUMNS Data Dictionary View
15 USER_VIEWS Data Dictionary View
16 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views

1 What is a Sequence
2 Creating Sequences
4 Modifying Sequences
6 Dropping Sequences
7 Using Sequences
9 Using Sequences as a Default Value
11 Sequence Caching
12 The User_Sequences View
13 Oracle IDENTITY Column Part 1
14 Oracle IDENTITY Column Part 2

1 What is a Synonym
2 Creating Using and Dropping Synonyms
4 Analyzing The USER_SYNONYMS View

1 What is an Index in SQL
2 Index Types in SQL
3 How to Create Indexes Part 1
5 How to Create Indexes Part 2
7 How to Create Indexes While Table Creation
9 How to Remove Drop Indexes
11 Function Based Indexes
13 Multiple Indexes on the Same Columns Invisible Indexes
15 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views
17 How to Modify Alter Indexes

1 What are Privileges in SQL
2 How to Create a User in Oracle Database Part 1
3 How to Create a User in Oracle Database Part 2
5 Changing Database Users Passwords in Oracle Database
7 Granting System Privileges
9 Roles and PUBLIC Part 1
11 Roles and PUBLIC Part 2
12 Granting Object Privileges
14 Definers Rights and Invokers Rights Part 1
15 Definers Rights and Invokers Rights Part 2
17 Revoking Privileges and Roles Part 1
18 Revoking Privileges and Roles Part 2

1 Appendix 1 Oracle Database 12c Installation into Your Computer
3 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c

Instructors

Enrolment options

Udemy - The Complete Oracle SQL Bootcamp (2025) 2025-8

Udemy - The Complete Oracle SQL Bootcamp (2025) 2025-8

Course modified date: 12 Sept 2025

Udemy - The Complete Oracle SQL Bootcamp (2025) 2025-8

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

Guests cannot access this course. Please log in.