SQL Articles

Sorted By: Most Recent
Terence Shin Terence Shin
Updated on February 26, 2024

90 Data Science Interview Questions to Know

Data science interviews encompass a variety of challenging questions to test your knowledge in machine learning, probability, SQL and more. Hone your skills with these questions.

Image: Shutterstock / Built In
Max Reynolds Max Reynolds
Updated on October 05, 2023

Differences Between SOQL and SQL Explained

SOQL is Salesforce’s proprietary programming language that’s used to query data directly from your Salesforce. SQL is a language used to query data from a general database. Here’s what you need to know.

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
Aashish Nair Aashish Nair
Updated on August 03, 2023

Understanding SQL Query Order of Execution

Take the time to understand how the clauses in SQL are evaluated. We discuss the order of execution in SQL and why it matters.

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
Terence Shin Terence Shin
Updated on March 15, 2023

10 Advanced SQL Concepts You Should Know for Data Science Interviews

Learn 10 advanced SQL concepts you should know for data science interviews to take your SQL skills to the next level.

Image: Shutterstock / Built In
Abdishakur Hassan Abdishakur Hassan
Updated on March 15, 2023

What Is SQLite?

SQLite is a software library that provides a lightweight, embeddable database engine. Here’s how it works.

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
Sara A. Metwalli Sara A. Metwalli
Updated on March 15, 2023

What Is MySQL?

MySQL is a relational database management system that stores all the information you need to run complex websites. Here’s how it works.

Image: Shutterstock / Built In