Learn SQL: Aggregate Functions
Perform calculations inside SQL queries to answer specific data questions.
Time to completeAverage based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary1 hour
Prerequisites1 courseWe suggest you complete the following courses before you get started with Learn SQL: Aggregate Functions:
- Intro to SQL
About this course
Continue your SQL learning journey! In this course, you will learn how to incorporate calculations into SQL queries to answer specific data questions.
Skills you'll gain
Apply aggregate functions
Group data by category
Filter out unwanted data
Projects in this course
Analyze Hacker News TrendsQuery Hacker News data using SQL to discover trends.
Trends in StartupsIn this project, we're going to practice aggregate functions in SQL so you can hone your skills and feel confident taking them to the real world. Using these functions will combine row values together and return a single result.
Learn SQL: Aggregate Functions course ratings and reviews
- 5 stars
- 4 stars
- 3 stars
- 2 stars
- 1 star
- 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
Join over 50 million learners and start Learn SQL: Aggregate Functions today!
Looking for something else?
Related courses and paths
- Skill path
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.Includes 8 CoursesWith Certificate16 hours
- Free course
Learn C++: FunctionsTake your C++ skills to the next level by learning how to use using C++ functions to write more flexible, modular, reusable code.3 hours
- Free course
Learn Swift: FunctionsContinue your Swift journey by learning functions — reusable and callable code blocks!2 hours
Browse more topics
- Data Science5,811,391 learners enrolled
- SQL1,613,351 learners enrolled
- Code Foundations13,248,491 learners enrolled
- For Business9,772,007 learners enrolled
- Computer Science7,474,701 learners enrolled
- Web Development6,899,584 learners enrolled
- Python4,552,416 learners enrolled
- Cloud Computing4,118,359 learners enrolled
- Data Analytics3,921,246 learners enrolled
Unlock additional features with a paid plan
Practice ProjectsGuided projects that help you solidify the skills and concepts you're learning.
AssessmentsAuto-graded quizzes and immediate feedback help you reinforce your skills as you learn.
Certificate of CompletionEarn a document to prove you've completed a course or path that you can share with your network.