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: Getting Started
Likes 61 Likes 61  
COURSE MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
Likes 11 Likes 11  
COURSE Database Fundamentals: Working with SQL Commands

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE MySQL Database Development: GIS, Cloud, & Connectors
Likes 16 Likes 16  
COURSE Python: Getting Started
Likes 456 Likes 456  
COURSE JIRA Administration: Leveraging the Platform for Development Projects
Likes 120 Likes 120