Certification training

1z0-0821z0-082: Oracle Database Administration I

Prepare for your Oracle exam with a structured video course built for focused study, topic review, and repeatable progress before exam day.

202Lectures
27h 5mDuration
OracleVendor
1z0-082: Oracle Database Administration I course cover Best seller
Oracle certification training 1z0-082 202 lessons arranged in a guided course path
Course overview

Study with a clear path.

Move through focused sections, review lecture timing, and return directly to the objectives that need more work.

Sequenced lessons

Follow the course in order or jump directly to the section you need to revisit.

Video-first prep

Use concise lecture blocks for technical review before moving into exam practice.

Fast access

Your purchased course becomes available in the member area after confirmed payment.

Curriculum

Course sections.

13 sections, 202 lessons, and lecture-level duration details.

01 Basic Introduction 11m
02 Brief History of Oracle Database 0s
03 Oracle DB editions 5m
04 Database VS Database Instance 8m
05 sever processes and the PGA 7m
06 System Global Area Part 1 10m
07 System Global Area Part 2 7m
08 Background Processes 6m
09 Database Files 9m
10 Logical Storage Structure 5m
11 Default tablespaces 7m
12 Multitenant Database 12c /18c 6m
13 DBA Tasks and tools 6m
14 Installation Methods and OS 4m

01 Overview about installation steps 5m
02 Downloading and installing Oracle Vbox 2m
03 Downloading oracle Linux image 5m
04 Creating our virtual machine for this course 5m
05 Installing oracle Linux 12m
06 Installing gust additions 7m
07 Creating shared folder 3m
08 Basic Linux commands part 1 10m
09 Basic Linux commands part 2 5m
10 Basic Linux commands part 3 10m
11 Prerequisites for installing oracle DB 18c 11m
12 Valuable information about the installation Prerequisites 3m
13 OS configurations for oracle user 9m
14 Downloading and installing oracle DB 18c 11m

01 Database Startup part 1 8m
02 Database Startup part 2 7m
03 Shutdown database part 1 11m
04 Shutdown database part 2 9m
05 Understanding oracle listener and Listener.ora 6m
06 Understanding service name 5m
07 Understanding tnsnames.ora 4m
08 How client connections work 3m
09 Installing Putty and so connections 7m
10 Installing winSCP and so connections 5m
11 Installing Oracle SQL developer (client side) 5m
12 Connecting sys user in many methods 4m
13 Moving from container to pluggable 7m
14 Starting and stopping the listener 15m
15 Easy connect method 10m
16 connecting using tnsnames 10m
17 unlock the hr schema in the pluggable database 6m
18 saving and runing scripts 6m

01 oracle data dictionary concept 12m
02 Common uses VS local users part 1 4m
03 Common uses VS local users part 2 8m
04 Understanding Dynamic Performance Views 8m
05 cdb_ & dba_ when you are inside a pluggable 5m
06 query the data files 8m
07 query the temps files 5m
08 V$DATABASE / v$version / v$instance 4m
09 V$CONTAINERS / cdb_PDBS 5m
10 V$DATAFILE 5m
11 cdb_tablespaces / V$TABLESPACE 5m
12 v$logfile / V$CONTROLFILE 6m
13 Pluggable Database Save state 6m

01 Initialization Parameters & Parameters Files 6m
02 Search order for a parameter file 4m
03 Uses of Initialization Parameters 3m
04 Types of Initialization Parameters 11m
05 About Modifying Initialization Parameters 5m
06 Alter session example 8m
07 v$parameter VS v$parameter2 7m
08 v$system_parameter VS v$system_parameter2 8m
09 example: Search order for a parameter file and creating pfile 7m
10 Understanding the parameter spfile 3m
11 creating non default name for pfile and startup 10m
12 alter system example ( memory ) 7m
13 alter system example ( spfile ) 4m
14 alter system example ( both ) 5m
15 Default scope in alter statement part 1 2m
16 Default scope in alter statement part 2 9m
17 CONTAINER clause in alter system & Inheritance 1 5m
18 CONTAINER clause in alter system & Inheritance 2 11m
19 About Automatic Diagnostic Repository 6m
20 The alert log Part 1 7m
21 The alert log Part 2 6m
22 View alert log using ADRCI 9m
23 Trace files and Purging Part 1 7m
24 Trace files and Purging Part 2 15m
25 Enable DDL logging 7m
26 V$SPPARAMETER 7m

01 About creating PDBs 4m
02 Creating PDB from seed part 1 5m
03 Creating PDB from seed part 2 15m
04 Connecting to the new PDB 9m
05 Creating PDB from seed (DBCA) 6m
06 Dropping pluggable using SQL 4m
07 Dropping pluggable using DBCA 2m
08 Cloning PDBs part 1 5m
09 Cloning PDBs part 2 15m
10 Unplugging and plugging in PDBs part 1 6m
11 Unplugging and plugging in PDBs part 2 14m
12 Unplugging and plugging in PDBs part 3 6m

01 Establishing a connection and session 4m
02 The default listener 11m
03 The default listener exercise 9m
04 Using non-default port 8m
05 creating dynamic listener example 8m
06 creating static listener example 15m
07 Oracle net configuration assistant (netca) 12m
08 Oracle Net Manager (netmgr ) 7m
09 CREATE DATABASE LINK 6m
10 CREATE DATABASE LINK example part 1 6m
11 CREATE DATABASE LINK example part 2 13m

01 basic knowledge for controlling user access 12m
02 System and objects privileges part 1 8m
03 System and objects privileges part 2 14m
04 Creating private roles examples 11m
05 common users and common privileges 11m
06 common roles 11m
07 More About Users accounts 4m
08 Oracle- supplied administrator accounts 5m
09 Special system privileges for administrators 4m
10 Oracle –supplied roles 5m
11 Best practice to create user like SYS 13m
12 Best practice to create pluggable admin 6m
13 Role granted to another role 8m
14 Understanding the role PDB_DBA (DBCA method) 10m
15 system privileges with admin option 4m
16 About user profile 6m
17 Password Parameters 7m
18 Oracle-supplied password verification functions 5m
19 Resource parameters 5m
20 Creating common profile example 13m
21 Creating local profile example 5m
22 Password verification full example 13m

01 Review tablespaces basic information 8m
02 How table data is stored 5m
03 Database block content 3m
04 About creating tablespace part 1 4m
05 About creating tablespace part 2 8m
06 About creating tablespace part 3 4m
07 Creating new PDB for practice 10m
08 Helpful queries for tablespaces 18m
09 Create permanent tablespace example 14m
10 managing tablespace using SQL developer wizard 14m
11 Alter tablespace and datafile 15m
12 Moving and Renaming Online Data Files 8m
13 last tips for this chapter 3m

01 Space can be automatically managed by Oracle 8m
02 Segments,Extents & blocks using SQL 1 15m
03 Segments,Extents & blocks using SQL 2 6m
04 Availability and Optimization of Free Space in a Data Block 7m
05 Row Chaining and Migrating 4m
06 Types of Segments 10m
07 Controlling Deferred Segment Creation 7m
08 Space-Saving Features (UNUSABLE index) 8m
09 basic compression part 1 13m
10 basic compression part 2 7m
11 Advanced row compression 8m
12 Monitoring Tablespace Space Usage 9m
13 DBMS_SERVER_ALERT.SET_THRESHOLD example 11m
14 Reclaiming Wasted Space 7m
15 Segment Advisor 6m
16 Segment Advisor and shrink exercise 14m
17 Managing Resumable Space Allocation 13m

01 Undo Data Overview 8m
02 Transactions and Undo Data 9m
03 Comparing Undo Data and Redo Data 5m
04 Creating new pluggable for practice 8m
05 CREATE UNDO TABLESPACE 11m
06 Local Undo Mode Versus Shared Undo part 1 8m
07 Local Undo Mode Versus Shared Undo part 2 14m
08 Overview of Automatic Undo Management 6m
09 About the Undo Retention Period 8m
10 Categories of Undo 4m
11 Flashback table and Flashback Version Query 14m
12 Automatic Tuning of Undo Retention 1 8m
13 Automatic Tuning of Undo Retention 2 16m

01 SQL*Loader part 1 8m
02 SQL*Loader part 2 10m
03 External Tables Part 1 17m
04 External Tables Part 2 10m
05 Moving Data from One PDB to Another 1 15m
06 Moving Data from One PDB to Another 2 8m
07 Moving Data from One PDB to Another 3 19m
08 Exporting schema (using user has DBA role) 8m
09 SQL loader Discard file Example 10m
10 Conventional Load Part 1 9m
11 Conventional Load Part 2 15m
12 Direct Path Load part 1 13m
13 Direct Path Load part 2 15m
14 SQL*Loader express mode 20m
15 External table with PARTITIONS 15m

01 DBA Responsibilities 5m
02 Categories of Failure 8m
03 incomplete vs 5m
04 redo logs and archived redo logs 6m
05 Prerequisites of point-in-time-recovery 4m
06 Oracle Backup Technologies 9m
07 Enabling ARCHIVELOG mode 5m
08 Configuring fast recovery area 6m
09 Make free space by dropping some pluggables 4m
10 Doing full backup for CDB and restoring 18m
11 Doing backup for pluggable db 8m
12 point-in-time recovery of the CDB 9m
13 point-in-time recovery of pluggable 7m
14 Deleting backup 6m
Continue preparing

Connect the lessons to exam-day practice.

Use the course for structured review, then move into current questions, timed simulator sessions, and a broader vendor catalog.

VTSimu exam simulatorRehearse pacing in focused desktop sessions.
Unlimited AccessBuild a practice library across vendors and formats.
More video coursesExplore every available certification training track.