• 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

Software Development Courses   SQL Training Courses

SQL

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.

 

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

 

- Describe the basic structure of a relational database
- Use the command line features of SQL*Plus
- Create SQL statements to select data from an Oracle Database
- Generate simple reports from selected data
- Use SQL*Plus control and run time parameters
- Create and alter tables, indexes and views
- Create, update and delete records
- Grant and revoke access privileges
- Access the Data Dictionary

Follow on courses:

PL/SQL

SQL Advanced

This course includes the following modules:

Course Topics:

• The Structure of a Relational Database
• Using SQL*Plus
• The Basic SQL Select Statement
• Selecting Data from Multiple Tables
• Inner Joins, Outer Joins and Self Joins
• Grouping and Sorting Output
• Sub-queries and In-line Views
• Character, Date and Numeric Functions
• SQL*Plus 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 or check availability.
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