FB

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.

Cheat Sheets

SQL Cheat Sheets

A range of cheat sheets that describe common features, keywords, and functions within SQL.

Download:

SQL Data Types Cheat Sheets

A range of cheat sheets that list all data types available in different databases and what they are used for.

Download:

SQL JSON Cheat Sheets

A range of cheat sheets that list some common functionality and features for using JSON in an SQL Database.

Download:

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.

Download:

SQL Function Cheat Sheets

A range of cheat sheets that list different functions and what they do in various databases.

Download:

SQL Editor Cheat Sheets

A range of cheat sheets that list different features and shortcuts for various SQL editors.

Download:

SQL Boolean Cheat Sheet

A cheat sheet for implementing and using the boolean concept in SQL databases.

Download

PDF Guides

3 Examples of Database Normalisation

Three different examples of the database normalisation process, from start to finish.

Download

Database Modelling Tools Spreadsheet

A spreadsheet that contains all of the database modelling tools in a filterable spreadsheet

Download

Database Normalisation Checklist

A list of things to check to help you normalise your database design.

Download

6 Examples of Joins

Examples of SQL queries that use joins to help you understand the concepts of joining tables.

Download

Index Analysis Guide

A step-by-step guide on how to work out if each column in a query is suitable for an index.

Download

Index Creation Flowchart

A flowchart to help you know when and what type of index to create.

Download

Execution Plan Guide

A range of guides to execution plans for different databases, to help you understand the terminology and when they are used.

Download:

Database Design Guides

A range of database design guides for different domains: an ERD, table and column definitions, and SQL scripts.

Download:

Oracle Certified Associate Practice Questions (1Z0-071)

A set of practice questions for the Oracle Certified Associate exam.

Download

SQL Editor Comparison List

A PDF that lists many SQL editors and how they compare to each other.

Download

SQL Interview Questions and Answers

A PDF that lists many SQL interview questions and answers.

Download

PL/SQL Tutorial

A PDF that contains the PL/SQL tutorial all in a single file.

Download

SQL Best Practices & Style Guide

A PDF with a range of SQL best practices and style tips.

Download

Time Saver Guide

A PDF checklist to help you find time to learn during your week.

Download

PDF of Posts

A range of PDF versions for different blog posts.

Download:

Scripts

Oracle How-To Kit

A collection of SQL scripts for achieving different results in an Oracle database.

Download

Useful Data Dictionary Queries

A collection of SQL queries that are useful to find information from the data dictionary.

Download:

Constraints SQL Queries

A collection of SQL queries for constraints with examples.

Download

Subquery SQL Queries

A collection of SQL queries for subqueries with examples.

Download

Introduction to Oracle SQL scripts

A collection of SQL scripts used in the Introduction to Oracle SQL series.

Download:

You can download all of these SQL files in a single ZIP file here: intro_sql_scripts.zip.