DS-Unit-3-Sprint-2-SQL-and-Databases

SQL and Databases for Data Science

This code was written by Samuel Hepner

Day 1: Intro to SQL

Reading a csv as pandas dataframe, choosing columns needed, converting pandas dataframe to SQL table,
creating a sqlite engine and making basic SQL queries, using pandas and sqlalchemy libraries.

Day 2: SQL for analysis

Creating SQL table from csv, connecting to sqlite, and more queries.

Day 3: NoSQL and Document Oriented Databases

Used MongoDB to make queries.

Day 4: ACID and Database Scalability Tradeoffs

Worked with the same dataset to see how SQL and NoSQL differ.
Used MongoDB and PostgreSQL to run queries on the titanic dataset.