SQLBolt is a series of short lessons and hands-on exercises that teach SQL. You don’t sit and listen to queries. They are typed in the browser and you get results immediately. The lessons include SELECT, filtering and sorting, joins, expressions, aggregate functions, and inserting, updating and deleting records. Useful for learning good hands-on skills before trying any system such as MySQL or PostgreSQL.

The skills learned: SQL fundamentals, Select, Where, Sort, Join, Aggregate, Insert, Update, Delete, and Database Table Concepts.

Who is it for? For people who have little or no SQL knowledge who wish to perform queries in an interactive manner.

Why choose it? When you study each idea you will write a query, and it will be much easier to see how SQL works.

A good introduction to SQL is the W3Schools SQL tutorial. It combines explanations, examples, and interactive exercises to allow experimenting with syntax along the way. It covers the concepts of creating and modifying database structures, queries, and filtering and sorting, joins, functions, and constraints.

You will learn the SQL syntax, SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, CREATE DATABASE, CREATE TABLE, JOIN, aggregate functions and constraints.

Who is it for? For those who need a simple introduction to SQL and database management.

Why choose it? There’s no setup whatsoever, the explanations are short and the examples run in your web browser.

The official PostgreSQL tutorial introduces the database, core relational databases concepts and the SQL language. It’s designed to provide hands-on experience of the features that are most important. You create databases and tables, insert records, query data, and work with joins, aggregate functions, views, foreign keys, transactions and window functions.

In this course, you will learn: Introduction to PostgreSQL, Database creation, Table creation, Data queries, Joins, Aggregate functions, Foreign keys, Transactions, Window functions.

Who is it for? People who are new to SQL and PostgreSQL and need to learn both at the same time.

Why choose it? It covers general database concepts as well as examples of using PostgreSQL, and is part of the official documentation.

This part of the PostgreSQL documentation goes into detail on using SQL with PostgreSQL databases. It goes beyond the basics and delves into SQL commands, data definition, data manipulation, queries, data types, functions, and operators. It is best used immediately after a beginning tutorial when you wish to enhance your “hands-on” instruction.

What you’ll learn: SQL commands, data definition, data manipulation, queries, PostgreSQL data types, functions, operators, tables, constraints and advanced SQL concepts.

Who is it for? Developers or learners with some SQL experience who wish to have a reference guide to PostgreSQL.

Why choose it? The technical detail is from the actual PostgreSQL project.

MySQL is one of the most widely used relational database systems, and has an official document with a dedicated tutorial. It explains how to create databases, tables, how to retrieve data, how to add data, multiple tables and foreign keys. It is a good basis if you are going to utilize MySQL with PHP, WordPress, web applications and/or again end growth.

What you’ll learn: MySQL basics, database creation, tables, SQL queries, INSERT, UPDATE, DELETE, working with multiple tables, foreign keys and database administration basics.

Who is it for? Anyone looking to learn MySQL from the official documentation, as well as SQL.

Why choose it? They are straight out of the MySQL docs, so they serve as a tutorial and a comprehensive reference.

The MySQL Reference Manual is a huge technical resource on the database system. It includes SQL statements, data types, database administration, security, optimization, indexes, replication and storage engines. It is not a video course per se, but it is an important reference for the developers and database administrators.

You’ll learn: MySQL Architecture, SQL Statements, Data Types, Indexes, Administration, Security, Optimization, Storage Engines, Replication, Backup & Recovery.

Who is it for? Intermediate and advanced learners who need detailed MySQL technical information.

Why choose it? It is the official reference, and it becomes very useful once you work on real projects.

Whether you are developing, administering, modeling data for MongoDB, or searching for other DB resources, MongoDB University provides you with self-paced learning. Free skills, labs and learning paths are available on the platform. The catalog can be sorted by expertise, learning method and paid or free, which makes it easy to find what is free.

You will learn: MongoDB basics, NoSQL databases, document database, CRUD operations, MongoDB data modeling, data aggregation, MongoDB Atlas, administration, search and performance.

Who is it for? For beginners, as well as after more advanced MongoDB skills for developers and administrators.

Why choose it? A collection of mongo specific material, such as free skills and practical labs.

Getting Started with MongoDB is an interactive tutorial for introducing those new to document databases to the concepts of MongoDB. This beginner-friendly tutorial introduces MongoDB and walks you through the basic steps for getting started with the database. This is an easy introduction if you aren’t familiar with NoSQL.

You will learn how to start using MongoDB, collections, documents, inserting, querying, updating and deleting data, and get your first look at MongoDB Atlas.

Who is it for? Completely new to MongoDB users who are looking for their first hands-on experience with MongoDB without installing a database server.

Why choose it? Try out for free in the browser.

The basic operations performed on data in the database are called CRUD operations. There is a free skill on creating, reading, updating and deleting records in MongoDB’s learning platform. You see how documents are inserted, queried, modified and removed, and CRUD Operations in MongoDB is currently listed among the free skills.

