Oracle 12c Data Base Administration Express Introduction for Support Personnel

Overview

Course Description

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.

Audience Profile

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

Prerequisites

  • Knowledge of SQL
  • Oracle 12c SQL & SQLPLUS Express Introduction
  • Oracle 12c PL/SQL Introduction

Learning Objectives

  • 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

Course Outline

Course Outline

Module 1: Introduction
Lessons
• Describe the basic concepts of a relational database
• Discuss core database administrator tasks
Lab: Architecture / Advanced Memory Management

Module 2: Architecture
Lessons
• Describe Oracle database architecture
• Understand the instance architecture
• Use the management framework, and the database creation assistant
Lab: Starting and Stopping the Database

Module 3: Controlling the database
Lessons
• Start and stop the agent, the enterprise manager database console, and the listener
• Startup and shutdown the database
Lab: Managing Tablespaces / Datafiles

Module 4: Storage Structures
Lessons
• Define the purpose of tablespaces and data files
• Create and manage tablespaces
• Obtain tablespace information
Lab: Oracle Database Files

Module 5: Administering users
Lessons
• Create and manage database user accounts, and manage roles
• Grant and revoke privileges
• Control resource usage by users
Lab: Users and Security

Module 6: Oracle Database Security
Lessons
• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features, and Audit database activity
Lab: Oracle Networking

Module 7: Oracle Net Services
Lessons
• 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
Lab: Configuring the Database for Backup

Module 8: Performance Monitoring
Lessons
• Troubleshoot invalid / unusable objects
• Gather optimizer statistics
• View performance metrics
• Reacting to performance issues
Lab: Basic Database Media Recovery

Module 9: Diagnostic Sources
Lessons
• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling trace file size
• Alert notification
Lab: Archivelog Setup

Module 10: Backup and Recovery Concepts
Lessons
• 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
Lab: Automation Tools

Module 11: Database backups
Lessons
• Create consistent database backups, incremental backups, and Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down
Lab: Performance Tuning Tools

Module 12: Database Recovery
Lessons
• 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
Lab: Oracle Job Scheduling

Module 13: Scheduler
Lessons
• Creating jobs and job classes
• Creating schedules and windows
• Scheduler programs
• Prioritizing jobs
• Scheduler component reuse
• Query Scheduler information

Module 14: SQL Tuning Tools
Lessons
• 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

Module 15: Performance Tuning
Lessons
• Application Identification
• Enterprise Manager Tools
• SQL Tuning Advisor
• SQL Access Advisor
• DBMS_SQLTUNE
• DBMS_ADVISIOR
• Quick Tune

Register for Course

Tuition
Available Registrations: Unlimited
The Tuition ticket is sold out. You can try another ticket or another date.

Cost

$2,650.00

Course Code

FRCORA-13

Course Duration

5

Instructions Method

Instructor Led
Category
REGISTER