Book your SQL Advanced Training Course

This two day course is being run eleven times between Thursday 16th February 2012 and Thursday 13th December 2012 in London,

Book this course with us today from as little as £652.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.

See all courses provided by StayAhead

Expert Help

If you would like
advice, or to book, call
one of our experts on
01920 460232

Open: 9am - 5:30pm
Monday- Friday

Locations/dates for this course
DateLocationRatingPrice
Thursday 16 February 2012LondonSave £72.50£652.50+VAT
Thursday 22 March 2012LondonSave £72.50£652.50+VAT
Thursday 17 May 2012LondonSave £72.50£652.50+VAT
Thursday 21 June 2012LondonSave £72.50£652.50+VAT
Thursday 12 July 2012LondonSave £72.50£652.50+VAT
Thursday 16 August 2012LondonSave £72.50£652.50+VAT
Thursday 13 September 2012LondonSave £72.50£652.50+VAT
Thursday 04 October 2012LondonSave £72.50£652.50+VAT
Thursday 25 October 2012LondonSave £72.50£652.50+VAT
Thursday 15 November 2012LondonSave £72.50£652.50+VAT
Thursday 13 December 2012LondonSave £72.50£652.50+VAT
 

Book your course now with Coursebookers!

Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.

Remember:

  • Not only are we great value, we can also boast no booking fees
  • Human administrators make booking & coordination simple and painless
  • Coursebookers is vendor neutral we can offer unbiased and independent advice
  • If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
  • We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course Outline

Summary: 

This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.

PreRequisites: 

Delegates should have attended the SQL course or have a similar level of experience.

Audience: 

Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. The more advanced topics are covered in this course for the Introduction to Oracle9i: SQL Oracle Certified Professional examination (1Z0-007).

Objectives: 

By the end of this course, the delegate will be able to:

  • Use iSQLPlus
  • Implement ANSI-Compliant Table Joins
  • Develop Hierarchical Queries
  • Use the ROLLUP, CUBE and GROUPING SETS Group By Extensions
  • Use the GROUPING and GROUPING_ID Functions
  • Handle DATE, TIMESTAMP and INTERVAL Datatypes and Functions
  • Create Queries to Rank Data by Value
  • Create Queries to Calculate Percentiles
  • Use Reporting and Windowing Aggregate Functions
  • Understand Regular Expression Notation
  • Use Regular Expression Functions
  • Implement CASE Expressions in SQL Statements
  • Implement Enhanced Table Handling Features

  • How to use iSQLPlus
  • ANSI-Compliant Inner Joins
  • ANSI-Compliant Outer and Self Joins
  • Hierarchical Queries
  • Enhanced Grouping Extensions and Functions
  • TIMESTAMP, TIMEZONE and INTERVAL Datatypes
  • TIMESTAMP and INTERVAL Functions and Literals
  • Overview of Analytic Functions
  • Ranking Data by Value and Percentile
  • Providing Cumulative, Moving and Centered Aggregates
  • POSIX Compliant Regular Expression Notation
  • Regular Expression Functions
  • Enhanced Subquery Functions
  • CASE Expressions
  • Extended Insert and Merge Operations on Tables
  • Creating and Using External Tables

Description: 

This course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.

StayAhead

StayAhead training has been offering high quality IT technical training courses since 1992. They specialise in UNIX, Oracle, Linux and MySQL training and pride themselves on the long term investments they put into attending delegates.
StayAhead has gained a reputation for offering high quality courses and is ranked as one of the UK’s top 50 business organisations in 2008.

Want to leave your own testimonial? click Here
No Testimonials have been left for this course.

Software Vendor

IT Technical

Business Skills