• 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*Plus

View course dates

Course Duration: 3 days

Course Code: OSP

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:

An understanding of IT 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 Structure of a Relational Database
• The Basic SQL Select Statement
• Selecting Data from Multiple Tables
• Inner Joins, Outer Joins and Self Joins
• Sub-queries
• Grouping and Sorting Output
• Character, Date and Numeric Functions
• Run-time Parameters and Variables
• SQL*Plus Control Parameters
• Producing Reports with SQL*Plus
• Creating and Changing Tables and Views
• Constraints and Indexes
• Inserting, Updating and Deleting Data
• Basic Transaction Control
• Controlling Access to the Database
• Related Data Dictionary Tables and Views

 

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.
Birmingham	3 days	£995				2 - 4		18 - 20
Bristol	3 days	£995		12 - 14		30 - 1
Edinburgh	3 days	£995	8 - 10	12 - 14	16 - 18	16 - 18		11 - 13
Leeds	3 days	£995		26 - 28		23 - 25
London	3 days	£995	8 - 10	12 - 14	2 - 4 23 - 25	23 - 25	27 - 29	18 - 20
Manchester	3 days	£995		12 - 14		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