Oracle Database 12c: Fundamentals for Developers and System Administrators




    2 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    This Oracle Database 12c: Fundamentals for Developers and System Administrators course has been designed for Database Administrators that helps them to perform basic Oracle Database 12c administration tasks that are essential to operating the database. This course will also introduce you to Oracle Database Cloud Service.

    Completion of this training course will enable candidates in:

    • Installing Oracle Database 12c software and create a database.
    • Using Enterprise Manager Database Express to manage the database.
    • Managing database storage structures and schema objects.
    • Administering users and security.
    • Backing up and recovering the Oracle Database.
    • Monitoring the database and use the Advisors.
    • Gaining an understanding of the Oracle Database Cloud Service.

    Course Benefits:

    Attaining certification of this course will ensure fast, reliable, secure and easy to manage performance. Also, this training will help individuals to optimize database workloads, at lower IT costs and deliver the better quality of service. 

    1. Course Overview

    • Course Objectives & Agenda
    • Course Environment & Additional Resources

    2. Oracle Database: Overview

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

    3. Installing and Creating a Database

    • Installation Workflow
    • Oracle Universal Installer
    • Installation Prerequisites
    • Set Environment Variables
    • Installation Steps
    • Configure Security Updates
    • Download Software Updates
    • Specify Installation Options

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

    • Management Framework
    • Enterprise Manager Database Express: Overview
    • Configure the HTTPS Port for EM Express
    • Access EM Express
    • Use the Database Home Page
    • Navigate Through EM Express
    • Grant Access to EM Express
    • SQL*Plus

    5. Configuring the Oracle Network Environment

    • Overview of Network Configuration
    • Oracle Net Listener: Configuration and Management
    • Tools to Configure and Manage the Oracle Network
    • Use the Listener Control Utility
    • Connect to an Oracle Database
    • Name Resolution
    • Oracle Net: Naming Methods

    6. Managing the Oracle Instance

    • Oracle Instance Management
    • Initialization Parameters
    • Oracle Processes
    • Oracle Memory Structures
    • Start and Shut Down an Instance
    • States of an Instance
    • Stop and Start an Instance by Using SQL*Plus
    • Stop and Start an Instance by Using SQL Developer

    7. Managing Database Storage Structures

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

    8. Administering Users and Security

    • Overview of Users and Security
    • Oracle-Defined Users
    • Create Users
    • Modify Users
    • Drop Users
    • Lock and Unlock Accounts
    • Unlock a User Account and Resetting the Password
    • Set the Password Policy

    9. Managing Schema Objects

    • What Is a Schema?
    • Access Schema Objects
    • Specify Data Types in Tables
    • Create and Modifying Tables
    • Modify a Table
    • Understand Data Integrity
    • Define Constraints

    10. Performing Backup and Recovery

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

    11. Monitoring the Database and Using the Advisors

    • Proactive Database Monitoring
    • Monitor General Database State and Workload
    • Monitor Performance
    • Diagnose Performance Problems
    • Types of ADDM Findings
    • View a Summary of ADDM Performance Findings
    • Respond to Findings
    • Use Advisors

    12. Managing the Software

    • Understand Software Management and Patch Releases
    • Patch Oracle Database Software
    • Use the Database Upgrade Assistant to Upgrade the Database
    • Remove Oracle Database Software

    13. Oracle Database Cloud Service: Overview

    • Architecture, Features, and Tooling of Database as a Service
    • Software Editions: Included Database Options and Management Packs
    • Automated Database Provisioning
    • Manage the Compute Node Associated with a Database Deployment
    • Manage Network Access to Database as a Service
    • Enable Access to a Compute Node Port
    • Scale a Database Deployment & Patching Database as a Service
    • Use the Oracle Database Cloud Service Console to Manage Patches

    This Oracle 12c Fundamentals course is ideal for those working with the profiles of:

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

    Basic understanding of the Linux operating system

    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.