Introduction to SQL on Oracle

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

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

Who will the Course Benefit?

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

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.

Select specific date to see price, venue and full details.

Learning Objectives

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

Pre-Requisites

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. Some previous programming or database experience 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

Related Courses

We can arrange to deliver all our public courses at your premises. In-house training offers advantages over booking public courses including:

cost savings
avoidance of travel expenses
tailoring to meet specific needs

Simply fill out the form below or call our sales team.

Remember, we aim to beat any like for like quote you have received.

Company:

Number of delegates:

Training location:

Time frame:

First name:

Last name:

Email address:

Phone number:

Notes:

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

I would like to receive marketing via email: