Online Oracle Database 12c Administrator Certified Associate Course

Become Oracle Certified and expand your IT job opportunities.

Quick Details

Towson University’s online Oracle Database 12c Administrator Certified Associate course teaches you how to master the skills associated with becoming Oracle (OCA) Certified. Completion of this course prepares you to sit for Oracle 12c Certification Exams IZ0-071 and 1Z0-062: Oracle Database 12c: Administration (OCA) certification exams. Passing the exam ensures you have a strong foundation and expertise in the industry’s most advanced database management system—Oracle 12c.

Total Hours: 180

Tuition: $2,699

Location: Online

This course is WIOA approved and is on the Maryland Eligible Training Provider List (ETPL).

This course is delivered by our education partners at Ed4Career.

Upcoming Date Schedule REGISTER
Open enrollment. Begin anytime. Set your own. Must be completed within twelve months of registration. Register

We create opportunities for Greater Baltimore’s Workforce.

Learn More

Have questions? We have answers.

Request Information

More About This Course

The process of becoming Oracle Database certified broadens your knowledge and skills by exposing you to a wide array of important database features, functions and tasks. Our training course teaches you how to master the skills associated with becoming Oracle (OCA) Certified. You’ll become more valuable to your current and/or future potential employer. Earning this in demand certification will expand your job opportunities, support job stability, and speed up your career. The Oracle Database 12c Administrator Certification ensures that as database professionals you have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 12c.

Our training course prepares you for two Oracle certification exams: IZ0-071 and IZ0-062. Your training will describe how to use SQL features, how to create and manage tables, how to manipulate data, running queries, managing schema objects, how to install and maintain an Oracle database, how to configure the Oracle network environment, managing data and databases, SQL features, backup/recovery techniques, upgrading, and migrating data.

Candidates can prepare for the exams by taking this training; no other prerequisites are required by Oracle.

By the end of this course, you will be able to:

  • Identify SQL features and how to manage tables
  • Recall how to manipulate data, restrict, and sort data
  • Recognize how to report aggregated data and how to display data
  • Describe how to run subqueries and how to manage schema objects
  • List how to manipulate large data sets and how to control user access
  • Identify the fundamentals of installing Oracle Database software
  • Recognize the architectural components of the Oracle Database as well as how to manipulate data
  • Recall how to create an Oracle Database and how to manage storage and space
  • List how to implement security and auditing functions as well as how to manage database performance
  • Recognize how to use the back-up recovery system, how to perform and upgrade and how to configure grid infrastructure

Module 1: SQL and DDL Statements

  • Identify the Connection Between an ERD and a Relational Database
  • Relationship Between a Database and SQL
  • Purpose of DDL
  • Purpose of DML
  • SELECT Statement
  • Categorize the Main Database Objects
  • Create a Simple Table
  • Review the Table Structure

Module 2: Manipulating Data

  • Truncate Data
  • Insert Rows into a Table
  • Update Rows in a Table
  • Delete Rows from a Table
  • Control Transactions
  • Restricting and Sorting Data
  • SQL Row Limiting

Module 3: Single-Row Functions and Conversion Functions

  • Character and Number Functions
  • Date Functions
  • DUAL Table
  • Conversion Functions
  • Analytical Functions
  • Nesting Functions
  • SELECT Statements

Module 4: Aggregated Data – Group Functions and Multiple Tables

  • Describe the Use of Group Functions
  • Group Data by Using the GROUP BY Clause
  • Displaying Data from Multiple Tables
  • Different Types of Joins and Their Features
  • Join a Table to Itself by Using a Self-Join
  • Inner Joins and National Joins
  • USING

Module 5: Subqueries and Schema Objects

  • Define Subqueries
  • Types of Subqueries
  • Update and Delete Rows Using Correlated Subqueries
  • EXISTS and NOT EXISTS Operators
  • Write Single-Row and Multiple-Row Subqueries
  • How Schema Objects Work
  • Create Simple and Complex Views with Visible/Invisible Columns
  • Create, Maintain, and Use Sequences
  • Perform Flashback Operations

Module 6: Set Operators and Data Dictionary Views

  • Describe Set Operators
  • Control the Order of Rows Returned
  • ORDER BY – By Position
  • ORDER BY – By Reference
  • Query Various Data Dictionary Views
  • Dynamic Performance Views

