• 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

Oracle Introduction for Experienced SQL Users

View course dates

Course Duration: 2 days

Course Code: OIEU

Course Description:

This course is designed for anyone who needs to access and work with an Oracle Database.  In conjunction with the Oracle PL/SQL course, this course is suitable for delegates intending to sit the; Introduction to Oracle: SQL and PL/SQL Oracle Certified Professional examination (1Z0-001).  In conjunction with the Oracle9i SQL Advanced course, this course is suitable for delegates intending to sit the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

Prerequisites:

Experience of using SQL with another relational database is required.

Relevant Certifications:

Oracle PL/SQL and Oracle Forms Developer

Oracle Internet Application Developer Rel. 6i Certified Professional

This course includes the following modules:

Course topics:

• The Basic SQL Select Statement
• Selecting Data from Multiple Tables
• Inner Joins, Outer Joins and Self Joins
• Hierarchical Queries
• Sub-queries
• Grouping and Sorting Output
• CUBE and ROLLUP features
• Character, Date and Numeric Functions
• Run-time Parameters and Variables
• SQL*Plus Control Parameters
• Creating and Changing Tables and Views
• Constraints and Indexes
• Inserting, Updating and Deleting Data
• Multi-Table Inserts and Merges
• Basic Transaction Control
• Controlling Access to the Database
• Related Data Dictionary Tables and Views

 

Location	Duration	RRP	Oct	Nov	Dec	Jan	Feb	Mar
Click on course date to make a booking, check availability, or find out about available discounts.
London	2 days	£725		24 - 25		12 - 13		2 - 3

<< 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