Skip to navigation
Skip to navigation
Skip to search form
Skip to login form
Skip to footer
Skip to main content
MVP189
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
LEO777
PAREPOS
JAVABET99
KONTAN88
PEWE128
LAGA88
SKY99IDN
BUANA88
BOXING55
DEWISRI88
DEWISRI88
DEWISRI88
MVP189
slot mania
MVP189
situs tergacor
pg slot wallet
Accessibility options
Accessibility profiles
Visual impairment
Seizure and epileptic
Color vision deficiency
ADHD
Learning
Content adjustments
Readable font
Highlight titles
Highlight links
Stop animations
Text size
+
+ +
+ + +
Line height
+
+ +
+ + +
Text spacing
+
+ +
+ + +
Color adjustments
Dark contrast
Light contrast
High contrast
High saturation
Low saturation
Monochrome
Orientation adjustments
Reading guide
Reading Mask
Big black cursor
Big white cursor
Email: it@huph.edu.vn
Email: it@huph.edu.vn
Các khóa học
Link list
Đổi giao diện
Giao diện cũ
Giao diện mới
Learning AI
Machine Learning cơ bản
en
English
Technology
Database
Udemy - Oracle Database SQL Certified Associate 1Z0-071 2024-5
0 students
Last updated
Jul 2025
Enrol now
Overview
Course content
Instructors
About the course
Udemy - Oracle Database SQL Certified Associate 1Z0-071 2024-5
Show more...
Course content
Sections:
27
•
Activities:
1
•
Resources:
169
Expand all
Section 1
Introduction
Announcements
1 Course Agenda
2 System Development Life Cycle Database Definition
3 What is a Table
4 Data Models ERM
5 About Primary key foreign key
6 SQL and Types of SQL Statements
7 Oracle Database 12c Architecture
8 HR Schema in this Course
Section 2
Live SQL & Download Install
1 Oracle Live SQL No Installation for anything
4 Downloading Oracle DB 12c
5 Installing Oracle DB 12c
Section 3
Connecting to the Database
1 Connecting SYS using SQL plus SQL Developer
3 Unlock HR Account Part 1
4 Unlock HR Account Part 2
5 ORA 01033 oracle initialization or shutdown in progress 12c
Section 4
Retrieving data using the select statement
1 Navigate HR schema
2 Capabilities of SQL SELECT Statements
3 Arithmetic expressions and NULL values
4 Column Alias Concatenation Distinct and DESCRIBE
5 Important Notes in Select Statement
Section 5
Restricting and Sorting Data
1 The WHERE Clause Comparison Operators
2 Using Between and IN Like Operators
3 Using IS NULL NOT Not equal Operators
4 Logical Operators AND OR NOT
5 Order by Clause
6 The FETCH Clause
Section 6
Substitution Variables
1 What is a Substitution Variables
2 DEFINE UNDEFINE
3 ACCEPT PROMPT
4 Double Ampersand SET VERIFY SET DEFINE
Section 7
Using Single-Row Functions to Customize Output
1 Single Row Function Introduction
2 Character functions Upper Lower Initcap
3 Character functions concat substr length
4 Character functions instr
5 Character functions lpad rpad replace trim
6 Number functions Round Trunc MOD
7 Date Functions Sysdate
8 Date Functions months_between add_months next_day last_day
9 Date Functions round trunc
10 Nesting Functions
Section 8
Using Conversion Functions and Conditional Expressions
1 Implicit Data Conversion VS Explicit
2 TO_CHAR with dates
3 TO_CHAR with numbers
4 TO_NUMBER TO_DATE Functions
5 nvl nvl2 nullif and coalesce Functions
6 The CASE Function
7 The DECODE Function
Section 9
Reporting Aggregated Data Using the Group Functions
1 Group functions Introduction
2 Group functions sum count max min avg more
3 Group by Clause Having Clause
Section 10
Displaying Data from multiple tables using joins
1 Before You Start important notes
2 HR Tables Diagram Joins Clarification
3 What is Cartesian product
4 Old Joins Equijoin
5 Old Joins nonEquijoins
6 Old Joins outer join
7 Old Joins Self Join and More Practices
8 1999 Syntax Cross Join Cartesian product
9 1999 Syntax Natural Join
10 1999 Syntax USING Clause
11 1999 Syntax ON Clause
12 1999 Syntax LeftRightfull Outer Join
Section 11
Using Subqueries to Solve Queries
1 Single row Subqueries
2 Multiple rows Subqueries
3 NULL values and Subqueries
4 Exists and not Exists
Section 12
Using the Set Operators
1 Overview Union union all intersect minus
2 Practice Union union all intersect minus
Section 13
Managing tables using DML Statments
1 Introduction to DML
2 Insert Statement
3 Inserting common errors
4 Update Statement
5 Delete Statement
6 What is Database Transactions
7 About Commit Rollback
8 Practice Commit and rollback
9 SAVEPOINT
10 ROW Lock
11 FOR UPDATE Clause
Section 14
Introduction to Data Definition Language
1 DDL Naming Rules
2 Data Types Part 1
3 Data Types Part 2
4 Creating Tables without constraints
5 Types of constraints and why we use it
6 Creating Tables Column Level Constraints
7 Creating Tables Table Level Constraints
8 Constraints Guidelines
9 ON DELETE cascade ON DELETE set null
10 Create Table AS subquery
11 Alter Table Add Columns
12 Alter Table Modify Columns
13 Alter Table Drop Columns
14 Alter Table Set Unused
15 ALTER TABLE READ ONLY READ write
16 Drop Table
17 Rename Column Rename Table
Section 15
Tips you Should know
1 Tips you Should know Part 1
2 Tips you Should know Part 2
3 Tips you Should know Part 3
4 Tips you Should know Part 4
5 Tips you Should know Part 5
6 Tips you Should know Part 6
Section 16
Exam 1Z0-061 Oracle Database 12c SQL Fundamentals
1 About Exam 1Z0 061 Visiting Oracle Website
2 My recommendations
Section 17
Introduction to Data Dictionary Views
1 What is Data Dictionary Views
2 What is DICTIONARY
3 USER_OBJECTS ALL_OBJECTS
4 USER_TABLES ALL_TABLES USER_TAB_COLUMNS
5 USER_CONSTRAINTS USER_CONS_COLUMNS Part 1
6 USER_CONSTRAINTS USER_CONS_COLUMNS Part 2
7 COMMENT ON TABLE COLUMN
Section 18
Creating sequences, synonyms, and indexes
1 Sequences Part 1
2 Sequences Part 2
3 Sequences Part 3
4 Sequences Part 4
5 Creating Synonyms
6 Creating Indexes Part 1
7 Creating Indexes Part 2
Section 19
Creating Views
1 What is a View What is the benefits of Views
2 Creating Simple Views
3 Creating Complex Views
4 With READ ONLY With check option Force view
Section 20
Managing Schema Objects
1 Adding constraints dropping constraints
2 Rename Column Rename Constraint
3 Enable Disable Constraints
4 Understanding DEFERRABLE Constraints
5 DEFERRABLE Constraints Exercises
6 GLOBAL TEMPORARY TABLE
7 About SQLLoader
8 External Tables Part 1
9 External Tables Part 2
Section 21
Retrieving Data By Using Subqueries
1 Using the subquery as a source table
2 Pairwise Non Pairwise Subqueries
3 Scalar Subquery Correlated Subquery
4 Reminder of Exists Not Exists
5 WITH Clause
Section 22
Manipulating Data By Using Subqueries
1 Inserting Updating Deleting Using a subquery as a target
2 Correlated Update Correlated Delete
Section 23
Controlling User Access
1 Database Security System Privileges Roles
2 Database Security Object Privileges
3 System Privileges Privileges Practice 1
4 System Privileges Privileges Practice 2
5 Creating ROLE Practice
6 With Grant Option
7 Drop user Statement
Section 24
Manipulating Data
1 What is Data Warehouse
2 Explicit default value in insert update statement
3 Copy rows from another table
4 INSERT ALL statement INSERT FIRST
5 Another INSERT ALL Example Notes
6 Creating Matrix Report Using PIVOT
7 The Merge Statement
8 FLASHBACK Table System change Number SCN
Section 25
Managing Data in Different Time Zones
1 THE INTERVAL YEAR TO MONTH day TO second
2 to_yminterval to_dsinterval
3 Extract function
4 timestamp timestamp with time zone
5 VTIMEZONE_NAMES and some functions
6 timestamp with local time zone
7 TZ_OFFSET FROM_TZ TO_TIMESTAMP
Section 26
Exam 1Z0-071 for SQL Certified Associate
1 About the Exam 1Z0 071
Section 27
Bonus Section
1 Using SELECT statement to create dynamic scripts
2 Installing oracle 11g express edition
3 Rownum and rowid
4 About PLSQL
7 DML logs using package dbms_errlog
8 oracle 18c express edition part 1 download and install
9 oracle 18c express edition part 2 unlock hr
10 oracle 18c express edition part 3 sql developer
Instructors
Enrolment options
Udemy - Oracle Database SQL Certified Associate 1Z0-071 2024-5
Course modified date:
21 July 2025
Udemy - Oracle Database SQL Certified Associate 1Z0-071 2024-5
Enrolled students:
There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Continue
Enrol now
This course includes
Forums
Resources
Share this course
Scroll to top
×
Close
×
Close