Oracle Database 12cR2 Essential Administration Training Course

Course Contents - DAY 1

Course Introduction

• • Administration and Course Materials
• • Course Structure and Agenda
• • Delegate and Trainer Introductions

Session 1: INTRODUCTION

• • Oracle product overview
• • Oracle Support services
• • Relational database concepts
• • Oracle architecture
• • Oracle Multitenant architecture
• • Overview of the Oracle Cloud
• • Database administration tasks
• • Database administration responsibilities

Session 2: INSTALL THE ORACLE DATABASE SOFTWARE WITH THE OIU

• • Installation planning
• • Understand system requirements and operating system pre-requisites
• • Oracle flexible architecture
• • Environment variables
• • Use Oracle Universal Installer to install Oracle software (OUI)
• • The Oracle Inventory
• • De-install Oracle Database softare

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

• • Select a storage method
• • Select a CDB or non-CDB database
• • Select a database type based on workload
• • Select a character set for the database
• • Create a database using the DBCA

Session 4: ADMINISTER A DATABASE

• • Administrative tools available to a DBA
• • Use SQL*Plus and SQL Developer to manage a database
• • Administer the database using Enterprise Manager Express
• • An overview of Enterprise Manager Cloud Control

Session 5: CONFIGURE THE ORACLE NETWORK ENVIRONMENT

• • Overview of network configuration
• • Oracle Net Listener configuration and management
• • Oracle Net Naming methods
• • Tools for configuring and managing the Oracle network
• • Configure local naming for client connections with Net Manager
• • Start and stop the Oracle listener
• • Configure the listener with EM
• • Use TNSPING to test Oracle Net connectivity
• • Connect to the database

Oracle Database 12cR2 Essential Administration Training Course

Course Contents - DAY 2

Session 6: MANAGE AN ORACLE INSTANCE

• • Oracle Instance
• • Instance management
• • Memory structures
• • Background processes
• • Database authentication methods
• • Initialization parameters
• • Password file
• • Shut down the database
• • Start up the database
• • View alert log and trace files

Session 7: DATABASE STORAGE STRUCTURES

• • Oracle database structures
• • Control files
• • Redo log and archive redo log files
• • Tablespaces and data files
• • Create tablespaces
• • Manage tablespaces
• • Manage undo and use the Undo Advisor
• • Use Enterprise Manager Express and SQL Developer to view the storage structure of the database

Session 8: MANAGE USERS

• • Database administration accounts
• • User accounts
• • Create and administer user accounts
• • Lock and unlock user accounts
• • Change a user's password
• • Administer privileges and roles

Session 9: MANAGE SCHEMA OBJECTS

• • Create schema objects
• • Create a new table
• • View the attributes and contents of a table
• • Understand data integrity
• • Define constraints
• • Create indexes
• • View index attributes
• • Create views
• • Create synonyms
• • Create sequences

Session 10: BACKUP,RECOVER AND RESTORE A DATABASE

• • Oracle backup strategy
• • Overview of backup,restore and recovery
• • Backup and recovery configuration
• • Configure ARCHIVELOG mode
• • Overview of backup and recovery operations
• • Overview of scheduled backups
• • Configure backup settings
• • Configure recovery settings
• • Perform recovery

Session 11: PERFORMANCE MONITORING

• • Overview of self-monitoring architecture
• • Monitor an Oracle database
• • Automatic Workload Repository
• • Automatic Database Diagnostics Monitor (ADDM)
• • Additional monitoring
• • Use the advisors