FB

MySQL

MySQL is a free SQL database. It’s common with beginners and developers working on small projects, but is also used by large companies to run their systems.

Note: more content will be added to this page soon!

Getting Started

A range of articles and other resources to get you started with MySQL

e

59 Best Resources for Learning SQL

This article lists 59 of the best places to learn SQL.

Read More

j

PostgreSQL vs MySQL

An analysis of the differences between PostgreSQL and MySQL.

Read More

19 Best Database Books

Here’s my list of 19 of the best database-related books.

Read More

SQL Roadmap

Understand the topics to learn for SQL and databases, from the very beginning to advanced topics.

Read More

SQL Keywords

A list of definitive guides on many of the SQL keywords.

:

SELECT

Read data from the database

Read More

L

CREATE TABLE

Create a new table on the database.

Read More

U

WHERE Clause

Filter your query based on criteria.

Read More

/

JOINs

Connect two tables together in a query.

Read More

1

CASE

Use conditional logic in a query.

Read More

;

INSERT

Add new data into a table.

Read More

/

ALTER TABLE

Modify an existing table.

Read More

*

ORDER BY

Sort the results of your query.

Read More

a

DISTINCT

Eliminate duplicate results from your query.

Read More

=

UPDATE

Modify data already in a table.

Read More

K

DROP TABLE

Delete a table.

Read More

.

GROUP BY and HAVING

Group your results and filter them.

Read More

Operators

Perform calculations and operations on data.

Read More

<

DELETE

Delete data from a table.

Read More

O

TRUNCATE

Remove all data from a table.

Read More

f

WHERE vs HAVING

The difference between WHERE and HAVING.

Read More

>

Set Operators

Combine results from two queries into one.

Read More

Further Learning: Objects

Learn all about the different objects available in MySQL.

Keys

A guide to database keys (surrogate, natural, composite & more).

Read More

b

Database Schema

An explanation of what a database schema is.

Read More

l

Stored Procedures

A guide to stored procedures in SQL.

Read More

o

Temp Tables

An explanation of what a temp table is and how to create one.

Read More

Views and Materialized Views

A guide to views and materialised views in SQL.

Read More

Further Learning

More features and topics in SQL Server.

u

Interview Questions and Answers

A list of 69 interview questions and answers, plus interview tips.

Read More

w

Subqueries

A guide to subqueries, what they are and many different examples.

Read More

Transactions and Isolation Levels

An explanation of transactions in SQL and what isolation levels are.

Read More

Wildcards

An explanation of what wildcards are and how to use them.

Read More

Database Version Control, CI, and CD

An in-depth guide on database version control, continuous integration, and continuous deployment.

Read More

d

DDL, DML, and TCL

A list of SQL commands and what DDL, DML, and TCL mean.

Read More

e

Limiting Results

A guide to SQL row limiting and Top-N queries.

Read More

L

Concatenate

What concatenation is and how to do it in SQL.

Read More

K

NULL

A guide on what NULL is and how to handle them in SQL.

Read More

{

Comments

A guide to comments in SQL and why they can help.

Read More

|

Aliases

A guide to column aliases and table aliases in SQL.

Read More

CTE (WITH Clause)

A guide to Common Table Expressions (CTEs) aka the WITH clause.

Read More

Z

Booleans

How SQL handles booleans and how you can implement them.

Read More

Data Warehouses

A in-depth guide to data warehouses.

Read More

Data Types

A guide to data types in many different databases.

Read More

How To

A collection of articles detailing how to do common tasks in SQL queries.

`

Escape Single Quotes

How to escape single quotes in SQL.

Read More

Tools

A list of guides and collations of different tools for database developers and administrators.

d

42 ETL Tools

A list of 42 different ETL tools.

Read More

Get Your SQL Cheat Sheets Now:

Want Some SQL Cheat Sheets?

sql-cheat-sheet-images-v2

Download the SQL Cheat Sheets: common commands and syntax - to save you time.

You'll get them for Oracle, SQL Server, MySQL, and PostgreSQL.

Print them or use them as an easy reference.