Shop our Labor Day sale and take 40% off all regularly priced courses and bundles sitewide.  Just add to cart to see your discounts.

Lock In At Our Lowest Price Ever: $14.99/month for 2,500+ hours of IT training.
Limited time only. Enroll now, cancel anytime!

Oracle Database 11g (OCA)

This course is specifically created to help you ace the Oracle Database 11g Administrator (OCA 11g) Certification Exam. Acquiring this certification confirms that your database administration skills are at an optimal level, as it requires a deep understanding of one of the industry’s most sophisticated databases: Oracle 11g.

Included In This Course

Included In This Course

Total Hours
50  Training Hours
Oracle Database 11g (OCA)
182 On-demand Videos
Closed Caption

Closed Captions

Course Topics
32  Topics
Prep Questions
508 Prep Questions
Oracle Database 11g (OCA)

Certificate of Completion

Course Description

Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052)

This course is in preparation for the Oracle Database 11g Administrator (OCA 11g) certification exam. The Oracle Database 11g Administrator Certification (OCA 11g) ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

Oracle 11g training course will teach students how to install and maintain an Oracle database, how to create an operational database, and how to properly manage the various structures in an effective and efficient manner, including performance monitoring, database security, user management, and backup/recovery techniques.

Students will also learn skills required for working with SQL, including how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. After completing Oracle OCA 11g course, students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another.

Oracle databases are one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!

Frequently Asked Questions About Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052)

What’s the goal of this Oracle Database 11g Certified Associate (OCA) course?

The course is designed to get you ready to crush the Oracle Database 11g Administrator (OCA 11g) Certification Exam. Once you nail this certification, it shows you’ve got top-notch database administration skills with a strong understanding of Oracle 11g, one of the most advanced databases out there​.

What kind of content does the course offer?

This course provides a pretty solid package. You’ll get 50 hours of training, 182 on-demand videos, and 508 prep questions. It covers 32 topics, and to top it off, you’ll also get a Certificate of Completion at the end.

What will I learn from the course?

The course covers all the basics and then some. You’ll learn how to install and maintain an Oracle database, create an operational database, and effectively manage different structures. This includes performance monitoring, database security, user management, and backup/recovery techniques. On top of this, you’ll also learn SQL skills, like advanced querying and reporting techniques, as well as how to control privileges at the object and system level​.

Is this course for beginners or advanced learners?

This course is designed for learners who want to gain a deep understanding of Oracle 11g, whether you’re new to databases or already have some experience. However, keep in mind that it’s specifically aimed at preparing you for the Oracle Database 11g Administrator (OCA 11g) certification exam, so it’s pretty comprehensive and in-depth.

What does the course outline look like?

The course is split into several modules, each focusing on a specific aspect of Oracle 11g. For instance, you’ll learn about Oracle Architecture, Database Schema, and Recovery Manager, among others. Each module is broken down into several parts, making the content easier to digest. Plus, there are practical demos to give you a hands-on understanding of the concepts.

Why should I take this course?

Oracle databases are one of the most popular database platforms in the world. By taking this course and achieving Oracle certification, you’ll be boosting your skills and increasing your marketability. It’s a great way to stand out in the job market and accelerate your career.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Course Outline

Oracle 12c OCP 1Z0-062: Installation and Administration Course Content

Module 1: Database Concepts And Tools

  •    Instructor And Course Introduction

  •    Database Concepts And Tools - Part 1

  •    Database Concepts And Tools - Part 2

Module 2: Memory Structure

  •    Memory Structure - Part 1

  •    Memory Structure - Part 2

Module 3: Tables

  •    Tables - Part 1

  •    Tables - Part 2

Module 4: Indexes

  •    Indexes - Part 1

  •    Indexes - Part 2

Module 5: Constraints And Triggers

  •    Constraints And Triggers - Part 1

  •    Constraints And Triggers - Part 2

