Basic Track
SQL from A to Z
Become a SQL master – even if you’ve never coded before. Learn all the necessary tools to freely and efficiently work with any type of data. Start from the basics, then discover advanced SQL functions and features.
4.91
324,243 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 database using SQL.
- 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 in a readable way.
- Learn when and how to write recursive SQL queries, which allow you to process hierarchical SQL data structures like trees and charts.
Last reviews
- 11/02/2024★★★★★★★★★★
Very helpful and easy to learn! I used to dislike coding because it seemed too complicated, but it turns out it’s not hard at all. With just a bit of practice, I’ve made real progress. I'm so glad I found this program!
Xuan Dinh
Description
This learning path is for people who have no experience in IT and want to start their adventure with SQL. You’ll learn the basic and advanced features of this language. When you’ve completed this track, you’ll be able to efficiently work with databases and analyze data. Scroll down for details.
Don't have any IT experience and want to learn SQL? This learning path is for you! Data is everywhere. It’s the basis for almost every kind of business – banks, online services, taxi companies, stores, you name it. If you want to have an advantage over the competition, you need to know how to use data. To use data, you need SQL.
Maybe you dream of working as a database administrator or data analyst. Master SQL with the SQL from A to Z learning path. Don't waste time looking for other courses; this path has everything you need in one place. It will guide you through the entire learning process, from the very basics to the advanced features of modern SQL.
What's in it for me?
- Smooth entry into the world of coding. No prior experience, extra software, or practice data sets needed.
- Well-defined learning path with 7 fully interactive courses. This comprehensive SQL track contains everything you need to learn SQL in one place. The courses are arranged in logical order, and the teaching process was carefully designed for beginners to gain confidence and experience.
- Proven learning efficiency. Don’t just learn concepts: get hands-on practice with our real code editor, real data sets, and real-life exercises.
- Online certification. After successfully completing each course, you will receive a certificate that you can publish on your LinkedIn profile.
- Trusted support system. Every course comes with access to our resource base, student2student support, mentor2student support, and technical support. You can also join our learning community and participate in on-task discussions.
- Hints and more. If you get stuck, you can use the included exercise hints. Or use the Discuss tab to ask questions and share insights with other members of the LearnSQL community. You can also drop us a line at contact@learnsql.com and we'll be more than happy to help!
Objectives:
- 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 database using SQL.
- 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 in a readable way.
- 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 learning path?
- SQL beginners.
- People without any IT experience.
- Computer Science / IT students.
- Programmers learning SQL.
- Anyone who wants to learn complete SQL, including SQL’s modern features.
Requirements:
- A web browser
- An internet connection
While doing the SQL From A to Z learning path, you can practice your knowledge with our SQL Practice track. You can also develop your skills and add new tools to your arsenal by continuing to the SQL Reporting learning path.
Track courses
-
SQL Basics129 Coding challenges Basic
Start here if you’re new to SQL. Learn the basics of SQL, retrieve data from an SQL database and build simple reports.
-
Standard SQL Functions211 Coding challenges Basic
Learn how to process numerical, text, and other types of data with SQL’s most-used functions.
-
How to INSERT, UPDATE, and DELETE Data in SQL52 Coding challenges Basic
Go beyond simple SELECT statements! Learn all about the SQL UPDATE, INSERT, and DELETE commands, and find out how to combine them with NULLs and JOINs.
-
Creating Basic SQL Reports97 Coding challenges Advanced
Teach yourself how to build basic SQL reports to track and analyze the performance of your metrics.
-
Window Functions218 Coding challenges Advanced
Learn how to use analytic SQL functions to deeply understand data.
-
Recursive Queries114 Coding challenges Advanced
Master the most challenging type of SQL queries. Learn how to process trees and graphs in SQL, and how to effectively organize long SQL queries.
-
GROUP BY Extensions in SQL63 Coding challenges Advanced
Do you want to work more efficiently using SQL and be able to create more complex and sophisticated queries? Learn about GROUP BY clauses, such as ROLLUP, CUBE, and GROUPING SETS.
Get the Certificate of Competency in SQL
This certificate will confirm your practical SQL problem-solving skills
Reviews (11)
Very helpful and easy to learn! I used to dislike coding because it seemed too complicated, but it turns out it’s not hard at all. With just a bit of practice, I’ve made real progress. I'm so glad I found this program!
Xuan Dinh
I've written two exercises that fail my code but my code returns the exact same results as the answer code. What is happening? Is the type wrong? I'm not sure why this is happening if both sets of codes, my written one and the answer code, return the exact same results.
Taylor Stultz
great track!
Miles Flynn
From the very basics to more advanced topics. Interesting and helpful. I highly recommend.
Евгений Скляров
Excellent course for moving from zero knowledge to advanced topics. There are small items that keep it from being five stars. 1. Query results are limited to certain number of rows which, at times, with the larger tables, makes troubleshooting your code problematic. It's akin to flying blind. You can't see the entirety of what your query produces so you literally have to know it off straight theory. Perks to to this I suppose, but causing difficulties for someone brand new to SQL. 2. There are exercises here and there that are not specific enough in the output desired, for example, in one of the exercises, it will not accept a single null value in one column when using a sum function, but directions do not indicate that you must code for it to be a zero. Causes low-key frustration when your code is actually correct in general but the output doesn't match the desired answer exactly. Overall, excellent course, with some minor details that are frustrating and cumbersome.
Daniel St. Clair
Excellent introduction to SQL. Nice job of working the learner from basics to intermediate to advanced topics. Great tool!
Gary Netherton
It was a great adventure, and I'm very thankful for all work you've done. The only thing I missing is the certificate code. You recommend posting it on LinkedIn, but there is no way my contacts can check the accreditation.
Alina Pereverzieva
amazing, exactly what i needed, is a complete guide to what i need to learn and practice step by step, thanks.
Rafael Diaz
This is a great way to learn. I'm a beginner and feel capable of working with SQL. I would recommend this course to anyone looking to learn something new and challenging.
Lautaro Cuevas
It's a pity that the site isn't well known despite being around for 4 years as far as I can tell. The focus on completing hands-on SQL coding practices on a wide variety of datasets that are relevant to the real world is a great approach! Definitely prefer this approach over learning through videos with lesser emphasis on the practical aspects. Hoping for this site to get more recognition in the future!
Jerron Chua Wei Quan