All resourcesGuidesCourses

Database patterns

Databases 101

8 lessons, 34 minutes

Practice with patterns

 In your companion doc:
  1. Create another view of your Tasks table (type “/tasks”)
  2. Add a column called Team
  3. Make it a Relation column, create a new table when prompted and put that table below your newly create View of Tasks
  4. Add some teams in your Team table
  5. In your View of Tasks table, assign some teams to tasks
  6. Back in your Team table, used a Linked Relation column to pull in the tasks assigned to each team.
  7. Count those tasks in another column in your Team table.

UP NEXT

Shifting to a database model

We all develop habits based on the tools we learn first, and sometimes it’s challenging to develop new habits. In this video, we’ll walk through how to make the change to a database model so you can leverage all of its superpowers.

Next lesson

Databases 101

Databases make your data accessible in different ways. In this course, you’ll learn all about how Coda docs help you view your data where, and how, you want.

8 lessons, 34 minutes total

1

Welcome to Databases 101

1:03

2

What is a database?

6:52

3

Tip: Importing data

1:20

4

Database best practices

5:28

Database patterns

6:23

6

Shifting to a database model

8:39

7

Troubleshooting databases

3:27

8

Tip: How to reference a row

1:19