Learn how to use the most common MySQL 5 and MySQL 8 functions. You’ll be writing MySQL queries like a pro!
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:
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:
Plus, you’ll get to practice your skills in 136 interactive exercises.
How much do you know about SQL?
Discover MySQL's text functions!
Learn how to do math (and more) with MySQL's numeric functions.
Learn how to work with date and time data in MySQL
Learn how to successfully work with NULLs.
How well do you remember the contents of this course? Let's find out!