Coffing Data Warehousing

Two Minutes to Cloud Migration and World Domination

Lets Learn SQL! Lesson 122: Creating SET and MULTISET Tables

Lets Learn SQL! Lesson 111: In, Out, InOut Parameters in Stored Procedures

Let's Learn Teradata Lesson 25: Introduction to Simple Partitioning

Stored Procedures: Modifying and Deleting a Stored Procedure

Understanding Python: Splitting a Quote in a String into a List

Understanding Python: Tricks and Tips to Single and Multi-line Strings

Amazon Redshift: Data and Data Blocks

Let's Learn Teradata Lesson 29: Introduction to Case_N Partitioning

Stored Procedures: Input Parameters and Using Case Statements

Let's Learn SQL! Lesson 15 : Escape Characters in the Like Command

Stored Procedures: Using Group By Grouping Sets, Roll Up, and Cube

Let's Learn SQL! Lesson 57: OLAP Basics and Teradata Syntax for CSUM

Let's Learn Netezza! Lesson Fifteen: The Create Table As Function

Analytic Functions for all database systems

Best Practice Save the Result Set as a Table

Oracle ROW_NUMBER Analytic

Azure Synapse Row_Number Analytic

Nexus 60-Second Video - Using Excel

Seamlessly Unite Databricks and Snowflake

Migrate and Federate Snowflake and Databricks

Excel World Record - 19 Excel Spreadsheets Join to Production Table

Google BigQuery Row_Number Analytic

Let's Learn Netezza! Lesson 33: External Tables

Stored Procedures: Pivoting Data

Let's Learn SQL! Lesson 91: NULLIF and ZEROIFNULL

Stored Procedures: Dynamic SQL and System Procedures

Let's Learn SQL! Lesson 45 : Global Temporary Tables and A Derived Table Quiz!

Let's Learn SQL! Lesson 23 : Derived Tables with Aggregates!

Understanding Python: Printing on Multiple Lines

Snowflake Row_Number Ordered Analytic

Let's Learn SQL! Lesson 68 : The Partition By and Qualify Statements in RANK

Let's Learn SQL! Lesson 74 : Primary/Foreign Key Relationship in Subqueries

Nexus 60 Second Video Cloning System Connections

Let's Learn SQL! Lesson 29: Joins and ANSI Standard Syntax

Two Minutes to Cloud Migration and World Domination

Stored Procedures: Create and Execute a Stored Procedure

Stored Procedures: Dynamic SQL

Let's Learn SQL! Lesson 56 : The Basics of Global Temporary Tables

Let's Learn SQL! Lesson 85 : Trimming Trailing Spaces and Characters

The Complexity of Analytics In the Year 2024

The Friendliest, Yet Most Powerful Federated Query Tool Ever Invented

Let's Learn Teradata Lesson 98: Collect Statistics Enhancements for V14.10

Understanding Python: Variables and Formatting with the Print Command

The LEAD Analytic Function on Yellowbrick - Working Session

Let's Learn SQL! Lesson 16 : Distinct Command vs Group By

Let's Learn SQL! Lesson 83: The Characters Command

15 table join across 15 systems

Let's Learn SQL! Lesson 22 : Where Clause vs Having Clause

Unite All Databases Into One Giant Ecosystem

Let's Learn SQL! Lesson 128: Creating a Queue Table