STUDENT LOGIN
REDEEM VOUCHER





24/7 SUPPORT LINE from our caring & friendly experts. Just fill in the form below and get a guaranteed response in as little as 10 mins away:
*The fields marked in red are required for a successful submission.
Name*


Contact Number*


E-mail*


Comment


Oracle Training

Oracle headquarters in Bay peninsula, San Franciso

Certifications gained from Oracle training courses are one of the most sought after markers of credibility for expertise due to Oracle technologies powering of the internet.


As one of the largest multinational hardware and software providers, Oracle Corporation produces large database management systems, preferred by major corporations worldwide.


Being an Oracle Certified Professional can help raise your visibility and increase your access to the industry's most challenging job and career opportunities and financially rewarding roles.


Training is offered to both users of the database management systems (in areas like web development, finance etc) to database developers and administrators.


Oracle training courseFor any I.T Professional Certification is your passport to serious IT salaries. With an Oracle certification, you have devoted the time and effort – and acquired the skills necessary – to prove your worth to potential employers, whether as a full time employee or as a consultant.

 

For any company, Certification is your guarantee that employees will possess the skills required to work in a controlled and effective manner, whether as system managers and engineers, or as users.

 

Any questions? Just let us know!

 

 
 
  • Oracle Course Database Training Package
  • £899.99
  • Oracle Database 11g Administration I (1Z0-052)
  •  30 Hours
  • £499.99
 

This training course is for anyone who is preparing for the Oracle Database 11g Administration I (1Z0-052) exam.

 

The Oracle Database 11g: Administration I study guide will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate as well as laying the foundation for the Oracle Database 11g Administrator Certified Professional certification. This series will cover some of the more in-depth database administration topics, such as configuration, security, backups, and recovery. These topics, along with a strong emphasis on database management, will prepare you for the exam.

 

Benefits of training:

 

The course uses engaging activity screens, questions and assessments in conjunction with videos which set the scene for fun, interactive learning. Students will work through real-world technical challenges and will learn how to overcome them. Authentic screenshots, videos, interactive activities and audio feature throughout. The training is delivered through a secure, privacy controlled application, so you can jump in and out of any course whenever you sign in.

 

• Gain access to NUS Student Discount Card. Exclusive student discounts including Apple store, ASOS, Co-op food, Amazon, Microsoft softwares, Cineworld, Odeon, EasyJet, Matalan, Superdrug, The AA, National Express, Three Mobile, Riley's, Domino's, Pizza Hut, McDonalds, the list goes on!
• 1 on 1 Tutor Support available throughout your entire training;
• Freephone Support;
• Job Placement and Reference and IT Career Assistance;
• Interactive simulations, videos and audio based training;
• Practice and Mock Exams, Questions and Answers;
• Access to constantly updated content;
• No additional software needed;
• Flexible learning over PCs, Tablets and Hand-Held/Mobile Devices;

 

Course Topics:

 

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

Database Administrator Tasks and Tools
Planning a Oracle Database Installation
Using Optimal Flexible Architecture
Installing the Oracle Software using OUI
Module Summary
Review Quiz

 

Creating an Oracle Database

Planning for Database Creation
Configuring the Listener
Creating a Database
Module Summary
Review Quiz

 

The Oracle Instance

Starting and Stopping the Oracle Database
Using the Oracle Enterprise Manager
Access a Database with SQL*Plus
Modify Database Initialization Parameters
Database Startup
Database Shutdown
Viewing the Alert Log and Dynamic Performance Views
Module Summary
Review Quiz

 

Oracle Network Environment

Creating and Configuring Additional Listeners
Creating Oracle Net Service Aliases
When to Use Shared and Dedicated Servers
Module Summary
Review Quiz

 

Database Storage Structures

Describe Table Row Data and Define Tablespaces
Creating and Managing Tablespaces
Automatic Storage Management
Module Summary
Review Quiz

 

User Security

Create and Manage User Accounts
Grant and Revoke Privileges
Create and Manage Roles
Create and Manage Profiles
Module Summary
Review Quiz

 

Schema Objects

Defining Schema Objects and Data Types
Creating and Modifying Tables
Defining Constraints
Viewing Columns and Contents of a Table
Creating Indexes
Creating Views
Creating Sequences
Using Temporary Tables
Module Summary
Review Quiz

 

Data and Concurrency

Managing data Using SQL
Identifying and Administering PL/SQL Objects
Monitoring and Resolving Locking Conflicts
Module Summary
Review Quiz

 

Undo Data

Implementing Undo Data
Working with Undo Data
Module Summary
Review Quiz

 

