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

Take an extra 30% off this course! No coupon needed; auto applies in cart.

$49.00

Sale Ends Soon

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

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.

50  Training Hours
182 Videos
32  Topics
508 Practice Questions

Course Description

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!

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.

Course Outline

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

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 Outline

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 Outline

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
access 2013 course
Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052)

$49.00

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.

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
$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

This course is designed to provide six hours of training and 45 videos that will equip you with the knowledge and skills needed to create network diagrams, explain basic networking concepts, understand switches and routers, comprehend OSI models, gain insight into wide area (WAN) and local area networks (LAN), master wireless networking strategies ,and develop IP addressing proficiency.

$15.00

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.

$10.00

This Cisco Voice 640-461 course covers the Cisco Certified Network Associate Voice (CCNA Voice) attests to the fact that the IT professional has requisite associate-level knowledge and skills needed to manage a voice network.

$15.00

This Cisco 200-355 training IT course will enable students to set up and troubleshoot Small Medium Business and Enterprise wireless networks.

UNLOCK

25% OFF

Sign up for updates, discounts, and more.