Training Course

Oracle SQL

PDF
3 Days
The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 28 Apr 2025
Virtual Course
£1495
02 Jun - 04 Jun 2025
Virtual Course
£1495
30 Jun - 02 Jul 2025
Virtual Course
£1495
28 Jul - 30 Jul 2025
Virtual Course
£1495
01 Sep - 03 Sep 2025
Virtual Course
£1495
29 Sep - 01 Oct 2025
Virtual Course
£1495
27 Oct - 29 Oct 2025
Virtual Course
£1495
24 Nov - 26 Nov 2025
Virtual Course
£1495

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Prerequisites

    • There are no formal pre-requisites for the Oracle SQL course, although an understanding of databases and exposure to information technology in general would be useful.

Course Objectives

    • Creating SQL statements to query database tables
      Using standard aggregate functions and related SELECT statement clauses
      Joining Tables
      Using basic subqueries and the set operators
      Using numeric, character and date functions
      Using conversion and other miscellaneous functions
      Using SQL parameters
      Using complex subqueries
      Creating and altering tables and views
      Inserting, updating and deleting rows in database tables
      Managing sequences and synonyms

Course Certification

Together with the Oracle SQL Advanced course, the Oracle SQL course also covers the major topics required for the following Oracle examination:

Oracle Database SQL Fundamentals 1Z0-071
Before taking this exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

This exam is not included as part of the course.

Target Audience for this Course

    • Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database.

Included with this course

    • Comprehensive course materials and exercises

Oracle SQL Course Content

  • DAY 1

    Session 1: RELATIONAL DATABASE CONCEPTS
    What is an Oracle Database
    Relational Database Structures
    Tables, Rows and Columns
    Indexes, Primary Keys and Foreign Keys
    Supported Datatypes
    The Data Dictionary

    Session 2: USING SQL*PLUS
    What is SQL*Plus
    Getting Started
    Entering and Executing SQL Statements
    The SQL*Plus Command Line History
    Editing SQL Statements
    The login.sql File
    Creating, Editing and Executing SQL Files
    The SQLcl Utility

    Session 3: USING SQL DEVELOPER
    What is Oracle SQL Developer
    Starting SQL Developer
    Configure a Connection
    Navigation Tabs
    SQL Worksheet
    Query Builder

    Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT
    The SELECT Statement
    The SELECT and FROM Clauses
    Conditions and the WHERE Clause
    Other Conditional Operators
    Logical Operators
    The ORDER BY Clause
    Column Aliases
    Arithmetic Expressions
    Precedence of Operators
    Markup CSV

    Session 5: AGGREGATE FUNCTIONS
    Overview of Built In Aggregate Functions
    The GROUP BY Clause
    The HAVING Clause

    Session 6: JOINING TABLES
    Overview of Table Joins
    Inner Joins
    Table Aliases
    Outer Joins
    Self Joins
    ANSI Standard Joins

    Session 7: BASIC SUBQUERIES AND SET OPERATORS
    Overview of Subqueries
    Basic Subqueries
    Set Operators
    The Union, Intersect and Minus Operators

  • DAY 2

    Session 8: NUMERIC, CHARACTER AND DATE FUNCTIONS
    Function Types
    Using the Table dual to try out Functions
    Numeric Functions
    Character Functions
    String Concatenation
    Date Arithmetic and Date Functions

    Session 9: CONVERSION AND MISCELLANEOUS FUNCTIONS
    Conversion Functions
    The NVL and NVL2 Functions
    The DECODE Function
    CASE Expressions
    The COALESCE and NULLIF Functions

    Session 10: SQL PARAMETERS
    Command Line Substitution Parameters
    The Accept Command
    The Define and Undefine Commands

    Session 11: COMPLEX SUBQUERIES
    Subqueries Usage
    In-Line Views
    Top-N Queries
    Subqueries with Joins
    Multi Column Subqueries
    Correlated Subqueries
    Subquery Rules
    Using the ANY, ALL and SOME Operators

  • DAY 3

    Session 12: MANAGING DATA
    Inserting Rows
    Updating Rows
    Deleting Rows
    Verifying Updates
    Transaction Control
    Commit and Rollback
    Savepoints
    Commits and Constraints
    Amending Data in SQL Developer

    Session 13: MANAGING TABLES
    Creating Tables
    Specifying Constraints
    Altering Tables, Columns and Constraints
    Dropping Tables, Columns and Constraints
    Recovering Dropped Tables
    Copying Tables

    Session 14: MANAGING INDEXES AND VIEWS
    Creating Indexes
    Dropping Indexes
    Listing Indexes
    Creating and Using Views
    Dropping Views
    Listing Views

    Session 15: MANAGING SEQUENCES AND SYNONYMS
    Create a Sequence
    View Sequence Details
    Create a Synonym
    List Synonyms

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 28 Apr 2025
Virtual Course
£1495
02 Jun - 04 Jun 2025
Virtual Course
£1495
30 Jun - 02 Jul 2025
Virtual Course
£1495
28 Jul - 30 Jul 2025
Virtual Course
£1495
01 Sep - 03 Sep 2025
Virtual Course
£1495
29 Sep - 01 Oct 2025
Virtual Course
£1495
27 Oct - 29 Oct 2025
Virtual Course
£1495
24 Nov - 26 Nov 2025
Virtual Course
£1495

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Oracle SQL Course Options
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Course Reviews
"Pivot Tables will help me present reports and information much better and more comfortably on a day to day basis"

J.C. , Excel Level 3

Following this training what are you going to do differently "Write some macros into my spreadsheets following the course next month, always create tables for the data, name cells to use in formulas"

A.G. Yorwaste, Excel Level 3

Which part of the course did you find particularly valuable "Learning more about the skills of a minute taker and learning about how important the role is."

E.S. Skills for Care, Minute Taking and Speedwriting

"All aspects were worthwhile, Everything was well laid out explained."

L.G. James Jones and Sons Ltd, Excel Level 1

"An enjoyable day!"

R.G. James Jones and Sons Ltd, Excel Level 2

Which part of the course did you find particularly valuable "Learning how to structure training sessions "

S.M. Thermo Fisher Scientific, Train the Trainer Training Skills for the Workplace

"[The trainer] unveiled a lot of well hid little sneak cheats on making life a lot easier whilst working in Word. Really enjoyed the training, I work mainly in Excel, so it was great to learn about Word, and I'm no longer afraid to work in it."

D.I. Houghton International, Word Essentials

"I felt the course was really excellent and no improvement needed"

S.D. Everyturn, Excel Level 3

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
24 Apr - 28 Apr 2025
Virtual Course
£1495
02 Jun - 04 Jun 2025
Virtual Course
£1495
30 Jun - 02 Jul 2025
Virtual Course
£1495
28 Jul - 30 Jul 2025
Virtual Course
£1495
01 Sep - 03 Sep 2025
Virtual Course
£1495
29 Sep - 01 Oct 2025
Virtual Course
£1495
27 Oct - 29 Oct 2025
Virtual Course
£1495
24 Nov - 26 Nov 2025
Virtual Course
£1495

Private Training

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your Oracle SQL course, we have many solutions available to ensure you receive the best training possible.
Your SQL course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Oracle SQL course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master SQL, please contact us to book a place or request a quote for your Oracle SQL course.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2025 4:28:58 PM