CREATE TABLE Statement (SQL) - Creating Database Tables

Introduction to Machine Learning

Introduction to Entity Relationship Diagrams (ERDs)

CREATE INDEX Statement (SQL) - Creating New Database Indexes

Introduction to Robotic Process Automation (RPA)

Kimball vs Inmon - The History of Data Warehousing

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

Introduction to Big Data

Introduction to Data Quality Management

CREATE VIEW Statement (SQL) - Creating Virtual Tables

Introduction to Data Governance

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

Incremental vs Full Data Loads

ETL vs ELT - Extracting, Transforming, & Loading Data

Introduction to Data Warehouses

Introduction to Cloud Computing

Introduction to Process Mining

Introduction to the Snowflake & Star Schemas

Introduction to Data Modeling

Introduction to Database Normalization

CREATE TABLE Statement (SQL) - Creating Database Tables

CAST Function (SQL) - Converting Data Types

Introduction to Data Privacy & Security

WHERE Clause (SQL) - Filtering Records

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