Skip to content

README.md

Latest commit

 

History

History
32 lines (21 loc) · 2.6 KB

README.md

File metadata and controls

32 lines (21 loc) · 2.6 KB

Reading Material Databases Week 2

Agenda

These are the topics for week 2:

  1. Identifiers (Primary key, Foreign key, Composite key)
  2. Relationships (One-to-One, One-to-Many, Many-to-Many)
  3. SQL clauses
    • Joins
    • Aggregate functions
    • Distinct
    • Group By
    • Have
  4. Indexes
  5. Domain modeling

Week goals

This week we are going to start diving deeper into SQL and how to structure your tables. Let's start by looking into identifiers that allow you to add constraints to your database here. After that, let's look into relationships between tables. There are three types of relationships (one-to-one, one-to-many and many-to-many), read about when to use them over here.

Next we will look at more complex SQL commands that will be needed now that the table structures are getting more complicated. Let's look into the advanced sql commands and when to use them here.

With more complex and bigger databases performance can become a problem. To help you solve this, you can configure your database in such a way to speed up specific queries using Indexes. Finally, with all of these relationships between multiple tables it can become a little hard to keep track. To help visualise your databases we generally use what is called an Entity Relationship Diagram, read all about them here.

Bonus: We have a bonus video here of one of our mentors (@Unmesh on slack! Thank him if you found it useful) going through a practical example of how to deal with the asynchronicity of working with databases.

Bonus 2: A second bonus video here that goes through some of the topics of this week: keys, relationships and joins. Again it is @Unmesh on slack, a thanks if this helped you is much appreciated!

Finished?

Are you finished with going through the materials? High five! If you feel ready to get practical, click here.