Tables you will be using:

City Jail ERD: City Jail ERD(pdf)

City Jail ERD: city Jail ERD image

Book file:

oracle_12c_sql

Scripts from book:

CityJail_8

JLDB_Drop (please don't run)


To login to Oracle Application Express:

  1. Go to https://apex.oracle.com/pls/apex/f?p=4550:1:110253740713061:::::
  2. Enter Workspace as provided below.
  3. Enter your username as provided .
  4. Enter your Password: password1
  5. IF you need to change your password, please just change it to password1 again. You can reuse passwords.
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 DDLpdf

1Z0-071 Large Data Sets

1Z0-071 Manipulating Data

1Z0-071 Oracle and Structured Query Language (SQL)

1Z0-071 Querying Multiple Tables

1Z0-071 Reporting Aggregates

1Z0-071 Restricting and Sorting Data

1Z0-071 Set Operations

1Z0-071 Single-Row Functions

1Z0-071 Subqueries

 

Exam link:

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-071