Loader
Course Image
Institution Image

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

STUDY365

Certificate , IT Help Desk

Course Description

Overview             

Understand 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. Gain the 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.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Overview              Understand 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...

Read More

Course Content

Course Curriculum

Free Introduction1: Database Admininstration2: Oracle Architecture3: Database Schema4: Recovery Manager5: Introduction to SQL6: Filtering and Sorting Data7: Functions8: SET Operators and Subqueries9: Regular Expressions and SQL*Loader

Course Curriculum

Free Introduction1: Database Admininstration2: Oracle Architecture3: Database Schema4: Recovery Manager5: Introduction to SQL6: Filtering and Sorting Data7: Functions8: SET Operators and Subqueries9: Regular Expressions and SQL*Loader

 

Entry Requirements

 

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

 

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Assessment Methods

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test (please be aware, this is not the official exam). The online test is marked straight away, so you will know immediately if you have passed the course.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test (please be aware, this is not the official exam). The online test is marked straight away, so you will know immediately if you have passed the course.

Additional Information

Certification:

Successful candidates will be awarded a certificate for Oracle Database 11g Certified Associate (OCA) Fundamentals and Admin.

(This course is not included the official certificate) 

Certification:

Successful candidates will be awarded a certificate for Oracle Database 11g Certified Associate (OCA) Fundamentals and Admin.

(This course is not included the official certificate)