Book your SQL Fundamentals Training Course

This five day course is being run eleven times between Monday 13th February 2012 and Monday 10th December 2012 in London,

Book this course with us today from as little as £1,525.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
Monday 13 February 2012LondonSave £169.50£1,525.50+VAT
Monday 19 March 2012LondonSave £169.50£1,525.50+VAT
Monday 14 May 2012LondonSave £169.50£1,525.50+VAT
Monday 18 June 2012LondonSave £169.50£1,525.50+VAT
Monday 09 July 2012LondonSave £169.50£1,525.50+VAT
Monday 13 August 2012LondonSave £169.50£1,525.50+VAT
Monday 10 September 2012LondonSave £169.50£1,525.50+VAT
Monday 01 October 2012LondonSave £169.50£1,525.50+VAT
Monday 22 October 2012LondonSave £169.50£1,525.50+VAT
Monday 12 November 2012LondonSave £169.50£1,525.50+VAT
Monday 10 December 2012LondonSave £169.50£1,525.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 for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

Objectives: 

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

  • Describe the structure of a relational database
  • Use the command line features of SQLPlus and iSQLPlus
  • Create SQL statements to select data from an Oracle database
  • Use single row functions
  • Use enhanced grouping functions
  • Implement analytic functions
  • Generate hierarchical queries
  • Generate scripts and apply formatting to output
  • Use SQLPlus control and run time parameters
  • Create and alter tables, indexes and views
  • Use external tables
  • Create, update and delete records
  • Create users, profiles and roles
  • Grant and revoke access privileges
  • Access the data dictionary

  • The Structure of a Relational Database
  • Using SQLPlus and iSQLPLus
  • The Basic SQL Select Statement
  • Using Oracle and ANSI-Compliant Inner and Outer Joins
  • Sub-Queries and Sub-Query Operators
  • In-line views and Top-'N' Analysis
  • Hierarchical Queries
  • Grouping and Sorting Output
  • Advanced Grouping Expressions and Functions
  • Character, Date and Numeric Functions
  • Timestamp and Interval Datatypes and Functions
  • Analytic Functions
  • CASE Expressions
  • Regular Expression Notation and Related Functions
  • SQLPlus and iSQLPlus Parameters and Variables
  • Producing Reports with SQLPlus
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Creating and Using External Tables
  • Basic Transaction Control
  • Controlling Access to Objects
  • Data Dictionary Tables and Views

Description: 

This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

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