Free
CourseLearn SQL: Aggregate Functions
Perform calculations inside SQL queries to answer specific data questions.
This course includes
This course includes
Skill level
BeginnerTime to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary1 hourProjects
2Prerequisites
1 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
Syllabus
Aggregate Functions
Learn powerful functions for performing complex database operations with ease.
Projects in this course
- practice Project
Analyze Hacker News Trends
Query Hacker News data using SQL to discover trends. - practice Project
Trends in Startups
In 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.
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.
Learn SQL: Aggregate Functions course ratings and reviews
413 ratings
- 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 resources
- Article
Difference Between WHERE and HAVING Clause in SQL
Discover the key differences between SQL's WHERE and HAVING clauses. Learn their syntax and use cases and how to apply them effectively in data filtering. - Article
Common SQL Interview Questions
Practice with some common SQL interview questions. - Article
How to Use the SQL Subquery: A Detailed Guide
Learn how to use subqueries in SQL for advanced data manipulation and analysis. Explore different types of SQL subqueries, usage methods, applications, and best practices.
Related courses and paths
- Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.Includes 9 CoursesWith CertificateBeginner Friendly17 hours - Free course completed!
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 completed!
Intro to SQL
Use SQL to create, access, and update tables of data in a relational database.Beginner Friendly2 hours
Browse more topics
- Data science4,868,630 learners enrolled
- SQL1,399,353 learners enrolled
- Code foundations7,943,270 learners enrolled
- Computer science6,411,191 learners enrolled
- Web development5,325,312 learners enrolled
- Python3,928,306 learners enrolled
- For business3,723,114 learners enrolled
- JavaScript3,028,016 learners enrolled
- Data analytics2,810,948 learners enrolled
Unlock additional features with a paid plan
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.