What you’ll learn: create, read, update and delete operations, MongoDB queries, documents, collections and basic database operations.

Who is it for? Apprentices with a basic programming ability seeking the basic functions for interacting with MongoDB.

Why choose it? CRUD is a first MongoDB skill that is used in almost all database driven applications.

A crucial aspect of a good database design is data modeling. MongoDB’s platform has resources on designing document schemas, modeling relationships and picking the right structure for your application. There is a dedicated Data Modeling learning path in the catalog and schema patterns appear in the skills catalog, along with related content.

You will learn: MongoDB data modeling, document schema design, embedded and referenced documents, relationships, schema patterns, modeling for workloads and schema validation.

Who is it for? Developers with some basic knowledge of how to use MongoDB and are looking to design databases for real applications.

Why choose it? The impact of good data modeling on the efficiency of an application in storing and retrieving information is real.

Khan Academy’s Intro to SQL course is an interactive way to learn querying and managing data. Lessons include Table creation, Inserting Data, Table queries, Aggregating Data and using related tables. You work the same way in the browser, which many prefer over just reading syntax. Advanced queries, relational queries and database projects are then covered in the curriculum.

The database fundamentals, table creation, data insertion, SELECT statements, filtering, sorting, aggregation, GROUP BY, HAVING, JOINs, and database projects will be covered.

Who is it for? A beginning course for those who wish to learn SQL and database query from scratch.

Why choose it? All explanations, challenges, projects and interactive SQL environment are all in one place.

The SQL Basics section provides basic SQL operation to work with relational data. You add data to tables; retrieve, filter, sort, and perform simple aggregation on table data. The challenges are real-world ones, for instance, creating data bases on books, groceries and other data sets.

You will learn: CREATE TABLE, INSERT, SELECT, WHERE, ORDER BY, aggregate functions, database tables and a few small SQL projects.

Who is it for? Beginner SQL learners looking to get up to speed with SQL before moving onto other lessons.

Why choose it? You receive instant feedback on your browser and SQL is built up in small tasks.

Khan Academy provides a free, interactive course unit covering more advanced SQL queries and techniques for working with databases.

After mastering the fundamentals, Khan Academy’s more advanced lessons lead the way. They add complex conditions, IN queries and subqueries, HAVING, CASE and many other methods for processing and analyzing relational data. Practical challenges and projects are provided.

You will learn about: AND and OR conditions, IN, subqueries, GROUP BY, HAVING, CASE, advanced filtering and SQL data analysis.

Who is it for? Students with existing knowledge of basic SELECT statements, who desire more advanced SQL.

Why choose it? It explains where the beginner SQL skills starts and the real-world database techniques begin.

IELTS is an interactive course unit that provides you with a variety of practice exercises for all four skills: writing, reading, listening, and speaking.IELTS is an interactive course unit that gives you a range of practice activities for each skill (writing, reading, listening, speaking).

Most relational databases store data in a number of related tables, and SQL JOIN can be used to retrieve the data. The lessons on Khan Academy focus on joining related tables, left outer joins, self-joins, combining multiple joins and query optimization.

You will learn: relational databases, JOIN, LEFT JOIN, self-join, multiple join, foreign-key relationships, query planning, query optimization.

Who is it for? Students who have some experience with SQL, and wish to become familiar with working with several connected tables.

Why choose it? JOINs are one of the most essential SQL concepts and are learned in the course by using examples.

SQLZoo is an interactive learning website, where you can write and execute SQL queries in the browser. The tutorials begin with simple SELECT statements and progress to aggregate functions, JOINs, subqueries, NULL values, window functions and other concepts of query.

You will learn selecting elements, using WHERE clause, ordering elements with ORDER BY, using SUM and COUNT, grouping with GROUP BY, creating JOINs, using subqueries, advanced SQL and handling values of the SQL NULL type.

Who is it for? For those just starting out who would like to get some practice, and intermediate students who would like more query practice.

Why choose it? Test a query as it is being typed and experiment to learn.

Stanford provides university level education on database systems, relational databases, SQL and database design. These materials are useful if you need to dig deeper than just the syntax, and learn what is going on under the hood of contemporary database systems.

This course covers: database systems, relational databases, SQL, database design, query processing, database architecture, transactions and data management.

Who is it for? Programmers or SQL users who would like to expand their knowledge of databases.

Why choose it? Short introductory tutorials don’t provide as solid a grounding in theory as university material.

freeCodeCamp’s free Relational Database course provides interactive lessons and projects to learn about databases and backend development. It teaches the concepts of SQL and relational databases, Bash scripting, Git and PostgreSQL. The curriculum is delivered via the browser, without the need for the entire environment to be installed locally.

You will learn about relational databases, PostgreSQL, SQL, Bash, Git, Database design, CRUD operations and Database projects.

Who is it for? Anyone interested in starting to learn about databases who wants to take their back-end skills to the next level.

Why choose it? Mixes theory, practical projects and links database skills to the command line and development workflows.

SQLite is a low-level relational database engine which is used by many applications that do not require a dedicated database server. Official documentation contains tutorials and technical information about SQL, database files, tables, queries, indexes, transactions and features that are specific to SQLite. Due to its lightness, you can try without establishing a server.

You will learn: SQLite basics, SQL, tables, queries, indexes, transactions, database files and database design concepts.

Who is it for? Developers who need to get started with relational databases, but don’t have access to a heavyweight DBMS.

Why choose it? SQLite is simple to experiment with, utilized in applications, embedded systems and mobile programming.

The Intro to SQL course on Kaggle is an interactive online course that teaches the basics of SQL with hands-on exercises. It includes writing SQL queries, selection and filtering of data, sorting of data, grouping of data, use of aggregate functions and joins of multiple tables. The course is geared toward beginners, and uses a browser based environment for practicing SQL.

You will learn: SQL syntax, SELECT statements, WHERE, ORDER BY, GROUP BY, HAVING, aggregate functions, common table expressions (CTEs), JOINs, and relational data.

Who is it for? Those who are new to SQL and would like to learn how to query a database practically.

Why choose it? It is a blend of short lessons, hands-on SQL exercises that will be useful to learn and practice SQL database queries.

HackerRank provides SQL challenges that will help you practice solving problems using SQL queries to solve programming style problems. Practice in basic SELECT, filtering, aggregation, joins and advanced SQL. Excellent for after an introductory course, using the knowledge learned to solve problems independently.

You will learn: Filtering, Aggregation, GROUP BY, JOINs, subqueries, advanced SQL, and problem solving using SQL.

Who is it for? Students with some SQL experience and seeking to improve their ability to write queries.

Why choose it? Challenges—Answer questions with respect to a database without any step-by-step instructions.

Database Management Essentials teaches the fundamentals of the storage, organization and management of information in databases. It introduces new concepts and terminology, and also has a brief chapter on relational databases, SQL, and the database management systems to help the reader get comfortable with terminology before learning tools such as MySQL, PostgreSQL, or MongoDB.

You will learn: Principles of a Database, Database Management Systems, Relational Databases, Tables and Records, and SQL Basics and Data Organization.

Who is it for? Students, beginners and aspiring developers who want a general introduction to database management.

Why choose it? It gives you a broader foundation before you specialize in one platform.

MongoDB for Beginners introduces concepts of MongoDB and document-oriented NoSQL databases. You can observe that it stores data as documents and collections, rather than rows and tables like relational databases. For developers familiar with basic database concepts and are interested in experimenting with NoSQL development, it is convenient.

What you will gain: Knowledge of MongoDB basics, NoSQL databases, documents, collections, CRUD operations, queries and the MongoDB data structure.

Who is it for? For beginners looking to learn about MongoDB and Document Oriented Databases.

Why choose it? By learning the document model, you will get a sense of the differences between NoSQL and relational systems.

Normalization is one of the fundamental concepts in the design of relational databases. It makes it easier to structure the data in related tables, and eliminates unnecessary data duplication. This introduction covers the design principles of first, second and third normal form, before you implement any of these in MySQL or PostgreSQL.

The learner will gain knowledge on database normalization, 1st, 2nd and 3rd Normal Form, Functional Dependency, Data Redundancy and Decomposition.

Who is it for? For students or beginners, who wish to learn about the normalized relational databases.

Why choose it? Normalization appears frequently in courses on databases, and in real development.

NPTEL has courses on Database Management Systems (DMS) at the university level taught through lectures by faculty from the Indian Institutes of Technology and other institutes. Usually these courses include relational concepts, SQL, relational algebra, database design, normalization, transactions, indexing, query processing and concurrency control. They are designed for those who are interested in gaining a deeper understanding of the role of databases, and not necessarily SQL syntax.

You will learn about: Database management systems, relational algebra, SQL, database design, normalization, transactions, concurrency control, indexing and query processing.

Who is it for? Computer science students, developers and learners who require knowledge of database systems at university level.

Why choose it? The organized lectures facilitate the understanding of the theoretical aspects of databases employed in practical software development.

GeeksforGeeks has a vast collection of tutorials and articles covering the basics to the advanced topics of SQL and databases. It contains queries, Database commands, joins, Constraints, Normalization, sub-queries, Functions, Transactions, Indexes and interview Questions. It is a good choice for students who enjoy the conceptual approach to learning, with examples and coding practice.

You will learn: SQL commands, basics of SQL, SELECT statements, JOINs, subqueries, SQL constraints, functions, transactions, indexes and normalization.

Who is it for? Students, developers and job seekers who are getting ready for SQL and database interviews.

Why choose it? It is useful for learning and revision thanks to the numerous examples and practice questions.