Oracle 11g & 12c Bundle

Overview 
 
Completion Certificate awarded upon completion to show employers your new skills
Free upgrade on to our state of the art platform
Career Advice available on completion
12 Months unlimited Access
 
Oracle 11g & 12c Bundle
ORACLE 11g
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 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 the one of the most popular database platforms in the world. Increase your skills and marketability today by achieving Oracle certification!
ORACLE 12c
With Oracle Database 12c: SQL Fundamentals and installation and administration, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.
 
Course Outline
 
Oracle 11g Course Outline
Module 1: Database Administration
Module 2: Oracle Architecture
Module 3: Database Schema
Module 4: Recovery Manager
Module 5: Introduction to SQL
Module 6: Filtering and Sorting Data
Module 7: Function
Module 8: SET Operators and Subqueries
Module 9: Regular Expressions and SQL*Loader
 
Oracle 12c Course Outline
 
Oracle 12c OCP 1Z0-061: SQL Fundamentals
Module 1 Introduction To Oracle 12c SQL Fundamentals
Module 2 Retrieving Data
Module 3 SQL Functions
Module 4 Subqueries
Module 5 Data Manipulation Language
Module 6 Data Control Language
Module 7 Data Definition Language
Module 8 Combining Queries
Module 9 Oracle 12C SQL Fundamentals
 
Oracle 12c OCP 1Z0-062: Installation and Administration Course Syllabus 
 
Module 1 Database Concepts And Tools
Module 2 Memory Structure
Module 3 Tables
Module 4 Indexes
Module 5 Constraints And Triggers
Module 6 Users
Module 7 Internal Structures
Module 8 Starting Up and Shutting Down Database
Module 9 Critical Storage Files
Module 10 Data Manipulation Language
Module 11 Data Concurrency
Module 12 BackUp And Recovery
Module 13 Installation
Module 14 Course Review
 
Who Is This For
 
This package is designed for any individual wishing to pursue or enhance their career as a Database Programmer or Administrator.
Our Online Courses is a cost-effective and successful approach for many individuals. It provides a flexible learning method, allowing candidates to schedule learning at a time that suits them and fits in with other commitments; ideal for those who find it difficult to take time away from their workplace. It also allows candidates to work at their own pace, and revisit sections of the course as often as needed, leading to a fuller understanding of all the topics covered.
In addition, there are none of the high costs of travel and accommodation associated with courses at an external venue.
 
Requirements
 
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.