• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle Developer Training Courses

SQL Advanced

View course dates

Course Duration: 2 days

Course Code: OSA

Course Description:

Anyone who needs to use and understand iSQL*Plus and Oracle9i SQL*Plus to an advanced level, to retrieve data from and to update an Oracle database. The more advanced topics are covered in this course for the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)

Prerequisites:

Delegates should have attended the Oracle SQL*Plus course or have a similar level of experience. Before taking any exam, ensure you have the recommended experience.

Prerequisite courses:

SQL*Plus

Relevant Certifications:

Oracle PL/SQL and Oracle Forms Developer

This course includes the following modules:

Course topics:

• Oracle9i Datatypes and Functions
• Advanced Single Row Functions
• Advanced Group Functions
• Ansi Standard Table Joins
• isql*Plus
• Inline Views
• Top-'N' Analysis
• Inserting Rows into Multiple Tables
• Merging Data into Tables
• External Tables
• CASE Expressions
• Table Locking
• Creation of User, Profiles and Roles

 

Location	Duration	RRP	Dec	Jan	Feb	Mar	Apr	May
Click on course date to make a booking, check availability, or find out about available discounts.
Leeds	2 days	£725		19 - 20			6 - 7
London	2 days	£725		15 - 16	26 - 27	26 - 27	30 - 1

<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course