Premium project

What and Where Are the World's Oldest Businesses?

Use SQL data manipulation and joins to discover the oldest businesses around the world.

Start Project
9 Tasks1,500 XP

Loved by learners at thousands of companies


Project Description

An important part of business is planning for the future and ensuring that the company survives changing market conditions. Some businesses do this really well and last for hundreds of years. In this project, you'll explore data from BusinessFinancing.co.uk on the world's oldest businesses: when they were founded and which industries they belong to.

Project Tasks

  1. 1
    The oldest business in the world
  2. 2
    How many businesses were founded before 1000?
  3. 3
    Which businesses were founded before 1000?
  4. 4
    Exploring the categories
  5. 5
    Counting the categories
  6. 6
    Oldest business by continent
  7. 7
    Joining everything for further analysis
  8. 8
    Counting categories by continent
  9. 9
    Filtering counts by continent and category
Technologies
SQL SQL
Topics
Data Manipulation
Richie Cotton Headshot

Richie Cotton

Curriculum Architect at DataCamp
Richie is a Learning Solutions Architect at DataCamp. He has been using R since 2004, in the fields of proteomics, debt collection, and chemical health and safety. He has released almost 30 R packages on CRAN and Bioconductor – most famously the assertive suite of packages – as well as creating and contributing to many others. He also has written two books on R programming, Learning R and Testing R Code.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA