DEV Community

loading...
Cover image for Top 7 Resources to Learn SQL

Top 7 Resources to Learn SQL

Tamerlan Gudabayev
Learning is fun
Originally published at softwareadventuring.com ・Updated on ・2 min read

So, you want to go on the path of SQL?

But don't know where to start?

Well, look no further.

I've compiled a list of the best SQL resources I could find on the internet.

PS. If I miss anything, feel free to comment about it in the comments.

SQL Bolt

Alt Text

This is the platform I used when I first started learning about SQL. It's basically a bunch of interactive lessons that teach you the basics of SQL. I would highly recommend this to beginners, or to someone wishing to freshen up their knowledge.

SQL Zoo

Alt Text

SQL Zoo is a collection of tests that push your SQL knowledge to the limits. I've done this right after SQL Bolt and it helped immensely. The challenges range from easy ones that you can solve in a couple of seconds to hard ones where your brains are pushed to it's limits.

Use the Index Luke

Alt Text

After you get the basics of SQL down, you might want to check out "Use the Index, Luke!". It's a site that teaches you about writing efficient SQL code.

PostgreSQL Exercises

Alt Text

PostgreSQL is one of the world's most popular database management systems. With that in mind, this platform has a bunch of exercises to test your SQL and PostgreSQL knowledge.

Khan Academy

Alt Text

I've used Khan Academy for all sorts of subjects and they never disappoint. This course offered by them covers the basics of SQL to more advanced topics such as JOINS, etc...

Udacity

Alt Text

If your more of a visual learner, I would recommend checking out Udacity "Into to Relational Databases". It covers beginner and intermediate topics. Along with the videos, it also included coding exercises. Heck, you might even continue on and take their nanodegree.

SQL for Web Nerds

Alt Text

This is more of an advanced course, it teaches you the gritty details of SQL. It was developed by MIT Professor Philip Greenspun. The site isn't flashy, but it offers expert-level content.

Conclusion

I hope you found some of the resources useful, and have begun your SQL journey.

Thanks for reading!

Discussion (3)

Collapse
bobbyiliev profile image
Bobby Iliev

I could also suggest this open-source eBook here too:

GitHub logo bobbyiliev / introduction-to-sql

Free Introduction to SQL eBook

πŸ’‘ Introduction to SQL

This is an open-source introduction to SQL guide that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career.

The guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL.

πŸš€ Download

To download a copy of the ebook use one of the following links:

πŸ“˜ Chapters

  • About the book
  • Databases
  • MySQL
  • Tables
  • Basic Syntax
  • SELECT
  • WHERE
  • ORDER and GROUP BY
  • INSERT
  • UPDATE
  • DELETE
  • JOIN
  • The MySQL dump command
  • Conclusion

🌟 Sponsors

This book is made possible thanks to these fantastic companies!

πŸ’™ DigitalOcean

DigitalOcean is a cloud services platform delivering…

Collapse
alan2207 profile image
Alan Alickovic

Great list, thanks for sharing!

Dataguide from Prisma is also a great resource to learn about databases:
prisma.io/dataguide/

Collapse
shahbazpycread profile image
MOHAMMAD SHAHBAZ ALAM

Thank you for sharing.
SelectStarSql and Mode are also great resources to learn SQL.