MISSION 257

Guided Project: Analyzing CIA Factbook Data Using SQL

In this guided project, you will put together everything you've learned in this SQL course to create a data science portfolio project analyzing data from the CIA World Factbook that you can show to employers to demonstrate proficiency in SQL.

In this project, you will work with SQL to answer real-world questions using targeted queries. Specifically, your lesson will be to use the CIA World Factbook to uncover some interesting insights about the various countries in the database. To complete this project, we highly recommend downloading Jupyter Notebook to follow along with the instructions on your local machine. (However, you'll also be able to complete the steps using an embedded Jupyter Notebook interface in our platform if you prefer.)

Objectives

  • Work with SQL data.
  • Answer real-world questions using SQL queries.

Lesson Outline

1. Overview of the Data
2. Summary Statistics
3. Exploring Outliers
4. Exploring Average Population and Area
5. Finding Densely Populated Countries

6. Next Steps

Take a Look Inside