Data, Analytics & AI Category Banner Image

Oracle Database SQL (OCDB)

Length 3 days
Price NZD 3500 exc GST

Course overview

View dates &
book now

Course locations >>

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

View all Oracle courses

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

Introduction to SQL
- Oracle Database introduction
- Relation and Object relational database systems
- Development environments for SQL
- Tables used in this course
SQL SELECT statement
- General SQL syntax rules
- Basic SELECT statements
- Use of DUAL table
- Operators
- Column aliases
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
Built-in Functions to customise output
- Single-row functions
- Character-manipulation functions
- Numeric functions
- Date-manipulation functions
- Conversion functions
- General functions
- Case Expression
Data aggregations using GROUP BY, and HAVING
- Group functions
- GROUP BY clause usage
- Restricting group results with the HAVING clause
Join Types
- Join fundamentals
- Types of joins
- INNER JOIN
- ON and USING clauses
- Self-joins
- OUTER joins: LEFT, RIGHT, and FULL
- Cartesian products
Subqueries
- Subqueries use cases
- Guidelines for using subqueries
- Single-row, and multiple-row subqueries
- ANY, and ALL operators
- Multiple-column subqueries
Set Operators
- Set operator use cases
- UNION
- UNION ALL
- INTERSECT
- MINUS
- ORDER BY in set operations
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
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

Prerequisites

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.