Overview

The course provides those interested in pursuing a career in database development, web development or computer programming with the necessary skills to develop and maintain relational databases using Oracle Database 12c.

Candidates will learn how to design, create and administer a relational database. They will improve their knowledge of SQL from beginner to intermediate level. SQL is a programming language that stores and access information in relational databases.

Candidates will acquire transferable skills, which can be applied to other RDBMS (relational database management systems) such as SQL Server or MySQL.

Successful candidates will be certified by Oracle as an Oracle Database SQL Certified Associate (Exam Number: 1Z0-071) and can seek employment opportunities as database application developers.

The course prerequisite is (A): IT Specialist Databases (ITS OD 201) or (B): Microsoft MTA Database Fundamentals (98-364). Applicants will be asked to upload a copy of their digital badge or e-Certificate (awarded by Microsoft) on enrolment.

What’s Included

  • All course content

  • Practice exercises and quizzes

  • A practice exam

  • A certification exam voucher

Course Handbook

Download Course Handbook

Course Topics

Topic 1

Oracle and Structured Query Language (SQL)

Topic 2

Using DDL Statements To Create and Manage Tables

Topic 3

Manipulating Data

Topic 4

Restricting and Sorting Data

Topic 5

Using Single-Row Functions to Customize Output

Topic 6

Using Conversion Functions and Conditional Expressions

Topic 7

Reporting Aggregated Data Using the Group Functions

Topic 8

Displaying Data from Multiple Tables

Topic 9

Using Subqueries to Solve Queries

Topic 10

Managing Schema Objects

Topic 11

Using the Set Operators

Topic 12

Managing Objects with Data Dictionary Views

Topic 13

Manipulating Large Data Sets

Topic 14

Controlling User Access

Prerequisites & Requirements

The course prerequisite are the (A): IT Specialist Databases (ITS OD 201) or (B): Microsoft MTA Database Fundamentals (98-364). Applicants will be asked to upload a copy of their digital badge or e-Certificate on enrolment.

If you have an interest in programming and wish to become skilled in one of the world’s most popular and versatile languages, this course is for you.

  • All students should have access to a PC or laptop running a supported version of Windows (e.g Windows 10). Apple/Android devices are not supported and cannot be used for this course.
  • A broadband connection is essential to stream video content.

You require a web browser to view the content and access web platforms.

Employment

After earning your Oracle accreditation, you will be skilled in one of the world’s most versatile programming languages (SQL). Upon qualification, you may be confident in seeking junior roles in web development, database development, software development, software testing and many other related fields.

Academic

After completing the course, you can further specialise by enrolling in the following eCollege programmes:

  • Software Testing-ISTQB Certified Tester Foundation Level
  • IT Specialist –  Python
  • IT Specialist –  HTML and CSS
  • Java Foundations Certified Junior Associate

Course Code: NC 12057 Oracle Certified Associate

There are multiple ways to apply for this course, please check out the different options below.

FETCH is the further education and training course finder. To apply for this course use the button below.

Apply Now

If you are currently unemployed, you will find the contact details for your local Intreo office by using the button below. An Intreo officer will be able to guide you through your application.

Learn More

Skills to Advance is the further education and training initiative for people in employment.

Find out more

Related Courses