ISQL: Introduction to SQL

Modules

Hide all

RELATIONAL DATABASE CONCEPTS (6 topics)

• What is an Oracle Database
• Relational Database Structures
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Supported Datatypes
• The Data Dictionary

USING SQL*PLUS (5 topics)

• What is SQL*Plus
• Getting Started
• Entering and Executing SQL Statements
• Editing SQL Statements
• Creating, Editing and Executing SQL Files

USING SQL DEVELOPER (6 topics)

• What is Oracle SQL Developer
• Starting SQL Developer
• Configure a Connection
• Navigation Tabs
• SQL Worksheet
• Query Builder

RETRIEVING DATA WITH THE SELECT STATEMENT (9 topics)

• The SELECT Statement
• The SELECT and FROM Clauses
• Conditions and the WHERE Clause
• Other Conditional Operators
• Logical Operators
• The ORDER BY Clause
• Column Aliases
• Arithmetic Expressions
• Precedence of Operators

AGGREGATE FUNCTIONS (10 topics)

• Overview of Built In Aggregate Functions
• The GROUP BY Clause
• The HAVING Clause
• Session 6: JOINING TABLES
• Overview of Table Joins
• Inner Joins
• Table Aliases
• Outer Joins
• Self Joins
• ANSI Standard Joins

BASIC SUBQUERIES AND SET OPERATORS (4 topics)

• Overview of Subqueries
• Basic Subqueries
• Set Operators
• The Union,Intersect and Minus Operators