Aggregate Functions Courses and Certifications

Discover powerful SQL aggregate functions for complex database operations, enabling data grouping and filtering to answer specific questions efficiently.

• Codecademy
• 1 hour
• On-Demand
• Free Trial Available

Hussein Nasser

Understanding Aggregate Functions Performance - The Backend Engineering Show

Explore aggregate function performance in databases, focusing on COUNT, AVG, and MAX. Learn about clustering, sequential and random writes, and optimization strategies for improved query efficiency.

• YouTube
• 23 minutes
• On-Demand
• Free Video

SQL Bootcamp (Live Online)

212 ratings at Noble Desktop

Master essential SQL skills to write queries, join tables, aggregate data, and manipulate databases using PostgreSQL - applicable to all major SQL platforms.

• Noble Desktop
• 18 hours
• On-Demand
• $975.00

SQL Server Bootcamp (Live Online)

124 ratings at Noble Desktop

Master SQL querying fundamentals through hands-on practice with database operations, from basic SELECT statements to advanced stored procedures, functions, and data manipulation techniques.

• Noble Desktop
• 18 hours
• On-Demand
• $975.00

Mastering SQL Functions and Clauses

1 review

Master advanced SQL functions and clauses to analyze shopping data, from COUNT and DISTINCT operations to aggregate calculations and trend analysis using GROUP BY statements.

• CodeSignal
• On-Demand
• Free Certificate

SQL for Business Analysts

Boost your business SQL skills. Learn how you can use SQL to quickly analyze data and build powerful reports to overcome business problems.

• DataCamp
• 20 hours
• On-Demand
• Free Trial Available

Functions for Manipulating Data in SQL Server

Learn the most important functions for manipulating, processing, and transforming data in SQL Server.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Intermediate SQL

771 ratings at DataCamp

Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Statistician in R

121 ratings at DataCamp

A statistician collects and analyzes data and helps companies make sense of quantitative data, including spotting trends and making predictions.

• DataCamp
• 52 hours
• On-Demand
• Free Trial Available

Introduction to Excel

92 ratings at DataCamp

Master the Excel basics and learn to use this spreadsheet tool to conduct impactful analysis.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

PostgreSQL Summary Stats and Window Functions

87 ratings at DataCamp

Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Introduction to SQL Server

59 ratings at DataCamp

Learn to use SQL Server to perform common data manipulation tasks and master common data manipulation tasks using this database system.

• DataCamp
• 4 hours
• On-Demand
• Free Trial Available

Mastering SQL Functions and Clauses with Taylor Swift

Master SQL functions and data analysis through Taylor Swift's discography. Learn COUNT, DISTINCT, SUM, GROUP BY, and aggregation techniques to transform raw data into meaningful insights.

• CodeSignal
• On-Demand
• Free Certificate

Mastering SQL Functions and Clauses with PostgreSQL

Master advanced PostgreSQL functions and clauses to enhance data analysis capabilities, from COUNT operations to complex aggregations across multiple tables for improved reporting and insights.

• CodeSignal
• On-Demand
• Free Certificate

Mastering SQL Functions and Clauses with Leo Messi

Master advanced SQL functions and data analysis using real soccer statistics from Messi's career, covering COUNT, DISTINCT, SUM, GROUP BY, and aggregate functions for meaningful insights.

• CodeSignal
• On-Demand
• Free Certificate