For further information, please contact the Course Enquiry Team on 0161 9204466 or alternatively email us:

Oracle SQL I

What's the course about?

The aim of this course is to enable students to carry out a number of functions using SQL 1.

Areas covered by the course include:
• 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

The course is delivered through lectures and workshops and it is assessed on an end test.

How long is the course and when will it be taught?

This is a three day course.

Where is the course taught?
At Manchester New Technology Institute (MNTI), One Central Park, Northampton Road, Manchester.

How much will the course cost me?
You can call our Course Enquiry Team on FREECALL 0800 068 8585 for details of the fees for this course.

What qualifications or experience do I need to do this course?
Delegates should have a basic knowledge of IT.

Which qualifications will I be awarded if I successfully complete the course?
An Oracle SQL 1 certificate will be awarded at level 3.

What will I be able to do after I've completed this course?
On completion of this course, delegates could go on to study on the Oracle SQL 2 (Advanced) course at Manchester NTI. The Oracle SQL 1 course can enhance the career opportunities of junior database developers.

How do I apply?
For further information or to apply for a course, contact our Course Enquiry Team on FREECALL 0800 068 8585 or email enquiries@mancat.ac.uk.

Click here to Make an Enquiry

To register your interest in one of these courses or to request further information, please complete the online enquiry form or contact the Course Enquiry Team directly.

Course Enquiry Team

Tel: 0800 068 8585
Email: