MySQL Database Development: Working with Functions
MySQL 8.0
| Beginner
- 11 Videos | 1h 5m 30s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
describe what functions are, what they are used for, and the different categories of functions available in MySQLrecognize the syntax of the GROUP BY clause in a SELECT statement and the basic aggregate functions that are availablework with the GROUP BY clause and aggregate functions in SELECT statements to filter result setswork with numeric functions such as ROUND, POW, CEILING, and FLOORuse the COUNT function to determine the number of rows returned by a queryuse 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 querywork with various character functions in queries, including CONCAT, LEFT, RIGHT, and LENGTHuse the string comparison functions to compare one string to anotherwork with date and time values, including how to modify the way they are displayedcreate queries that use various MySQL functions to return specific results from the database
IN THIS COURSE
-
1.Introduction to Functions in MySQL4m 47sUP NEXT
-
2.The GROUP BY Clause and Aggregate Function Basics3m 29s
-
3.Using the GROUP BY Clause and Aggregate Functions8m 47s
-
4.Numeric Functions4m 42s
-
5.The COUNT Function6m 53s
-
6.MIN and MAX Functions4m 23s
-
7.SUM and AVERAGE Functions3m 48s
-
8.Character Functions6m 36s
-
9.String Comparison Functions6m 53s
-
10.Date/Time Functions8m 44s
-
11.Exercise: Using Functions in Queries6m 28s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.