Download sql File

I'm using PostgreSQL and here is my solution. Each table takes about a minute to import. You will need to know how to use Terminal, how to install software (in this case PostgreSQL), and how to start a service (the PostgreSQL server must be running). There are plenty of guides on the internet to get you started.

1. In Treehouse Playground, copy the entire table.
2. In your text editor, create a new file and save it as a CSV (e.g., books.csv). Paste your clipboard.
3. Do a find and replace to replace the tab stops with commas (tab stops look like an arrow in a text editor if you have show invisible characters turned on).
4. Start a postgres shell session and connect to the default database:

psql postgres

• Create a database called treehouse from the Postgres shell

CREATE DATABASE treehouse;

• Connect to the treehouse database from the Postgres shell:

\connect treehouse

• Create a books table from the Postgres shell:

CREATE TABLE books (id INT PRIMARY KEY, title TEXT, author TEXT, genre TEXT, first_published TEXT);

• Import your CSV:

COPY books (id, title, author, genre, first_published)
FROM '/Users/username/Desktop/books.csv' DELIMITER ',' CSV;

• Check to make sure it worked:

SELECT * FROM books;

Once you have your tables set up, you can use a GUI like pgAdmin to see your tables and run your queries.

Once I'm done with the course, I'll create a GitHub repo with the .sql files that do all these steps automatically and post the link on the first video of the course. With that said, knowing how to convert an HTML table to a SQL table is a good skill to have, since there is lots of tabular data on the internet.