SQL Articles

Sorted By: Most Recent
Adetoro Oyairo Adetoro Oyairo
Updated on March 13, 2024

What Is an Entity Relationship Diagram (ERD)?

An ERD illustrates the relationships between different concepts. Here’s everything you need to know.

Image: Shutterstock / Built In
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
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
Anthony Corbo Anthony Corbo
Updated on November 07, 2023

What Is SQL?

SQL allows programmers to query, update and reorganize data while modifying database schema to control data accessibility.

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
Yuval Erez Yuval Erez
Updated on May 31, 2023

How to Keep Your IT Job in an Age of Automation

Develop new skills and learn the latest tech to stay relevant.

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