Oracle/SQL Tutorial

Contents

Module A

Introduction to SQL

Oracle/SQL

Correcting Errors in SQL*Plus

SQL Exercise 1 - Creating and Copying Tables

SQL Exercise 2 - Selection

SQL Exercise 3 - Projection

SQL Exercise 4 - Using Distinct

SQL Exercise 5 -Logical Operators -And and Or

SQL Exercise 6 - Conditional Operators

SQL Exercise 7 - Arithmetic Operators: +, -, /, *

SQL Exercise 8 - Group Functions

SQL Exercise 9 - Joins and Subqueries

SQL Queries in IS 331 Text - Chapter 10  

Module B

Creating Your Own Tables in ORACLE

The Use of Commit and Rollback

Changing Data - Insert, Update and Delete

Using Indexes

Altering Tables  

Dropping Tables

SQL*Plus Commands

Command Files

Creating Reports with SQL*Plus