Module 6: Users

  •    Users

  •    Profiles

  •    Privileges

  •    Roles

Module 7: Internal Structures

  •    Storage Structures - Part 1

  •    Storage Structures - Part 2

  •    Internal Memory Structures - Part 1

  •    Internal Memory Structures - Part 2

  •    Background Processes - Part 1

  •    Background Processes - Part 2

Module 8: Starting Up and Shutting Down Database

  •    Starting And Stopping DataBase - Part 1

  •    Starting And Stopping DataBase - Part 2

Module 9: Critical Storage Files

  •    Critical Storage Files - Part 1

  •    Critical Storage Files - Part 2

Module 10: Data Manipulation Language

  •    DML Atomicity - Part 1

  •    DML Atomicity - Part 2

  •    DML Insert

  •    DML Update - Part 1

  •    DML Update - Part 2

  •    DML Delete And Review Of DML Statements - Part 1

  •    DML Delete And Review Of DML Statements - Part 2

Module 11: Data Concurrency

  •    Data Concurrency - Part 1

  •    Data Concurrency - Part 2

Module 12: BackUp And Recovery

  •    Back Up - Part 1

  •    Back Up - Part 2

  •    Back Up - Part 3

  •    RMAN Catalog

  •    RMAN BackUps - Part 1

  •    RMAN BackUps - Part 2

  •    Disaster Preparedness

  •    Recovery

  •    Flashback Recovery

Module 13: Installation

  •    Installation - Part 1

  •    Installation - Part 2

Module 14: Course Review

  •    Course Review - Part 1

  •    Course Review - Part 2

  •    Course Review - Part 3

  •    Course Review - Part 4

  •    Course Review - Part 5

  •    Course Outro

Oracle 12c OCP 1Z0-061: SQL Fundamentals Course Content

Module 1: Introduction To Oracle 12c SQL Fundamentals

  •    Introduction

  •    Intro To Oracle 12c-SQL Fundamentals

  •    Structure Of SQL

  •    Basic Select Statements

  •    Basic Select Statements Demo

Module 2: Retrieving Data

  •    Modifying Reported Output

  •    The Where Clause

  •    The Order By Clause

  •    Left And Right Outer Joins

  •    The Where Clause Demo

  •    Multi-Table Selection Demo

Module 3: SQL Functions

  •    Single Row Functions

  •    Aggregate Functions

  •    Single Row Functions Demo

  •    Muiltrow Functions Demo

  •    Group By

  •    Grouping Demo

  •    Conversion Functions

  •    Conversion Functions Demo

  •    Datetime Functions

  •    Datetime Functions Demo

Module 4: Subqueries

  •    Single-Row Subqueries

  •    Single-Row Subqueries Demo

  •    Multi-Row Subqueries

  •    Multi-Row Subqueries Demo

  •    Other Subquery Types

  •    Other Subquery Types Demo

Module 5: Data Manipulation Language

  •    Adding Data

  •    Changing Data

  •    Deleting Data

  •    DML Demo

Module 6: Data Control Language

  •    Security

  •    Object Privileges

  •    DCL Demo

Module 7: Data Definition Language

  •    Creating Objects In The Database

  •    Creating Objects In The Database Demo

  •    Sequences

  •    Sequenced Demo

  •    Indexes

  •    Views

Module 8: Combining Queries

  •    Combining Queries

Module 9: Oracle 12C SQL Fundamentals Review

  •    Oracle 12c SQL Fundamentals Review - Part 1

  •    Oracle 12c SQL Fundamentals Review - Part 2

  •    Oracle 12c SQL Fundamentals Review - Part 3

  •    Conclusion

Oracle Database 11g Certified Associate (OCA) Fundamentals 1Z0-051 and Admin 1z0-052 Course Content

