Here is a compilation of earlier blog posts that were relevant to Sample datasets, Sample projects, and Sample assignments. For quick reference only.
Category: Oracle SQL*Plus
SQL, TSQL and PL/SQL
The distinction between SQL, TSQL, and PL/SQL is a question that regularly arises while teaching data platform courses because these terminologies are used frequently in
Can we rename a view in SQL Server?
Although changing the name of the view using the sp_rename command is allowed, it is advised to first delete the current view before creating a
VIEWS vs Materialized Views in SQL
Here are listed the key distinctions between Views and Materialized Views. This material has been gathered throughout time from a variety of sources and books.
Sub-Queries in SQL Server
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
TRUNCATE TABLE in SQL
TRUNCATE TABLE is a Data Definition Language operation in SQL that marks the extent of a table for deallocation. This operation removes all data from
Big Data & SQL 