Converting a Dataset

45 minutes
  • 3 Learning Objectives

About this Hands-on Lab

In this hands-on lab, students will be provided with multiple formats of the same dataset, and be asked to convert between them.

Learning Objectives

Successfully complete this lab by achieving the following learning objectives:

Convert the CSV File to a PostgreSQL Table
  1. Load the CSV file to a postgres table using the COPY command.
Convert from a PostgreSQL Table to CSV
  1. Make an update to the PostgreSQL table and convert to a CSV file using the COPY command.
Convert JSON to CSV
  1. Convert a JSON file to CSV format using the jq JSON query client.

Additional Resources

In this hands-on lab, you will need to convert a CSV file to a PostgreSQL database table, and back to a CSV file using the copy command. The demo data will be downloaded to the /tmp directory, but you can also access it here: demo.csv demo.json

  • Database name: convert
  • Database user: postgres
  • Datbase table: users

What are Hands-on Labs

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Get Started
Who’s going to be learning?