2023

We provide three options for learning SQL. Here you will find our free article-based SQL language course. This consists of a number of articles that will get you started in your journey to learn SQL. If you are looking to go into more detail, practice with worked examples and elevate your skills to an expert

SQL (Structured Query Language) is a powerful tool for managing and querying relational databases. One of the fundamental operations in SQL is the SELECT statement, which allows you to retrieve data from a database. In this article, we will explore how to use SQL SELECT statements to retrieve, sort and filter data. We will look

In SQL, grouping data is a powerful operation that allows you to aggregate and analyse data effectively. This is especially useful when you want to generate aggregated data or perform calculations. You can also filter the returned aggregations based on the aggregated results rather than individual row details.  This cannot be done with the WHERE

Subqueries, sometimes referred to as nested queries or inner queries, are a useful feature in SQL that allows you to deal with more complex data retrieval and manipulation tasks. They are a useful tool for any SQL developer or database administrator, enabling you to write more sophisticated queries. This article will provide an in-depth understanding

So far we have largely looked at selecting data from a single table. In this article, we will look at how data can be combined from multiple tables with the use of SQL joins. There are different ways of joining data together including the INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

In this guide, you will learn the syntax and see some practical examples of how to use the SQL insert data command. We will introduce some new Keywords including INSERT INTO and look at how you can insert a single or multiple rows. SQL Insert data table of contents Learn SQL online For our instructor