Oracle 12c: Database Administration Express Introduction for Support Personnel

Live Online & Classroom Enterprise Training

Location: Bangalore, India | Dubai, UAE

Industry Experienced Instructor  |  Remote Labs  |  Lab Access Post Training

Need help finding the right training?

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.

Course Prerequisites

  • Knowledge of SQL

Course Agenda

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
  • DBMS_STATS
  • Execution Plans
  • Autotrace
  • SQL_TRACE And TKPROF
  • Using Hints
  • Stored Outlines And Plan Stability

15.  Performance Tuning

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