Skill Path

Analyze Data with SQL

Learn to analyze data with SQL and prepare for technical interviews.

Includes SQL, Data Science, Command Line, SQLite, Databases, Queries, Tables, and more.

99,286 learners enrolled

  • Skill level

    Beginner

  • Time to complete

    6 weeks

  • Certificate of completion

    Yes

  • Prerequisites

    None

About this skill path

All companies use data now, and most of it is stored in databases. In this Skill Path, you will use SQL queries to create databases, pull data from databases, and analyze the results. You will practice your skills with real-world marketing and user analysis case studies, and prepare for technical interviews. Interested in a career as a data analyst? This Skill Path is the perfect place to start.

Skills you'll gain

  • Read and write databases with SQL
  • Turn raw data into actionable insights
  • Compute standard business metrics

Syllabus

8 units • 15 lessons • 18 projects • 5 quizzes
  • 1

    Getting Started with SQL

    Learn the basics of SQL databases and build your own.

  • 2

    Writing Basic Queries

    Write your own queries to access data and apply your SQL knowledge to complete real-world projects.

  • 3

    Calculating Aggregates

    Increase the number of tools in your SQL toolset by learning about aggregates, then apply them to datasets to discover new insights.

  • 4

    Joining Multiple Tables

    Expand your abilities by joining multiple sources of data.

  • 5

    Going Off-Platform

    Set up a SQL database on your own computer and practice the commands you’ve learned.

  • 6

    Analyze Real Data with SQL

    Combine everything that you learned to solve real business problems.

  • 7

    Advanced SQL

    Dive into the more advanced SQL topics like window functions, math functions, and date functions.

The platform

Hands-on learning

Don't just watch or read about someone else coding — write your own code live in our online, interactive platform. You'll even get AI-driven recommendations on what you need to review to help keep you on track.
Animated demonstration of running code in Codecademy's learning environment

Projects in this skill path

Reviews from learners

  • The progress I have made since starting to use codecademy is immense! I can study for short periods or long periods at my own convenience - mostly late in the evenings.
    Chris
    Codecademy Learner @ USA
  • I felt like I learned months in a week. I love how Codecademy uses learning by practice and gives great challenges to help the learner to understand a new concept and subject.
    Rodrigo
    Codecademy Learner @ UK
  • Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.
    John-Andrew
    Codecademy Learner @ USA

Our learners work at

  • Google Logo
  • Meta Logo
  • Apple Logo
  • EA Logo
  • Amazon Logo
  • IBM Logo
  • Microsoft Logo
  • Reddit Logo
  • Spotify Logo
  • Uber Logo
  • YouTube Logo
  • Instagram Logo

What's included in skill paths

  • Practice Projects

    Guided projects that help you solidify the skills and concepts you're learning.

  • Assessments

    Auto-graded quizzes and immediate feedback help you reinforce your skills as you learn.

  • Certificate of Completion

    Earn a document to prove you've completed a course or path that you can share with your network.
See pricing and plans
How it works

Skill paths help you level-up

  1. Get a specialized skill

    Want to level up at work? Gain a practical, real-world skill that you can use right away to stand out at your job.

  2. Get step-by-step guidance

    We guide you through exactly where to start and what to learn next to build a new skill.

  3. Get there quickly

    We’ve hand-picked the content in each Skill Path to fast-track your journey and help you gain a new skill in just a few months.

Ready to learn a new skill?

Get started on Analyze Data with SQL with a free Codecademy account

Looking for something else?

Explore full catalog