Welcome to the VIP Page!
I’m glad you’re here.
This page contains all of the bonuses and guides that I’ve prepared for readers of this website or viewers of my YouTube channel.
I’ll keep it up to date, so whenever I have something new, I’ll add it to this page.
SQL JSON Cheat Sheets
A range of cheat sheets that list some common functionality and features for using JSON in an SQL Database.
SQL Pivot Cheat Sheets
A range of cheat sheets that list some common functionality and features for pivoting and unpivoting data in an SQL database.
SQL Function Cheat Sheets
A range of cheat sheets that list different functions and what they do in various databases.
SQL Boolean Cheat Sheet
A cheat sheet for implementing and using the boolean concept in SQL databases.
3 Examples of Database Normalisation
Three different examples of the database normalisation process, from start to finish.
Database Modelling Tools Spreadsheet
A spreadsheet that contains all of the database modelling tools in a filterable spreadsheet
Database Normalisation Checklist
A list of things to check to help you normalise your database design.
6 Examples of Joins
Examples of SQL queries that use joins to help you understand the concepts of joining tables.
Index Analysis Guide
A step-by-step guide on how to work out if each column in a query is suitable for an index.
Index Creation Flowchart
A flowchart to help you know when and what type of index to create.
Oracle Certified Associate Practice Questions (1Z0-071)
A set of practice questions for the Oracle Certified Associate exam.
SQL Editor Comparison List
A PDF that lists many SQL editors and how they compare to each other.
SQL Interview Questions and Answers
A PDF that lists many SQL interview questions and answers.
A PDF that contains the PL/SQL tutorial all in a single file.
SQL Best Practices & Style Guide
A PDF with a range of SQL best practices and style tips.
Time Saver Guide
A PDF checklist to help you find time to learn during your week.
Oracle How-To Kit
A collection of SQL scripts for achieving different results in an Oracle database.
Useful Data Dictionary Queries
A collection of SQL queries that are useful to find information from the data dictionary.
Constraints SQL Queries
A collection of SQL queries for constraints with examples.
Subquery SQL Queries
A collection of SQL queries for subqueries with examples.
Introduction to Oracle SQL scripts
A collection of SQL scripts used in the Introduction to Oracle SQL series.
- 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.