Oracle SQL Fundamentals

Qualification type: Short Course Location:
One Central Park
Subject area:
Information Technology (IT)
Level: n/a
Course Code: CR7541-01 Leaflet Number: 6316
Awarding body: Generic award - no awarding body (NONE)
in
Awarding body: 
Generic award - no awarding body (NONE)
Qualification type: 
Short Course
Level: 
n/a
Subject area: 
Information Technology (IT)
Location: 
One Central Park

What's the Oracle SQL Fundamentals course about?

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

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

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 Data Administration (Advanced) course at Manchester NTI. The Oracle SQL Fundamentals course can enhance the career opportunities of junior database developers.

What qualifications or experience do I need to do this course?

Delegates should have a basic knowledge of IT.

Which qualification will I be awarded if I successfully complete the Oracle SQL Fundamentals course?

There is no requirement to undertake an assessment with this skills based course. All delegates will receive a certificate of skills validation from The Manchester College.

Attendance

Part time (evening)

Course length

10 Week(s)

Weeks per year

10

Hours per week

2.5

As the definition of full time and part time can vary from course to course, please check with the tutor as to the exact number of hours study each week this course will entail.

Price (for guidance only)

£250.00

The fee for this course is approximate and subject to change.The price includes tuition and materials fees (where applicable), but excludes any exam or registration fees (where applicable). The actual amount you pay may also be affected by your age and personal circumstances. For further details please visit our fees section.

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@themanchestercollege.ac.uk.

You can also apply on line for the Oracle SQL Fundamentals course.

Please note, the course information on this website is provided as a reference guide only and is subject to change. It is therefore important that you check all course details, including location, timetable, fee, etc, at enrolment as the college operates a no refund policy.