Learn SQL Online

As one of the most popular databases, MySQL is used by services such as WordPress. MySQL is fast and relatively easy to use, so if you're learning SQL for web development and prefer to get straight into learning MySQL while you learn SQL, be sure to check out the documentation.

If you're planning to set up a database for a complex website and want to use an open-source, powerful RDBM (Relational Database Managment System), perhaps you'd want to look into PostgreSQL. If so, their documentation should be quite helpful in learning both SQL and PostgreSQL.

This lightweight system is mostly used to handle databases for mobile apps, and if you're learning SQL to handle data from apps, you'd want to look into the documentations on SQLite.

This introductory tutorial will quickly walk you through the basics of SQL programming with exercises at the end of each chapter. There are also several tutorials for things such as MySQL, Oracle, and SQL Server.

If you want to have a bit of fun while you learn SQL, you might want to give GalaXQL a try. This is an interactive tutorial where you can visually see the results of your coding as you use SQL to manipulate the code, and as such, the tutorial has been praised by many.

SQL Zoo walks you through exercises and lets you run your code and see the results. It's a fairly interactive tutorial that is very helpful, and at the end you can take a quiz to test how well you've absorbed the information. There are also guides on how to get started on things like MySQL and PostgreSQL.

The famous series of learn code the hard way also covers SQL. The guide is clearly written and and will walk you through exercises so you can learn as you go. It uses SQLite as a training tool.

This site provides video tutorials for SQL development, and each video comes with notes that you can use to review what you've learned. Although it is labeled for MySQL, it nonetheless focuses on teaching you the basics of SQL programming.

This site will teach you the basics of how to code with SQL queries, and the concise tutorial is easy to follow.

This popular and free online course on MySQL is highly rated for a reason. Beginners have really found the course helpful and easy to follow, and the instructor has a way with teaching, so if you're a total beginner to SQL, be sure to take a look.

This site hosts an interactive tutorial where you can follow along, execute your queries through interpreters, and see the results. The site also provides guides to introduce you to RDBMs such as MySQL, PostgreSQL, Oracle, and more. Once you think you've gotten the basics down, you can test your knowledge through tests on their sister site

Tutorial‘s point's SQL guide provides simple tutorials to learn SQL basics through sample code that will help you understand how things work. They also have several tutorials for more advanced SQL coding, and a PostgreSQL,MySQL, SQLite and more.

This guide provides a clearly written tutorial on how to set up Postgres as well as some basic SQL introduction. The guide also has general Postgres tips along with performance tricks for database optimization.

This is a free, short ebook introducing beginners to SQL coding. No prior experience with SQL is required, and although it is written with Ingres as the RDBM, the code would work on any SQL-compliant database management system.

Split up into several mini-courses to help you control your own learning pace, this online course will introduce you to databases will teach you the basics. There are in-video and in-depth standalone quizzes to check your understanding.

This site offers video course that teaches you how to execute a SQL transaction, run SQL queries, or master database administration in general. There are some free video tutorials you can watch after registering, and if you find the courses helpful, you can become a paid member to have unlimited access to the video courses on the site.

This 3 hours and 22 minutes course will walk you through SQL basics and teach you how to use SQL, such as how to add, change, remove data to SQL-compliant databases and more. As the site is based on membership subscription, they also offer other SQL courses, such as MySQL Performance Optimization and how to use SQL with big data.

Although the tutorial is not specifically about SQL but rather PostgreSQL, you can nevertheless still learn SQL while you learn PostgreSQL. The first few videos are free, and if like what you've learned, you can become a paid member to finish up the course. Like other subscription sites, you'll be able to access other videos on the site.

For tips on common pitfalls to tricks to how to better optimize and use your MySQL database, this blog is regularly updated by varios MySQL experts and should be pretty helpful for any developer looking to work with MySQL.

If you're looking to develop with Postgres, this site is definitely the place to go for your fix of Postgres tips and tricks. It's a fairly new site so there aren't much in the archives, but it's updated regularly and you'll be sure to find some useful things.

Previously an employee of Microsoft, the blog owner Paul is one of the most active people on the SQL Server community. On his blog, he posts his answers to questions people have asked him, and you may just find the articles quite helpful.

This popular blog mostly features tips and advice for those working with SQL Servers, so if you're planning to work with those, be sure to check this frequently updated site out.

Whether you're going to be working with databases such as MySQL, SQL Server, or Oracle, you should take a look at this site. If you dig around a bit, you should find several hidden gems.

As a guide to database performance, this site provides tips on how to become a more effective database developer. You can learn about SQL indexing from the source code perspective, and the site covers DB2, MySQL, PostgreSQL, Oracle, and SQL Server.

Practice makes perfect. If you aren't learning SQL for web development, haven't decided what RDBM to use, or just need to quickly test a code, you can make use of this online coding playground where you can run your code without having to download anything else.

An IDE for SQL development in general, 0xDBE will provide coding assistance, detect bugs and suggest fixes on the fly, automatically format your code, and more. It has a neat table editor to boost your efficiency, and you can easily manage your schema with it. For those who want to improve their productivity, this is a good choice.

For a painless way to manage your postgres database and make scaling easier, Heroku Postgres is the way to go. It is secure and easy to set up, and you can access it from anywhere through SSL connections. There are a plethora of other features available, so if you're interested in the platform, be sure to check it out.

Vertabelo is a cross-platform online database visual designer that allows users to share database models across the team and collaborate on projects via their web browser at the same time. It has a clean user interface, making it easy to navigate through your database models.

This GUI for MySQL integrates SQL development, modeling, atabase design, creation and maintenance into a single development environment. Overall, many MySQL developers have found the visual interface helpful for developing databases.

Despite its name, this is a web-based SQLite administration tool written in php, so you won't need to install any additional software to manage your SQLite database. You'll just need to download the source-file and drop it in a directory of your servery for it to work, as it is accessed through your browser. For those who plan on working with SQLite, this should be a handy tool.

A multi-purpose administration tool for database management, control and development, AnySQL Maestro will help you design databases. It has a visual query builder and provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. Naturally the freeware edition doesn't have all these features, but you can try it out and see if the tool works for you.