Downloads
Countries and cities

World

Countries, cities and spoken languages with population, area and life expectancy. No dates, so it is ideal for pure SQL and for hierarchies and maps.

worldSQL ServerMariaDB 3 tables
citycountrycountrylanguage

Good for

Beginner SQLSorting and filteringMap visuals

Questions to try

  • Which are the ten largest countries by population?
  • How many cities does each country have?
  • Which languages are official in the most countries?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database world, in Excel or Power BI (Import mode) or DBeaver. In queries use the schema-qualified name shown for each table (for example world.city).

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to world and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (3)

Click a table to preview it in the Playground.

Practice files for this database

Beginner24 KB

World: Countries of the World

Population, area, GNP and life expectancy for every country. Good for filters, sorting and dealing with blanks.

Download

← All databases