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