All Things SQL - Page 3 of 4 - All Things Related To SQL, Databases & Cloud Based Solutions

SQL DROP – Tables, Views, Etc. – Deleting an Object

delete objects sql, drop objects sql, dropping objects sql, sql delete object, sql drop object

Separate from TRUNCATE and DELETE commands, we can use the DROP command to remove objects such as tables in SQL

SQL Case Statement Examples – Replacing If-Else

case statement sql, sql case statement, sql case statement examples, sql if else replacement, sql using case instead of if

Although some databases do support the IF ELSE functionality, the syntax can vary. The CASE statement can be used as

Microsoft SSIS vs Azure Data Factory (ADF)

adf vs ssis, azure data factory vs ssis, difference between adf and ssis, difference between azure data factory and ssis, difference between ssis and adf, ssis vs adf, ssis vs azure data factory

SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) both serve as ETL tools to extract data, transform data,

ALTER TABLE – Add, Remove, or Modify Column in SQL

add column sql, alter table add column, alter table add sql, alter table drop column sql, modify column in sql, rename a column in sql, sql add column, sql alter table drop column, sql modify column, sql rename column

We can use the ALTER TABLE command to either add or remove columns in SQL. The ALTER command is considered

SQL LEAD() Function – Getting Next Value

sql function lead, sql function next value, sql lead example, sql lead function example, sql next value, sql server lead function, sql window lead

Very similar to the Lag() function that provides a previous record value is the Lead() function which provides the opposite

SQL LAG() Function – Getting Previous Value

sql function lag, sql function previous value, sql lag example, sql lag function example, sql previous value, sql server lag function, sql window lag

There are several functions in SQL that are very useful such as the Lag() and Lead() functions. The lag function

Create a Table Using a SQL SELECT Statement

create table using select, create table using select in sql, create table using select statement, create table with select, create table with select sql, create table with select statement, sql create table select, sql create table using select, sql create table with select

There are several ways to create tables with special keywords such as specifying primary keys, foreign keys, unique constraints and

5 Reasons Why We Should Use SQL Views

purpose of a sql view, purpose of sql views, reasons for sql views, reasons to use sql views, sql view, sql view purpose, view in sql, view sql, views in sql, why use sql views

SQL views are very powerful when used properly. They allow us to store our SQL queries into virtualized containers (aka

Quick & Dirty: What is a Snowflake Database?

snowflake, snowflake cloud, snowflake data, snowflake data warehouse, snowflake db, what is snowflake, what is snowflake db

Over the last few years the demand for a new database built in the cloud has skyrocketed. In 2020 Snowflake