All resourcesGuidesCoursesTips

Database best practices

Databases 101

11 lessons, 26 minutes

Practice with best practices

 In your companion doc, you’ll create a quick to-do list:
  1. Add a new page and title it Backend
  2. Type “/table” on this new page and name it Tasks
  3. Set the table up to have the following columns
    1. Task Name (this should be your display column)
    2. Due date (change the column type to date)
    3. Owner (this could be a text column type, but it really gets exciting if you make it a people type)
    4. Done (change the column type to a checkbox or toggle)
    5. Priority (change to a scale column type)
  5. Add some tasks
  6. Go back to the best practice page and type “/Tasks” to create a view of your Tasks table
  7. Name the view Incomplete Tasks and filter this view to show only incomplete tasks

UP NEXT

One Big Table

Learn about the most common database pattern.

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.

11 lessons, 26 minutes total

1

Welcome to Databases 101

0:52

2

Importing data

1:20

Database best practices

3:15

4

One Big Table

2:16

5

Web

2:37

6

Extraction

1:58

7

Summarize

3:25

8

Bidirectional

1:44

9

Shifting to a database model

4:19

10

How to reference a row

1:19

11

Evolution of a database

3:07

Was this helpful?

YesNo