Do you want to work with data using the most popular database in the world? Learn the basics of MySQL with these 126 practice exercises. No previous IT experience required.
In today's world, data is essential. Almost every company collects data, processes it, and stores it in databases. This course explores SQL basics using the MySQL dialect – the most popular version of SQL in the world.
MySQL has been a database leader for years. Analysts, programmers, software testers, and IT professionals use it every day. If you want to become one of them, you’ll need to learn to use MySQL.
In this interactive course, you’ll learn the basics of SQL. Find out how a MySQL database organizes data into tables, how to find and filter data in a single table, how to combine data from multiple tables, and how to do simple and complex computations in SQL.
This course is designed for complete beginners. You don’t need any prior experience in programming or coding. There’s nothing to install or set up on your computer. All you need is your favorite browser and a willingness to learn.
SQL Basics in MySQL 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, an example, and a task that you complete. This lets you put your new knowledge into practice right away.
This course uses MySQL 8. However, users working with MySQL 5 and earlier can also take the course and benefit from it. There are some SQL features that are only available in MySQL 8; we’ve clearly marked those features in the course.
Plus, you’ll get to practice your skills in 126 interactive exercises.
Find out what relational databases are and get to know SQL – a language to talk to MySQL databases.
Discover how to select data from a single table.
Learn how to select data from multiple tables.
Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.
Learn about various kinds of JOINs to best suit your needs.
Queries within queries? That's right! Discover how to build and use subqueries.
Combine query results using set operations.