Funtions in MySQL are used to produce values from other values, or to determine values that may be unknown. Explore the syntax and use of the most common MySQL functions, including aggregate, date/time and string functions.
MySQL Database Development: Working with Functions
- describe what functions are, what they are used for, and the different categories of functions available in MySQL
- recognize the syntax of the GROUP BY clause in a SELECT statement and the basic aggregate functions that are available
- work with the GROUP BY clause and aggregate functions in SELECT statements to filter result sets
- work with numeric functions such as ROUND, POW, CEILING, and FLOOR
- use the COUNT function to determine the number of rows returned by a query
- use the MIN and MAX functions in queries to return the smallest and largest values
- use the SUM and AVERAGE functions to calculate the total and average of the values returned by a query
- work with various character functions in queries, including CONCAT, LEFT, RIGHT, and LENGTH
- use the string comparison functions to compare one string to another
- work with date and time values, including how to modify the way they are displayed
- create queries that use various MySQL functions to return specific results from the database
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.