Save for later
Performing Data Aggregation using SQL Aggregate Functions
In this 2-hour long project-based course, you will learn how to retrieve data from tables in a database using SQL SELECT statement with SQL Aggregate functions. The aggregate functions we will consider in this project are COUNT, SUM, MIN, MAX and AVG. Aggregate functions are used to summarize data from rows of a table into a single value. In addition, you will learn how to set conditions on the output of an aggregate function using the HAVING clause. Finally, you will learn how to tidy up the result set of aggregate functions using the ROUND function.
Note: You do not need to be a data administrator or data analyst to be successful in this guided project, just a familiarity with querying databases using SQL SELECT statement suffice for this project. If you are not familiar with SQL and want to learn the basics, start with my previous guided projects titled “Performing Data definition and Manipulation in SQL." and “Querying Databases using SQL SELECT statement”
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 2 weeks |
Effort | 2 hours |
Starts | Jul 17 (44 weeks ago) |
Cost | $9 |
From | Coursera Project Network via Coursera |
Instructor | Arimoro Olayinka Imisioluwa |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science IT & Networking |
Tags | Data Science Data Analysis Information Technology Data Management |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Treasury Accountant, Aggregate Industries US $65k
Enterprise Architecture-Corp Functions $66k
BUILD Leadership Development Program-HR Generalist, Corporate Functions $67k
Marketing Coordinator - Functions & Promotions $73k
BUILD Leadership Development Program-HR Generalist, Corporate Functions Manager $113k
Senior Corporate Functions Recruiter - Talent Acquisition Specialist $114k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 2 weeks |
Effort | 2 hours |
Starts | Jul 17 (44 weeks ago) |
Cost | $9 |
From | Coursera Project Network via Coursera |
Instructor | Arimoro Olayinka Imisioluwa |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Data Science IT & Networking |
Tags | Data Science Data Analysis Information Technology Data Management |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course