cookies-icon

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.

Course

Basic

Common MySQL Functions

Learn how to use the most common MySQL 5 and MySQL 8 functions. You’ll be writing MySQL queries like a pro!

Table of contents

10 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 65 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 65 present and future courses

$149

$599

75% OFF

Buy now
Details
136

Interactive exercises

18 h

Estimated time

818

Users enrolled

☆☆☆☆☆
★★★★★

98 ratings

Description Table of contents Reviews Start learning

Common MySQL Functions is an interactive SQL course for intermediate users who want to up their skills. Do you dream of a career in data analysis or data engineering? Or do you use MySQL databases in your daily work? If you answered yes and have a basic knowledge of MySQL, this course is perfect for you!

MySQL, like any other database, comes with a number of built-in functions; knowing them is essential to becoming proficient in SQL. A function is a predefined piece of code that performs a certain operation. MySQL functions let you change the case of text, extract a word from a sentence, round decimal numbers, and lots more.

Common MySQL Functions will teach you the most commonly used built-in functions in MySQL and how to work with them. It uses MySQL 8, but MySQL 5 users can take this course, too: we clearly mark functions available only in MySQL 8.

The course is split into multiple parts. Each part is dedicated to a different type of function:

  • Text functions let you work with text data. You’ll learn how to merge two or more texts, how to compute the length of a text, how to transform text into uppercase or lowercase, how to extract part of a text, and more.
  • Numeric functions work with numeric data. You will learn about arithmetic in MySQL (computer computations may not get the result you think!) and how to avoid common mistakes. You’ll also learn how to round decimal numbers, how to get the absolute value of a number, and much more.
  • Date and time functions work with months, days, hours, and so on. You’ll learn about date and time data types in MySQL, how to filter records by a date interval, how to extract part of a date, and more.
  • NULL functions work with NULLs, or unknown values. NULLs can be tricky to handle; these functions make it easier.

At the end of the course, there is a final challenge. It combines concepts from all the other parts and lets you practice the functions you’ve learned.

Common MySQL Functions is interactive. You’ll learn by writing real SQL queries in our online console and immediately seeing the results. Our platform runs your code and verifies your solution. Each exercise includes an instruction and a task that you complete. This way, you can put your new knowledge into practice right away.

This course is for users who have some familiarity with SQL. You should already know:

  • How to select from a single table, including writing WHERE conditions
  • How to JOIN tables
  • How to use GROUP BY and HAVING

What Do You Need to Take This Course?

  • A web browser
  • Some understanding of SQL, such as the concepts presented in our SQL Basics in MySQL course

This Course Will Teach You How To:

  • Use common MySQL text functions
  • Correctly use MySQL arithmetic operators – and avoid common mistakes
  • Use MySQL numeric functions
  • Work with date and time data types in MySQL
  • Use MySQL date and time functions
  • Work with NULLs in MySQL

Plus, you’ll get to practice your skills in 136 interactive exercises.

Who Should Take This Course?

  • Database analysis beginners
  • Junior developers
  • Students taking classes in relational databases
  • Business database users who want to improve their skills
  • Anyone who wants to learn about common MySQL functions

What's In It for Me?

  • 136 interactive exercises. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
  • Lifetime access to the course. When you purchase the course, you’ll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you’ll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you’re not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints and help. There are hints available in the exercises to help you if you get stuck. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line – we’ll be more than happy to answer!

Table of contents

Free

Paid content

0%

Course progress

0/136

Exercises completed

1.

Introductory Quiz

How much do you know about SQL?

0/7
Start now

Introductory Quiz

Introduction
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Congratulations

2.

Pretty Printing

Discover MySQL's text functions!

0/29
Start now

Introduction

Introduction
The copywriter table
The slogan table

Concatenation

The CONCAT() function
Using CONCAT() with NULL
The CONCAT_WS() function

Simple text functions

The CHAR_LENGTH() function
Practice CHAR_LENGTH()
The LENGTH() function
The LOWER() and UPPER() functions
The LTRIM() and RTRIM() functions
The TRIM() Function
Using LEADING, TRAILING or BOTH with TRIM
Practice text functions
Text patterns: % and _
More practice

How to modify strings

The SUBSTRING() function
Using SUBSTRING() with the length argument
The LEFT() and RIGHT() functions
The INSERT() function
The LOCATE() function
The REVERSE() function
The REPLACE() function
The REPEAT() and SPACE() functions

Summary and Review

Summary
Exercise 1
Exercise 2
Exercise 3
Congratulations

3.

Numeric Functions

Learn how to do math (and more) with MySQL's numeric functions.

0/24

Introduction

Introduction
The hero table
Numbers in SQL
Using CONCAT() with numbers

So you think you can count ...

Subtraction
Binary arithmetic is not exact
The CAST() keyword
Division by zero – 1
Division by zero – 2
Getting rid of division by zero
The MOD() function

Round and other functions

The ROUND() function
Precision with ROUND()
Other rounding functions
Practice FLOOR()
Practice TRUNCATE()
The ABS() function
The SQRT() function

Summary and Review

Summary
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Congratulations

4.

Date and Time Functions

Learn how to work with date and time data in MySQL

0/48

Introduction

Introduction
The route table
The aircraft table
The flight table

Dealing with dates

Dates in MySQL
The DATE data type
Using logical operators with dates
Using BETWEEN with dates
Dates with ORDER BY
Dates – exercise

Working with time

Time in SQL
The TIME data type
Using BETWEEN with time data
Comparing dates and times using operators
Sorting by TIME columns
Practice time!

Date and time data types

Date and time
Date and time data types
Using date and time with constant values
Using BETWEEN with date and time data
Sorting date and time data with ORDER BY
Practice time!

Extracting dates and times

The YEAR(), MONTH(), and DAY() functions
Using YEAR(), MONTH(), and DAY() with aggregate functions
The EXTRACT() function

Doing arithmetic with dates

The ADDDATE() function
The TIMESTAMPADD() function
The ADDTIME() function
Using ADDDATE() to subtract a date
Using TIMESTAMPADD() to subtract an interval
Using ADDTIME() to subtract a time
The DATEDIFF() function
The TIMEDIFF() and TIMESTAMPDIFF() functions

Converting date and time data

The CAST() function
The CONVERT() function
The CONVERT_TZ() function
The DATE_FORMAT() and TIME_FORMAT() functions

Current date and time data

Getting the Current Date and Time in MySQL
The CURRENT_TIMESTAMP and NOW() functions
The CURDATE() and CURTIME() functions
The UTC_TIMESTAMP(), UTC_DATE(), and UTC_TIME() functions

Summary and review

Summary
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Congratulations

5.

NULL functions

Learn how to successfully work with NULLs.

0/17

Introduction

Introduction
The product table
A quick review of NULLs

The ISNULL() function

The ISNULL() function
Using ISNULL() with aggregate functions

The COALESCE() function

The COALESCE() function
Data types in COALESCE()
Using COALESCE() with other functions
Using COALESCE() in calculations
Using COALESCE() with multiple parameters

The NULLIF() function

The NULLIF() function
Practice NULLIF() – 1
Practice NULLIF() – 2

Summary and review

Summary
Exercise 1
Exercise 2
Congratulations

6.

Final Quiz

How well do you remember the contents of this course? Let's find out!

0/11

Quiz

Introduction
The person table
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Exercise 5
Exercise 6
Exercise 7
Exercise 8
Congratulations

Reviews (0)

Average rating

4.64/5

☆☆☆☆☆
★★★★★

98 ratings

Details

5 stars

81%

4 stars

12%

3 stars

0%

2 stars

5%

1 stars

2%