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,338 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
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills