Home About Courses Schedule Services Webinars Contact Search

Oracle SQL Starter

SEE SCHEDULE

Duration: 1 Day

Method: Instructor led, Hands-on Workshops

Price: $600.00

Course Code: OR5800


Audience

All

Description

This course targets the student that needs to get up to speed on Oracle SQL now. The course gets the student up and running fast teaching them how to access data using various operators, using joins and using supplied and aggregate functions. Clauses covered include the FROM clause, the WHERE clause, the ORDER BY clause, the GROUP BY clause and the HAVING clause. Writing efficient SQL is emphasized.This course is perfect for both programmers and non-programmers along with students that are backups, end users, managers, students that may not have the time/budget for a longer course at this time or students just needing a refresher or needing to fill in some blanks. Hands-on workshops provide students with a solid understanding of the concepts presented in the lectures.

Prerequisites

None

Topics

  • I.The SQL SELECT Statement
    • Expressions and Expression Types
    • The FROM Clause
    • Restricting Result Sets
    • The WHERE Clause
    • WHERE Clause Operators
      • =, <>, !=, <, >
      • IN, BETWEEN, LIKE, IS NULL
      • NOT
    • Sorting Result Sets
      • The ORDER BY Clause
  • II.Joins
    • Joining Data from Multiple Tables/Views
    • Inner Joins
    • Join Syntax
      • In the WHERE Clause
      • JOIN ON
      • JOIN USING
      • NATURAL JOIN
    • Specifying Join Order
    • Outer Joins
      • Using the (+) Outer Join Operator
      • Using LEFT/RIGHT/FULL OUTER JOIN
  • III.Using Functions
    • Row Functions
    • Common Supplied Functions
    • Function Types
      • Character
      • Numeric
      • Date/Time
      • Conversion
      • Miscellaneous
    • Aggregate/Group Functions
      • COUNT, MAX, MIN, AVG, SUM
      • Using the GROUP BY Clause
      • Using the HAVING Clause
      • HAVING vs. WHERE