Learn SQL
Free SQL Resources & Tutorials
42 articles in SQL
Solution - Like and Wildcards in SQL
Challenge - AI and SQL
Database Terminology and Primary & Foreign Keys in SQL
Benefits of Learning SQL
Like and Wildcards in SQL
Solution- 2.0 Date Functions in SQL
Solution WIndow Functions in SQL
Solution to PostgreSQL Coding Challenge
How to Leverage AI in SQL
CASE Exercise in SQL
Exercise- Aggregate Function and ROUND in SQL
Aggregate Window Functions in SQL
Solution- Aggregate Function and ROUND in SQL
Solution- Inner Join in SQL
Pattern Matching in SQL
SQL Learning Resources
Solution- Filtering with WHERE in SQL
Coding Exercise in PostgreSQL
Getting Started & Your First SQL Query
Grouping Data in SQL
Constructing Complex PostgreSQL Queries Using Aggregate Functions
Learn how to construct complex PostgreSQL queries using aggregate functions to analyze data and gain valuable insights.
Using Outer Joins in PostgreSQL to Identify Unmatched Rows in Your Database
Learn how to use outer joins in PostgreSQL to find unmatched rows in your database and optimize your data analysis process.
AI and SQL - Hands On Challenge - Solution
5 Advantages Developers Gain by Learning SQL
SQL (Structured Query Language) is the main programming language used by database management systems. In this article, we'll explore the top advantages...
Top 20 SQL Commands to Master
Databases play an important role in numerous types of technology. When proper database management is paired with Structured Query Language (SQL), companies can...
Database Terminology
Understand the basics of electronic databases, the organization of data in tables, the various relationships between tables, and the crucial role of keys in...
Intro to SQL & Relational Databases
Dive into the world of back-end programming with SQL, the standard language for relational database management systems, and learn about its various functions,...
WHERE - SQL’s Strongest Filter
When we perform our SQL queries, we often want to select one or more columns of data for the final result. However, it’s in our best interest to filter our...
Intro to SQL Queries
While most people in the business world work within spreadsheets, larger data is stored in databases, and to access this data, we often employ the use of a...
What is SQL and How Do We Use It?
With the rise of big data, understanding how to analyze and interpret this information is crucial. This article provides an in-depth look into Structured Query...
The Many Flavors of SQL
Explore the world of SQL and relational database management systems, their commercial and open-source variants, and the nuances that make each unique yet...
Excel vs. SQL: CASE WHEN
In this article, we'll explore the differences between SQL and Excel in performing a text-based grouping exercise. Our hands-on exercise will take you inside...
SQL Commands Cheat Sheet
This handy cheat sheet will serve as a reference for your basic SQL querying needs and provide some examples to apply the material.
SQL for Business Analysts
In this article, we'll cover the key reasons why SQL is such an in-demand skill for business analysts and how it can help you at your job.
SQL SELECT Tutorial
Simple Tutorial on how to use the SELECT statement in SQL
SQL WHERE Tutorial
This tutorial walks through the basics of the WHERE statement in SQL and an example of how to use it.
SQL ORDER BY Tutorial
Learn to use the ORDER BY function in SQL to sort data with our tutorial and screenshots.
SQL MIN Tutorial
Learn the basics of the MIN function and how and when to use it in this tutorial.
SQL MAX Tutorial
Learn the basics of the MAX function in SQL with an example and screenshots.
SQL COUNT Tutorial
In this tutorial, we'll go through the basics of the COUNT function in SQL, the syntax of it, and walk through an example of the COUNT function.
How to Install SQL Server Express
Learn how to install SQL Server Express on your computer with this step-by-step guide with pictures.