Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

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
Hack-a-thon - Learning Spikes - Workshops
Duration
3 Days
Related Technologies
SQL

 

Productivity 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

Real-World Content

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

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

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

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

By filling out this form and clicking submit, you acknowledge our privacy policy.