SQL Articles

Sorted By: Most Recent
Joel Hereth Joel Hereth
Updated on March 12, 2024

How to Optimize SQL for Large Data Sets

Optimizing SQL for large data sets is an important step in managing the performance of your database. Follow these best practices to achieve faster data retrieval and efficiency. 

Image: Shutterstock / Built In
Jonathan Moore Jonathan Moore
Updated on September 12, 2023

MySQL: Create New User and Grant Permissions

Creating a new user involves defining the user's credentials and privileges. Follow these steps to create a new user in MySQL.

Image: Shutterstock / Built In
Merlin Schäfer Merlin Schäfer
Updated on August 02, 2023

Using Arrays in PostgreSQL: A Guide

With the array, PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. 

Image: Shutterstock / Built In
Jye Sawtell-Rickson Jye Sawtell-Rickson
Updated on March 15, 2023

Why SQLZoo Is the Best Way to Practice SQL

Whether you’re applying to new jobs or trying to upskill in your current role, SQLZoo is a great place to hone your skills. Here’s how to get started.

Image: Shutterstock / Built In
Manuel Silverio Manuel Silverio
Updated on March 15, 2023

What Is a Relational Database?

Relational databases (SQL databases) are organized collections of data that are structured to recognize relationships between records.

Image: Shutterstock / Built In