Oracle Database 12c: Fundamentals for Developers and System Administrators (D79228) – Outline

Detailed Course Outline

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