Search⌘ K

Introduction to SQL Toolbox

Explore how to improve your SQL writing skills using practical examples in PostgreSQL. Learn to express problems clearly, work interactively on queries, and gain confidence in both basic and advanced SQL techniques to write efficient, reliable database applications.

In this part, we’re going to add to our proficiency in writing SQL queries. The structured query language doesn’t look like any other imperative, functional, or even object-oriented programming language.

SQL techniques

This part contains a long list of SQL techniques from the most basic select clause to advanced lateral joins, each time with practical examples working with a free database that you can install at home.

It’s highly ...