![]() Use the Index is a very useful advanced training site for SQL. It is free to try if you want to take a look. (not sure if that’s just how old this tutorial is, or an honest warning). It’s free-to-use, but may use quite a few intensive resources as it’s running. If you want a more focused and curated approach to learning SQL - this might be it for you.Īnother interactive SQL course, meant to run in the browser. You can read through it and then go through each exercise, feeling like you’re being guided on your journey by the book-like structure. SQLBolt is constructed a bit like a virtual, interactive book on SQL. Yet another text + examples format of teaching SQL, TutorialsPoint does offer more of the same: but if you’re looking for more and more practice or different ways to digest SQL material, it might be handy enough for you. Source: author screenshot 12- TutorialsPoint ![]() If you’re already on KhanAcademy, this could be a perfect transition to you learning SQL. It runs through to the basics until aggregating data - there are projects in between as well. If you prefer a set of curated video tutorials that cover different topics, then look no further than the KhanAcademy course that introduces SQL. The interface is a bit janky, but it’s workable. It is another handy way to practice your SQL skills for free. SQLCourse offers a curriculum with specific exercises for different functions. In case none of the resources above it seem to be working for you, this is another free resource where you can break down and learn SQL functions one-by-one. SQL Tutorial offers an interface like W3Schools without the exercises. It is however meant to be an introduction - don’t expect to become an expert in SQL just by watching this video. It starts going over the basics of SQL, then shifts into the end by talking through different functions and examples on video. If you prefer learning with video content, this 1-hour video tutorial on SQL might just do the trick for you. Notably, there isn’t much here in the way of aggregation functions or subqueries, which other courses above will teach. It follows the same conventional structure of teaching you how to select and query data, then teaching you how to sort and manipulate it within a data table, finally moving to joining and modifying tables. This Sololearn course is interesting because it has different quizzes to make sure you retain material as you’re learning it. That type of content always does well however, because it’s never priced and the focus of the team in question is to deliver maximum quality and substance for your learning objectives. They’re trying to upsell you to their paid product in offering this educational resource. It can help you rapidly place your SQL skills in a context that is like real-world uses, and once again, it’s free. Mode Analytics offers a cool, intuitive interface along with a case study like approach involving Crunchbase data. Source: Author screenshot 6- Mode Analytics I used it a lot to practice SQL as I was picking up data analysis skills and I still use it every once in a while as a refresher. The set of rich, interactive exercises placed in real-world settings is about as close as you’ll get to working with SQL in complex production-level environments without actually being hired. SQLZoo is one of the coolest free SQL resources out there. ![]() You’ll see that several other providers do the same thing as W3Schools, but for me, W3 is the best resource out of the lot. I like looking through individual-level examples of different functions, especially when I’ve forgotten the nuances of one or another. W3Schools offers a text + exercises tutorial that breaks down individual SQL functions. I classified it as a free resource as it doesn’t seem like O’Reilly’s paywalled it. It can be completely free with a free trial of their Safari product (though the trial will run out). This book by O’Reilly entitled SQL Head First helps you dive deep into SQL topics, with tons of examples and writing to help you learn SQL. This free self-paced mini-lesson on databases and SQL allows you to follow along with what top computer science students at Stanford are learning - all this at a self-directed pace, and for the total cost of zero dollars. ![]() Source: author screenshot 2- Stanford Databases Mini-Course ![]()
0 Comments
Leave a Reply. |