MISSION 246

Creating Tables

Learn how to create tables with proper data types in Postgres.

Objectives

  • Learn how to create a table in Postgres.
  • Learn about using proper datatypes for your data.

Mission Outline

1. Describing a Table
2. Adding the id Field
3. Finding the Max Length
4. Max String-like Datatypes
5. Creating the Other String Fields
6. Float-like Types
7. Boolean Types
8. Date Type
9. Next steps
10. Takeaways

postgres-for-data-engineers

Course Info:

Intermediate

The median completion time for this course is 5.2 hours. View Details

This course requires a premium subscription. This course includes five missions, one installation tutorial and one guided project.  It is the first course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside