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 Database Administration I

GK# 7491 Vendor# OR202

Course Overview

TOP

In this course, you will learn about the Oracle Server architecture, expand the size of the database, implement security, and how to perform specific database administration tasks.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

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

Outline

TOP
Viewing outline for:

Virtual Classroom Live 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

TOP
Viewing labs for:

Virtual Classroom Live 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

Prerequisites

TOP

Who Should Attend

TOP
  • Data analysts
  • Database administrators
  • 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