Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 12c SQL & SQLPLUS Express Introduction

GK# 7377 Vendor# OR110

Course Overview

TOP

In this course, you will receive an introduction to Oracle's relational database, and a hands-on introduction in how to add, update, extract, and organize information from the database. You will work with Oracle's Structured Query Language (SQL), SQL*Plus, and SQL Developer.

What You'll Learn

TOP
  • Format reports using SQL*Plus commands
  • Extract and organize information from the database
  • Insert, update, and delete information in database tables
  • Understand Structured Query Language basics

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

1. Introduction to the Oracle Database

  • Why Use an Entity Relationship Model?
  • Physical Data Storage
  • Relationships between Tables
  • Domains and Data Integrity Constraints
  • Data Model Review

2. SQL Basics and SQL*Plus

  • Understanding the Difference Between SQL, SQL*Plus and PL/SQL
  • Invoking and Leaving SQL*Plus
  • Entering and Executing Commands
  • The SQL Buffer, SQL*Plus Default Output
  • LOGIN.SQL / GLOGIN.SQL
  • The SELECT Command & Mandatory Clauses

3. Using SQL Developer

  • Understanding SQL Developer
  • SQL Developer Setup
  • Advanced Functionality

4. The WHERE and ORDER BY Clause

  • WHERE, ORDER BY Clause
  • Using the Data Dictionary
  • Hierarchical Queries
  • Pattern Matching

5. Single Row Functions

  • Arithmetic Operators
  • Operator Precedence
  • Single Row vs. Group Functions
  • Date and Numeric Format Models
  • Data Conversion / Date Manipulation / Time Zones
  • Control Statements
  • IF THEN ELSE Logic
  • Regular Expressions

6. Joining Data from Multiple Tables in Queries

  • ANSI SQL 92 and SQL99 Joins
  • The JOIN Condition / The Cartesian Product
  • Outer JOINs

7. Group Functions and the GROUP BY Clause

  • Group Functions
  • Distinct Operator in Group Functions
  • GROUP BY, WITH Clause, ROLLUP, CUBE
  • GROUPING SETS

8. Using Subqueries

  • Single-Row, Multi-Row, Multi-Column Subqueries
  • Subqueries in a WHERE / FROM / HAVING Clauses
  • Subqueries In the SELECT Clause - Scalar Subqueries
  • Correlated Subqueries / Hierarchical Queries
  • EXISTS / NOT EXISTS / WITH / Recursive WITH

9. Data Manipulation Language (DML) Commands

  • INSERT, UPDATE, DELETE Command

10. Getting Data In And Out Of Oracle

  • SQL*Loader Basics
  • Importing Into Excel
  • Direct Database Queries Using ODBC

Labs

TOP
Viewing labs for:

Virtual Classroom Live Labs

Lab 1: RDBMS Principles

Lab 2: SQL*Plus Basics

Lab 3: SQL Developer

Lab 4: Insert, Update and Delete Data

Lab 5: SQL Queries

Lab 6: Filtering And Sorting Data

Lab 7: Number Functions

Lab 8: Character Functions

Lab 9: Date Functions

Lab 10: Misc. Functions

Lab 11: Joining Multiple Tables

Lab 12: ANSI SQL99 Joins

Lab 13: Group Clauses and Functions

Lab 14: Subqueries

Lab 15: SQL Loader

Who Should Attend

TOP

Anyone who needs to extract and organize information from an Oracle database, including formatting reports, adding, updating, and deleting data, and exporting data to ODBC files, including:

  • Application designers
  • Developers
  • Database administrators
  • End users
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 3 day

Request this course in a different delivery format.
Enroll