Introduction to Oracle SQL Course

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

Hack-a-thon - Learning Spikes - Workshops

Duration

3 Days

Related Technologies

SQL

Download

Productivity Objectives:

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

Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.

about our training

Real-World Content

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

Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
Experiential Learning

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

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

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