Data, Analytics & AI Category Banner Image

Oracle Database SQL (OCDB)

  • Length 3 days
  • Price  NZD 3500 exc GST
Course overview
View dates &
book now

Why study this course

Oracle Database SQL offers you an introduction to Oracle® Database technologies and will equip you with essential SQL skills to query an Oracle database efficiently.

SQL is the primary query language used in multiple relational database systems. This hands-on course teaches you how to query single and multiple tables and insert, update, and delete existing data.

This course provides the fundamental concepts about relational databases, does not assume prior knowledge of databases, and is the right starting point before PL/SQL.

Request Course Information

What you’ll learn

After completing this course, students should be able to:

  • Understand the fundamental components of an Oracle database

  • Retrieve data from tables with the SELECT statement

  • Create sorted and restricted data reports

  • Use SQL functions to customise output

  • Run queries combining data from multiple tables

  • Execute commands to update data, and create and manage objects

Oracle corporate PNG logo

Oracle at Lumify Work

Oracle offers a complete enterprise cloud designed to modernise your business, including cloud applications and cloud infrastructure services. Lumify Work offers courses in Oracle Database and web app development so you can utilise the world's leading converged, multimodel database management system in the cloud.

Who is the course for?

Anyone seeking to learn the fundamental concepts of Oracle Database technologies, and using SQL to query an Oracle Database.

Course subjects

  1. Introduction to SQL

    • Oracle Database introduction

    • Relation and Object relational database systems

    • Development environments for SQL

    • Tables used in this course

  2. SQL SELECT statement

    • General SQL syntax rules

    • Basic SELECT statements

    • Use of DUAL table

    • Operators

    • Column aliases

  3. WHERE, and ORDER BY clauses

    • Limiting rows by using the WHERE clause

    • Comparison operators

    • BETWEEN, IN, and LIKE operators

    • Logical operators AND, OR and NOT

  4. Built-in Functions to customise output

    • Single-row functions

    • Character-manipulation functions

    • Numeric functions

    • Date-manipulation functions

    • Conversion functions

    • General functions

    • Case Expression

  5. Data aggregations using GROUP BY, and HAVING

    • Group functions

    • GROUP BY clause usage

    • Restricting group results with the HAVING clause

  6. Join Types

    • Join fundamentals

    • Types of joins


    • ON and USING clauses

    • Self-joins

    • OUTER joins: LEFT, RIGHT, and FULL

    • Cartesian products

  7. Subqueries

    • Subqueries use cases

    • Guidelines for using subqueries

    • Single-row, and multiple-row subqueries

    • ANY, and ALL operators

    • Multiple-column subqueries

  8. Set Operators

    • Set operator use cases

    • UNION



    • MINUS

    • ORDER BY in set operations

  9. Data Manipulation Language statements

    • Adding new rows using INSERT statements

    • Changing data in a table using UPDATE

    • Removing rows from a table using DELETE

    • Controlling database transactions with COMMIT, and ROLLBACK

  10. Data Definition Language introduction

    • Rules for object creation

    • CREATE TABLE statement

    • Table constraints: NOT NULL, UNIQUE, PRIMARY, FOREIGN KEY, and CHECK

    • ALTER TABLE statement

    • TRUNCATE tables

    • Dropping tables

    • Oracle recycle bin


No prior knowledge of databases is assumed.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.