Day 2 of 14 30 minCREATE TABLEData typesINSERT
Create your own database, design a table, choose the right data types and add your first rows.
By the end of today you can
- Create a database and connect to it
- Pick sensible data types for common kinds of data
- Create a table with a generated primary key and defaults
- Insert rows and see what was stored with RETURNING
What's inside
- 6 sections
- 2 diagrams and mind maps
- 5 code examples you can run
- 5-question quiz
- 1Create a database
- 2Data types: choosing the right box
- 3Design the books table
- 4Add some rows
- 5Look at your data
- 6Change the table later
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free