Module 1: Database Admininstration

  •    Intro to Oracle

  •    Database Administration

  •    Installing Oracle - Part 1

  •    Installing Oracle - Part 2

  •    Post Setup Overview - Part 1

  •    Post Setup Overview - Part 2

  •    SQLplus - Part 1

  •    SQLplus - Part 2

  •    SQLplus Demo - Part 1

  •    SQLplus Demo - Part 2

  •    SQLplus Demo - Part 3

  •    Startup and Shutdown - Part 1

  •    Startup and Shutdown - Part 2

Module 2: Oracle Architecture

  •    Oracle Architecture

  •    Schema Objects

  •    Data Access

  •    Architecture

Module 3: Database Schema

  •    Database Schema

  •    Create Table & Tablespace - Part 1

  •    Create Table & Tablespace - Part 2

  •    Create View

  •    Create Index

  •    Create Sequence

Module 4: Recovery Manager

  •    Recovery Manager

  •    What is RMAN

  •    RMAN Demo

  •    Restore - Part 1

  •    Restore - Part 2

Module 5: Introduction to SQL

  •    SQL - Part 1

  •    SQL - Part 2

  •    Parts of SQL Statement

  •    Select Statement

Module 6: Filtering and Sorting Data

  •    Build ERD - Part 1

  •    Build ERD - Part 2

  •    Build ERD - Part 3

Module 7: Functions

  •    Functions

  •    More Functions

  •    Group Functions

  •    Custom Functions

Module 8: SET Operators and Subqueries

  •    SET Operations

  •    Subqueries

Module 9: Regular Expressions and SQL Loader

  •    Regular Expressions

  •    SQL Loader

Add a review
Oracle Database 11g (OCA) Oracle Database 11g (OCA)
* Rating is required
Your review
* Review is required
* Name is required
Based on 49 reviews
5 star
4 star
3 star
2 star
1 star
1-5 of 49 reviews
  1. I was looking for an online course for Six Sigma as my new boss is a true believer and I wanted to have a better handle of what is Six Sigma. I started looking around and found ITU, and bought the course, and could not be happier. I have no intention of getting certified, but at least now I can speak the jargon and understand what my boss is talking about.

  2. The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.

  3. The CompTIA PenTest was an excellent course and the instructor, Chrys, explained the material in a clear and easy way for me to understand and comprehend essential techniques. Highly recommend!

  4. This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.

Your Training Instructor

Rafiq Wayani

Rafiq Wayani

Project Management Instructor

Rafiq has extensive experience including more than 20 years in IT as a Systems Architect, Software Engineer, DBA, and Project Manager. He has instructed in a variety of technical areas and has designed and implemented network and information systems. Bringing nearly 30 years of advanced IT experience to each course and adding his unique perspective and “real world” tips, Rafiq has a knack for making complex topics easy to understand.

Oracle Database 11g (OCA)



Subscribe To All-Access

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Oracle Database 11g (OCA)

access 2013 course
Oracle Database 11g (OCA)
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses


Master the art of network troubleshooting with Cisco CCNP Troubleshooting IP Networks 300-135 training. Enroll today!

The CCNP Troubleshooting IP Networks 300-135 exam ascertains that the candidate possesses the information and abilities required to regularly maintain complex enterprise routed and switched networks.


Get started with IT fundamentals by taking the Microsoft MTA 98-367 course. Learn the basics of security, network infrastructure, and more!

Ready to jumpstart your tech career? The Microsoft MTA 98-367 – Security Fundamentals course provides the necessary skills and knowledge for you to ace the Microsoft MTA 98-367 exam. Developed by experts, this training offers a comprehensive overview of essential technology concepts from Microsoft Technology Associate (MTA) certification exams which are set up to verify basic understandings needed when beginning work with Windows technologies.


Become an expert in Cisco video network devices with our 210-065 course. Enroll now to prepare for the Cisco certification exam!

This course provides students with the fundamental knowledge Cisco Tele-Presence products covered in Cisco exam 210-065, digital media platforms including digital media players for small businesses and is the second part of a two-course series on Cisco Collaboration technologies.