Comprehensive Video Tutorials

Oracle 11g OCA and Oracle Database SQL Expert Online Training Course

CareerVision Training

£ 150 - (Rs 12,924)

Important information

  • Course
  • Online
  • Duration:
  • When:

The following course, offered by Career vision, will help you improve your skills and achieve your professional goals. During the program you will study different subjects which are deemed to be useful for those who want to enhance their professional career. Sign up for more information!

Important information

Where and when

Starts Location

What you'll learn on the course

Database training

Course programme

• Instructor Led Video Training -12 Month Online Subscription
• Demos and Lab Learning
• Multimedia Presentations and Self-Paced Navigation
• Practice Exam and Test Simulator

COURSE DESCRIPTION The Oracle Database 11g Administrator Certification (OCA 11g) Course ensures that database professionals have a strong foundation and expertise in the industry’s most advanced database management system, Oracle 11g.

Our 11g OCA training package covers includes the following exam courses needed for certification:

* 1Z0-047: Oracle Database SQL Expert
* 1Z0-052: Oracle Database 11g: Administration I

This training course will teach students how to install and maintain an Oracle database, how to create an operational database and 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 the 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 DBA's manage the industry's most advanced information systems and command some of the highest salaries. By earning your Oracle Certification, you will be one step closer to gaining access to better career opportunities. We are so certain this OCA 11g training course meets and exceeds the exam objectives, we guarantee you will pass your exam!

COURSE OUTLINE Oracle OCA Exam 1Z0-052

Database Architecture
Architectural Components of the Oracle Database
Memory Structures
Server Processes and Background Processes
Logical and Physical Storage Structures
Module Summary
Review Quiz

Installing the Oracle Software
Creating an Oracle Database
The Oracle Instance
Oracle Network Environment
Database Storage Structures
User Security
Schema Objects
Data and Concurrency
Undo Data
Oracle Performance
Backup and Recovery
Database Backups
Moving Data
Database Maintenance
Oracle Database/ SQL Expert: Exam 1Z0-047

Introduction to Oracle SQL
Select Statements
Where and Order By Clauses
Single Row Functions
Group Functions
Set Operators