Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 12c Data Base Administration Express Introduction for Support Personnel

GK# 7496 Vendor# OR227

Course Overview

TOP

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.

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

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

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

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

Prerequisites

TOP

Who Should Attend

TOP
  • Database administrators
  • Support engineers
  • Technical consultants
  • Systems administrators
  • Network managers
  • Technical support personnel
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll