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

Course Info:

Postgres for Data Engineers

Intermediate

The average completion time for this course is 10-hours.

This course requires a premium subscription. This course includes 1 free mission, 4 paid missions, 1 installation tutorial and 1 guided project.  It is the 1st course in the Data Engineer path.

START LEARNING FREE

Take a Look Inside

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit