23rd Apr 2020 Updated: 8th Oct 2024 16 minutes read Top 3 Platforms to Learn SQL Online: A Complete Comparison Arleta Więch learn sql Table of Contents Learning SQL Platform: LearnSQL.com Course Offering Teaching Method User Experience SQL Focus Additional Resources Pricing Model Learning SQL Platform: DataCamp Course Offering Teaching Method User Experience SQL Focus Additional Resources Pricing Model Learning SQL Platform: Codecademy Course Offering Teaching Method User Experience SQL Focus Additional Resources Pricing Model Choose the Best Place to Learn SQL Online Updated on: October 08, 2024 Do you want to learn SQL online? Where do you start? There are many choices on the internet, and it can be hard to decide. But don’t worry—I tested and compared three major platforms to help you find the best place to learn SQL online! E-learning is still on the rise. It gives us infinite possibilities of growing our professional careers without leaving our homes. And increasing our competencies is especially important now that the labor market has become dynamic and unstable. That’s why you may want to learn SQL online using an online learning platform. It’s a great choice! Interactive online learning environments make learning SQL far more practical than standard courses. And additional resources make it even more fun and effective. The problem is that there are many platforms to choose from, and you probably are wondering which is the best site to learn SQL. Don’t worry, I’ll give you a hand. I tried out three major online platforms for learning SQL: LearnSQL.com, DataCamp, and Codecademy. Below, you’ll find my complete comparison covering aspects such as teaching methods, UX, learning resources, and pricing. Let's get started! Learning SQL Platform: LearnSQL.com LearnSQL.com only offers SQL courses so it’s the perfect place to go if you want a platform that is solely focused on SQL. Each course is written by experienced SQL professionals so you get high-quality content that is grounded in real-world applications. One of the best things about this platform is the emphasis on practical learning. While you are introduced to theoretical concepts, the courses are designed to get you hands-on. You’ll work through a ton of real-world exercises that mimic the challenges you’ll face in the real world. This will not only help you understand the SQL syntax and functions but also give you the skills to tackle actual data tasks. By focusing on practice LearnSQL.com helps you build confidence and prepares you for data analysis and database management. Course Offering As I’ve mentioned, LearnSQL.com only teaches SQL skills, but you can choose from a variety of courses. They’re grouped into paths, tracks, and mini tracks. However, it doesn’t prevent you from learning SQL with a single course. If you’re a data analysis newbie or a basic-level programmer, you’ll benefit most from the Analytical Path. It teaches SQL querying and reporting for analyzing datasets and getting key insights from data. Its main track, SQL from A to Z, consists of seven courses designed for users learning SQL from scratch. Finishing this track takes approximately two to three weeks, and it lets you work with data independently. Do you want to see if data analysis is for you? Take a look at the SQL Basics course—it’ll help you learn the absolutely necessary fundamentals in approximately 10 hours. Then, you can decide if you want to dive deeper. All of the courses on this platform have three versions: Standard SQL, Microsoft Server SQL, MySQL, and PostgreSQL. These are different “dialects” of SQL (i.e., varieties used in different database management systems). They’re mostly similar but differ in some built-in functions, naming conventions, and error messages. It’s super useful that LearnSQL.com allows you to choose which version. Once you learn Microsoft Server SQL, it’s pretty annoying to switch to PostgreSQL. Most programming platforms offer just one of the dialects without referencing to the others. Other courses powered by LearnSQL.com cover practical topics such as generating SQL reports or analyzing revenue trends (especially useful for business professionals). There’s also a special course with only exercises called SQL Practice Set—I strongly recommend you to take it once you finish learning SQL at the basic level. Programming is like a sport: you need training and practice to become a professional. The same goes for learning SQL and writing code. Currently, LearnSQL.com offers 20 learning tracks and over 70 individual courses, but their developers are continually working on adding more courses. I recommend visiting their page regularly to stay up-to-date. Teaching Method Learning SQL with this platform is very practical because all courses feature loads of exercises. They’re based on real-world examples, mainly from the business field (so you’ll work with revenue spreadsheets, HR databases, and so on). If you’re seeking an analytical job within business operations or want to learn SQL online to power up your business skills, you’ll find it very useful. The courses on LearnSQL.com include a number of lessons followed by either a quiz or a summary, serving as a quick recap of what has been learned. New concepts are explained through short descriptions with examples. If you prefer extensive theoretical explanations, you may find them scarce. But it’s worth remembering that programming is all about practice, so it’s good to get down to coding ASAP. I found all of the recaps crystal clear and didn’t have additional questions (but if you do have them, you can always ask LearnSQL.com specialists using the Disqus tab). Another good thing about learning SQL with this platform is that you write the code yourself. Some e-learning platforms teach programming by giving out strings with blank spaces to fill in. It may seem helpful, especially for beginners, but to become skillful at any programming language, you need to write thousands of lines yourself. User Experience Creating an account on this platform takes seconds (yes, seconds). You can use your Google or Facebook profile or simply create a new one. Once set up, you can use it to take a look at some free exercises from your chosen course. LearnSQL.com provides an interactive programming environment, which means you don’t have to install a database management system on your device. You write and execute your code directly in the browser and get instant feedback if anything’s wrong. The platform is easy to navigate and intuitive. The interactive console also works smoothly. Whenever you get stuck, you can either get a hint or see the full answer, but in most cases, the error messages displayed after running your code are enough. Last but not least: there’s a dark mode! Most users, including me, prefer working on a dark interface. Surprisingly, not all platforms provide it. SQL Focus As I‘ve said, on this platform, you can only learn SQL. It doesn’t provide courses in other languages, which makes it unique on the e-learning market, which is full of all-in-one solutions. If you’ve decided to learn SQL, a specialized platform like this one is a great choice. The specialization provides high-quality content created by professionals in the chosen field (on LearnSQL.com, they’re delivered by experienced SQL developers). Additional Resources LearnSQL.com offers an extensive library of articles explaining how to learn SQL online quickly and efficiently. Apart from learning tips, you’ll find additional explanations regarding useful SQL functions, developers’ stories, or advice on how to write code that’s easy to read. New articles are published almost every day! There’s also a special section called Cookbook. It’s a collection of simple, recipe-like entries covering single SQL problems and their solutions. They guide you step-by-step through the coding challenge you’re facing and give you a clear solution (with fragments of code presented). It’s super useful if you’re searching for a quick solution. And they’re sorted by database types (Standard SQL, MS SQL, etc.) to help you find your answer quickly. LearnSQL.com offers a comprehensive SQL Skill Assessment tool, designed to evaluate your current SQL knowledge and identify areas for improvement. This interactive feature helps you gauge your proficiency and tailor your learning path accordingly. For those starting from scratch, the SQL Primer is an invaluable resource that covers fundamental concepts in a straightforward manner, ensuring you build a solid foundation before diving deeper into more complex topics. Moreover, LearnSQL.com provides a collection of handy cheat sheets, which serve as quick references for various SQL commands and functions. These cheat sheets are perfect for beginners and experienced users alike, offering concise summaries that can save you time while coding and help reinforce your learning on the go. Pricing Model To learn SQL online with this platform, you need to create an account (as I’ve said, it takes seconds). It gives you free access to several exercises from the first lessons of each course so that you can test them out. If you like the platform and want to start learning SQL for real, you’ll need to purchase a single course ($39), tracks or All Forever Package - access to all curent and future courses on the platform. There is also a Business plan for enterprise clients. It doesn’t have fixed pricing, so you will need to contact the LearnSQL.com team for details. It provides access to custom courses, an early access program, a dedicated success manager, and an additional learning management portal, which allows you to track user progress. Check the details here. Learning SQL Platform: DataCamp DataCamp is a platform that offers numerous basic and advanced courses in data science. They cover nine technologies, including SQL. The courses are taught mainly by internal DataCamp developers but also university professors and business professionals. Learning SQL with this platform is slightly different from LearnSQL.com because DataCamp doesn’t focus exclusively on SQL. Plus, it uses a different learning method. Course Offering On DataCamp, you can browse the course catalogue by technology or topic. There are several technologies to choose from and a separate category for theoretical courses. The topics cover data engineering, data manipulation, statistics, reporting, etc. DataCamp offers career tracks and skill tracks. They make learning SQL more goal-oriented, and you need to know what you’re looking for. There’s one career track for those interested in learning SQL called Data Analyst with SQL Server. As far as skill tracks, new learners will benefit most from SQL Fundamentals or SQL Server Fundamentals, depending on the chosen database. Unfortunately, DataCamp skill tracks don’t cover other SQL variations (e.g., the popular PostgreSQL). The platform has 34 courses for learning SQL at basic and more advanced levels. Teaching Method Learning SQL on DataCamp is slightly different from LearnSQL.com. DataCamp courses start with short videos with simple slides that are commented on by a teacher. After this theoretical introduction, you move on to exercises with written explanations. While learning SQL, you can go back to the video or view the slides. DataCamp courses consist of several chapters, including lessons and a summary. Most lessons end with a final exercise that’s slightly more complex than the others. The explanations are clear, so doing the exercises shouldn’t be problematic. If you’re an auditory learner, you’ll probably find the videos cool. For me, it’s easier to follow written text while learning SQL—I need to focus on new concepts and give myself enough time to grasp them. That’s why I didn’t find the videos very useful and preferred to go directly to the descriptions. On DataCamp, you don’t really write code yourself. When learning SQL with the basic courses, you instead fill in blank spaces with single words or clauses. You’re provided most of the necessary strings and instructions explaining what each line of your code should do. It’s at the same time good and bad: good because it makes learning SQL easier and helps you understand everything fully, but bad because it doesn’t provide enough practice. I prefer to write code myself, so I mostly deleted the code provided in the lessons and wrote it again. User Experience Creating an account on DataCamp is super quick. You can either provide your email and create a password or use your Google, Facebook, or LinkedIn account. After logging in for the first time, the system asks you about your preferred technology and the topic you’re interested in (e.g., reporting, Machine Learning, business analytics, etc.) and suggests suitable courses. You can start learning instantly, but the free account only gives you access to the first chapter of each course. If you already have some SQL skills, you can test your knowledge with DataCamp’s assessment tool. Using DataCamp is simple and intuitive, and navigating through the website is easy. However, at first, you may have problems understanding what each page contains because there are many of them: career tracks, skill tracks, courses, practice, projects… Interestingly, the platform offers many additional resources (I’ll explain it later on), but not all of them are accessible from the user dashboard. To access them, you have to enter the Community section from the home page, which is visible after logging out. Just like LearnSQL.com, DataCamp provides an interactive environment that allows writing and executing queries in your browser. While learning SQL with its courses, you get instant feedback on what’s wrong with your code, and you can also use hints. And there’s a dark mode! Unfortunately, it doesn’t cover the whole interface—the console gets dark, but the instructions remain light. Pity! SQL Focus DataCamp is a platform for learning various analytical languages. It’s a one-stop-shop for data science professionals, not only those interested in learning SQL. It offers courses in nine technologies, including popular languages like R, Python, and Git, and some additional chapters providing theoretical background for business professionals. While you’re browsing the course catalogue, it becomes clear that the platform is not focused on SQL. It offers some courses in SQL, much more in Python, and even more in R. The other technologies have even fewer courses than SQL, so I’d say that it’s specialized in Python and R. Additional Resources DataCamp has an extensive section of additional resources. First of all, it offers Practice and Projects: additional learning materials for practicing newly acquired skills. Practice sets include quizzes while Projects are…well, projects that are based on real-world data. Unfortunately, because DataCamp doesn’t focus on SQL, there are only two Practice sets and one Project for this SQL. There’s also a separate page called DataCamp Community where you’ll find more resources. It features a data science blog (for basic and advanced users), a podcast (definitely for advanced users), cheat sheets (mainly for Python and R; no SQL here), and step-by-step tutorials (mainly for Python programmers; I found only a few for SQL). As I’ve said, most of the resources are not available from the user dashboard, so make sure to access them directly or from the DataCamp homepage. Pricing Model To learn SQL on DataCamp, you need to create a free account. Once you have it, you get access to the first chapter of each course, challenges, a one-time skill assessment, and seven projects. To continue learning, you need to purchase a subscription plan: Premium for $13/month: access our full content library Teams for $25/month: access to all courses and ability to view learning activity and track progress There’s also the Enterprise plan for business users (no fixed pricing; contact DataCamp for details). You’ll find the description of all plans here. Learning SQL Platform: Codecademy Codecademy is another one-stop-shop platform for basic and advanced developers. Apart from learning SQL, you can use it to dive into web development, design, other data science technologies, and more. It offers many programming languages in total, which is a robust course catalogue. Course Offering On Codecademy, you can browse the course catalogue by subject (web development, programming, data science, etc.) or language. There are 13 technologies to choose from, including SQL. The courses are grouped into career paths and skill paths. The only career path including SQL, Data Science, also covers Python, Data Visualization, and Machine Learning. There’s also one SQL skill path called Analyze Data with SQL that takes approximately six weeks to complete (counting lessons, articles to read, quizzes to take, and projects to complete). Codecademy offers 10 SQL courses in total: some elementary and others slightly more advanced (I’d call them intermediate). However, if you’re not sure if SQL is the one, Codecademy will help you choose your technology with a short quiz assessing your personal abilities. I’m not sure about its usefulness though. I took it and got similar results in all four programming language categories. The platform doesn’t offer any courses for learning SQL at an advanced level. Teaching Method On Codecademy, you learn SQL with textual explanations. The teachers (developers collaborating with the platform from around the world) provide you with simple descriptions of new concepts and sample code lines. After getting familiar with a new concept, you have to complete an exercise. Codecademy courses include several lessons and a review summarizing key concepts. Most of these lessons feature a cheat sheet with SQL functions, keywords, etc. (they’re nice, but not formatted for printing—pity!). After completing a course, you’re encouraged to do an additional project. I generally found the instructions clear, but sometimes I did have questions. In such cases, Codecademy redirected me to its user forum where I was likely to find an answer. On Codecademy, unlike at DataCamp, you write the code yourself from scratch. User Experience The platform allows you to create an account using your LinkedIn, Google, Facebook, GitHub, or Twitter profile. After logging in, you can immediately get down to learning SQL with the basic course, but you only have access to the first lesson. For more, you need to purchase a paid plan. Navigating through the website is rather easy. The user dashboard is simple as well, but I found the homepage a bit stacked. The platform shows you your courses, suggested practice and projects, new content, support tabs, and community hyperlinks all on one page! It’s a bit overwhelming. Codecademy also provides an interactive coding environment that doesn’t require installing databases on your computer. While doing exercises, you make use of a built-in console that works smoothly. If you get stuck, you can get a hint, take a look at a cheat sheet, or look for an answer in the Codecademy community forum. Just like on other platforms, you get instant feedback on what’s wrong with your code. Interestingly, Codecademy has only a dark mode! However, it works like the one at DataCamp: the console is dark while instructions remain light. SQL Focus Codecademy is similar to DataCamp: it’s an all-in-one platform. However, it’s not for data science only. Apart from learning SQL, you can use it for learning other programming languages such as Java, Ruby, C++, PHP, or Swift. Python and JavaScript have the most courses. Codecademy has only a couple of courses devoted to SQL, which is the lowest number of the three platforms I’ve tested. It clearly shows that SQL isn’t its primary focus. Additional Resources Codecademy offers some additional resources that make learning SQL more effective. First of all, it features projects based on genuine databases and practice sets including quizzes. You can use them to practice your new SQL skills. The platform also has a blog section with entries on learning programming online, new courses, and news from the tech world. There are also posts about data science and developing in general, which are targeted to newbies. You can get some knowledge from the Codecademy articles page with content grouped by languages. Unfortunately, there is no SQL section. There is also a forum section where you can ask questions and discuss ideas. That’s where the lessons redirect to. Pricing Model To learn SQL online with Codecademy, you need to create a free account. It gives you full access to basic courses (obviously, there are only a few of them, and they’re elementary). To enjoy more benefits, you will need to purchase a subscription plan: PLUS for $29.99/month PRO for $39.99/month: access to non-basic courses, mobile practice, projects, and peer support There’s also a plan called Teams for enterprise clients without fixed pricing (contact Codecademy for details). Check out the plans here. Choose the Best Place to Learn SQL Online I hope that my comparison will help you choose your platform for learning SQL online. All of them have their pros and cons, so think about your learning priorities, set your goals, and…learn! Below, you’ll find a short summary of my comparison: AspectLearnSQL.comDataCampCodecademy Courses72 (basic and advanced level)34 (basic and advanced level)10 (basic level) MethodTextual explanations + write the codeVideos + fill in blank spacesTextual explanations + write the code UXIntuitive and simple + dark modeIntuitive and simple + semi-dark modeRather simple + semi-dark mode FocusSQLData scienceProgramming ResourcesArticles + cookbooks + cheat sheets and moreDataCamp CommunityPractice + Projects, blog, articles, forum Tags: learn sql