MySQL Database Development: Working with Functions

MySQL 8.0    |    Beginner
  • 11 Videos | 1h 5m 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
    FREE ACCESS
  • Locked
    4. 
    Numeric Functions
    4m 42s
    FREE ACCESS
  • Locked
    5. 
    The COUNT Function
    6m 53s
    FREE ACCESS
  • Locked
    6. 
    MIN and MAX Functions
    4m 23s
    FREE ACCESS
  • Locked
    7. 
    SUM and AVERAGE Functions
    3m 48s
    FREE ACCESS
  • Locked
    8. 
    Character Functions
    6m 36s
    FREE ACCESS
  • Locked
    9. 
    String Comparison Functions
    6m 53s
    FREE ACCESS
  • Locked
    10. 
    Date/Time Functions
    8m 44s
    FREE ACCESS
  • Locked
    11. 
    Exercise: Using Functions in Queries
    6m 28s
    FREE ACCESS

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

COURSE MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
Likes 18 Likes 18  
COURSE MySQL Database Development: Introduction
Likes 109 Likes 109  
BOOK MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE MySQL Database Development: Database Design Fundamentals
Likes 74 Likes 74  
COURSE Expert Insights on Communication Essentials
Likes 4348 Likes 4348  
COURSE Agile Principles and Methodologies
Likes 2971 Likes 2971