All Things SQL Archives - All Things SQL

Understanding a Primary Key with SQL

primary key sql, sql primary key, sql what are primary keys, sql what is a primary key, what is a primary key in sql, what is a primary key sql, what is a primary key used for in sql

We use primary keys on most tables while utilizing the SQL language in an OLTP or OLAP data model. These

Subqueries in SQL – Embedding SELECT in SELECT

select in select sql, sql select in a select, sql select inside select, sql subqueries, sql subquery, sql subquery examples, sql subquery in select statement, subqueries sql, subquery sql

Our SQL abilities tend to go from beginner to intermediate when we start to learn how to utilize subqueries. A

Comparing Primary Keys VS Foreign Keys

comparing foreign and primary keys, comparing primary and foreign keys, foreign vs primary key sql, primary and foreign key differences sql, primary key vs foreign key, primary vs foreign key sql, primary vs foreign key sql difference between primary and foreign key, sql foreign vs primary keys, sql primary and foreign key differences, sql primary foreign key comparison, sql primary vs foreign key

Relational databases that we use to write our SQL database queries contain tables. These tables will almost undoubtedly contain keys.

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

SQL VIEW – Create, Replace, Modify & Drop

create view sql, create view using sql, create views in sql, delete view sql, modify view sql, sql create view, sql delete view, sql modify view

We can use SQL views for many reasons and are very powerful when used properly. Views allow us to store

SQL LENGTH – Finding Max & Min String Width

max length sql, min length sql, select max length of column in sql, select max length sql, sql max length, sql min length, sql string max length

We can use a combination of the MAX and MIN functions in conjunction with the SQL length function to get

SQL Concatenate – Combining Columns in a Table

combine columns in sql, combining columns in sql, combining two columns in sql, concat 2 columns in sql, concat two columns in sql, sql combine columns, sql combining two columns, sql concat 2 columns, sql concat two columns

We can combine multiple columns together into one in SQL using concatenation. Many databases have their own versions of combining

← Previous