Databases

Start here

Database tables designing tool: before you can start coding up a new app, you must consider its basic data relationships.

SQLtutor, a learn-by-doing tutorial giving you lots of practice making different kinds of raw SQL queries.

Books

• Seven Databases in Seven Weeks
• Beginning Database Design

SQL

• MySQL cheatsheet
• SQL course
• SQL via the Ruby Bastard’s book
• SQLZoo tutorial
• SQLite tutorial from Zetcode
• Dev Bootcamp’s SQLtutor, an awesome learn-by-doing tutorial giving you lots of practice making different kinds of raw SQL queries.
• “SQL Tutorial for beginners”: a comprehensive tutorial to MySQL databases (and learning SQL query language generally).

Understanding SQL join concepts

PostgreSQL

• PostgreSQL’s awesome documentation, a really important read, especially Chapter 1
• PostgreSQL exercises