Oracle Database 12c: Fundamentals for Developers and System Administrators

Download Course Contents

Oracle Database 12c: Fundamentals for Developers and System Administrators 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.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1:Course Overview
  • Additional Resources
  • Course Objectives
  • Course Agenda
  • Course Environment
  • 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
  • Configuring Security Updates
  • Specifying Installation Options
  • Installation Workflow
  • Installation Steps
  • Setting Environment Variables
  • Oracle Universal Installer
  • Downloading Software Updates
  • Installation Prerequisites
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Patching Oracle Database Software
  • Understanding Software Management and Patch Releases
  • Using the Database Upgrade Assistant to Upgrade the Database
  • Removing Oracle Database Software
  • 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
Live Online Training (Duration : 16 Hours)
Group Training 850 Per Participant Incl. Official Courseware
30 - 31 May 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 1700 950 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 32 hours is too long. We can offer Comfort Track for 16 hours for only USD 760

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.

Request More Information

Add Name and Email Address of participant (If different from you)


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner