Oracle Database 10g: Introduction To SQL - Part I

This course has been superseded

We suggest the following instead:
Oracle Database - SQL I Introduction

Course Description

This course is a common starting point for Oracle database administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.
3 Days
Contact us for pricing
 

Prerequisites

No mandatory prerequisites

RELATIONAL DATABASES & SQL

ABOUT RELATIONAL DATABASES
ELEMENTS OF SQL

USING SQL*PLUS

ABOUT SQL*PLUS
USING THE MS WINDOWS SQL*PLUS TOOL
USING THE ISQL*PLUS WEB TOOL
ENTERING COMMANDS & SYNTAX

BUILDING A SELECT STATEMENT

ABOUT THE SELECT STATEMENT
SELECTING COLUMNS
USING ALIAS NAMES

BUILDING A WHERE CLAUSE

ABOUT LOGICAL OPERATORS
EQUALITY OPERATOR
BOOLEAN OPERATORS
NULL & BETWEEN OPERATORS
FINDING TEXT STRINGS
IN OPERATOR

ORDERING THE RESULT TABLE

ABOUT THE ORDER BY CLAUSE
MULTIPLE COLUMN SORTS
SPECIFYING THE SORT SEQUENCE
ABOUT NULL VALUES WITHIN SORTS
USING COLUMN ALIASES

PSEUDO COLUMNS & FUNCTIONS

ABOUT PSEUDO COLUMNS & FUNCTIONS
USING ROWID
USING ROWNUM
USING THE FUNCTIONS
USING THE DUAL TABLE
SESSIONTIMEZONE FUNCTION

JOINING TABLES

ABOUT JOINS
INNER JOIN
REFLEXIVE JOIN
NON-KEY JOIN
OUTER JOIN

USING SET OPERATORS

ABOUT THE SET OPERATORS
SET OPERATOR EXAMPLES

SUMMARY FUNCTIONS

ABOUT SUMMARY FUNCTIONS
SUMMARY FUNCTIONS WITH DISTINCT

USING SUBQUERIES

ABOUT SUBQUERIES
STANDARD SUBQUERIES
CORRELATED SUBQUERIES

CREATING & SELECTING GROUPS

ABOUT SUMMARY GROUPS
FINDING GROUPS WITHIN THE BASE TABLES
SELECTING DATA FROM THE BASE TABLES
SELECTING GROUPS FROM THE RESULT TABLE

SQL*PLUS COMMANDS

ABOUT SQL*PLUS COMMANDS
MORE ABOUT SCRIPT FILES
INVOKING OPERATING SYSTEM COMMANDS
SAVING SESSION OUTPUT

BUILD SIMPLE SQL*PLUS REPORTS

ABOUT THE SQL*PLUS REPORT FEATURES
SESSION OUTPUT WITH SET
FORMAT COLUMN OUTPUT WITH COLUMN
DEFINING REPORT BREAKS WITH BREAK
PRODUCE SUBTOTALS WITH COMPUTE

SQL DATA DEFINITION LANGUAGE

ABOUT SQL DDL
CREATE TABLE STATEMENT
ALTER TABLE STATEMENT
DROP TABLE STATEMENT
SUPPORTIVE STATEMENTS

SQL DATA MANIPULATION LANGUAGE

ABOUT SQL DML
ABOUT THE INSERT STATEMENT
ABOUT THE DELETE STATEMENT
ABOUT THE UPDATE STATEMENT
ABOUT TRANSACTIONS
TRUNCATE TABLE
COMPLEX TABLE REFERENCES
OracleOracle 10gOracle Database 10g