September 2021 - All Things SQL

What Is A SQL Index Used For?

sql index what is it, sql what are indexes, sql what is an index, what are indexes in sql, what does an index do in sql, what does indexing do in sql, what is a sql index, what is an index used for in sql, what is the use of a sql index

We can create, alter, and delete database indexes using SQL, but what do we need really need to index for?

SQL INDEX – CREATE, ALTER, or DELETE

composite index sql, create index sql, create index with multiple columns sql, create table index sql, sql composite index, sql create index, sql create table index

We use the sql INDEX as a way to optimize our database queries. A database administrator or data architect will

SQL Alias (Rename) – Columns, Tables, and More

column alias in sql, how to rename columns in sql, how to rename tables in sql, rename columns in sql, renaming columns in sql, renaming tables in sql, sql alias, sql aliasing columns, sql aliasing tables, sql column alias, sql rename columns, sql rename tables, sql renaming tables, sql table alias, table alias in sql, using alias in sql, what is a sql alias

When writing queries, functions, or procedures in SQL we often want to abbreviate and rename objects. In SQL this is

SQL NULL – What Is It & How Is It Used?

what does null value mean, what is a null value in sql, what is null and not null in sql, what is null in sql

When writing in sql the NULL value becomes very useful. Technically a NULL isn’t a value, but the lack of