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
20,313 Lerners enrolled
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
-
SQL Basics in MySQL126 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.
-
Common MySQL Functions136 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!
-
How to INSERT, UPDATE, or DELETE Data in MySQL70 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.
-
Creating Basic SQL Reports in MySQL97 Coding challenges Advanced
Learn how to build MySQL reports that track and analyze key performance metrics with this interactive course.
-
Window Functions in MySQL 8218 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!
-
Recursive Queries in MySQL 8114 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!
-
GROUP BY Extensions in MySQL27 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
