2001 - Oracle 12c Database Administration I


2001 - Oracle 12c Database Administration I


Price
Length : 5 days
$2,695.00

What You'll Learn

• Oracle Server Architecture
• Install Oracle Server Software
• Start and Stop an Oracle Database
• Manage Tablespaces and Undo Segments
• Create an Oracle Database
• Create Tables, Constraints, and Indexes
• Create All Other Database Objects
• Manage Redo Logs
• Manage Tablespaces and Datafiles
• Manage Controlfiles
• Manage Security
• Audit the Database
• Manage Oracle Networking
• Perform Appropriate Backups
• Perform Complete and Incomplete Recoveries

Who Needs to Attend

• Data analysts
• Database administrators
• Systems administrators
• Network managers
• Technical support personnel

Prerequisites

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

Outline

  1. Introduction and Duties of the DBA
    • Oracle RDBMS Components
    • DBA Responsibilities
    2. Tables, Constraints, and Indexes
    • Introduction to Datatypes and Tables
    • Integrity Constraints
    • Temporary Tables, Partitioned Tables, External Tables, and IOTs
    • Indexes and Skip Scanning
    • Online Reorganization
    • Database Workspace Management
    3. Other Database Schema Objects
    • DDL Commands used
    • Views, Materialized views
    • Sequences, Synonyms, Database Links
    • Outlines, Dimensions, Hierarchies
    • PL/SQL Program Units
    • Supplied Packages
    • Oracle Data Dictionary
    • Storage of Large Objects (BFILEs, BLOBs, CLOBs)
    4. Starting and Stopping the Database
    • What Tool to Use?
    • Connecting as a Privileged User
    • Password file authentication
    • Starting a Database
    • Shutting Down a Database
    • Reading the Alert Log / Trace Files
    • Quiescing the database
    • SPFILE / Parameter management
    5. How Space is Physically Consumed - Blocks and Extents
    • Basic Definitions
    • Blocks and Extents
    • Fragmentation / Deallocation
    6. How Space is Logically Consumed - Segments
    • Introduction to Segments
    • Managing Undo Segments
    • Automatic Undo Management
    • Managing Sort Activity
    • Managing Data Segments
    • Managing Index Segments
    • Monitoring Database segments
    7. Managing Tablespaces - Default behavior of CREATE TABLESPACE command
    • Tablespace Overview
    • System Tablespace
    • Types of Tablespaces
    • Creating additional tablespaces
    • Altering Tablespaces
    • Temporary Tablespaces - Default Temporary Tablespaces
    • Tablespace Quotas
    • Monitoring Tablespaces
    8. Basic Oracle Architecture
    • Architecture Overview
    • Database Structures
    • Process Structures
    • Memory Structures - SGA
    • Memory Structures - PGA
    • Alternative Configurations
    9. Oracle Database Files
    • Basic Structures of an Oracle RDBMS
    • Data Files
    • Redo Log Files
    • Archived Redo Log Files
    • Control Files
    • Oracle-Managed Files (OMF)
    10. Users and Security
    • Managing Database Users
    • System / Object Privileges
    • Managing Roles / Profiles
    • Resource and Password Management
    • The Virtual Private Database
    11. Networking
    • Duties of the DBA for Networking
    • Overview of Oracle Network Architecture
    • Name Resolution
    • Oracle Net Client Configuration
    • Oracle Net Server Configuration
    • Tools
    • Configuring the Listener
    • Shared Server
    12. Physical NOARCHIVELOG Mode Backups
    • Oracle Database Backups
    • Automatic Recovery Architecture
    • NOARCHIVELOG Mode
    • ARCHIVELOG Mode
    • Physical Backups
    • Closed Backups in NOARCHIVELOG Mode
    13. Configuring Archivelog Mode
    14. Physical ARCHIVELOG Mode Backups
    • Configuration of the database for archiving
    • Setting the ARCHIVELOG mode
    • Establishing multiple archiving destinations
    • Closed backups in ARCHIVELOG mode
    • Open backups in ARCHIVELOG mode
    • Controlfile Backup
    15. Complete Recovery
    • Recovery Structures and Processes
    • Recovery in NOARCHIVELOG and ARCHIVELOG Mode
    16. Incomplete Recovery
    • What is Incomplete Recovery?
    • Recovering from Loss of Current Redo Log Files
    17. Data Loading
    • SQL*Loader
    • External Tables Data Pump

Labs

• Lab 1: Architecture
• Lab 2: Database Startup and Shutdown
• Lab 3: Using and Managing SPFILES and Parameters
• Lab 4: Creating Tables, Indexes, and Constraints
• Lab 5: Creating Other Database Schema Objects
• Lab 6: Users and Security
• Lab 7: Undo Segments
• Lab 8: Segments
• Lab 9: Managing Tablespaces
• Lab 10: Multiple Block Size Management
• Lab 11: Advanced Memory Management
• Lab 12: Oracle Database Files
• Lab 13: Data Loading
• Lab 14: Backup and Archivelog Mode
• Lab 15: Complete Recovery
• Lab 16: Incomplete Recovery

Class Dates:

Classes being scheduled,
call 1-800-755-0142 or

Contact Us with your request.

On Site Class Available

ExpertONE Learning Solutions Provider Microsoft Certified Partner Logo GSA Advantage