Home / Courses / AI, Data & Analytics / Oracle Database 12c R2: SQL Workshop 1

Oracle Database 12c R2: SQL Workshop 1

Name: Oracle Database 12c R2: SQL Workshop 1
Availability: InStock
Rating: 4.6 (5878 reviews)

This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

24.00 hours

19.5 CPD hours

Overview:

Description:

- Understand SQL statements, as well as the Oracle Relational Database.
- Use SQL Developer.
- Write reports using SQL statements.
- Manipulate data in relational tables and save the data.
- Understand the concepts of relational databases and the powerful SQL programming language.
- Write reports using SQL Statements
Use Single Row Functions:

This Oracle Database course will also teach you how to use single row functions to customize output. Explore using conversion functions and conditional expressions, along with use group functions to report aggregated data.

Reinforce Your Knowledge through Hands-On Exercises:

Demonstrations and hands-on practice reinforce the fundamental concepts you'll delve into in this course. You will discover and use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is also introduced as an optional tool

Course Outline:

Introduction

- Course Objectives, Course Agenda and Appendixes Used in this Course
- Overview of Oracle Database 12c and Related Products
- Overview of relational database management concepts and terminologies
- Introduction to SQL and its development environments
- What is Oracle SQL Developer?
- Starting SQL*Plus from Oracle SQL Developer
- The Human Resource(HR) Schema
- Tables used in the Course
Retrieving Data using the SQL SELECT Statement

- Capabilities of the SELECT statement
- Arithmetic expressions and NULL values in the SELECT statement
- Column aliases
- Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
- Use of the DESCRIBE command
Restricting and Sorting Data

- Limiting the Rows
- Rules of precedence for operators in an expression
- Substitution Variables
- Using the DEFINE and VERIFY command
Using Single-Row Functions to Customize Output

- Describe the differences between single row and multiple row functions
- Manipulate strings with character function in the SELECT and WHERE clauses
- Manipulate numbers with the ROUND, TRUNC and MOD functions
- Perform arithmetic with date data
- Manipulate dates with the date functions
Using Conversion Functions and Conditional Expressions

- Describe implicit and explicit data type conversion
- Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
- Nest multiple functions
- Apply the NVL, NULLIF, and COALESCE functions to data
- Use conditional IF THEN ELSE logic in a SELECT statement
Reporting Aggregated Data Using the Group Functions

- Group Functions
- Creating Groups of Data
- Restricting Group Results
Displaying Data From Multiple Tables Using Joins

- Introduction to JOINS
- Types of Joins
- Natural join
- Self-join
- Non equijoins
- OUTER join
Using Subqueries to Solve Queries

- Introduction to Subqueries
- Single Row Subqueries
- Multiple Row Subqueries
Using the SET Operators

- Set Operators
- UNION and UNION ALL operator
- INTERSECT operator
- MINUS operator
- Matching the SELECT statements
- Using ORDER BY clause in set operations
Managing Tables using DML statements

- Data Manipulation Language
- Database Transactions
Introduction to Data Definition Language

- Data Definition Language

Available Delivery Options for Oracle Database 12c R2: SQL Workshop 1

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Oracle Database 12c R2: SQL Workshop 1 provide?

The 3 day Oracle Database 12c R2: SQL Workshop 1 course gives you up to 19.5 CPD hours/structured learning hours.

Who is the correct audience for Oracle Database 12c R2: SQL Workshop 1?

- Forms Developer
- Functional Implementer
- System Analysts
- Application Developers
- PL/SQL Developer

Do you provide training for Oracle Database 12c R2: SQL Workshop 1?

Yes, we provide corporate training, dedicated training and closed classes for Oracle Database 12c R2: SQL Workshop 1. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Oracle Database 12c R2: SQL Workshop 1?

The Oracle Database 12c R2: SQL Workshop 1 training takes place over 3 day(s), with each day lasting approximately 24.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Oracle Database 12c R2: SQL Workshop 1, Oracle Database Training, OCDSQLW1

Why are Nexus Human the best provider for Oracle Database 12c R2: SQL Workshop 1?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Oracle Database 12c R2: SQL Workshop 1?

Yes, the discount code PENPAL5 is currently available for Oracle Database 12c R2: SQL Workshop 1 training. Only one discount code can be used per booking.

DURATION 1 Day

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.