Skip to content

Instantly share code, notes, and snippets.

@johnptmcdonald

johnptmcdonald/module-025-Databases-SQL.md

Last active April 9, 2019 17:29
Show Gist options
  • Save johnptmcdonald/7b942a72b1ad809ebb9c16349bd7430c to your computer and use it in GitHub Desktop.
Save johnptmcdonald/7b942a72b1ad809ebb9c16349bd7430c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
module-025-Databases-SQL.md

Databases and SQL

Needs Statement

Relational databases are the dominant way to store large amounts of data. Students need to understand why databases are necessary in order to efficiently build a full stack application. SQL is the standard language used for managing and performing operations on relational databases.

Objective

Students will be able to set up a postgres server on their local machine, then create a database and interact with it using SQL. Students will understand the use of schemas to organise database objects into logical groups.

Prework

Pre-reading

Pre-tutorial

In-class

Instructor Demo

The instructor will demonstrate SQL using the imdb.sqlite database and the SQL walkthrough on learndot linked below. Specifically, the instructor should cover

Tutorial

Homework

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment