From the course: Database Foundations: Intro to Databases
Join today to access over 23,400 courses taught by industry experts.
Use built-in functions
From the course: Database Foundations: Intro to Databases
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.