Oracle 12c Data Base Administration Express Introduction for Support Personnel Course Details:

In this course, you will learn how applications interface with the Oracle database and how to help troubleshoot problems arising in the installation and operation of applications. You will learn about the Oracle database architecture and how its components work and interact with one another. You will also learn how to properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Hands-on exercises reinforce the material covered.

    No classes are currenty scheduled for this course.

    Call (919) 283-1653 to get a class scheduled online or in your area!

1. Introduction

  • Describe the basic concepts of a relational database
  • Discuss core database administrator tasks

2. Architecture

  • Describe Oracle database architecture
  • Understand the instance architecture
  • Use the management framework, and the database creation assistant

3. Controlling the database

  • Start and stop the agent, the enterprise manager database console, and the listener
  • Startup and shutdown the database

4. Storage Structures

  • Define the purpose of tablespaces and data files
  • Create and manage tablespaces
  • Obtain tablespace information

5. Administering users

  • Create and manage database user accounts, and manage roles
  • Grant and revoke privileges
  • Control resource usage by users

6. Oracle Database Security

  • Apply the principal of least privilege
  • Manage default user accounts
  • Implement standard password security features, and Audit database activity

7. Oracle Net Services

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners, and configure client and middle-tier connection
  • Use the listener control utility to control the Oracle Net Listener
  • Use TNSPING to test Oracle Net connectivity

8. Performance Monitoring

  • Troubleshoot invalid / unusable objects
  • Gather optimizer statistics
  • View performance metrics
  • Reacting to performance issues

9.     Diagnostic Sources

  • Alert Logs and Trace Files
  • Enterprise Manager and Alerts
  • Controlling trace file size
  • Alert notification

10. Backup and Recovery Concepts

  • Describe the basics of database backup, restore and recovery
  • List the types of failure that may occur in an Oracle Database, and Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log file
  • Configure ARCHIVELOG mode
  • Flashback Database / Table / Query

11. Database backups

  • Create consistent database backups, incremental backups, and Automate database backups
  • Monitor the flash recovery area
  • Back your database up without shutting it down

12. Database Recovery

  • Recover from loss of a control file, a redo log file, or a data file
  • A Day in the Life of a DBA
  • Periodic and As Needed Tasks

13.  Scheduler

  • Creating jobs and job classes
  • Creating schedules and windows
  • Scheduler programs
  • Prioritizing jobs
  • Scheduler component reuse
  • Query Scheduler information

14. SQL Tuning Tools

  • Optimizer Overview
  • Execution Plans
  • Rule-Based Optimization (Desupported)
  • Cost-Based Optimization
  • Table And Index Statistics
  • Execution Plans
  • Autotrace
  • Using Hints
  • Stored Outlines And Plan Stability

15.  Performance Tuning

  • Application Identification
  • Enterprise Manager Tools
  • SQL Tuning Advisor
  • SQL Access Advisor
  • Quick Tune

*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Install and configure the Oracle 12c database
  • Create and administer user accounts in the Oracle 12c database
  • Backup and recover the database
  • Monitor, troubleshoot, and maintain the database
  • Configure Oracle Net services

Lab 1: Architecture / Advanced Memory Management

Lab 2: Starting and Stopping the Database

Lab 3:  Managing Tablespaces / Datafiles

Lab 4:  Oracle Database Files

Lab 5:  Users and Security

Lab 6:  Oracle Networking

Lab 7:  Configuring the Database for Backup

Lab 8:  Basic Database Media Recovery

Lab 9:  Archivelog Setup

Lab 10:  Automation Tools

Lab 11:  Performance Tuning Tools

Lab 12:  Oracle Job Scheduling

  • Knowledge of SQL
  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
  • Technical support personnel

Ready to Jumpstart Your IT Career?