● 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:
<span class="hljs-built_in">mkdir</span> cassini
<span class="hljs-built_in">cd</span> cassini
<span class="hljs-built_in">mkdir</span> csvs
<span class="hljs-built_in">touch</span> csvs/import.sql
<span class="hljs-built_in">touch</span> 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:
<span class="hljs-built_in">head</span> -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.