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 Server Bootcamp

1045 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

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

Microsoft SQL for Beginners

34472 ratings at Udemy

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

• Udemy
• 3 hours 59 minutes
• On-Demand
• Paid Course

SQL Bootcamp

247 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

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
• 2 days 4 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

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

Window Functions in Snowflake

Discover Snowflake window functions to solve complex data problems with rankings, partitions, and rolling calculations.

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

Intermediate SQL with AI

Build SQL skills by writing AI prompts that generate queries for sorting, grouping, filtering, and categorizing data.

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

Learn SQL

26353 ratings at Codecademy

Learn to communicate with databases using SQL, the standard data management language.

• Codecademy
• 5 hours
• On-Demand
• Free Trial Available