Data Analysis and Data Modeling Projects with SQL

Poject 1: Analysis of Buisness Questions Using SQL

This project is to demonstrate advanced SQL techniques using a fictional database based on common databases that most businesses will use. Analysis will be done on a modified version of the database Chinook. The Chinook database contains information about a fictional digital music shop - similar to a type of mini-iTunes store.

Link: Analyzing_Business_Questions

Project 2: Analsis of CIA Factbook data with SQL and Python

This project will work with data form the CIA World Factbook, a compendium of statistics about all of the countries on Earth. The Factbook contains demographic information like:

• population -> The population as of 2015
• population_growth -> The annual population growth rate, as a percentage
• area -> The total land and water area.

Link: Analyzing_CIA_Factbook_Data

Poject 3: Designing and Creating a Database

This project demonstrates key skills necessary to design and create a database using python and sql.

Link: Designing_and_Creating_Database