Relational Databases (WIP)

Purpose

Many of our projects use relational databases.

Learning Material

Basics

The PostgreSQL Tutorial provides a nice introduction to SQL and to Postgres. Sections 3.5 and 3.6 are less relevant.

The Django Documentation about Models provides a nice description of how the Django ORM relates to the underlying database.

Further Learning

This Stanford Course is a great place to learn databases in-depth, including the mathematical foundations of relational databases. There is too much information here for practical day-to-day usage, but if you have time time and inclination, this course lays a great foundation. Articles that provide a conceptual basis for how CSS works:

Exercises

No problems are written for this lesson yet.

Continuous Lesson Improvement

Please help us make these lessons as relevant and up-to-date for future engineers as possible!

You can help in several ways:

  • Shorten or clarify the writing. We're all busy and less is more.
  • Ask if the purpose of the lesson is unclear. We want all of the lessons to seem useful.
  • Remove exercises or learning material that aren't useful.
  • Add more exercises, exercise answers, or learning material as appropriate.

You can quickly open the lesson page in the GitHub editor. Create a new branch and pull request and assign it to David.