1z0-082: Oracle Database Administration I Exam – Complete Certification Training Course & Exam Dumps

Curriculum For This Course

Introduction and foundations

14Lectures

Time 01:31:00

Download & installing + Basic Linux commands

14Lectures

Time 01:38:00

Database Startup,shutdown and connections

18Lectures

Time 02:08:00

Helpful queries to explore Oracle DB architecture

13Lectures

Time 01:21:00

Managing Database Instance

26Lectures

Time 02:59:00

Creating PDBs

12Lectures

Time 01:31:00

Configuring the Oracle Network Environment

11Lectures

Time 01:39:00

Administering User Security

22Lectures

Time 03:00:00

Creating and managing tablespaces

13Lectures

Time 01:54:00

Managing Storage Space

17Lectures

Time 02:33:00

Managing UNDO Data

13Lectures

Time 01:59:00

Moving Data

15Lectures

Time 03:12:00

Backup and Recovery Concepts

14Lectures

Time 01:40:00

Introduction and foundations
	1. Basic Introduction	11:00
	2. Brief History of Oracle Database	0:00
	3. Oracle DB editions	5:00
	4. Database VS Database Instance	8:00
	5. sever processes and the PGA	7:00
	6. System Global Area Part 1	10:00
	7. System Global Area Part 2	7:00
	8. Background Processes	6:00
	9. Database Files	9:00
	10. Logical Storage Structure	5:00
	11. Default tablespaces	7:00
	12. Multitenant Database 12c /18c	6:00
	13. DBA Tasks and tools	6:00
	14. Installation Methods and OS	4:00

Download & installing + Basic Linux commands
	1. Overview about installation steps	5:00
	2. Downloading and installing Oracle Vbox	2:00
	3. Downloading oracle Linux image	5:00
	4. Creating our virtual machine for this course	5:00
	5. Installing oracle Linux	12:00
	6. Installing gust additions	7:00
	7. Creating shared folder	3:00
	8. Basic Linux commands part 1	10:00
	9. Basic Linux commands part 2	5:00
	10. Basic Linux commands part 3	10:00
	11. Prerequisites for installing oracle DB 18c	11:00
	12. Valuable information about the installation Prerequisites	3:00
	13. OS configurations for oracle user	9:00
	14. Downloading and installing oracle DB 18c	11:00

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

Helpful queries to explore Oracle DB architecture
	1. oracle data dictionary concept	12:00
	2. Common uses VS local users part 1	4:00
	3. Common uses VS local users part 2	8:00
	4. Understanding Dynamic Performance Views	8:00
	5. cdb_ & dba_ when you are inside a pluggable	5:00
	6. query the data files	8:00
	7. query the temps files	5:00
	8. V$DATABASE / v$version / v$instance	4:00
	9. V$CONTAINERS / cdb_PDBS	5:00
	10. V$DATAFILE	5:00
	11. cdb_tablespaces / V$TABLESPACE	5:00
	12. v$logfile / V$CONTROLFILE	6:00
	13. Pluggable Database Save state	6:00

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

Creating PDBs
	1. About creating PDBs	4:00
	2. Creating PDB from seed part 1	5:00
	3. Creating PDB from seed part 2	15:00
	4. Connecting to the new PDB	9:00
	5. Creating PDB from seed (DBCA)	6:00
	6. Dropping pluggable using SQL	4:00
	7. Dropping pluggable using DBCA	2:00
	8. Cloning PDBs part 1	5:00
	9. Cloning PDBs part 2	15:00
	10. Unplugging and plugging in PDBs part 1	6:00
	11. Unplugging and plugging in PDBs part 2	14:00
	12. Unplugging and plugging in PDBs part 3	6:00

Configuring the Oracle Network Environment
	1. Establishing a connection and session	4:00
	2. The default listener	11:00
	3. The default listener exercise	9:00
	4. Using non-default port	8:00
	5. creating dynamic listener example	8:00
	6. creating static listener example	15:00
	7. Oracle net configuration assistant (netca)	12:00
	8. Oracle Net Manager (netmgr )	7:00
	9. CREATE DATABASE LINK	6:00
	10. CREATE DATABASE LINK example part 1	6:00
	11. CREATE DATABASE LINK example part 2	13:00

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

Creating and managing tablespaces
	1. Review tablespaces basic information	8:00
	2. How table data is stored	5:00
	3. Database block content	3:00
	4. About creating tablespace part 1	4:00
	5. About creating tablespace part 2	8:00
	6. About creating tablespace part 3	4:00
	7. Creating new PDB for practice	10:00
	8. Helpful queries for tablespaces	18:00
	9. Create permanent tablespace example	14:00
	10. managing tablespace using SQL developer wizard	14:00
	11. Alter tablespace and datafile	15:00
	12. Moving and Renaming Online Data Files	8:00
	13. last tips for this chapter	3:00

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

Managing UNDO Data
	1. Undo Data Overview	8:00
	2. Transactions and Undo Data	9:00
	3. Comparing Undo Data and Redo Data	5:00
	4. Creating new pluggable for practice	8:00
	5. CREATE UNDO TABLESPACE	11:00
	6. Local Undo Mode Versus Shared Undo part 1	8:00
	7. Local Undo Mode Versus Shared Undo part 2	14:00
	8. Overview of Automatic Undo Management	6:00
	9. About the Undo Retention Period	8:00
	10. Categories of Undo	4:00
	11. Flashback table and Flashback Version Query	14:00
	12. Automatic Tuning of Undo Retention 1	8:00
	13. Automatic Tuning of Undo Retention 2	16:00

Moving Data
	1. SQL*Loader part 1	8:00
	2. SQL*Loader part 2	10:00
	3. External Tables Part 1	17:00
	4. External Tables Part 2	10:00
	5. Moving Data from One PDB to Another 1	15:00
	6. Moving Data from One PDB to Another 2	8:00
	7. Moving Data from One PDB to Another 3	19:00
	8. Exporting schema (using user has DBA role)	8:00
	9. SQL loader Discard file Example	10:00
	10. Conventional Load Part 1	9:00
	11. Conventional Load Part 2	15:00
	12. Direct Path Load part 1	13:00
	13. Direct Path Load part 2	15:00
	14. SQL*Loader express mode	20:00
	15. External table with PARTITIONS	15:00

Backup and Recovery Concepts
	1. DBA Responsibilities	5:00
	2. Categories of Failure	8:00
	3. incomplete vs. complete recovery	5:00
	4. redo logs and archived redo logs	6:00
	5. Prerequisites of point-in-time-recovery	4:00
	6. Oracle Backup Technologies	9:00
	7. Enabling ARCHIVELOG mode	5:00
	8. Configuring fast recovery area	6:00
	9. Make free space by dropping some pluggables	4:00
	10. Doing full backup for CDB and restoring	18:00
	11. Doing backup for pluggable db	8:00
	12. point-in-time recovery of the CDB	9:00
	13. point-in-time recovery of pluggable	7:00
	14. Deleting backup	6:00