Oracle Database 12c: Administration - Canada

Oracle Database 12c: Administration Course Outline

Module 1: Introduction to Oracle Database 12c

• Overview of the Oracle Database 12c
• Oracle Cloud
• Relational Database Concepts
• Database Administration Tasks

Module 2: Oracle Database Architecture

• Overview of the Oracle Database Architecture
• Oracle Database Instance
• Oracle Database Memory Structures
• Process Architecture
• Server and Client Processes
• Oracle Database Storage Structure

Module 3: Administer a Database Instance

• Administrative Tools Available to a DBA
• Starting SQL*Plus and Connecting to the Database
• Creating a Database Connection Using SQL Developer
• Administer the Database Using Enterprise Manager (EM)
• Enterprise Manager Framework
• Enterprise Manager Cloud Control
• Initialisation Parameter Files

Module 4: Configure the Oracle Network Environment

• Network Configuration
• Oracle Net Listener Configuration and Management
• Tools for Configuring and Managing the Oracle Network
• Configure Client Connections with Net Manager
• View Listener Configuration
• Start and Stop the Oracle Listener
• Connect to the Database

Module 5: Storage Structures

• Data Block
• Tablespaces and Datafiles
• Create and Alter Tablespace Commands
• Temporary Tablespaces
• Create and Manage Data Files
• Use OMF
• Drop Tablespaces and Datafiles

Module 6: Manage Users

• Predefined Database Administration Accounts
• User Accounts
• Create a User Account
• User Authentication
• Change User’s Password
• Manage a User Account
• Drop a User Account
• Terminate User Sessions

Module 7: Manage Profiles and Resources

• User Profiles
• Profile Resource Parameters
• Create Profile Command
• Manage Passwords with Profiles
• Control Resource Usage with Profiles

Module 8: Manage Privileges

• Common Roles
• System and Object Level Privileges
• Grant and Revoke Commands
• Create, Modify, and Drop Roles
• Use Predefined Roles

Module 9: Database Auditing

• What is Database Security?
• Introduction to Database Auditing
• Security Compliance
• Unified Audit Trail
• Specify Audit Options

Module 10: Data Concurrency and Lock Conflicts

• Lock Modes in Oracle
• Data Concurrency
• Locking Behaviour
• DML Locks
• Lock Conversion and Escalation
• User-Defined Locks

Module 11: Proactive Database Maintenance

• Database Maintenance
• View the Alert Log
• Automatic Workload Repository
• Statistic Levels
• Automatic Database Diagnostic Monitoring
• Monitor an Oracle Database
• Use the Advisors

Module 12: Performance Management

• Tuning Information Sources
• Designing and Developing for Performance
• Instance Tuning
• Managing Memory

Module 13: SQL Tuning

• What is SQL Tuning?
• Oracle Optimiser
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Tuning Advisor

Module 14: Moving Data

• Create Directory Objects
• Oracle Data Pump Overview
• Data Pump API
• Oracle Database Vault Data Dictionary Views
• SQL Loader
• Control File
• Data Files
• External Tables

Module 15: Automate Tasks with the Scheduler

• Introduction to the Scheduler
• Access Rights
• Scheduler Components and Workflow

Module 16: Managing Resources with Resource Manager

• Database Resource Manager
• Create Resource Plans
• Automated Maintenance Tasks Reference
• Create Resource Plan Directives
• Resource Manager Administration Privileges

Module 17: Manage Space

• Logical Space Management
• Space Management in Data Blocks
• Segment Types
• Allocate and Deallocate Extents
• Row Chaining and Migration

Module 18: Oracle Support

• Enterprise Manager Support Workbench
• Oracle Support Integration
• Service Requests
• Manage and Apply Patches