MISSION 248

Loading and Extracting Data With Tables

Learn how to load and extract data with Postgres tables.

Objectives

  • Learn how to load data into Postgres tables
  • Learn how to extract Postgres data and clean it

Mission Outline

1. Prepared Insert
2. Faster Inserts
3. Advanced COPY Statement
4. Which method is faster?
5. Extracting Table to CSV File
6. Transform an Old Table to a New Table
7. Insert Into with Select
8. Next steps
9. Takeaways

postgres-for-data-engineers

Course Info:

Postgres for Data Engineers

Intermediate

The median completion time for this course is 5.2 hours.

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