March 2021 - All Things SQL

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

DML vs DDL Using SQL – What’s The Difference?

0 Comments ddl and dml in sql, ddl commands in sql, ddl dml, ddl vs dml, dml commands in sql, dml ddl, dml vs ddl, sql ddl dml, sql dml ddl

To first understand the key differences between DML and DDL when writing SQL we should define what these two acronyms

What’s an Oracle Outer Join? – Using the Plus Sign

0 Comments oracle inner join, oracle join, oracle left join, oracle outer join, oracle outer join example, oracle outer join syntax, oracle plus outer join

You may be familiar with SQL and how to write a query using the LEFT, RIGHT, and FULL OUTER keywords.

What is SSMS? SQL Server Management Studio

0 Comments microsoft server management studio, microsoft sql management, microsoft ssms, ms sql management studio, sql server management studio, sql ssms, what is ssms

If you’re new to the Microsoft database world you might not be familiar with SSMS otherwise known as SQL Server

What Does SQL Stand For? – Structured Query Language

sql abbreviation, sql definition, sql means, sql stands for, what does sql stand for

SQL – otherwise known as “sequel” – is a database programming language used to find answers in a database. There