Database (Tutorials and CheatSheet)

This is a series of tutorials on how to use relational databases and the SQL database query language. We are using a Postgres database although the concepts apply generally to relational databases. All the concepts are included in the corresponding Database CheatSheet.

CheatSheet: Free web version | Desktop version: for Mac or Windows to create or modify your own CheatSheets.

Link to Postgres Database tutorial page

Postgres Database

The first step is to download and install a Relational Database. We will use Postgres. We will also install the Postgres Admin GUI interface, and the PSQL Shell.

Open CheatSheet

Link to SQL Syntax tutorial page

SQL Syntax

In this section we go over SQL syntax. We also discuss how to use the PG Admin tool to interact with the Postgres database.

Open CheatSheet

Link to Data Types tutorial page

Data Types

In this section we go over data types. When creating a table in your database, you add columns. Every column must include a name and a data type. The datatype determines what type of data can be inserted in that column. We also go over how to use the PG Admin tool for accessing the database.

Open CheatSheet

Link to Create Tables tutorial page

Create Tables

In this section we finish how to create tables. Specifically we cover adding default values and constraints to our tables. It includes adding primary keys and indexes. Finally, we cover table associations and foreign key constraints.

Open CheatSheet

Link to Modify Data tutorial page

Modify Data

In this section we go over modification queries for creating rows, updating rows, and deleting rows.

Open CheatSheet

Link to Query Data tutorial page

Query Data

In this section we go over read queries on the database.

Open CheatSheet

Link to Joins tutorial page

Joins

In this section we go Join queries. Joins allow you to pull data from two or more associated tables in one query.

Open CheatSheet

Link to Bookstore Example tutorial page

Bookstore Example

This is a summary of the steps taken throughout the tutorial series to build the bookstore database. Follow the steps to rebuild the database, repeating it until you are comfortable with the process.

Open CheatSheet