Tables you will be using:
City Jail ERD: City Jail ERD(pdf)
City Jail ERD: city Jail ERD image
Book file:
Scripts from book:
JLDB_Drop (please don't run)
To login to Oracle Application Express:
User | password | workspace |
A.AUSTIN | password1 | BCSQL |
ALVAJ80 | password1 | BCSQL |
BENNC21 | password1 | BCSQL |
CRAIGJS | password1 | BCSQL |
CUBIJS | password1 | BCSQL |
DUPOCQ | password1 | BCSQL |
FLORA7 | password1 | BCSQL |
FULMTJ | password1 | BCSQL |
GRATDN | password1 | BCSQL |
GRAYK2 | password1 | BCSQL |
GUERD18 | password1 | BCSQL |
HARID | password1 | BCSQL |
HERRD15 | password1 | BCSQL |
JENKS5 | password1 | BCSQL |
JOHNSD2 | password1 | BCSQL |
JOSED66 | password1 | BCSQL |
KANTJE | password1 | BCSQL |
MINEWJ | password1 | BCSQL |
MOUBMI | password1 | BCSQL |
MSIMJ | password1 | BCSQL |
NORAW | password1 | BCSQL |
PADROY1 | password1 | BCSQL |
PEINJM | password1 | BCSQL |
R.TORRES | password1 | BCSQL |
REYNOY | password1 | BCSQL |
RICKK | password1 | BCSQL |
RILERB | password1 | BCSQL |
SANCA31 | password1 | BCSQL |
SERRFA1 | password1 | BCSQL |
STUAT1 | password1 | BCSQL |
VILSJS | password1 | BCSQL |
WILLS7 | password1 | BCSQL |
cjfatty | password1 | BCSQL |
Test prep questions:
1Z0-071 Conversion and Conditional Functions
1Z0-071 Oracle and Structured Query Language (SQL)
1Z0-071 Querying Multiple Tables
1Z0-071 Restricting and Sorting Data
Exam link: