Largest Population by Country

Introduction

In this project, you will learn how to access a MySQL database, import data, and query the top 10 countries by total population from the city table.

👀 Preview

🎯 Tasks

In this project, you will learn:

• How to access MySQL using the sudo command without a password
• How to import data from a SQL script into a MySQL database
• How to write a SQL query to retrieve the top 10 countries by total population from the city table

🏆 Achievements

After completing this project, you will be able to:

• Efficiently access and manage a MySQL database
• Understand how to import and work with data in a MySQL database
• Write SQL queries to retrieve and analyze data from a database