Here are the files to go along with the Introduction to Oracle SQL videos:
- create user.sql – the script used to create the user on the database
- sample data.sql – creates and populates the tables
- viewing data.sql – SELECT, WHERE, and DISTINCT
- more operators.sql – IN, ANY, ALL, and BETWEEN
- order.sql – ORDER BY
- set operators.sql – UNION, UNION ALL, INTERSECT, and MINUS
- aggregate functions.sql – Aggregate functions (COUNT, SUM, AVG, MIN, MAX), GROUP BY, and HAVING
- aliases and joins.sql – Table aliases, column aliases, and joins
- functions.sql – String, number, and date functions
- subqueries.sql – Subqueries
- data edit.sql – INSERT, UPDATE, DELETE, COMMIT, and TRUNCATE
- table.sql – CREATE, ALTER, and DROP a table
You can download all of these SQL files in a single ZIP file here: intro_sql_scripts.zip.