Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           

Results-Based Oracle Foundation Skills Training

Results-Based Oracle Foundation Skills Training
Search

ORACLE COURSES

Oracle® Certification Course

Training for Oracle Foundation delivered in 11 UK locations or at your offices UK-wide
See Our Latest Reviews on TrustPilot:
Your First Choice for Oracle Foundation Skills Training
Classroom training Classroom training

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Click for details of:
    Course outlines and links
    More about classroom training

Move to next Oracle Foundation Skills section
Quick Links to Information

REQUEST MORE INFORMATION

PRICES for training

BOOK a public class date

Oracle page

More on This Page
COURSE OUTLINES & LINKS FOR
ORACLE FOUNDATION SKILLS TRAINING
Browse the outlines and click for more details on each course

Oracle Fundamentals

Oracle Fundamentals

COURSE OUTLINE
[Duration: five day]

  • Relational Database Concepts
  • Using SQL*Plus
  • Using SQL Developer
  • Retrieving Data With The Select Statement
  • Aggregate Functions
  • Joining Tables
  • Numeric, Character and Date Functions
  • Conversion and Miscellaneous Functions
  • SQL*Plus Parameters
  • Using Subqueries
  • Managing Data
  • Managing Tables
  • Managing Indexes and Views
  • Managing Sequences and Synonyms
  • PL/SQL Fundamentals
  • Program Logic
  • Using Cursors
  • Exceptions and Nested Blocks
  • Pl/SQL Records and Index-By Tables

Click for FULL COURSE DETAILS

Introduction to SQL

Introduction to SQL

COURSE OUTLINE
[Duration: one day]

  • Relational Database Concepts
  • SQL Language Essentials
  • Summarising and Grouping Data
  • Querying Multiple Tables
  • Additional SQL Features

Click for FULL COURSE DETAILS

Oracle SQL

Oracle SQL

COURSE OUTLINE
[Duration: three day]

  • Relational Database Concepts
  • Using SQL*Plus
  • Using SQL Developer
  • Retrieving Data With The Select Statement
  • Aggregate Functions
  • Joining Tables
  • Numeric, Character and Date Functions
  • Conversion and Miscellaneous Functions
  • SQL Parameters
  • Using Subqueries
  • Managing Data
  • Managing Tables
  • Managing Indexes and Views
  • Managing Sequences and Synonyms

Click for FULL COURSE DETAILS

Oracle SQL Fundamentals

Oracle SQL Fundamentals

COURSE OUTLINE
[Duration: five day]

  • Relational Database Concepts
  • Using Sql*Plus
  • Using Sql Developer
  • Retrieving Data With The Select Statement
  • Aggregate Functions
  • Joining Tables
  • Numeric, Character and Date Functions
  • Conversion and Miscellaneous Functions
  • SQL Parameters
  • Using Subqueries
  • Managing Data
  • Managing Tables
  • Managing Indexes and Views
  • Managing Sequences and Synonyms
  • Retrieve Data Using Subqueries
  • Hierarchical Queries
  • Enhanced Grouping Features
  • Manage Large Data Sets
  • Flashback Technology
  • Date, Time and Timezone Support
  • Regular Expression Support
  • Manage Objects With The Data Dictionary
  • Manage Schema Objects
  • Access Control

Click for FULL COURSE DETAILS

Oracle SQL Advanced

Oracle SQL Advanced

COURSE OUTLINE
[Duration: two day]

  • Retrieve Data Using Subqueries
  • Hierarchical Queries
  • Enhanced Grouping Features
  • Manage Large Data Sets
  • Flashback Technology
  • Date, Time and Timezone Support
  • Regular Expression Support
  • Manage Objects With The Data Dictionary
  • Manage Schema Objects
  • Access Control

Click for FULL COURSE DETAILS

Oracle PL/SQL

Oracle PL/SQL

COURSE OUTLINE
[Duration: two day]

  • PL/SQL Fundamentals
  • Program Logic
  • Using Cursors
  • Exceptions and Nested Blocks
  • PL/SQL Records and Index-By Tables

Click for FULL COURSE DETAILS

Oracle Programming with PL/SQL

Oracle Programming with PL/SQL

COURSE OUTLINE
[Duration: five day]

  • PL/SQL Fundamentals
  • Program Logic
  • Using Cursors
  • Exceptions and Nested Blocks
  • PL/SQL Records and Index-By Tables
  • Triggers
  • Procedures
  • Functions
  • Packages
  • Using PL/SQL Records and Tables In Packages
  • Cursor Variables (Ref Cursors)
  • Managing Dependencies
  • Native Compilation and Compile-Time Warnings
  • Oracle-Supplied Packages

Click for FULL COURSE DETAILS

Oracle PL/SQL Stored Program Units

Oracle PL/SQL Stored Program Units

COURSE OUTLINE
[Duration: three day]

  • Triggers
  • Procedures
  • Functions
  • Packages
  • Using PL/SQL Records and Tables In Packages
  • Cursor Variables (Ref Cursors)
  • Managing Dependencies
  • Native Compilation and Compile-Time Warnings
  • Oracle-Supplied Packages

Click for FULL COURSE DETAILS

Oracle PL/SQL Advanced

Oracle PL/SQL Advanced

COURSE OUTLINE
[Duration: three day]

  • Designing Pl/Sql Code For Performance
  • Use Collections
  • Advanced Interface Methods
  • Vpd And Fine-Grained Access Control
  • Manipulate Large Objects
  • Administer Securefile Lobs
  • Tuning Pl/Sql Code For Performance
  • Use Sql And Pl/Sql Caching To Improve Performance
  • Analyze Pl/Sql Code
  • Profile and Trace PL/SQL Code
  • Safeguard Code

Click for FULL COURSE DETAILS
Move to next Oracle Foundation Skills section
CLASSROOM TRAINING FOR
ORACLE FOUNDATION SKILLS
Do you want the best? Here's how to get it!
Classroom training for ORACLE FOUNDATION SKILLS
Classroom training provides the best learning experience and knowledge retention, and is the preferred choice if you want to really get to grips with the subject.
Our class sizes are always small, allowing lots of time for questions and discussion, so you come away with a full grasp of the content, ready to use it right away.
Options for Classroom Training
Scheduled Public Classes

Best for: 1 - 4 delegates

With 11 centres across the UK, we always have a full schedule of great courses at super prices.
And we don't cancel classes – even if you are the only delegate booked on the course!

Price Guide
  • Prices for public classes start at £449
  • For multiple delegates, prices can be as low as £449

Book Online
It couldn't be easier with our full listings of classes and dates: just click here and reserve your place in two minutes.

Private Training at Our Centres

Best for: 3 or more delegates

If you want training away from your offices (and possible distractions), we can arrange a day at one of our centres with only your staff in attendance.

Call us on 0333 6000 111 or request a callback so we can discuss your needs.

Move to next Oracle Foundation Skills section
GENERAL INFORMATION
ABOUT ORACLE FOUNDATION SKILLS TRAINING
What we do, and how we work, to make sure you get the most from the courses you attend


GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

ORACLE® CERTIFICATION COURSE

We can enhance your skills with certification courses for Oracle® at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our oracle courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering oracle certification course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses in Oracle to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Courses in Oracle® from Activia.

Why not contact us today to see how we can help with providing your courses for Oracle database ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top
Quick Links to Information
More on This Page