MySQL Database Development: Working with Functions Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description 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.
Expected Duration (hours)
1.1
Lesson Objectives 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
Course Number: it_dfmydd_06_enus
Expertise Level
Beginner