ITO 101 – Oracle Database 11g: OCA (Oracle Certified Associate)

The Oracle Database 11g: OCA (Oracle Certified Associate) SQL Fundamentals 1Z0-051 and Administration 1Z0-052 course aims to ensure that database professionals are equipped with the skills and knowledge needed to efficiently administer Oracle 11g databases by imparting a thorough understanding of Oracle database architecture and components.
Name: Oracle Database 11g: OCA (Oracle Certified Associate)
Course Code: ITO 101
Course Time: 08:00am - 05:00pm
Prerequisite(s): N/A
Credit(s): 4.0
Course ID: 00025
Room Number: GHR 003
Course Days: Mon - Fri
Component(s): Access: 12 Months
Location: Map
Notes: For credit, all modules are to be successfully completed.

Get Oracle OCA Certified

OCA (Oracle Certified Associate) with the 1Z0-051 and 1Z0-052 Exams

Enroll For this course!

ITO 101 - Oracle Database 11g: OCA (Oracle Certified Associate)

OVERVIEW OF THIS COURSE

What you will learn

The Oracle Database 11g: OCA (Oracle Certified Associate) SQL Fundamentals 1Z0-051 and Administration 1Z0-052 course aims to ensure that database professionals are equipped with the skills and knowledge needed to efficiently administer Oracle 11g databases by imparting a thorough understanding of Oracle database architecture and components.

During the Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 and Administration 1Z0-052 course, students will be taught the following:

  •  Creating an operational database
  •  Performance monitoring
  •  Database security
  •  User management
  •  Backup/recovery techniques
  •  Advanced features of SQL
  •  Querying and reporting techniques
  •  Control privileges at the object and system level

Once you have completed this course, you will have taken the first steps towards a rewarding career as a Database Administrator.

CERTIFICATION DETAILS

Oracle Database 11g OCA SQL Fundamentals and Administration Course Assessment

To earn your Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 and Administration 1Z0-052 qualification you will be required to study the course material and pass the associated exams:

  •  Exam 1Z0-051 – Oracle Database 11g: SQL Fundamentals
  •  Exam 1Z0-052 – Oracle Database 11g: Administration

Oracle Database 11g OCA SQL Fundamentals and Administration Course Requirements

There are no prerequisites for studying the Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 and Administration 1Z0-052 course.

IS THE COURSE FOR ME?

Career path/Job Opportunities

The Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 and Administration 1Z0-052 course is suited for anyone looking to work in any of the following roles:

  •  Database Administrator
  •  Oracle Developer
  •  Oracle Architect
  •  Oracle Consultant
  •  Oracle Specialist
  •  Oracle Project Manager

YOUR TRAINING BENEFITS

Benefits available to you with this course

  • Recruitment Resource Pack
  • Dedicated Account Manager
  • Student Care Team
  • CV Review & Optimization
  • Completion Certificate
  • 24/7 Anytime Access
  • Practice Questions

Frequently Asked Questions

QUESTION What will the pass mark be for these exams?

The pass mark for the Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 exam is 60% and the pass mark for the 11g: OCA Administration 1Z0-052 exam is 66%.

QUESTION What will the format of the exams be?

Both of these exams will be presented in multiple choice format throughout.

QUESTION How much time will I have to complete each of these exams?

You will have 120 minutes (2 hours) in which to complete the 11g: OCA SQL Fundamentals 1Z0-051 exam and 90 minutes in which to complete the 11g: OCA Administration 1Z0-052 exam.

Oracle Database 11g: OCA SQL Fundamentals 1Z0-051 and Administration 1Z0-052:

Database Administration

Oracle Architecture

Database Schema

Recovery Manager

Introduction to SQL

Filtering and Sorting Data

Functions

SET Operators and Subqueries

Regular Expressions and SQL*Loader