Oracle SQL Data Administration

Awarding body: 
Generic award - no awarding body (NONE)
Qualification type: 
Short Course
Level: 
n/a
Subject area: 
Information Technology (IT)
Location: 
Northenden Campus

What's the Oracle SQL Data Administration course about?

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

Topics covered include:
- How to use iSQLPlus
- ANSI-Compliant Inner Joins
- ANSI-Compliant Outer and Self Joins
- Hierarchical Queries
- Enhanced Grouping Extensions and Functions
- TIMESTAMP, TIMEZONE and INTERVAL Datatypes
- TIMESTAMP and INTERVAL Functions and Literals
- Overview of Analytic Functions
- Ranking Data by Value and Percentile
- Providing Cumulative, Moving and Centered Aggregates
- POSIX Compliant Regular Expression Notation
- Regular Expression Functions
- Enhanced Subquery Functions
- CASE Expressions
- Extended Insert and Merge Operations on Tables
- Creating and Using External Tables

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 PL/SQL course at Manchester NTI. The Oracle SQL Data Administration course can enhance the career opportunities of junior Oracle developers.

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

Delegates should have attended the Oracle SQL Fundamentals course or have a similar level of experience.

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

There is no requirement to undertake an assessment with this skills based course. All delegates will receive a certificate of skills validation from Manchester New Technology Institute (MNTI).

Attendance

Part time (day)
Course length: 
10 Week(s)
Weeks per year: 
10
Hours per week: 
3

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)

£199.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 Data Administration 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.