Oracle Workbook

Main Page >> Oracle and SQL >> Workbook

Welcome to the Online Teaching/Learning Resources for Oracle and SQL

This workbook is aimed at students studying their first database module, such as 5CI022, or 7CI006, or as a reminder of how to use Oracle and SQL for advanced database modules.

Section 1	1.1 Introduction 1.2 Getting Started using SQL*Plus 1.2.1 Register for an account 1.2.2 Installing SQL*Plus 1.2.3 Using SQL*Plus 1.2.3 Setting up the sample database 1.2.4 Initial queries 1.3 SQL Overview 1.3.1 Setting Environment Variables 1.3.2 How to edit 1.3.3 Getting information from a table 1.3.4 Quitting Oracle 1.3.5 Getting Help and Summary
Section 2	2.1 Saving query output 2.2 Saving and retrieving queries 2.3 Login.sql
Section 3	3.1 Data Manipulation Commands (DML) 3.1.1 SELECT 3.1.2 INSERT and COMMIT/ROLLBACK 3.1.3 DELETE 3.1.4 UPDATE 3.2 Data Definition Commands (DDL) 3.2.1 CREATE TABLE 3.2.2 DROP TABLE 3.3.3 ALTER TABLE
Section 4	4.1 Joining Tables 4.1.1 Basic Join conditions 4.1.2 Recursive joins 4.1.3 Outer joins
Section 5	5.1 Arithmetic operators, Group BY, Subqueries and Functions 5.1.1 Arithmetic operators 5.1.2 Group functions 5.1.3 Subqueries 5.1.4 Date functions 5.5.5 Character functions
Section 6	6.1 Miscellaneous Features 6.1.1 Control commands 6.1.2 Substitution Variables 6.1.3 Views 6.1.4 Indexing Tables 6.1.5 Data Dictionary
Section 7	7.1 Advanced Features 7.1.1 Database Triggers 7.1.2 Database Procedures
Reference Material	Sample Data Set Set up code ER Diagram Using Oracle from home
Exercise Answers	Section 1 Exercises Section 2 Exercises Section 3 Exercises Section 5 Exercises Section 6 Exercises