SQL For Absolute Beginners: Understanding SQL Clauses

Learn the Fundamentals of SQL Clauses Using DB-Fiddle and Demo Data

Unsplash Image

Understanding how SQL clauses are used to build queries is the best starting point for learning SQL. You can think of SQL clauses as the building blocks of queries.

In this article, we use DB-Fiddle as a practice PostgreSQL environment to explore the basics of SQL clauses by querying demo data.

Let’s go!

Getting Started with DB-Fiddle

DB-Fiddle is an easy-to-use website for practicing your SQL skills. If, for some reason, you cannot access DB-Fiddle, you’ll need to either download and install PostgreSQL and a client or use a hosted solution like ElephantSQL or Supabase.

Head to www.db-fiddle.com and check out the interface; screenshot below for reference.

DB-Fiddle Interface

There are three things to point out.

1. You can change the database type DB-Fiddle uses with the drop-down menu in the top-left corner (red rectangle above). You’ll need to select a PostgreSQL version to follow along with this…