Oracle SQL Training

Course Number: ORA100-W

Duration: 4 days

Format: Live, online

Overview

This Oracle training course is designed for students new to writing SQL queries with Oracle. While most of the SQL learned in this course is standard to all modern databases, the course focuses specifically on Oracle's implementation. The course is full of exercises, so students get a lot of practice writing SQL queries to solidify the skills learned in class.

Objectives

  • Understand how Oracle works
  • Learn how tables are structured and how data is stored.
  • Learn to use Oracle to output reports.
  • Learn to use SQL functions.
  • Learn to group data to get aggregate values.
  • Learn to write joins and subqueries to get data from multiple tables.
  • Learn to use SET operators.
  • Learn to do conditional processing with CASE.
  • Learn to write INSERT, UPDATE, and DELETE statements.
  • Learn to create views.

Attendee Setup Instructions

For details about what is required when attending this class, please refer to the these instructions (will open in a seperate browser window).

Outline

  • Relational Database Basics
    • Brief History of SQL
    • Relational Databases
      • Tables
      • Rows
      • Columns
      • Relationships
      • Data Types
      • Primary Keys
      • Foreign Keys
      • Relational Database Management System
    • Popular Databases
      • Commercial Databases
      • Popular Open Source Databases
    • Schemas and Users
      • Connection Lines
      • Tables
  • Creating Tables
    • Data Types
    • Creating Tables
      • NULL Values
      • Primary Keys
      • Foreign Keys
    • Adding Constraints
      • Dropping Constraints
    • UNIQUE Constraints
    • Adding and Dropping Columns
    • Dropping Tables
  • Basic Selects
    • Comments
    • Whitespace and Semi-colons
    • Case Sensitivity
    • SELECTing All Columns in All Rows
    • SELECTing Specific Columns
    • Sorting Records
      • Sorting by a Single Column
      • Sorting By Multiple Columns
      • Ascending and Descending Sorts
    • The WHERE Clause and Logical Operator Symbols
      • Checking for Equality
      • Checking for Inequality
      • Checking for Greater or Less Than
      • Checking for NULL
      • WHERE and ORDER BY
    • Checking Multiple Conditions with Boolean Operators
      • AND
      • OR
      • Order of Evaluation
    • The WHERE Clause and Logical Operator Keywords
      • The BETWEEN Operator
      • The IN Operator
      • The LIKE Operator
      • The NOT Operator
    • Limiting Rows
      • Fetching a Percent of Records
  • Oracle SQL Functions
    • The DUAL Table and Column Aliases
      • Column Aliases
    • Calculated Fields '
      • Concatenation
      • Mathematical Calculations
    • ROW_NUMBER()
    • Numeric Functions
      • ABS(), POWER(), and SQRT()
      • CEIL(), FLOOR(), and ROUND()
      • ROUND(num1, num2) and TRUNC(num1, num2)
      • MOD()
    • Character Functions Returning Character Values
      • TO_CHAR(number, format_model)
      • CONCAT()
      • LOWER(), UPPER(), and INITCAP()
      • LPAD() and RPAD()
      • TRIM(), LTRIM(), and RTRIM()
      • REPLACE() and SUBSTR()
    • Character Functions Returning Number Values
      • INSTR() and LENGTH()
    • Datetime Functions
      • CURRENT_DATE, CURRENT_TIMESTAMP, SYSDATE, and
      • SYSTIMESTAMP
      • TO_DATE()
      • TO_CHAR(datetime, format_model)
      • ROUND() and TRUNC()
    • NULL-Related Functions
      • COALESCE()
      • NVL()
      • NVL2()
    • Other Functions
      • DECODE()
      • GREATEST() and LEAST()
  • Aggregate Functions
    • Introduction to Aggregate Functions
    • Grouping Data
      • GROUP BY
      • HAVING
      • Order of Clauses
      • Grouping Rules
    • Selecting Distinct Records
    • ROLLUP() and CUBE()
      • ROLLUP()
      • CUBE()
  • Joins
    • Inner Joins
    • Outer Joins
      • Left Joins
      • Right Joins
      • Full Outer Joins
  • Subqueries
    • Subquery Basics
    • Subqueries in the SELECT Clause
      • Combining SELECT and WHERE Subqueries
  • Set Operators
    • Set Operators
    • Rules for Set Operations
    • UNION
    • UNION ALL
    • INTERSECT
    • MINUS
  • Conditional Processing with CASE
    • Using CASE
    • Selected Case
    • Searched Case
  • Data Manipulation Language
    • INSERT
    • UPDATE
    • DELETE
    • Updating and Deleting Multiple Records
  • Creating Views
    • Creating Views
      • Dropping Views
    • Benefits of Views
    • Inline Views

Schedule

Date / Time Price (USD)  
Oct 25 - 28
10 AM - 5 PM ET
$2,300 Register
Nov 29 - Dec 2
10 AM - 5 PM ET
$2,300 Register
Dec 27 - 30
10 AM - 5 PM ET
$2,300 Register
Jan 3 - 6
10 AM - 5 PM ET
$2,300 Register
Jan 31 - Feb 3
10 AM - 5 PM ET
$2,300 Register
Feb 28 - Mar 3
10 AM - 5 PM ET
$2,300 Register
Mar 28 - 31
11 AM - 6 PM ET
$2,300 Register
Apr 25 - 28
11 AM - 6 PM ET
$2,300 Register
May 23 - 26
11 AM - 6 PM ET
$2,300 Register
Jun 21 - 24
11 AM - 6 PM ET
$2,300 Register
Jul 18 - 21
11 AM - 6 PM ET
$2,300 Register
Aug 15 - 18
11 AM - 6 PM ET
$2,300 Register
Sep 12 - 15
11 AM - 6 PM ET
$2,300 Register
Oct 10 - 13
11 AM - 6 PM ET
$2,300 Register
Nov 7 - 10
10 AM - 5 PM ET
$2,300 Register
Dec 5 - 8
10 AM - 5 PM ET
$2,300 Register
$2,300 USD
Oct 25 - 28
10 AM - 5 PM ET
Register
Nov 29 - Dec 2
10 AM - 5 PM ET
Register
Dec 27 - 30
10 AM - 5 PM ET
Register
Jan 3 - 6
10 AM - 5 PM ET
Register
Jan 31 - Feb 3
10 AM - 5 PM ET
Register
Feb 28 - Mar 3
10 AM - 5 PM ET
Register
Mar 28 - 31
11 AM - 6 PM ET
Register
Apr 25 - 28
11 AM - 6 PM ET
Register
May 23 - 26
11 AM - 6 PM ET
Register
Jun 21 - 24
11 AM - 6 PM ET
Register
Jul 18 - 21
11 AM - 6 PM ET
Register
Aug 15 - 18
11 AM - 6 PM ET
Register
Sep 12 - 15
11 AM - 6 PM ET
Register
Oct 10 - 13
11 AM - 6 PM ET
Register
Nov 7 - 10
10 AM - 5 PM ET
Register
Dec 5 - 8
10 AM - 5 PM ET
Register
Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan