Oracle - Course Details

OraD12c:FDSAN Oracle Database 12c: Fundamentals for Developers and System Administrators NEW

Oracle Course Description:
This course is ideal for Database Administrators of small to medium sized businesses. This Oracle Database 12c: Fundamentals for Developers and System Administrators course helps you perform basic Oracle Database 12c administration tasks needed to keep the database operational.
Oracle Course Duration:
2 DAYS
Oracle Course Target Audience:
Database Administrators,Support Engineer,Technical Administrator,Technical Consultant
Oracle Course Prerequisite:
Basic understanding of the Linux operating system
Course Content:
  • Course Overview

    • Course Objectives
    • Course Agenda
    • Course Environment
    • Additional Resources

  • Oracle Database: Overview

    • Relational Databases: Introduction
    • Relational Database Terminology
    • Relating Multiple Tables
    • Structured Query Language (SQL)
    • SQL Statements
    • Using SQL to Access the Database
    • Development Tools for Oracle Database
    • Oracle Instance and Database: Overview

  • Installing and Creating a Database

    • Installation Workflow
    • Oracle Universal Installer
    • Installation Prerequisites
    • Setting Environment Variables
    • Installation Steps
    • Configuring Security Updates
    • Downloading Software Updates
    • Specifying Installation Options

  • Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools

    • Management Framework
    • Enterprise Manager Database Express: Overview
    • Configuring the HTTPS Port for EM Express
    • Accessing EM Express
    • Using the Database Home Page
    • Navigating Through EM Express
    • Granting Access to EM Express
    • SQL*Plus

  • Configuring the Oracle Network Environment

    • Network Configuration: Overview
    • Oracle Net Listener: Configuration and Management
    • Tools for Configuring and Managing the Oracle Network
    • Using the Listener Control Utility
    • Connecting to an Oracle Database
    • Name Resolution
    • Oracle Net: Naming Methods

  • Managing the Oracle Instance

    • Oracle Instance Management
    • Initialization Parameters
    • Oracle Processes
    • Oracle Memory Structures
    • Starting and Shutting Down an Instance
    • States of an Instance
    • Stopping and Starting an Instance by Using SQL*Plus
    • Stopping and Starting an Instance by Using SQL Developer

  • Managing Database Storage Structures

    • Oracle Database Structures
    • Exploring the Storage Structure of the Oracle Database
    • Control File
    • Redo Log Files
    • Multiplexing the Redo Log
    • Tablespaces and Data Files
    • Tablespaces in the Preconfigured Database
    • Enlarging the Database

  • Administering Users and Security

    • Overview of Users and Security
    • Oracle-Defined Users
    • Creating Users
    • Modifying Users
    • Dropping Users
    • Locking and Unlocking Accounts
    • Unlocking a User Account and Resetting the Password
    • Setting the Password Policy

  • Managing Schema Objects

    • What Is a Schema?
    • Schemas
    • Accessing Schema Objects
    • Specifying Data Types in Tables
    • Creating and Modifying Tables
    • Modifying a Table
    • Understanding Data Integrity
    • Defining Constraints

  • Performing Backup and Recovery

    • Oracle Recovery Features
    • Backup File Types
    • Types of Backups
    • Media Recovery Options
    • Media Recovery Step
    • Configuring the Database for Backup and Recovery
    • Configuring the Fast Recovery Area
    • Credentials Required to Perform Backup and Recovery

  • Monitoring the Database and Using the Advisors

    • Proactive Database Monitoring
    • Monitoring General Database State and Workload
    • Monitoring Performance
    • Diagnosing Performance Problems
    • Types of ADDM Findings
    • Viewing a Summary of ADDM Performance Findings
    • Responding to Findings
    • Using Advisors

  • Managing the Software

    • Understanding Software Management and Patch Releases
    • Patching Oracle Database Software
    • Using the Database Upgrade Assistant to Upgrade the Database
    • Removing Oracle Database Software