Relational Databases

Purpose

Many of our projects use relational databases.

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

Open the lesson page in the GitHub editor.

Remove any exercises or learning material that are not useful to the intended audience. Find ways to shorten and clarify the writing. Add generally useful exercises, responses, or learning material. Your improvements will make our training program great!

Create a new branch and pull request and assign it to your lesson mentor. The available lesson mentors are included in the YAML front matter of the lesson. They will set up a time to review your suggested changes and to talk through your exercises for the lesson.

After the review add your self to the "completed" property in the lesson's YAML front matter and merge in your changes!