Oracle Database 12c: Fundamentals for Developers and System Administrators

Course DateLocationDaysPriceRegister
Call for Classroom Training Dates2 $1,930Register


Course DateLocationDaysPriceRegister
Sep 7, 2017Live Virtual - 3:00 am Eastern2 $1,840Register
Nov 2, 2017Live Virtual - 4:00 am Eastern2 $1,840Register
Nov 2, 2017Live Virtual - 5:00 am Eastern2 $1,840Register
Sep 5, 2017Live Virtual - 9:00 am Eastern2 $1,840Register
Oct 2, 2017Live Virtual - 9:30 pm Eastern2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,700Register


Oracle Database 12c: Fundamentals for Developers and System Administrators

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.

Duration: 2 Days

Learn to:

  • Install Oracle Database 12c software and create a database.
  • Use Enterprise Manager Database Express to manage the database.
  • Manage database storage structures and schema objects.
  • Administer users and security.
  • Backup and recover the Oracle Database.
  • Monitor the database and use the Advisors

Audience:

  • Database Administrators
  • Technical Administrator
  • Technical Consultant
  • Support Engineer

Required Prerequisites:

  • Basic understanding of the Linux operating system

Course Objectives:

  • Install Oracle Database 12c
  • Create a Database
  • Use Enterprise Manager Database Express to manage the database
  • Manage database storage structures and schema objects
  • Administer users and security
  • Backup and recover the Oracle database
  • Monitor the database and use the Advisors

Topics:

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 Develop

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

 

Course DateLocationDaysPriceRegister
Call for Classroom Training Dates2 $1,930Register


Course DateLocationDaysPriceRegister
Sep 7, 2017Live Virtual - 3:00 am Eastern2 $1,840Register
Nov 2, 2017Live Virtual - 4:00 am Eastern2 $1,840Register
Nov 2, 2017Live Virtual - 5:00 am Eastern2 $1,840Register
Sep 5, 2017Live Virtual - 9:00 am Eastern2 $1,840Register
Oct 2, 2017Live Virtual - 9:30 pm Eastern2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,700Register