SQL Triggers: Syntax, Examples, and Use Cases

Learn what a SQL trigger is, how it works, and when to use one. Includes syntax, examples, types, use cases, and when to avoid triggers altogether.

SQL Operators: 6 Different Types (w/ 45 Code Examples)

Here's a quick reference guide to all of the different types of SQL operators, with examples that illustrate when and how to use them.

Install PostgreSQL 14.7 on Ubuntu

Install PostgreSQL 14.7 on Ubuntu step-by-step. Includes package setup, Northwind database installation, and Jupyter Notebook integration.

Install PostgreSQL 14.7 on Windows 10

Install PostgreSQL 14.7 on Windows 10 step-by-step. Includes environment setup, Northwind database, and Jupyter Notebook connection.

Install PostgreSQL 14.7 on MacOS

Install PostgreSQL 14.7 on macOS with Homebrew step-by-step. Includes setup, Northwind database installation, and Jupyter integration.

SQL Certification: 15 Recruiters Reveal If It's Worth the Effort

SQL is a key skill for data jobs. But you probably DON'T need a SQL certification to get a job. In fact, it might not even help! Here's why.

Intermediate SQL: PostgreSQL, Subqueries, and more!

Learn how to perform intermediate SQL tasks including setting up tables in PostgreSQL, views, subqueries and more.

SQL Queries You Need to Know (with Practical Examples)

Learn how to write SQL queries to extract data from two or more databases, use SQL dot commands to simplify tasks, and more!

10 SQL Skills You Need to Know

Learn why SQL is a must-have skill in today's data-driven world. Our blog post guides you through key techniques for success.

How to Learn SQL: The Best Way

What's the best way to learn SQL? We've done the homework (and spoken with tons and tons of learners) to figure out what actually works!

Top 20 SQL JOINs Interview Questions and Answers

In this roundup, we'll explore the top 20 SQL JOINs questions and answers you need to know for your next interview.

How to Install MySQL on Windows: A Simple Guide

MySQL is a light, open-source, easy-to-install database management system. Here's how to get a MySQL server operating on your machine.

SQL Subqueries: A Beginner's Guide (with Code Examples)

Every data scientist needs to know their way around a SQL database. Here’s an introduction to using subqueries.

Tutorial: Connect, Install, and Query PostgreSQL in Python

What is PostgreSQL in Python? How do I use it? In this tutorial, we show examples of querying PostgreSQL and more. It’s everything you need to get started!

Why does SQL Server Consume So Much Memory

SQL vs T-SQL: Understanding the Differences

SQL vs. T-SQL — what's the difference, and which one should you learn if you need to work more efficiently with your company's database? We'll tell you.

SQL Commands: The Complete List (w/ Examples)

What can you do with SQL? Here's a reference guide to the most commonly-used SQL commands, with code examples you can copy-paste.

SQL vs MySQL: Key Differences Explained (2026)

SQL and MySQL are important tools for working with data. But what are they, exactly, and how are they different? Let's clear that up.

SQL Interview Questions — Real Questions to Prep for Your Job Interview

A lot of the SQL interview questions you'll find on the web are generic: "What is SQL?" You'll never be asked that. We've got REAL questions to help you prep

SQL Basics — Hands-On Beginner SQL Walkthrough Analyzing Bike-Sharing

Learn the SQL basics and go hands-on querying databases as you analyze bike rental data in this free beginner SQL tutorial.

SQL Joins: Working with Databases

Learn how to master joins in the SQL joins tutorial. Learn to use inner, left, right, and outer joins while analyzing CIA factbook data.

SQL Aggregate Functions: Selecting Ungrouped Columns

This SQL aggregate function quirk can throw off your results if you're not careful! Learn about the "bare columns" issue and why it matters.

SQL Insert: Adding Records and DataFrames to a SQL Database

Master the art of the SQL Insert to add and update data in SQL and MySQL databases using SQL queries, as well as from within Python and pandas.

Working with SQLite Databases using Python and Pandas

In this post, focused on learning python for data science, you'll query, update, and create SQLite databases in Python, and how to speed up your workflow.