MySQL Database Development: Working with Functions

MySQL    |    Beginner
  • 11 videos | 1h 5m 30s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 41 users Rating 4.7 of 41 users (41)
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

  • 4m 47s
    Upon completion of this video, you will be able to describe what functions are, what they are used for, and the different categories of functions available in MySQL. FREE ACCESS
  • 3m 29s
    Upon completion of this video, you will be able to recognize the syntax of the GROUP BY clause in a SELECT statement and the basic aggregate functions that are available. FREE ACCESS
  • Locked
    3.  Using the GROUP BY Clause and Aggregate Functions
    8m 47s
    Learn how to use the GROUP BY clause and aggregate functions in SELECT statements to filter result sets. FREE ACCESS
  • Locked
    4.  Numeric Functions
    4m 42s
    In this video, you will work with numeric functions such as ROUND, POW, CEILING, and FLOOR. FREE ACCESS
  • Locked
    5.  The COUNT Function
    6m 53s
    In this video, learn how to use the COUNT function to determine the number of rows returned by a query. FREE ACCESS
  • Locked
    6.  MIN and MAX Functions
    4m 23s
    To find the smallest and largest values in a query, use the MIN and MAX functions. FREE ACCESS
  • Locked
    7.  SUM and AVERAGE Functions
    3m 48s
    Learn how to use the SUM and AVERAGE functions to calculate the total and average of the values returned by a query. FREE ACCESS
  • Locked
    8.  Character Functions
    6m 36s
    During this video, you will learn how to work with various character functions in queries, including CONCAT, LEFT, RIGHT, and LENGTH. FREE ACCESS
  • Locked
    9.  String Comparison Functions
    6m 53s
    During this video, you will learn how to use the string comparison functions to compare one string to another. FREE ACCESS
  • Locked
    10.  Date/Time Functions
    8m 44s
    In this video, you will work with date and time values, including how to modify the way they are displayed. FREE ACCESS
  • Locked
    11.  Exercise: Using Functions in Queries
    6m 28s
    In this video, you will create queries that use various MySQL functions to return specific results from the database. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book MySQL Crash Course: A Hands-on Introduction to Database Development
Journey How to Transform Tables with SQL
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: GIS, Cloud, & Connectors
Rating 4.5 of 33 users Rating 4.5 of 33 users (33)
Course MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
Course MySQL Database Development: Database Design Fundamentals
Rating 4.6 of 122 users Rating 4.6 of 122 users (122)