Database Star VIP Page
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:
Download SQL File Version of Cheat Sheet:
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:
- pgAdmin Cheat Sheet
- DBeaver Cheat Sheet
- Oracle SQL Developer Quick Start Guide
- Oracle SQL Developer Keyboard Shortcuts
- Oracle SQL Developer Time Saver Guide
- SQL Server in VS Code Cheat Sheet
SQL Boolean Cheat Sheet
A cheat sheet for implementing and using the boolean concept in SQL databases.
Docker Database Cheat Sheet
A cheat sheet for remembering the Docker commands for working with database images and containers.
PDF Guides
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.
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:
- AirBNB
- eCommerce website
- Train booking system
- Hotel booking system
- Online course system
- eCommerce Products (and the SQL scripts are here)
- Movie theatre booking (and the SQL scripts are here)
- Flight Booking database
- Doctor Clinic database
SQL Project Guides
A PDF and SQL scripts to help you create a database based on a real website (as demonstrated in a YouTube video).
IMDb Database:
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.
PL/SQL Tutorial
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.
SSMS Quick Reference Guide
A PDF guide with a range of shortcuts and tips for working with SSMS (SQL Server Management Studio).
SQL Editor Timesaver Guides
A range of PDF guides with tips to help you save time working with specific SQL editors.
Data Analysis Project Guides
A PDF to help you prepare the data, with a list of questions, and Select queries to answer those questions.
- Population Analysis (from this YouTube video)
- Car Sales Analysis (from this YouTube video)
- Olist eCommerce
- NBA Game Analysis
PDF of Posts
A range of PDF versions for different blog posts.
Download:
- Oracle JSON Guide
- SQL Server JSON Guide
- MySQL JSON Guide
- Postgres JSON Guide (coming soon)
SQL Roadmap
A diagram that shows the beginner, intermediate, and advanced level SQL and database concepts to learn on your SQL journey.
5 Steps to Write SQL
An overview of the 5 steps I recommend following to go from a business problem to a working SQL query.
EAV Design & Alternatives
A guide to the Entity Attribute Value design, five alternative designs, and pros and cons of each.
SQL Timezone Cheat Sheet
A cheat sheet that shows the data types and functions to best handle timezones in Oracle, SQL Server, MySQL, and Postgres.
Scripts
Calendar Table
A collection of SQL scripts for creating a calendar table, to help you report on dates and to simplify your date logic.
Download:
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.
Download:
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.
Download:
- 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.