Menu

Tel: 01423 534630    Email: info@tts-uk.com

Introduction to SQL on Oracle

The Introduction to SQL on Oracle course is designed to give delegates practical experience in using SQL.

Versions supported 11gR2, 12cR2, 18c, 19c.

Course Objectives

To provide the knowledge and skills needed to retrieve data held in a relational database using Oracle Database.

Who will the Course Benefit?

Anyone who needs to understand and use SQL to manipulate a database.

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

Course Notes

There is an overlap between the content of this 1 day Introduction to SQL course and the content on the suggested follow-on 3 day Oracle SQL courses. You may wish to review the content of the Oracle SQL course and if more suitable to your training needs this course rather than this 1 day Introduction to SQL course.

Skills Gained

The delegate will learn and acquire skills as follows:

Creating SQL statements to query a database table
Using standard aggregate functions and related SELECT statement clauses
Joining Tables
Using basic subqueries and the set operators

Prerequisites

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


  • Course content

    Session 1: RELATIONAL DATABASE CONCEPTS

    What is an Oracle Database
    Relational Database Structures
    Tables, Rows and Columns
    Indexes, Primary Keys and Foreign Keys
    Data Types
    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

Duration: 1 day
Price: £425 + VAT

Payment logos


Book Now Enquire now

Share Course:

Register to attend

    All fields with * are mandatory.