Basic Track

SQL from A to Z in MySQL

This complete SQL learning track will take you from total MySQL database beginner to full working proficiency! It’s an excellent way to learn MySQL, even if you’ve never coded before.

4.84 ★★★★★ ★★★★★ (3477 ratings)

20,338 Lerners enrolled

Lifetime access

limited to this track only

$273

Want a better deal?

Get unlimited lifetime access to all 76 present and future courses

Save $450

Unlimited lifetime access

to all 76 present and future courses

$149 $599

75% OFF

Free trial Yes

Certificate of completion Yes

Estimated time 91 h

Courses included 7

Skills you will gain

  • Create simple queries
  • Combine data from multiple tables using SQL JOINs
  • Write complex SQL queries using aggregation, subqueries, and set operations
  • Add, modify, and delete data from a MySQL database
  • Know when and how to use common standard functions
  • Prepare complex reports with the GROUP BY and CASE WHEN clauses
  • Understand and apply window functions, which make writing complex queries easier
  • Understand and use Common Table Expressions, which help organize long SQL queries
  • Learn when and how to write recursive SQL queries, which allow you to process hierarchical SQL data structures like trees and charts

Last reviews

Description

If you are serious about a career in IT, you need to know SQL. It’s the language used to retrieve data from databases. Knowledge of SQL is essential for anyone working with data: data analysts, business analysts, programmers, IT professionals, software testers, etc.

This 7-course track provides a complete and comprehensive SQL learning path. It includes SQL’s advanced features, which are rarely taught in online SQL courses. It focuses on MySQL, the version of SQL used in the world’s most popular open-source database system. And you don’t need any programming or IT background to take it.

You’ll start with the foundations of SQL: how to find and change data in a MySQL database and how to use common built-in functions. Next, you’ll move to an intermediate level and learn how to use MySQL to generate reports and statistics. Finally, you will discover advanced modern SQL features like window functions and recursive queries that are necessary for any SQL expert.

SQL from A to Z in MySQL is interactive. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don’t need to install any software on your computer.

This track uses MySQL 8. However, users working with MySQL 5 and earlier can also take it. The features that are only available in MySQL 8 are clearly marked.

What Do You Need to Take This Track?

  • A web browser
  • An Internet connection

This Track Will Teach You How To:

  • Create simple queries
  • Combine data from multiple tables using SQL JOINs
  • Write complex SQL queries using aggregation, subqueries, and set operations
  • Add, modify, and delete data from a MySQL database
  • Know when and how to use common standard functions
  • Prepare complex reports with the GROUP BY and CASE WHEN clauses
  • Understand and apply window functions, which make writing complex queries easier
  • Understand and use Common Table Expressions, which help organize long SQL queries
  • Learn when and how to write recursive SQL queries, which allow you to process hierarchical SQL data structures like trees and charts

Who Should Take This Track?

  • SQL beginners
  • People without any IT experience who want to work with MySQL
  • Computer Science / IT students working with MySQL
  • Programmers who work with MySQL
  • Anyone who wants to learn complete MySQL, including the features added in MySQL 8

What’s In It for Me?

  • Easy entry into the world of MySQL. No prior experience, special software, or practice data sets needed.
  • A well-defined learning path with 7 fully interactive courses. Learn at your own pace, from anywhere and at any time. Interactive, hands-on learning improves retention.
  • Lifetime access to the learning track. When you purchase the track, 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 track, 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. We offer student2student support, mentor2student support, and technical support. You can also ask our learning community for help through the Disqus tab. Or drop the course creators a line at contact@learnsql.com – we’ll be more than happy to answer! 😉

Track courses

  1. SQL Basics in MySQL
    ★★★★★ ★★★★★ (2029) 126 Coding challenges Basic

    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.

  2. Common MySQL Functions
    ★★★★★ ★★★★★ (98) 136 Coding challenges Basic

    Learn how to use the most common MySQL 5 and MySQL 8 functions. You’ll be writing MySQL queries like a pro!

  3. How to INSERT, UPDATE, or DELETE Data in MySQL
    ★★★★★ ★★★★★ (66) 70 Coding challenges Basic

    Have you already learned the basics of SQL? Now it's time for the next step: adding, changing, and removing data in MySQL using the INSERT, UPDATE and DELETE statements.

  4. Creating Basic SQL Reports in MySQL
    ★★★★★ ★★★★★ (193) 97 Coding challenges Advanced

    Learn how to build MySQL reports that track and analyze key performance metrics with this interactive course.

  5. Window Functions in MySQL 8
    ★★★★★ ★★★★★ (304) 218 Coding challenges Advanced

    Want to stay up to date with the latest MySQL features? MySQL window functions are essential for doing modern data analysis. Learn how to use them to take your analysis skills to the next level!

  6. Recursive Queries in MySQL 8
    ★★★★★ ★★★★★ (316) 114 Coding challenges Advanced

    Do you want to be able to process trees and graphs in MySQL? Are you using MySQL 8 or higher? Learn how to write recursive queries and you’ll soon be producing concise and powerful SQL queries!

  7. GROUP BY Extensions in MySQL
    ★★★★★ ★★★★★ (149) 27 Coding challenges Advanced

    Do you want to perform multiple groupings in one query? Learn how to use GROUP BY extensions, such as ROLLUP in MySQL. Take the next step towards being a SQL expert!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Reviews (0)

Average rating

4.84/5

★★★★★ ★★★★★ (3477 ratings)

5 stars

86%

4 stars

13%

3 stars

1%

2 stars

0%

1 stars

0%