Project Description

Overview

The course provides those who are 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 is used to store 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 a database application developer.

The course prerequisite is the Microsoft MTA Database Fundamentals (98-364) exam. 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 is the Microsoft MTA Database Fundamentals (98-364) exam. Applicants will be asked to upload a copy of their digital badge or e-Certificate (awarded by Microsoft) 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
  • Introduction to Programming using Python
  • Introduction to Programming using HTML and CSS
  • Java Foundations Certified Junior Associate

Is this course for you?

Find out how to apply by tapping the button below.

Please note you can only be enrolled on one eCollege course at any one time. 

Course Code: NC 12057

Apply Now

Related Courses