Module 7: Manipulating Large Data Sets and Controlling User Access

  • Features of Multitable INSERTS
  • Merge Rows into a Table
  • System Privileges from Object Privileges
  • Grant Privileges on Tables and on a User
  • Distinguish Between Privileges and Roles

Module 8: Exploring the Oracle Database Architecture

  • Install the Oracle Database Software
  • User Accounts
  • OUI Inventory
  • Generate Database Creation Scripts by Using DBCA
  • Configure Database Options by Using DBCA
  • Memory Structures
  • Background Processes
  • Physical Database Structures
  • Logical Database Structures

Module 9: Managing and Configuring

  • Use Database Management Tools
  • Understand Initialization Parameter Files
  • Alert Logs and Dynamic Performance Views
  • Configure Oracle Net Services
  • Configure Client-Side Network
  • Configure Communication Between Databases
  • Describe Storage of Table Row Data in Blocks
  • Create and Manage Tablespaces

Module 10: Managing Space and User Security

  • Save Space by Using Compression
  • Segment Advisor
  • Manage Resumable Space Allocation
  • Create and Manage Database User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles and Profiles
  • DML and Undo Data Generation
  • Monitor and Administer Undo Data

Module 11: Auditing and Maintenance

  • Shared and Exclusive Locks
  • Automatic and Manual Locking
  • Monitor and Resolve Locking Conflicts
  • DBA Responsibilities for Security and Auditing
  • Enable Standard Database Auditing and Unified Auditing
  • Manage the Automatic Workload Repository (AWR)
  • Describe and Use the Advisory Framework
  • Set Alert Thresholds
  • Automated Tasks

Module 12: Performance and Resources

  • Use Automatic Memory Management
  • Use the Memory Advisor to Size Memory Buffers
  • Manage Optimizer Statistics
  • Use the SQL Tuning Advisor
  • Use the SQL Access Advisor to Tune Workload
  • Configuring the Database Resource Manager
  • Access and Create Resource Plans

Module 13: Automating Tasks, Backup, and Recovery

  • Job Chains to Perform a Series of Tasks
  • Use Scheduler Jobs on Remote Systems
  • Moving Data
  • Create and Use Directory Objects
  • SQL*Loader
  • Oracle Data Pump
  • Back and Recovery: Configuration
  • Configure Fast Recovery Area
  • Automate Database Backups
  • Manage Backups

Module 14: Restart and Upgrades

  • Configure Storage for Oracle Automatic Storage Management
  • Standalone Server
  • Using Oracle Restart to Manage Components
  • Upgrade Methods
  • Migration Methods
  • Upgrade Process
  • Upgrade Requirements
  • Migrate to Unified Auditing

Outlines are subject to change, as courses and materials are updated.

Download Course Outline (PDF)

Upon successful completion of this course, students will be prepared to sit for both the Oracle 12c IZ0-071: Oracle Database 12c: Administration (OCA) certification exam and Oracle 12c IZ0-062: Oracle Database 12c: Administration (OCA) certification exam.

Internet Connection*

  • Broadband or High-Speed - DSL, Cable, and Wireless Connections

*Dial-Up internet connections will result in a diminished online experience. Classroom pages may load slowly and viewing large audio and video files may not be possible.

Hardware Requirements

  • Processor - 2GHz Processor or Higher
  • Memory - 1 GB RAM Minimum Recommended
  • Webcams are strongly recommended.

PC Software Requirements

  • Operating Systems - Windows 7 or higher
  • Microsoft Office 2013 or higher. Also, you could use a general Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers - Google Chrome is highly recommended, Cookies MUST be enabled, Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • QuickTime, Windows Media Player &/or Real Player

MAC Software Requirements

  • Operating Systems - Mac OS x 10 or higher with Windows
  • Mac office programs or a Word Processing application to save and open Microsoft Office formats (.doc, .docx, .xls, .xlsx, .ppt, .pptx)
  • Internet Browsers- Google Chrome is highly recommended, Cookies MUST be enabled, Pop-ups MUST be allowed (Pop-up Blocker disabled)
  • The Kindle Reader App or VitalSource Bookshelf App are needed for many of our courses (No special equipment needed. This can be downloaded for FREE onto your computer.)
  • PowerPoint Viewer (if you do not have PowerPoint)
  • Adobe PDF Reader
  • Apple QuickTime Media Player