Query Population of All Countries

# Introduction In this project, you will learn how to access a MySQL database, import data, and retrieve population data for all countries. This project will help you develop skills in working with relational databases and SQL queries. ## 👀 Preview ```mysql MariaDB [world]> SOURCE /home/labex/project/getPopulation.sql; +--------------------+ | Population / 10000 | +--------------------+ | 10.3000 | | 2272.0000 | | 1287.8000 | | 0.8000 | | 340.1200 | | 7.8000 | | 21.7000 | ... | 1064.0000 | | 4037.7000 | | 916.9000 | | 1166.9000 | +--------------------+ 239 rows in set (0.001 sec) ``` ## 🎯 Tasks In this project, you will learn: - How to access MySQL using the `sudo` command without a password - How to import a database into MySQL - How to write and execute SQL queries to retrieve data from a database ## 🏆 Achievements After completing this project, you will be able to: - Manage a MySQL database, including importing and querying data - Write SQL queries to retrieve specific data from a database - Understand how to work with population data and express it in units of ten thousand people

|60 : 00

Click the virtual machine below to start practicing