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

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.
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
Duration: 
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
      • =, >, <, >=, <=
      • IN, BETWEEN, LIKE, NOT NULL
    • CASEExpressions
      • Simple CASE
      • Searched CASE
    • ProcessingDate/TimeInformation
    • SQLStandards
  • Multi‐Table Operations
    • InnerJoin
    • OuterJoin
    • Usingthe(+)Operator
    • ANSIJoinSyntax
    • INNERJOIN,OUTERJOIN
    • JOINUSING,NATURALJOIN
    • JoinConsiderations
  • Data Manipulation Operations
    • UPDATE,DELETE,INSERTStatements
    • TheTRUNCATEstatement
    • TRUNCATEvs.DELETE
    • COMMITandROLLBACK
  • Row Functions
    • CharacterFunctions
    • NumericFunctions
    • Date/TimeFunctions
    • MiscFunctions
  • Group Functions
    • AggregateFunctions
      • COUNT, MAX, MIN, AVG, SUM
    • TheGROUPBYClause
    • TheHAVINGClause
    • HAVINGvs.WHERE
  • 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)
    • TRUNCATECASCADEOption

Contact us to learn more

Not all training courses are created equal. Let the customization process begin! We'll work with you to design a custom Introduction to Oracle SQL training course that meets your specific needs.

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

surveyask

Need help finding the right learning solution?   Call us: 877-629-5631