View Detailed Profile
APEX03 of 30: Use SQL Workshop to run scripts of SQL commands

APEX03 of 30: Use SQL Workshop to run scripts of SQL commands

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX03.DB01: Import a data model (data dictionary) with SQL Developer

APEX03.DB01: Import a data model (data dictionary) with SQL Developer

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX03.SQL01:  SQL commands to create tables, constraints, sequences, and triggers

APEX03.SQL01: SQL commands to create tables, constraints, sequences, and triggers

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX03.DB03: Relational database concepts and terms: primary, foreign and surrogate keys

APEX03.DB03: Relational database concepts and terms: primary, foreign and surrogate keys

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX04 of 30: Use SQL Workshop in APEX to run scripts that insert data into tables.

APEX04 of 30: Use SQL Workshop in APEX to run scripts that insert data into tables.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX23.SQL01: SQL command that creates a view (stored query, dynamic table)

APEX23.SQL01: SQL command that creates a view (stored query, dynamic table)

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX25 of 30: Switch page to modal setting.  Set page width.  Write SQL for a list of values (LOV).

APEX25 of 30: Switch page to modal setting. Set page width. Write SQL for a list of values (LOV).

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX17 of 30:  Use UPDATE to clean data.  Add a unary relationship to a table.  Remove a column.

APEX17 of 30: Use UPDATE to clean data. Add a unary relationship to a table. Remove a column.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX29 of 30: Two tables used twice in a view.  Why?  Copy an application & modify the menu.

APEX29 of 30: Two tables used twice in a view. Why? Copy an application & modify the menu.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX30 of 30: Development, production and public applications were created in this video series.

APEX30 of 30: Development, production and public applications were created in this video series.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX12 of 30: SQL code to concatenate display columns in a dynamic LOV.  APEX does LOV SQL code

APEX12 of 30: SQL code to concatenate display columns in a dynamic LOV. APEX does LOV SQL code

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files