Basic Course

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.

4.75 ★★★★★ ★★★★★ (2029 ratings)

14,077 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 10 h

Coding challenges 126

Skills you will gain

  • Retrieve 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
  • Create simple reports in MySQL using GROUP BY and aggregate functions
  • Write subqueries in MySQL
  • Understand the SQL set operation UNION
  • Practice your skills in 126 interactive exercises.

Last reviews

Table of contents

Course progress 0%

Exercises completed 0/126

  1. A primer on databases

    0/6

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

  2. Selecting from one table

    0/22

    Discover how to select data from a single table.

  3. Querying more than one table

    0/13

    Learn how to select data from multiple tables.

  4. Aggregation and grouping

    0/25

    Computations in SQL? Why not? You will learn how to group rows and compute statistics with aggregate functions.

  5. More on JOINs

    0/21

    Learn about various kinds of JOINs to best suit your needs.

  6. Subqueries

    0/22

    Queries within queries? That's right! Discover how to build and use subqueries.

  7. Set operations

    0/9

    Combine query results using set operations.

  8. Quiz

    0/8

    Check your SQL skills.

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Description

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
  • Create simple reports in MySQL using GROUP BY and aggregate functions
  • Write subqueries in MySQL
  • Understand the SQL set operation UNION

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! 😉

Reviews (1)

Average rating

4.75/5

★★★★★ ★★★★★ (2029 ratings)

5 stars

77%

4 stars

22%

3 stars

1%

2 stars

0%

1 stars

0%