Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
50 Training Hours
182 On-demand Videos
Closed Captions
32 Topics
508 Prep Questions
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
Your Training 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.
$49.00
OR
Subscribe To All-Access
Lock In $14.99 / Month Forever
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)
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
$49.00
Learn how to install and configure Windows Server with ITU’s Microsoft 70-410 certification training course. Get certified today!
In this Microsoft 70-410: Installing and Configuring Windows Server course you will learn how to install and configure servers, configure server roles and features, configure Hyper-V., and deploy and configure core network services. This course will also teach you how to install and administer Active Directory as well as create and manage Group Policy.
$49.00
Take your Windows 10 skills to the next level with our Power User training course. Boost your productivity with expert tips and tricks.
With the ITU course bundle, students will gain a competitive edge by unlocking the full potential of Windows 10. The comprehensive Microsoft Windows 10 Power User course provides valuable insight into using this platform effectively and efficiently so that novices can become power users in no time at all! Through hands-on training and engagement with experts, you’ll be well on your way to mastering Windows 10 before you know it.
$49.00
Prepare for the Microsoft 70-686 Pro: Windows 7, Enterprise Desktop Administrator exam with our expert-led training. Enroll now!
In this Microsoft 70-686 course, students will learn how to efficiently plan and deploy Windows 7 desktops in large organizations. By the end of the course, students should be able to confidently design, configure, and manage any Windows 7 client environment.
Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.