Skip to main content

Live Training: Analyzing Carbon Footprints in SQL


Have you ever wondered about the carbon footprint of your jeans or soft drink? In this code-along, we’ll use SQL to explore product carbon footprints at companies like Levi’s and Coca-Cola.

Understanding emissions along a product’s lifecycle is important to achieving the steep carbon reductions required to meet global carbon goals. Our dataset shows how product emissions have changed over the years, and which part of the product’s life is most problematic for the environment. Watch this code-along and use your SQL powers for planet earth!

Key Takeaways

  • Filter data to spotlight information of interest

  • Calculate metrics to summarize data

  • Analyze and visualize data changes over time


  • When in Workspace, go to integrations on the left-side bar, then:

  • Click “Create integration,” select PostgreSQL, and enter:

  • Integration name: SQL Carbon Emissions Training

  • Port: 5432

  • Hostname:

  • Database: emissions

  • Username: emissions_codealong

  • Password: emissions_codealong

  • Webinar notebook here

  • Solution notebook here

Follow along with this training in Workspace.

Izzy Weber Headshot
Izzy Weber

Curriculum Manager at DataCamp

View More Webinars

Recommended Content

Live Training: Analyzing Olympics Data with SQL and Python

Learn how to load data from different sources and perform exploratory analyses.


Spend Less Time in Spreadsheets with SQL

Hate wrangling data in spreadsheets? SQL does it better.


Hands-on learning experience

Companies using DataCamp achieve course completion rates 6X higher than traditional online course providers

Learn More

Upskill your teams in data science and analytics

Learn More

Join 2,500+ companies and 80% of the Fortune 1000 who use DataCamp to upskill their teams.

Don’t just take our word for it.