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

SQL Basics in MySQL

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.

Table of contents

Lifetime access

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

limited to this course only

$29

Buy now

Want a better deal?

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

Get unlimited lifetime access to all 60 present and future courses

Save $420

Unlimited lifetime access

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

to all 60 present and future courses

$ 179

$ 599

70% OFF

Buy now Full pricing
126

Interactive exercises

10 h

Estimated time

156

Users enrolled

☆☆☆☆☆
★★★★★

1 ratings

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.

What Do You Need to Take This Course?

  • Just a web browser and an internet connection

This Course Will Teach You How To:

  • Get information from a MySQL database
  • Build basic reports in MySQL from scratch
  • Write complex WHERE conditions, using logical operators like AND, OR, and NOT
  • Understand the LIKE, IN, and BETWEEN operators in MySQL
  • Work with multiple tables in MySQL
  • Use INNER JOIN, LEFT JOIN, RIGHT JOIN, and (in MySQL 8) FULL JOIN
  • Create simple reports in MySQL using GROUP BY and aggregate functions
  • Write subqueries in MySQL
  • Understand the SQL set operations UNION, INTERSECT, and EXCEPT

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

Who Should Take This Course?

  • Anyone who wants to learn MySQL
  • Analysts who use relational databases
  • Students taking courses in relational databases
  • Beginning programmers
  • Business database users who want to improve their skills

What's in it for Me?

  • 126 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/126

Exercises completed

1.

A primer on databases

Find out what relational databases are and get to know SQL – a language to talk to MySQL databases.

0/6
Start now

Reviews (0)

Average rating

5.00 / 5

☆☆☆☆☆
★★★★★

1 ratings

Details

5 stars

100%

4 stars

0%

3 stars

0%

2 stars

0%

1 stars

0%