Upcoming Dates
Train your team with Quanta. Private course delivery available. Contact us to discuss your options.
Build practical skills to confidently query, analyse, and manage data in Oracle databases
Descriptions
Who is this course for
Data specialists, database developers and support personnel who need to be able to query and report on data from Oracle databases.
Purpose of the course
This course is designed to provide a comprehensive introduction to Oracle SQL, equipping learners with the practical skills needed to query and manipulate data effectively. Through hands-on learning and real-world examples, delegates will gain a solid understanding of core SQL concepts, from basic queries to advanced techniques such as joins, aggregations, and analytical functions. By the end of the course, participants will be able to confidently create queries, work with multiple tables, and support data-driven reporting within Oracle environments.
You will learn how to
- Write Oracle SQL queries
- Join multiple tables
- Use windowing queries
- Summarise data in aggregate
- Create tables
- Understand transactions
- Use common table expressions
Benefits for you as an individual
Many roles require a knowledge of specifically Oracle SQL. This course will equip you with the skill to understand and use Oracle SQL. You will have confidence to build queries for Oracle databases.
Benefits for your organisation
Oracle is the chosen database for many enterprise applications and data warehouses. This course will give your organisation the ability to develop Oracle SQL queries to exploit this data. These queries will often be used as the basis of corporate and departmental reports.
Prerequisites
No previous experience of Oracle databases or databases generally is required.Introduction to Oracle SQL
- Relation Databases and Oracle
- Table Structure
- Primary and Foreign Keys
- Types of Data
- Using SQL Developer
- Using SQL*Plus
- Connecting to Oracle
Basic SQL Queries
- SELECT columns
- FROM tables
- Removing Duplicates
- Filtering Rows
- Combining Filters
- Handling NULLS
- Ordering Rows
- OFFSET and FETCH
Joining Tables
- Introduction to Joins
- Using Joins
- INNER JOIN
- OUTER JOIN
- CROSS JOIN
- Considerations for Joins
Set Operators
- Overview of Set Operators
- UNION and UNION ALL
- INTERSECT and INTERSECT ALL
- MINUS and MINUS ALL
- EXCEPT and EXCEPT ALL
Using Functions
- Types of Function
- Using Functions
- Single Row Functions
- Character Function
- Numeric Functions
- Datetime Functions
- Conversion functions
- Date Handling
- Using CASE
Aggregate Functions
- Grouping Rows
- Filtering Groups
- CUBE and Rollup
Subqueries
- Using Subqueries
- Simple Subqueries
- Correlated Subqueries
Windowing Functions
- Introduction to Windowing Functions
- Ranking Functions
- OVER clause
- Analytical Functions Overview
Common Table Expressions
- Using Common Table Expressions
- Hierarchical Queries
Pivoting Data
- Introduction to Pivoting Data
- PIVOT and UNPIVOT
Data Definition
- Datatypes
- Creating and Modifying Tables
- Using Constraints
- Using Synonyms
- Overview of Indexes
- Creating Indexes
- Overview of Views
- Creating and Using Views
Data Manipulation
- INSERT, UPDATE and DELETE
- Merging Data
- Transaction
- COMMIT and ROLLBACK
Data Control
- Privileges
- GRANT and REVOKE
Additional Exam Information
NonePre-Coursework
NoneBook Your Course
Start Date
Venue
Availability
Cost
Course confirmed - Guaranteed to run
Course Full/Limited availability
Price shown excluding VAT.
Get Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest News from Quanta
Service Management State of Play: All talks available to watch now.
Following the recent Service Management State of Play event in collaboration with PeopleCert, we are pleased to share the presentations…
Read More
Quanta Achieves FTG Gold Partner Status
We’re thrilled to share that Quanta Training has been awarded FTG Gold Partner status at this year’s FTG (Forces Transition…
Read More
ITIL Version 5: Bringing Clarity, Confidence & Connection to the Digital Age
With the launch of ITIL Version 5, Quanta’s head of portfolio for IT Service Management and ITIL Master, Adam White-Bower…
Read More