rdb-intro: Introduction to Relational Database

On a schema very close to HR by Oracle DB

• https://github.com/oracle/db-sample-schemas

Tested on these DBMS

• MySQL 9
• Oracle DB 21c
• PostgreSQL 14
• SQLite 3
• H2 2

Database setup

• SQLite

  • Run setup.sql to (re)set data

• MySQL, Oracle, PostgreSQL

  • Run once once.sql as dba to create user/schema "hron"
  • Run setup.sql as "hron" to (re)set data

• H2

  • scripts: java -cp h2.jar org.h2.tools.RunScript -url jdbc:h2:./hron -script <script.sql>
    • run once.sql and then setup.sql
  • server: java -cp h2.jar org.h2.tools.Server -baseDir .