Oracle Database 12c: Fundamentals for Developers and System Administrators

Oracle Database 12c: Fundamentals for Developers and System Administrators Certification Training Course Overview

This Oracle Database 12c: Fundamentals for Developers and System Administrators training course will helps you perform the basic Oracle Database 12c administration tasks. In this course, you will Learn how to keep the database operational and introduction to Oracle Database Cloud Service.

This course is recommended for Database Administrators of small to medium sized businesses.

Oracle Database 12c: Fundamentals for Developers and System Administrators (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 850
20 - 21 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 05 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 02 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 950
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1:Course Overview
  • Additional Resources
  • Course Objectives
  • Course Agenda
  • Course Environment
Module 2:Oracle Database: Overview
  • Oracle Instance and Database: Overview
  • Relating Multiple Tables
  • Relational Databases: Introduction
  • SQL Statements
  • Structured Query Language (SQL)
  • Relational Database Terminology
  • Using SQL to Access the Database
  • Development Tools for Oracle Database
Module 3:Installing and Creating a Database
  • Configuring Security Updates
  • Specifying Installation Options
  • Installation Workflow
  • Installation Steps
  • Setting Environment Variables
  • Oracle Universal Installer
  • Downloading Software Updates
  • Installation Prerequisites
Module 4:Using Oracle Enterprise Manager Database Express and SQL-Based Management Tools
  • Granting Access to EM Express
  • Management Framework
  • Accessing EM Express
  • Enterprise Manager Database Express: Overview
  • Navigating Through EM Express
  • Using the Database Home Page
  • SQL * Plus
  • Configuring the HTTPS Port for EM Express
Module 5: Configuring the Oracle Network Environment
  • Network Configuration: Overview
  • Oracle Net Listener: Configuration and Management
  • Tools for Configuring and Managing the Oracle Network
  • Oracle Net: Naming Methods
  • Name Resolution
  • Connecting to an Oracle Database
  • Using the Listener Control Utility
Module 6:Managing the Oracle Instance
  • Oracle Processes
  • Oracle Memory Structures
  • Initialization Parameters
  • Oracle Instance Management
  • Starting and Shutting Down an Instance
  • States of an Instance
  • Stopping and Starting an Instance by Using SQL Developer
  • Stopping and Starting an Instance by Using SQL * Plus
Module 7:Managing Database Storage Structures
  • Tablespaces and Data Files
  • Tablespaces in the Preconfigured Database
  • Exploring the Storage Structure of the Oracle Database
  • Enlarging the Database
  • Control File
  • Multiplexing the Redo Log
  • Redo Log Files
  • Oracle Database Structures
Module 8:Administering Users and Security
  • Unlocking to User Account and Resetting the Password
  • Setting the Password Policy
  • Creating Users
  • Dropping Users
  • Locking and Unlocking Accounts
  • Overview of Users and Security
  • Oracle-Defined Users
  • Modifying Users
Module 9:Managing Schema Objects
  • Modifying a Table
  • Schemas
  • Creating and Modifying Tables
  • Understanding Data Integrity
  • What Is a Schema?
  • Accessing Schema Objects
  • Specifying Data Types in Tables
  • Defining Constraints
Module 10:Performing Backup and Recovery
  • Oracle Recovery Features
  • Configuring the Fast Recovery Area
  • Backup File Types
  • Types of Backups
  • Media Recovery Step
  • Media Recovery Options
  • Configuring the Database for Backup and Recovery
  • Credentials Required to Perform Backup and Recovery
Module 11:Monitoring the Database and Using the Advisors
  • Types of ADDM Findings
  • Proactive Database Monitoring
  • Responding to Findings
  • Viewing a Summary of ADDM Performance Findings
  • Diagnosing Performance Problems
  • Monitoring Performance
  • Using Advisors
  • Monitoring General Database State and Workload
Module 12:Managing the Software
  • Patching Oracle Database Software
  • Understanding Software Management and Patch Releases
  • Using the Database Upgrade Assistant to Upgrade the Database
  • Removing Oracle Database Software
Module 13:Oracle Database Cloud Service: Overview
  • Software Editions: Included Database Options and Management Packs
  • Automated Database Provisioning
  • Using the Oracle Database Cloud Service Console to Manage Patches
  • Managing the Compute Node Associated with a Database Deployment
  • Database as a Service Architecture, Features and Tooling
  • Scaling to Database Deployment & Patching Database as a Service
  • Enabling Access to a Compute Node Port
  • Managing Network Access to Database as a Service
Download Course Contents

Request More Information

Course Prerequisites
  • Fundamental understanding of the Linux operating system
  • 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.
  • Gain an understanding of the Oracle Database Cloud Service.