From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 24,000 courses taught by industry experts.

Use built-in functions

Use built-in functions

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial Buy for my team

Use built-in functions

“

- [Instructor] Each database platform includes hundreds of built-in functions that you can use to manipulate your data. If you've ever applied a formula to your data in a spreadsheet application like Excel then you're familiar with the concept. Functions take in values in the form of arguments, process them through some routine and then return new values. If I select just the Price column from the Products table by running lines three and four, you can see that we get a lot of information back. There are 144 values here that correspond to the 144 products in the table. We're just pulling the column straight out of the Products table and displaying it all by itself. We can now use some built-in functions to give us statistical information about all of this data. Let me move this results window down on the screen a little bit so I can see line seven through 11. First, we're going to use the MAX function. Then inside the…

Contents