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.

90 Data Science Interview Questions to Know
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.

MySQL: Create New User and Grant Permissions
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. 

Using Arrays in PostgreSQL: A Guide
Aashish Nair Aashish Nair
Updated on June 28, 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.

Understanding SQL Query Order of Execution
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.

How to Keep Your IT Job in an Age of Automation
Sara A. Metwalli Sara A. Metwalli
Updated on January 04, 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.

What Is MySQL?
Anthony Corbo Anthony Corbo
Updated on December 29, 2022

What Is SQL?

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

What Is SQL?
Manuel Silverio Manuel Silverio
Updated on December 21, 2022

What Is a Relational Database?

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

What Is a Relational Database?
Abdishakur Hassan Abdishakur Hassan
Updated on December 21, 2022

What Is SQLite?

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

What Is SQLite?
Terence Shin Terence Shin
Updated on December 16, 2022

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.

10 Advanced SQL Concepts You Should Know for Data Science Interviews