Oracle SQL
Course Code: ClaTech7428
No Upcoming Events
No upcoming Scheduled Courses. Contact us for information on booking a private course or join the waiting list for a public event.
Contact Us
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
NoneGet Started
Forget trawling through endless course catalogues – Find the training that’s right for you
Learn MoreLatest from our blog
Kanban and Agile: Bridging the Gap
Kanban and Agile: Bridging the Gap Quanta’s Kanban University Certified Trainer Steve Church explores the way in which Agile and…
Read More
How a Ballerina could move into Cybersecurity
Jason Ford, Quanta Cybersecurity and IT Trainer talks about the limitations in Cybersecurity Training courses. Jason discusses a safe and…
Read More
Boost Team Performance and Productivity: Unlocking the Advantages of Emotionally Intelligent Leadership
Quanta People Development and Leadership Trainer, Giles Collins outlines the key elements of Emotionally Intelligent Leadership and how it impacts…
Read More