Introduction to SQL on Oracle

1 Day Course
Hands On
Code ISQLO

Book Now - 2 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

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

Objectives

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

Target Audience

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

Additional Information

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

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

RELATIONAL DATABASE CONCEPTS (6 topics)

  • What is an Oracle Database
  • Relational Database Structures
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Supported Datatypes
  • The Data Dictionary

USING SQL*PLUS (5 topics)

  • What is SQL*Plus
  • Getting Started
  • Entering and Executing SQL Statements
  • Editing SQL Statements
  • Creating, Editing and Executing SQL Files

USING SQL DEVELOPER (6 topics)

  • What is Oracle SQL Developer
  • Starting SQL Developer
  • Configure a Connection
  • Navigation Tabs
  • SQL Worksheet
  • Query Builder

RETRIEVING DATA WITH THE SELECT STATEMENT (9 topics)

  • 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

AGGREGATE FUNCTIONS (10 topics)

  • 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

BASIC SUBQUERIES AND SET OPERATORS (4 topics)

  • Overview of Subqueries
  • Basic Subqueries
  • Set Operators
  • The Union,Intersect and Minus Operators

Prerequisites

Some previous programming or database experience would be useful.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.

Pricing

Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price May Jun Jul Aug Sep Oct
ISQLO 1 Day $555
11
ISQLO 1 Day $555
ISQLO 1 Day $555
ISQLO 1 Day $555
18

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections