From the course: PostgreSQL Essential Training

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Challenge: Import data and write queries

Challenge: Import data and write queries - PostgreSQL Tutorial

From the course: PostgreSQL Essential Training

Start my 1-month free trial Buy for my team

Challenge: Import data and write queries

“

(upbeat music) - [Narrator] All right, let's apply some of your knowledge about querying data to another challenge. For this challenge, you're tasked with importing data to fill in two tables and then write a query against that new data. In the chapter four folder of the exercise files are two CSV files, one for the departments and one for the employees. Use these to fill data into the respective tables in the human resources schema of the KinetEco database that you created in the previous challenge. These are common CSV formatted files with a UTF8 encoding, column headers, and a comma-delimiter character. Once you've imported the data, write a query that shows all of the employees that work in the South building. I estimate that this task should take less than 10 minutes to complete. In the next video, I'm going to walk through the steps to arrive at the solution. Good luck.

Contents