The links below provide scripts and other files that are part of a
series of videos on YouTube.
There is a video series for SQL fundamentals and a series for
advanced SQL commands. To see the videos, go to YouTube and
query "kreie oracle sql" or, for examples using SQL Server, query
Used in the SQL Fundamentals and
SQL Advanced video series.
SQL scripts - These are zipped
files that contain CREATE, INSERT and DROP scripts for the SQL
Fundamentals and Advanced video series.
Oracle sample database: Human
Resources. This is used in the SQL Fundamentals and Advanced
SQL Fundamentals - Self-Joins: S cript
to create the example EMPLOYEE table.
SQL Advanced - Zipped file for the
APEX (Application Express)
This is a video series on YouTube that shows some of the features
in APEX, including building tables, importing data, creating
applications with forms and reports. Query for "kreie apex