Company Information

QRCode for Mobile Website
Visit our Mobile website.
Our Blog

Public Courses

Data Dog - Training your Data
Data Dog understands your Database issues.
Oracle

Microsoft

Java Training

Management

NME News

Morgan Freeman falls asleep during live TV interview - watch

His interview buddy Michael Caine carries on chatting happily

    


Channel 4 to pilot two new music shows, including one fronted by Rizzle Kicks

Nick Grimshaw will host a music quiz filmed in a 'well known music venue'

    


Benedict Cumberbatch takes a shower in 'Star Trek Into Darkness' deleted scene - watch

The 'Sherlock' star shows off the results of his Hollywood baddie gym regime

    


Slayer's Kerry King raises Jagermeister toast to Jeff Hanneman at guitarist's public memorial

Despite threats, Westboro Baptist Church did not picket the LA event

    


New Simon Pegg and Nick Frost movie 'The World's End' features secret cameo

The follow-up to 'Shaun Of The Dead' and 'Hot Fuzz' opens in cinemas on July 19

    


'Sherlock' return date hasn't been decided yet, says creator

Co-creator Mark Gatiss dismisses online rumours that series three will begin in September

    


Boards Of Canada unveil new track 'Reach For The Dead' – listen

The song comes from 'Tomorrow's Harvest' which is out on June 10 via Warp

    


Daft Punk racecar to compete in Monaco Grand Prix

'Random Access Memories' is set to be the fastest selling album of the year so far

    


Mayor of Camden names Amy Winehouse Foundation his 'charity of the year'

Councillor Jonathan Simpson has said the drugs and alcohol awareness programme is a 'fantastic cause'

    


Actor Christopher Lee to release metal album on his 91st birthday

The 'Star Wars' and 'The Hobbit' actor will put out his second LP - with help from Judas Priest's guitarist - next week

    



Information

On-Site Training - Have wheels will travel !!
On-site training course details, Click to view.
Oracle Web Site

Valid HTML5

Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Valid CSS!

Get Adobe Reader



 
Contents

A supplement course for experienced SQL Developers using SQL in a 11g Database, please refer to the index for this course for full details. The following aspects are included:

Regular Expressions
Sub-Queries with Group Clauses
Using Ansi SQL/99 Joins
Advanced ordering of siblings in Tree Walks
Populating tables using Merge and Multiple Inserts
Using External Tables
Flashbacks
Object Orientated Programming



Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.

The exercises include:

Using Oracle Multiple Inserts to populate Tables
Creating and manipulating Tables with Timestamps
Using Flashback to retrieve values
Creating Correlated Sub-Queries



Duration

Three Days

Advanced 11G SQL Training Course

Oracle SQL 11g
Advanced Training Course

Synopsis

An intense three day course designed to bring Developers up to speed with recent development in an Oracle 11g Database.

This course will give Delegates a complete knowledge of SQL in Oracle 11g databases.

Course Preview

The following options give examples of Course content ...

Index of Training Course Index of Training Course (html) Example pages of Delegate Manual Sample exercise


Pre-Requisite Course(s)

None

Suggested Further Course(s)

PLSQL I or
Advanced PLSQL 11g



This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.

On completion all delegates receive a certificate.



On Site or Off Site ?

On Site

All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.

Off Site

If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).



Weekday or Weekend ?

This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.



Standard or Customised ?

If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).



Contact Details

Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com