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.
Skill level
BeginnerTime to complete
6 weeksCertificate of completion
YesPrerequisites
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.
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.
Projects in this skill path
- Project
Create a Table
Build fluency in SQL manipulation. We're going to practice creating tables in SQL so you can hone your skills and feel confident taking them to the real world. - Project
New York Restaurants
Practice writing the most common types of queries. - Project
RPA Fraud Detection
Reputable Product Agency (RPA) has started receiving complaints from their credit card processor about fraudulent transactions. Help your finance department identify potentially risky transactions before they finish processing.
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.ChrisCodecademy 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.RodrigoCodecademy Learner @ UK
- Brilliant learning experience. Very interactive. Literally a game changer if you're learning on your own.John-AndrewCodecademy Learner @ USA
Our learners work at
Skill paths help you level-up
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.Get step-by-step guidance
We guide you through exactly where to start and what to learn next to build a new skill.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?
Related resources
- Article
What is a Relational Database Management System?
Learn about RDBMS and the language used to access large datasets – SQL. - Article
Common SQL Interview Questions
Practice with some common SQL interview questions. - Article
Running SQL commands in DB Browser
Learn how to use DB Browser to interact with SQLite databases
Related courses and paths
- Free course
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.Beginner Friendly5 hours - Free course
Learn SQL: Aggregate Functions
Perform calculations inside SQL queries to answer specific data questions.Beginner Friendly1 hour - Free course
Learn SQL: Multiple Tables
Combine data stored across multiple tables using joins, unions, and temporary tables.Beginner Friendly2 hours
Browse more topics
- Data Science5,576,638 learners enrolled
- SQL1,516,971 learners enrolled
- Code Foundations12,507,337 learners enrolled
- For Business9,519,917 learners enrolled
- Computer Science7,148,361 learners enrolled
- Web Development6,631,913 learners enrolled
- Python4,370,646 learners enrolled
- Cloud Computing3,952,070 learners enrolled
- Data Analytics3,733,521 learners enrolled
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.