SQL Scripts
You can run these scripts in SQL*Plus to populate the database with some data so you can practice your SQL queries. Some of these scripts are also used in your tutorials.
- all.sql
This script will add a bunch of tables and data into your database.
Warning: these scripts will delete any tables that you have that are named student, faculty, class, emp, works, dept, flights, aircraft, certified, employees, suppliers, parts, catalog, sailors, reserves, boats, movie, starsin and, moviestar. If you do not have such tables, it will complain that such tables don't exist, but it'll work just fine. - all_MySQL.sql
The MySQL equivalent of all.sql. - bookbiz.sql
Creates tables for a bookshop scenario and populates the tables with data. - mvb_create_tables.sql
Creates Motor Vehicle Branch tables. - mvb_drop_tables.sql
Drops Motor Vehicle Branch tables. - mvb_insert_rows.sql
Populates (loads data into) the Motor Vehicle Branch tables. - sql-clicker-scripts.zip
Scripts for most clicker questions. May not be exactly what you see in class, but you can always create your own.
SQL*Plus (Accessing Oracle through the Command Line)
- Guide for: SSH, SQLPlus, SCP, and text editing on the server [PDF]
- Getting started with SQLPlus
- Troubleshooting
Please note that your accounts will be deleted at the end of the term, so do not plan to use this as a permanent way to showcase your work!
Oracle VS Code Extension
DataGrip (a DBA Tool)
Term Project
PHP/Oracle
Javascript/Node.js/Oracle
Java/Oracle (Deprecated September 2024)
- Getting started. Video of these instructions
- Looking through the code
- Extra Information on Working with ResultSet
- Miscellaneous Topics
- Troubleshooting
Postgres and Node.js (not supported by the course staff)
Oracle Information
- Oracle Reference
- Oracle Date Functions (PDF)
- A free, legal, limited version of Oracle for home can be found here (we haven't tested the tutorial using this, though)