9  ❔ Structured Query Language (SQL)

Skill Level: ★ Beginner — ★★ Intermediate — ★★★ Advanced

9.1 Learn SQL

9.1.0.1 SQL Tutorial - Tutorial ★

A self-paced tutorial, by w3schools, that walks through basic SQL commands

9.1.0.2 SQL Keywords Reference - Reference ★

A quick reference list of the reserved words in SQL

9.1.0.3 SQLZoo Tutorial - Tutorial ★

A step by step tutorial reviewing the basics of SQL queries

9.1.0.4 Practical SQL, 2nd Edition - Book ★

An approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases

9.1.0.5 Learn SQL - Course ★

A free self-paced course, developed by codecademy, which demonstrates how to manage large datasets and analyze real data using standard data management language

9.1.0.6 SQLBolt: Introduction to SQL - Course ★

A series of interactive lessons and exercises designed to help you quickly learn SQL in your browser

9.1.0.7 SQL join flavors - Article ★★

An article that explores various types of SQL joins, including helpful visualizations for each

9.1.0.8 SQL for the Weary - Tutorial ★★

A tutorial with notes and working examples for various SQL and database functions

9.1.0.9 SQL Style Guide - Reference ★

A SQL syntax guide designed to be compatible with Joe Celko’s SQL Programming Style book

9.2 Helpful Tools

9.2.0.1 SQL Polyglot - Tool ★★

A browser-based tool for checking if a particular SQL feature is supported in various database systems