Subqueries in SQL (Inner Queries, Nested Queries)

Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF

Introduction to Big Data

Introduction to Data Modeling

Introduction to Process Mining

Introduction to Database Normalization

Introduction to Machine Learning

Introduction to the Snowflake & Star Schemas

Introduction to Wide Tables -- "One Big Table (OBT)"

Introduction to Robotic Process Automation (RPA)

CREATE INDEX Statement (SQL) - Creating New Database Indexes

CAST Function (SQL) - Converting Data Types

Introduction to Data Warehouses

Introduction to Cloud Computing

Kimball vs Inmon - The History of Data Warehousing

Introduction to Entity Relationship Diagrams (ERDs)

Introduction to Data Quality Management

Incremental vs Full Data Loads

CREATE VIEW Statement (SQL) - Creating Virtual Tables

Introduction to Data Privacy & Security

ETL vs ELT - Extracting, Transforming, & Loading Data

Introduction to Data Governance

Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT

WHERE Clause (SQL) - Filtering Records

CREATE TABLE Statement (SQL) - Creating Database Tables