Book your Oracle Database: Introduction to SQL Training Course

This five day course is being run 18 times between Monday 13th February 2012 and Monday 2nd July 2012 in London, Reading, Leeds, Manchester, Glasgow, Belfast,

Book this course with us today from as little as £2,325.00 + 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 by the manufacturer Oracle
See all courses provided by QA
See all courses provided by Oracle

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 2012London£2,555.00+VAT
Monday 13 February 2012London£2,555.00+VAT
Monday 20 February 2012London£2,555.00+VAT
Monday 26 March 2012ReadingSave £230.00£2,325.00+VAT
Monday 16 April 2012London£2,555.00+VAT
Monday 16 April 2012London£2,555.00+VAT
Monday 30 April 2012LeedsSave £230.00£2,325.00+VAT
Monday 30 April 2012London£2,555.00+VAT
Monday 30 April 2012LeedsSave £230.00£2,325.00+VAT
Monday 21 May 2012ManchesterSave £230.00£2,325.00+VAT
Monday 21 May 2012GlasgowSave £230.00£2,325.00+VAT
Monday 21 May 2012BelfastSave £230.00£2,325.00+VAT
Monday 21 May 2012ManchesterSave £230.00£2,325.00+VAT
Monday 21 May 2012GlasgowSave £230.00£2,325.00+VAT
Monday 28 May 2012BelfastSave £230.00£2,325.00+VAT
Monday 28 May 2012ReadingSave £230.00£2,325.00+VAT
Monday 18 June 2012London£2,555.00+VAT
Monday 02 July 2012London£2,555.00+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: 

Create reports of sorted and restricted data.
• Run data manipulation statements (DML).
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Retrieve row and column data from tables

PreRequisites: 

• Familiarity with data processing concepts and techniques
• Data processing

Audience: 

• Forms Developer
• Data Warehouse Administrator
• Business Analysts
• Developer
• System Analysts
• Application Developers
• PL/SQL Developer

Objectives: 

• Display data from multiple tables using the ANSI SQL 99 JOIN syntax.
• Identify the major structural components of the Oracle Database 11g.
• Create reports of aggregated data.
• Write SELECT statements that include queries.
• Retrieve row and column data from tables.
• Run data manipulation statements (DML) in Oracle Database 11g.
• Create tables to store data.
• Utilize views to display data.
• Control database access to specific objects.
• Manage schema objects.
• Manage objects with data dictionary views.
• Write multiple-column sub-queries.
• Employ SQL functions to retrieve customized data.
• Use scalar and correlated sub-queries.
• Use the regular expression support in SQL.
• Create reports of sorted and restricted data.

Description: 

Understanding the basic concepts of relational databases ensure refined code by developers. This course helps the participants to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Controlling privileges at the object and system level are also dealt with in detail.

This course covers creating indexes and constraints, and altering existing schema objects. Additionally, participants learn how to create and query external tables. In order to query and manipulate data within the database, to use the dictionary views to retrieve metadata and create reports about their schema objects, participants get to understand the advanced features of SQL. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL.

This course is a combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II courses. For this course, the main development tool used is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience. There are minor changes between 10g and 11g features in SQL.

Oracle

Oracle University is committed to providing world-class training and an unbeatable educational experience. So confident of delegate success, Oracle back up their training with a 100% Student Satisfaction program: If you are not completely satisfied with your training experience, you may re-take the same class for free.

In the past year, only one-third of 1% of Oracle University students requested a re-take of their class.

QA

QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.

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

Software Vendor

IT Technical

Business Skills