TOTAL QUALIFICATION TIME
105 HOURS
EXAM CODE
1Z0-082
1Z0-083
COURSE DESCRIPTION
An Oracle Database Administration 2019 Certified Professional has proven theoretical understanding of and the practical skills required to configure and manage Oracle Databases up to and including Oracle 19c. Passing this 1Z0-082 exam in the two exam path proves your skills in SQL programming skills, database and network administration. In addition, passing this 1Z0-083 in a two exam path proves your skills in: installation, upgrades, patching, SQL programming skills, database and network administration and backup and recovery. This person also demonstrates fluency with some advanced skills such as multi-tenant, SQL performance monitoring and problem determination.
LEARNING OUTCOMES
After the completion of the program, learner will be able meet the exam requirements of oracle as per below objectives :
Oracle Database Administration I
- Understanding Oracle Database Architecture
- Managing Database Instances
- Managing Users, Roles and Privileges
- Managing Storage
- Moving Data
- Accessing an Oracle Database with Oracle supplied Tools
- Configuring Oracle Net Services
- Managing Tablespaces and Datafiles
- Managing Undo
- Restricting and Sorting Data
- Using Conversion Functions and Conditional Expressions
- Displaying Data from Multiple Tables Using Joins
- Using SET Operators
- Understanding Data Definition Language
- Managing Views
- Managing Data in Different Time Zones
- Retrieving Data using the SQL SELECT Statement
- Using Single-Row Functions to Customize Output
- Reporting Aggregated Data Using Group Functions
- Using Subqueries to Solve Queries
- Managing Tables using DML statements
- Managing Sequences, Synonyms, Indexes
- Managing Schema Objects
Oracle Database Administration II
- Creating CDBs and Regular PDBs
- Manage CDBs and PDBs
- Backup and Duplicate
- Upgrading and Transporting CDBs and Regular PDBs
- Manage Application PDBs
- Manage Security in Multitenant databases
- Recovery and Flashback
- Backup Strategies and Terminology
- Restore and Recovery Concepts
- Using Flashback Technologies
- Duplicating a Database
- Configuring and Using RMAN
- Diagnosing Failures
- Performing Recovery
- Transporting Data
- RMAN Troubleshooting and Tuning
- Install Grid Infrastructure and Oracle Database
- Patching Grid Infrastructure and Oracle Database
- Upgrading to Oracle Grid Infrastructure
- Oracle Database 18c: New Features
- Creating an Oracle Database by using DBCA
- Oracle Restart
- Upgrade the Oracle Database
- Install Grid Infrastructure for a Standalone server
- Using General Overall Database Enhancements
- Using Availability Enhancements
- Using Diagnosibility Enhancements
- Monitoring and Tuning Database Performance
- Tuning SQL StatementsCOURSE OUTLINE
Oracle Database Administration I
Module 1 : Understanding Oracle Database Architecture
- Understanding Oracle Database Instance Configurations
- Understanding Oracle Database Memory and Process Structures
- Understanding Logical and Physical Database Structures
- Understanding Oracle Database Server Architecture
Module 2 : Managing Database Instances
- Starting Up Oracle Database Instances
- Using Data Dictionary Views
- Shutting Down Oracle Database Instances
- Using Dynamic Performance Views
- Using the Automatic Diagnostic Repository (ADR)
- Using the Alert Log and Trace Files
- Managing Initialization Parameter Files
Module 3 : Managing Users, Roles and Privileges
- Assigning Quotas to Users
- Applying the Principal of Least Privilege
- Creating and Assigning Profiles
- Administering User Authentication Methods
- Managing Oracle Database Users, Privileges, and Roles
Module 4 : Managing Storage
- Managing Resumable Space Allocation
- Shrinking Segments
- Deferring Segment Creation
- Using Space-Saving Features
- Deploying Oracle Database Space Management Features
- Managing Different Types of Segments
- Using Table and Row Compression
- Understanding Block Space Management
Module 5 : Moving Data Using External Tables
- Using Oracle Data Pump
- Using SQL*Loader
Module 6 : Accessing an Oracle Database with Oracle supplied Tools
- Using the Database Configuration Assistant (DBCA)
- Using Oracle Enterprise Manager Cloud Control
- Using racle enterprise Manager Database Express
- Using SQL Developer
- Using SQL Plus
Module 7 : Configuring Oracle Net Services
- Using Oracle Net Services Administration Tools
- Configuring Communication Between Database Instances
- Configuring the Oracle Net Listener
- Connecting to an Oracle Database Instance
- Comparing Dedicated and Shared Server Configurations
- Administering Naming Methods
Module 8 : Managing Tablespaces and Datafiles
- Viewing Tablespace Information
- Creating, Altering and Dropping Tablespaces
- Managing Table Data Storage
- Implementing Oracle Managed Files
- Moving and Renaming Online Data Files
Module 9 : Managing Undo
- Understanding Transactions and Undo Data
- Storing Undo Information
- Configuring Undo Rentention
- Comparing Undo Data and Redo Data
- Understanding Temporary Undo
Module 10 : Restricting and Sorting Data
- Applying Rules of precedence for operators in an expression
- Limiting Rows Returned in a SQL Statement
- Using Substitution Variables
- Using the DEFINE and VERIFY commandsModule 11 : Using Conversion Functions and Conditional Expressions
- Applying the NVL, NULLIF, and COALESCE functions to data
- Understanding implicit and explicit data type conversion
- Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nesting multiple functions
Module 12 : Displaying Data from Multiple Tables Using Joins
- Using Self-joins
- Using Various Types of Joins
- Using Non equijoins
- Using OUTER joins
Module 13 : Using SET Operators
- Matching the SELECT statements
- Using the ORDER BY clause in set operations
- Using The INTERSECT operator
- Using The MINUS operator
- Using The UNION and UNION ALL operators
Module 14 : Understanding Data Definition Language
- Using Data Definition Language
Module 15 : Managing Views
Module 16 : Managing Data in Different Time Zones
- Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
- Working with INTERVAL data types
Module 17 : Retrieving Data using the SQL SELECT Statement
- Using Column aliases
- Using The DESCRIBE command
- Using The SQL SELECT statement
- Using concatenation operator, literal character strings, alternative quote operator, and the
DISTINCT keyword
- Using Arithmetic expressions and NULL values in the SELECT statementModule 18 : Using Single-Row Functions to Customize Output
- Manipulating strings with character functions in SQL SELECT and WHERE clauses
- Performing arithmetic with date data
- Manipulating numbers with the ROUND, TRUNC and MOD functions
- Manipulating dates with the date function
Module 19 : Reporting Aggregated Data Using Group Functions
- Restricting Group Results
- Creating Groups of Data
- Using Group Functions
Module 20 : Using Subqueries to Solve Queries
- Using Single Row Subqueries
- Using Multiple Row Subqueries
Module 21 : Managing Tables using DML statements
- Managing Database Transactions
- Using Data Manipulation Language
- Controlling transactions
Module 22 : Managing Sequences, Synonyms, Indexes
- Managing Indexes
- Managing Synonyms
- Managing Sequences
Module 23 : Managing Schema Objects
- Creating and using temporary tables
- Managing constraintsOracle Database Administration II
Module 1 : Creating CDBs and Regular PDBs
- Configure and create a CDB
- Create a new PDB from the CDB seed
- Explore the structure of PDBs
Module 2 : Manage CDBs and PDBs
- Manage PDB service names and connections
- Manage startup, shutdown and availability of CDBs and PDBs
- Change the different modes and settings of PDBs
- Evaluate the impact of parameter value changes
- Performance management in CDBs and PDBs
- Control CDB and PDB resource usage with the Oracle Resource Manager
Module 3 : Backup and Duplicate
- Perform Backup and Recover CDBs and PDBs
- Duplicate an active PDB
- Duplicate a Database
Module 4 : Upgrading and Transporting CDBs and Regular PDBs
- Upgrade an Oracle Database
- Transport Data
Module 5 : Manage Application PDBs
- Explain the purpose of application root and application seed
- Define and create application PDBs
- Install, upgrade and Patch applications
- Create and administer Application PDBS
- Clone PDBs and Application containers
- Plug and unplug operations with PDBs and application containers
- Comparing Local Undo Mode and Shared Undo Mode
Module 6 : Manage Security in Multitenant databases
- Manage Security in Multitenant databases
- Manage PDB lockdown profiles
- Audit Users in CDBs and PDBs
- Manage other types of policies in application containersModule 7 : Recovery and Flashback
- Restore and Recovering Databases with RMAN
- Perform CDB and PDB flashback
Module 8 : Backup Strategies and Terminology
- Perform Full and Incremental Backups and Recoveries
- Compress and Encrypt RMAN Backups
- Use a media manager
- Create multi-section backups of very large files
- Create duplexed backup sets
- Create archival backups
- Backup of recovery files
- Backup non database files
- Back up ASM meta data
Module 9 : Restore and Recovery Concepts
- Employ the best Oracle Database recovery technology for your failure situation
- Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry
Module 10 : Using Flashback Technologies
- Configure your Database to support Flashback
- Perform flashback operations
Module 11 : Duplicating a Database
Module 12 : Configuring and Using RMAN
- Configure RMAN and the Database for Recoverability
- Configureand Using an RMAN recovery catalog
Module 13 : Diagnosing Failures
- Detect and repair database and database block corruption
- Diagnosing Database Issues
Module 14 : Performing Recovery
- Restore and Recovering Databases with RMAN
- Perform Non RMAN database recoveryModule 15 : Transporting Data
- Transport Data
Module 16 : RMAN Troubleshooting and Tuning
- Interpret the RMAN message output
- Diagnose RMAN performance issues
Module 17 : Install Grid Infrastructure and Oracle Database
- Install Grid Infrastructure for a Standalone server
- Install Oracle Database software
Module 18 : Patching Grid Infrastructure and Oracle Database
- Patch Grid Infrastructure and Oracle Database
Module 19 : Upgrading to Oracle Grid Infrastructure
- Upgrade Oracle Grid Infrastructure
Module 20 : Oracle Database 18c: New Features
- Image and RPM based Database Installation
Module 21 : Creating an Oracle Database by using DBCA
- Create, Delete and Configure Databases using DBCA
Module 22 : Oracle Restart
- Configure and use Oracle Restart to manage components
Module 23 : Upgrade the Oracle Database
- Plan for Upgrading an Oracle Database
- Upgrade an Oracle Database
- Perform Post-Upgrade tasks
Module 24 : Install Grid Infrastructure for a Standalone server
Module 25 : Using General Overall Database Enhancements
- Install Oracle Database software
- Create, Delete and Configure Databases using DBCA
- Creating CDBs and Regular PDBs
- Use Miscellaneaous 19c New FeaturesModule 26 : Using Availability Enhancements
- Use an RMAN recovery catalog
- Use Flashback Database
Module 27 : Using Diagnosibility Enhancements
- Use new Diagnoseability Features
Module 28 : Monitoring and Tuning Database Performance
- Managing Memory Components
- Understanding The Automatic Workload Repository (AWR)
- Understanding The Advisory Framework
- Monitoring Wait Events, Sessions, and Services
- Managing Metric Thresholds and Alerts
- Understanding and Using The Performance Tuning Methodology
- Performing Performance Planning
- Understanding The Automatic Database Diagnostic Monitor (ADDM)
Module 29 : Tuning SQL Statements
- Understanding The Oracle Optimizer
- Using The SQL Tuning Advisor
- Managing Optimizer Statistics
- Using The SQL Access Advisor
- Understanding The SQL Tuning Process
COURSE FORMAT
The taught instructor-led course will be a suitable mix of lectures, tutorials, workshops, case studies, videos and hands on practical exercises. Delegates will be given immediate opportunities to apply what they have learned with real life problems and case studies. A comprehensive course workbook is at the core of this course and delegates will also be guided through additional material in the instructor-led sessions.
PREREQUISITES
While there are no formal prerequisites to take the 1Z0-082 and 1Z0-083, Oracle recommends that candidates have:
- Basic understanding of SQL and PL/SQL
- Familiarity with Oracle Database architecture
- Basic knowledge of Linux or Windows operating systems for server administration
- Some hands-on experience with Oracle Database installation and configuration is helpfulCAREER PATHWAYS AND JOB ROLES
Achieving the 1Z0-082 and 1Z0-083 certification can open doors to various roles in the IT industry. Here’s a typical progression:
- Junior Database Administrator (DBA)
- Database Support Technician
- Database Developer (Entry Level)
- SQL Analyst
- Database Administrator (DBA)
- Senior DBA
- Oracle Database Consultant
- Database Architect