Security

DBA Security and Privileges
Enabling Auditing
Audit Options and Information
Fine Grained Auditing
Auditing the DBA and Maintaining the Audit Trail
Module Summary
Review Quiz

 

Maintenance

Managing Optimizer Statistics
Managing Automatic Workload Repository
Using the Automatic Database Diagnostic Monitor
Setting Alerts and Thresholds
Module Summary
Review Quiz

 

Oracle Performance

Performance Monitoring with the Enterprise Manager
Using Automatic Memory Management
Viewing Performance Related Dynamic Views
Troubleshooting invalid and Unusable Objects
Module Summary
Review Quiz

 

Backup and Recovery

Types of Database Failure
Checkpoints, Redo Log Files, and Archive Log Files
Instance Recovery
Configuring for Recoverability
Configuring Archive Log Mode
Module Summary
Review Quiz

 

Database Backups

Backup Solutions Overview
Configuring Backup Settings
Scheduling Backups
Backing up Control Files to a Trace File
Managing Backups and the Flash Recovery Area
Using the RMAN Command Line
Module Summary
Review Quiz

 

Recovery

Recovering From a Lost Control File
Recovering Redo Log Files
Recovering Non Critical and Critical Data Files
Using the Data Recovery Advisor
Module Summary
Review Quiz

 

Moving Data

Moving Data and Creating Directory Objects
Loading Data with the SQL Loader
Creating and Reading External Tables
Using Oracle Data Pump Export and Import
Data Pump Performance and Monitoring
Module Summary
Review Quiz

 

Database Maintenance

Using the Enterprise Manager Support Workbench
Metalink Integration and Managing Patches
Module Summary
Review Quiz
Course Review

  • Oracle Database SQL Expert (1Z0-047)
  •  28 Hours
  • £499.99
 

This training course is for anyone who is preparing for the Oracle Database: SQL Certified Expert (1Z0-047) exam.

 

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand 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. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

 

Introduction to Oracle SQL

Relational Database Systems
Examining SQL
SQL Developer and SQL Plus
Examining the Database and Schema
Module Summary
Review Quiz

 

Select Statements

Basic Select Statements
Selecting Columns and Using Arithmetic Operators
Operator Precedence
Concatenation Operator
Displaying the Table Structure
Module Summary
Review Quiz

 

Where and Order By Clauses

Implementing the Where Clause
Comparison Operators
Logical Operators
Rules of Precedence
Substitution Variables
Module Summary
Review Quiz

 

Single Row Functions

Types of Single Row Functions
Working with Dates
Module Summary
Review Quiz


Group Functions

Types of Group Functions
Creating Groups of Data
Multi Column Grouping
Module Summary
Review Quiz

 

Joins

Natural Joins
Nonequijoins and Outer Joins
Cartesian Joins
Module Summary
Review Quiz


Sub-Queries

Single Row Subqueries
Multiple Row Subqueries
Null Values
Module Summary
Review Quiz


Set Operators

Union and Union All Operators
Intersect and Minus Operators
Select Statements and the Order By Clause
Module Summary
Review Quiz


Data Manipulation Language

Insert Statements
Update Statement
Delete Statement
Database Transactions
Module Summary
Review Quiz


Data Definition Language

Creating Tables
Data Types and Constraints
Altering a Table Statement
Module Summary
Review Quiz


Schema Objects

Views
Sequences
Indexes
Synonyms
Module Summary
Review Quiz


User Privileges

Creating a User
System Privileges
Role and Object Privileges
Granting and Revoking Privileges
Module Summary
Review Quiz


Schema Objects

Altering a Table
Adding Constraints
Dropping Constraints
Indexes
Dropping Tables and Flashback Table
Create and Use External Tables
Module Summary
Review Quiz


Oracle Data Dictionary Views

Using the Oracle Data Dictionary
Types of Views and Querying the Data Dictionary
View Information
Module Summary
Review Quiz


Large Data Sets

Using Subqueries
Default values and Copying Rows
Multi Table Insert
Merge Statement
Flash Back Version Query
Module Summary
Review Quiz


Time Zones

Time Zone Functions
Time Stamp Data Types
Interval Data Types
Available Functions
Module Summary
Review Quiz


Advanced Sub-Queries

Pairwise and Nonpairwise Comparison Queries
Scalar Subquery
Correlated Subquery
Exist Operator and With Clause
Module Summary
Review Quiz


Regular Expressions

Using Regular Expressions
Using Subexpressions and Check Constraint Expressions
Module Summary
Review Quiz
Course Review