+44 7459 302492
info@uplatz.com
Job Meter = High
Introduction to SQL on Oracle
30 Hours
Online Instructor-led Training
USD 1120
About this Course
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. This chapter provides background information on SQL as used by most database systems.
------------------------------------------------------------
------------------------------------------------------------
Introduction to SQL on Oracle
Course Details & Curriculum
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
------------------------------------------------------------ 