1. Introduction to the Emp-dept case study

Worksheet Overview

The employee - department -salgrade database is a classic teaching example, originating in early Oracle training where it was known as the Scott/Tiger example, after the username and password of the creator. It is used here as the basis of an introductory tutorial.

If you would like to create your own version of the database, you can use these SQL statements to create the tables and load the data.


1. Read: Application familiarisation
2. Read: Database tables
3. Read: DBMS
4. Task: Sandbox
5. Demo: To list the tables in a database
6. Demo: To view the definition of a table.
7. Task: View the structure of the Department table (dept)
8. Task: View the structure of the Salary Grade table (salgrade)
9. Read: Completed

Related worksheets

2. Some simple SQL Select statements
3. Using Functions
4. Selecting ROWS to display
5. Multiple tables
6. Summarising and Grouping
7. Handling Dates
8. Inner and Outer Joins