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 mission 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.)


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

Mission 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


Course Info:


The median completion time for this course is 6.3 hours. View Details

This course includes five missions and one guided project.  It is the 11th course in the Data Analyst in Python path and the Data Scientist in Python path.


Take a Look Inside