Tel: 01423 534630 • Email: info@tts-uk.com
The Introduction to SQL on Oracle course is designed to give delegates practical experience in using SQL.
Versions supported 11gR2, 12cR2, 18c, 19c.
To provide the knowledge and skills needed to retrieve data held in a relational database using Oracle Database.
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.
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.
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
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.
What is an Oracle Database
Relational Database Structures
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Data Types
The Data Dictionary
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
What is Oracle SQL Developer
Starting SQL Developer
Configure a Connection
Navigation Tabs
SQL Worksheet
Query Builder
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
Overview of Built In Aggregate Functions
The GROUP BY Clause
The HAVING Clause
Overview of Table Joins
Inner Joins
Table Aliases
Outer Joins
Self Joins
ANSI Standard Joins
Overview of Subqueries
Basic Subqueries
Set Operators
The Union, Intersect and Minus Operators