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 5CI017, 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 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
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

---

Please note the workbook is currently under construction so not fully completed yet. In the meantime an electronic copy of the paper version is usually available in your WOLF topic.