● videoExtraction
Creating Our Workspace

Unlock PostgreSQL Fundamentals
2 hours of SQL video using NASA's Cassini data. See why developers become data pros.
SECTION
Extraction
NEXT UP
Importing the Master Plan
COURSE
PostgreSQL Fundamentals
28 lessons
About this lesson
We need to setup our dev environment (quickly) with a few bash commands:
mkdir cassini
cd cassini
mkdir csvs
touch csvs/import.sql
touch README.md
createdb cassini
These commands will create our working directories and, most importantly, a document where we can log what we've done and why we did it. That's really important for our future selves and teammates.
To pull out the names of the columns in our CSV we use the head command:
head -1 csvs/master_plan.csv
This will display the first row of our CSV.
Unlock PostgreSQL Fundamentals
2 hours of SQL video using NASA's Cassini data. See why developers become data pros.