Databases Topics

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 "MEC SQL."

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 video series.

SQL Fundamentals - Self-Joins: S cript to create the example EMPLOYEE table. 

SQL Advanced - Zipped file for the DIVISION example.


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 oracle."