Learn SQL

Getting Started & Your First SQL Query

Challenge - AI and SQL

Solution - Like and Wildcards in SQL

Pattern Matching in SQL

CASE Exercise in SQL

Coding Exercise in PostgreSQL

AI and SQL - Hands On Challenge - Solution

Solution- 2.0 Date Functions in SQL

Benefits of Learning SQL

Database Terminology and Primary & Foreign Keys in SQL

Solution- Filtering with WHERE in SQL

Like and Wildcards in SQL

Data Types and Filtering Results in SQL

SQL Learning Resources

Solution- Aggregate Function and ROUND in SQL

How to Leverage AI in SQL

Solution- Inner Join in SQL

Solution to PostgreSQL Coding Challenge

Solution WIndow Functions in SQL

Grouping Data in SQL

Aggregate Window Functions in SQL

Exercise- Aggregate Function and ROUND 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.

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.