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.

To start this Skill Path, upgrade your plan.
This skill path includes
Start
116,585 learners enrolled
This skill path includes
  • Skill level

    Beginner
  • Time to complete

    Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary
     
    17 hours
  • Projects

    19
  • 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. Plus, now you can build your prompt engineering skills and get hands-on experience writing, testing, and refining prompts directly in the course.

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

9 units • 16 lessons • 19 projects • 6 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

    Learn How to Use AI for SQL

    Learn how to use AI for SQL analytics.

  • 6

    Going Off-Platform

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

  • 7

    Analyze Real Data with SQL

    Combine everything that you learned to solve real business problems.

  • Certificate of completion available with Plus or Pro

    Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.

The platform

Hands-on learning

Animated GIF of an AI provided error explanation within Codecademy's learning environment
An AI-generated hint within the instructions of a Codecademy project
Animated GIF of Codecademy's Job Readiness Checker tool generating a compatibility report for a senior software engineer role
Animated GIF of building a phone screen interview using Codecademy's Interview Simulator
A fill-in-the-blank JavaScript question in a Codecademy assessment

Earn a certificate of completion

Show your network you've done the work by earning a certificate of completion for each course or path you finish.
  • Show proofReceive a certificate that demonstrates you've completed a course or path.
  • Build a collectionThe more courses and paths you complete, the more certificates you collect.
  • Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.

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
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.Start

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.