SQL Aggregate Functions episode artwork

EPISODE · Jun 5, 2014 · 32 MIN

SQL Aggregate Functions

from How to Program with Java Podcast · host Trevor Page: Java Guru | Programmer | Teacher

In today's podcast episode you'll be learning all about the aggregate functions that exist in SQL. What the heck is an aggregate function? Well that's what I'm going to try and teach you today, and I promise, it's not a difficult concept to grasp. Just think of an aggregate function as a method that you're calling that will process data in your database and return a value. Obviously the returned value will depend on which of the aggregate functions you choose to use. So that begs an obvious question, what are the aggregate functions that we can use in SQL? I'm glad you asked, here's the ones that I use all the time in MySQL: MAX MIN SUM AVG COUNT Okay, great! So now we know what the names of these functions are, now let's see some examples of them in use!

In today's podcast episode you'll be learning all about the aggregate functions that exist in SQL. What the heck is an aggregate function? Well that's what I'm going to try and teach you today, and I promise, it's not a difficult concept to grasp. Just think of an aggregate function as a method that you're calling that will process data in your database and return a value. Obviously the returned value will depend on which of the aggregate functions you choose to use. So that begs an obvious question, what are the aggregate functions that we can use in SQL? I'm glad you asked, here's the ones that I use all the time in MySQL: MAX MIN SUM AVG COUNT Okay, great! So now we know what the names of these functions are, now let's see some examples of them in use!

NOW PLAYING

SQL Aggregate Functions

0:00 32:12

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

MG Show MG Show The MG Show, hosted by Jeffrey Pedersen and Shannon Townsend, is a leading alternative media platform dedicated to uncovering the truth behind today’s most pressing political issues. Launched in 2019, the show has grown exponentially, offering unfiltered insights, comprehensive research, and real-time analysis. With a commitment to independent journalism and factual integrity, the MG Show empowers its audience with knowledge and encourages active participation in the political discourse. Breaking News Show | eTurboNews Juergen Thomas Steinmetz News is relevant to the global travel and tourism industry, human rights and global issues.Breaking news when it happens and only from the source. Eat to Live Jenna Fuhrman, Dr. Fuhrman Our health is our most precious gift and smart nutrition can change your life. Each month, join Dr. Fuhrman and his daughter, Jenna Fuhrman as they discuss important topics in the world of nutrition. Eat to Live will change the way you eat and think about food. French Your Way Jessica: Native French teacher founder of French Your Way Boost your French listening skills and test your comprehension with this one of a kind series of podcasts. Get the chance to listen to a real conversation between native speakers talking at normal speed AND customise your learning experience through carefully designed sets of questions (2 levels of difficulty) available for download at www.frenchvoicespodcast.com. All interviews also come with the transcript. French teacher Jessica interviews native speakers of French from around the world who share a bit of their life and passion. Where else would you meet in one same place a French yoga teacher based in Melbourne, a soap manufacturer from Provence, or a couple cycling around the world?

Frequently Asked Questions

How long is this episode of How to Program with Java Podcast?

This episode is 32 minutes long.

When was this How to Program with Java Podcast episode published?

This episode was published on June 5, 2014.

What is this episode about?

In today's podcast episode you'll be learning all about the aggregate functions that exist in SQL. What the heck is an aggregate function? Well that's what I'm going to try and teach you today, and I promise, it's not a difficult concept to grasp....

Can I download this How to Program with Java Podcast episode?

Yes, you can download this episode by clicking the download button on the episode player, or subscribe to the podcast in your preferred podcast app for automatic downloads.
URL copied to clipboard!