Oracle 12c: Database Administration I Part 2

 

Course Description

 

In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'cloud computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 12c database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

 

Once you have completed Oracle 12c Database Administration I Part 2 the next course you will want to take is Oracle 12c Database Administration II Part 1. The Oracle 12c Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 12c Database Administration II Part 1 and Part 2.

 

In This Course You Will Learn How To:

  • Explain Oracle's architectural components.
  • Demonstrate how to use Oracle's universal installer and configuration assistants.
  • Identify the different interfaces to an Oracle database.
  • Describe the different database control and storage structures.
  • Explain how to use schema and user management tools.
  • Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database.
  • Describe PL/SQL declarations, code and exceptions.
  • Discuss Oracle's password security and database auditing features.
  • Configure Oracle's default user account features.
  • Configure and tune Oracle's Listener and Net Services features.
  • Learn how to establish, tune and monitor Oracle's Shared Server configuration.
  • Explain how to manually and automatically monitor the performance of an Oracle database.
  • Describe how to use Oracle's advisors to help tune and monitor database performance.
  • Show how to tune and administer Oracle's database undo management.
  • Discover how Oracle detects and resolves locking conflicts.
  • Learn the roles of control files, data files and redo log files in database backup and recovery.
  • Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery.
  • Discuss the different types of database backups.
  • Differentiate the differences between user-managed and server-managed backups.
  • Contrast the differences between database restoration and database recovery.
  • Illustrate the importance of database incarnations in database recovery.

 

Prerequisites

 

In order to successfully complete Oracle 12c Database Administration 1 Part 2 you will need to have equivalent experience in or have taken:

  • Oracle 12c: Database Administration I Part 1
  • Oracle 10g/11g: Introduction to SQL
  • Oracle 10g/11g: Advanced SQL
  • Oracle 11g PL/SQL Programming Part 1
  • Oracle 11g PL/SQL Programming Part 2

 

Outline

 

Module 00: Course Introduction - Oracle 12c: Database Administration I Part 2

 

 

 

Module 01: Oracle 12c Enterprise Express

  • Install Enterprise Express
  • Use Enterprise Express
  • Lab Exercise: Use Enterprise Manager Express (DEMO)

 

Module 02: Oracle 12c Cloud Control

  • Identify the components of Cloud Control
  • Install Cloud Control
  • Set up targets within Cloud Control

 

Module 03: Undo Tablespaces

  • Create undo tablespaces
  • Manage Undo Tablespaces
  • Change Undo Tablespaces
  • Lab Exercise: Create Undo Tablespaces
  • Lab Exercise: Change Undo Tablespaces

 

Module 04: Database Auditing

  • Define Database Auditing
  • Identify Database Auditing Parameters
  • Set up database auditing
  • Lab Exercise: Setup Database Auditing

 

Module 05: Database Backups

  • Backup concepts
  • User managed Backups
  • Oracle Managed Backups
  • Archivelog Mode and No Archivelog Mode
  • Lab Exercise: Place the Database in Archivelog Mode

 

Module 06: RMAN Concepts

  • Identify Backupsets
  • Identify Image Copies
  • Incremental Backups
  • Quiz: RMAN Concepts

 

Module 07: RMAN Backups

  • Create RMAN Backups command Line
  • Create RMAN backups with Cloud Control
  • Lab Exercise Perform a database backup

 

Module 08: Database Recovery

  • User Managed Complete Recovery
  • User Managed Incomplete Recovery
  • RMAN complete Recovery
  • RMAN incomplete Recovery
  • Quiz: Database Recovery

 

Module 09: Additional Database Recovery

  • Definition of non-critical loss
  • Definition of Critical Loss
  • Using Data Recovery Advisor
  • Quiz: Data Recovery Advisor

 

Module 10: Oracle Data Pump

  • Define Oracle's Data Pump Architecture
  • Data Pump features
  • Perform a data pump export
  • Perform a data pump import
  • Lab Exercise: perform a database export
  • Lab Exercise: perform a database import

 

Module 11: Oracle Scheduling

  • Define the Scheduling components
  • Identify the differences between a: (Job, Program, Schedule, Window)
  • Identify how Oracle performs resource management with Job Scheduling
  • Create Schedule
  • Create a Job Chain

 

Module 12: Oracle 12 Performance Tuning

  • Identify the components of the SGA for tuning
  • Identify tuning parameters
  • Oracle 12c Tuning Tools

 

Module 13: Advisory Framework

  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitory (ADDM)
  • Real Time ADDM
  • Lab Exercise: Create and run an AWR report.

 

Module 14: Tuning Framework Tools

  • SQL Tuning Advisor
  • SQL Access Advisor
  • Quiz: Tuning Advisor Framework

 

Module 15: Plan Management

  • Identify SQL Baselines
  • Use SQL Baselines
  • Identify SQL Plan Management
  • Use SQL Plan Management

 

Module 16: Tune SQL Statements

  • Use DBMS_STATS
  • Set DBMS_STATS parameters
  • Create invisible indexes