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.
- bookbiz.sql
Creates all Bookbiz tables. - symphony.sql
Creates all Symphony tables.
SQL*Plus (Accessing Oracle through the Command Line)
- Getting started with SQLPlus
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
Python/Oracle
- Python/Oracle Setup Instructions
- Documentation for Python's oracledb library
- A free, legal, limited version of Oracle for home can be found here (we haven't tested the tutorial using this, though)