Introduction to Oracle SQL

The Introduction to Oracle SQL training course is designed to provide students with 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, Students will also learn 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 12c New Features.

A hands-on lab, students will use coding examples and workshops to bolster understanding of the material presented in class. The Introduction to Oracle SQL course can be taught for any version of Oracle.

Course Summary

Learn the basics of interactive SQL and SQL*Plus operations.
Programmers, Analysts, Database Administrators, and Users who access data in an Oracle database.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
3 Days
Productivity Objectives: 
  • Understand Data Retrieval Operations
  • Use Multi-Table Operations
  • Understand Data Manipulation Operations
  • Understand Row Functions
  • Understand Group Functions
  • Understand Subqueries
Introduction to Oracle SQL is part of the Oracle curriculum.

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
    • SortingtheResult(ORDERBY)
    • TheWHEREClause
    • AND,OROperators
    • WHEREClauseOperators
      • =, >, <, >=, <=
    • CASEExpressions
      • Simple CASE
      • Searched CASE
    • ProcessingDate/TimeInformation
    • SQLStandards
  • Multi‐Table Operations
    • InnerJoin
    • OuterJoin
    • Usingthe(+)Operator
    • ANSIJoinSyntax
    • JoinConsiderations
  • Data Manipulation Operations
    • TheTRUNCATEstatement
  • Row Functions
    • CharacterFunctions
    • NumericFunctions
    • Date/TimeFunctions
    • MiscFunctions
  • Group Functions
    • AggregateFunctions
    • TheGROUPBYClause
    • TheHAVINGClause
  • Related Oracle Objects
    • Views
    • Sequences
    • Synonyms
  • Subqueries
    • Non‐Correlated
    • Correlated
    • Usages
      • WHERE Clause
      • FROM Clause
      • SELECT Expression
      • DML Statements
    • TheWITHOption
    • BehaviorandBenefits
  • Oracle 12c New Features
    • FETCHFIRSTClause(Top‐nQueries)

Get Custom Training Quote

We'll work with you to design a custom Introduction to Oracle SQL training program that meets your specific needs. A 100% guaranteed plan that works for you, your team, and your budget.

Learn More

Chat with one of our Program Managers from our Boulder, Colorado office to discuss various training options.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients
Need help finding the right learning solution?   Call us: 877-629-5631