Managing Data(bases) using SQL


You are here: [Managing Data(bases) using SQL Downloads]

This section contains many downloadable files, mostly in pdf format. These documents are used and referred to in this course.

The pdf file below contains information on how to download and install Oracle Express Edition

Oracle Express for Windows Installation

The pdf file below contains information on how to download and install Oracle on Mac OS using a Virtual Machine

Oracle for Mac OS Installation

The pdf below contains information on how to install the Student Schema Database:

Install Student Schema

The text file below contains the script to run to install the student schema database:

student.txt

Entity Relationship Diagram for HR Schema

ERD HR Schema

Oracle Command Line Tool Instructions

Command Line Tool Instructions

Powerpoint Presentation Slides in pdf format

Powerpoint Presentation Class 1
Powerpoint Presentation Class 2
Powerpoint Presentation Class 3
Powerpoint Presentation Class 4
Powerpoint Presentation Class 5
Powerpoint Presentation Class 6
Powerpoint Presentation Class 7
Powerpoint Presentation Class 8
Powerpoint Presentation Class 9
Powerpoint Presentation Class 10

Below you find the SQL scripts used in the course reader examples by class

Course Reader Example Scripts Class 1
Course Reader Example Scripts Class 2
Course Reader Example Scripts Class 3
Course Reader Example Scripts Class 4
Course Reader Example Scripts Class 5
Course Reader Example Scripts Class 6
Course Reader Example Scripts Class 7
Course Reader Example Scripts Class 8
Course Reader Example Scripts Class 9
Course Reader Example Scripts Class 10