Introduction to Oracle SQL

Course Summary

The Introduction to Oracle SQL training course is designed to demonstrate a thorough introduction to interactive SQL and basic SQL*Plus operations.

The course begins with an examination of single table operations and moves into a discussion on the complexities of accessing multiple tables using joins or subqueries. Next, it explores the basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. The course concludes with an exploration of Oracle's New Features.

Purpose	Learn the basics of interactive SQL and SQL*Plus operations
Audience	Programmers, Analysts, Database Administrators, and Users who access data in an Oracle database
Role	Software Developer
Skill Level	Introduction
Style	Lecture \| Hands-on Activities \| Labs
Duration	3 Days
Related Technologies	SQL

Learning Objectives

Describe data retrieval operations
Use multi-table operations
Identify Data Manipulation Operations
Associate row functions
Discover group functions
Review subqueries

What You'll Learn:

In the Introduction to Oracle SQL training course, you'll learn:

Data Retrieval Operations

SELECT Statement
SELECT Expressions
- Columns, Functions, Constants, Subqueries
Sorting the Result (ORDER BY)
The WHERE Clause
AND, OR Operators
WHERE Clause Operators
- =, >, <, >=, <=
- IN, BETWEEN, LIKE, NOT NULL
CASE Expressions
- Simple CASE
- Searched CASE
Processing Date/Time Information
SQL Standards

Multi-Table Operations

Inner Join
Outer Join
Using the (+) Operator
ANSI Join Syntax
INNER JOIN, OUTER JOIN
JOIN USING, NATURAL JOIN
Join Considerations

Data Manipulation Operations

UPDATE, DELETE, INSERT Statements
The TRUNCATE statement
TRUNCATE vs. DELETE
COMMIT and ROLLBACK

Row Functions

Character Functions
Numeric Functions
Date/Time Functions
Misc Functions

Group Functions

Aggregate Functions
- COUNT, MAX, MIN, AVG, SUM
The GROUPBY Clause
The HAVING Clause
HAVING vs. WHERE

Related Oracle Objects

Views
Sequences
Synonyms

Subqueries

Non-Correlated
Correlated
Usages
- WHERE Clause
- FROM Clause
- SELECT Expression
- DML Statements
The WITH Option
Behavior and Benefits

Oracle's New Features

FETCH FIRST Clause (Top-nQueries)
TRUNCATE CASCADE Option

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

Expert Practitioners

Industry experts that bring their battle scars into the classroom.

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!

“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

Introduction to Oracle SQL

Course Summary

Purpose

Audience

Role

Skill Level

Style

Duration

Related Technologies