My name is Dave Stanton

< Home

Creating the Database

2017-01-18

tl;dr

We will execute our SQL script to create tables, and then we will manually add records.

Video

Transcript

  1. Execute SQL to create tables
    1. Copy/paste 1-create-tables-sql
    2. Execute the script
    3. See tables
  2. Add some example data
    1. Create a card
    2. Create a card-set
    3. Create a card-set-card
  3. Export SQL as create statements
    1. Get card-set-card and save into 2-insert-records.sql
    2. Repeat for card-set
    3. Repeat for card
    4. Save

Next post in this series

Bootstrapping the Database