Working with Functions

MySQL 8.0    |    Beginner
  • 11 Videos | 1h 10m 30s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
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 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

IN THIS COURSE

  • Playable
    1. 
    Introduction to Functions in MySQL
    4m 47s
    UP NEXT
  • Playable
    2. 
    The GROUP BY Clause and Aggregate Function Basics
    3m 29s
  • Locked
    3. 
    Using the GROUP BY Clause and Aggregate Functions
    8m 47s
  • Locked
    4. 
    Numeric Functions
    4m 42s
  • Locked
    5. 
    The COUNT Function
    6m 53s
  • Locked
    6. 
    MIN and MAX Functions
    4m 23s
  • Locked
    7. 
    SUM and AVERAGE Functions
    3m 48s
  • Locked
    8. 
    Character Functions
    6m 36s
  • Locked
    9. 
    String Comparison Functions
    6m 53s
  • Locked
    10. 
    Date/Time Functions
    8m 44s
  • Locked
    11. 
    Exercise: Using Functions in Queries
    6m 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.

YOU MIGHT ALSO LIKE

Likes 22 Likes 22  
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1602 Likes 1602  
Likes 18 Likes 18