Oracle 11g & 12c Bundle

Oracle 11g & 12c Bundle

£295.00Price

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.