Basic Course

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!

4.64 ★★★★★ ★★★★★ (98 ratings)

849 learners enrolled

Lifetime access

limited to this course only

$39

Want a better deal?

Get unlimited lifetime access to all 72 present and future courses

Save $450

Unlimited lifetime access

to all 72 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Time to complete 18 h

Coding challenges 136

Skills you will gain

  • 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
  • Practice your skills in 136 interactive exercises.

Last reviews

Table of contents

Course progress 0%

Exercises completed 0/136

  1. Introductory Quiz

    0/7

    How much do you know about SQL?

  2. Pretty Printing

    0/29

    Discover MySQL's text functions!

  3. Numeric Functions

    0/24

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

  4. Date and Time Functions

    0/48

    Learn how to work with date and time data in MySQL

  5. NULL functions

    0/17

    Learn how to successfully work with NULLs.

  6. Final Quiz

    0/11

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

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Description

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!

Reviews (0)

Average rating

4.64/5

★★★★★ ★★★★★ (98 ratings)

5 stars

81%

4 stars

12%

3 stars

0%

2 stars

5%

1 stars

2%