sql-webinar-materials

Collection of materials + Python scripts used to set up the webinar "Spend Less Time in Spreadsheets with SQL"

Overview

Did you know I set up the relational database for this webinar using Python? Here's the script showing how I did this.

Steps include:

• Getting data from an API
• Converting the results to a CSV
• Converting the CSV to a SQLite database

Included here

• Python script detailing steps to setting up the database
• Final SQLite database to explore the list of open job postings with nyc.gov