Cody Baldwin

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

Introduction to Data Modeling

ETL vs ELT - Extracting, Transforming, & Loading Data

Introduction to Data Quality Management

Introduction to Data Privacy & Security

Kimball vs Inmon - The History of Data Warehousing

Introduction to Data Governance

Incremental vs Full Data Loads

Introduction to Database Normalization

Introduction to Entity Relationship Diagrams (ERDs)

Introduction to the Snowflake & Star Schemas

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

CAST Function (SQL) - Converting Data Types

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

Introduction to Robotic Process Automation (RPA)

Introduction to Process Mining

Introduction to Machine Learning

Introduction to Big Data

Introduction to Data Warehouses

Introduction to Cloud Computing

CREATE TABLE Statement (SQL) - Creating Database Tables

CREATE VIEW Statement (SQL) - Creating Virtual Tables

CREATE INDEX Statement (SQL) - Creating New Database Indexes

WHERE Clause (SQL) - Filtering Records

SQL Query Optimization - Tips for More Efficient Queries

UNION Operator (SQL) - Combining Results (UNION, UNION ALL)

Window Functions in SQL - Performing Calculations across Rows

LAG and LEAD Functions (SQL) - Accessing Data in Other Rows

Introduction to Joins (SQL) - Combining Data (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)

SQL Style Guide (for Readability, Portability, Consistency)

Common Table Expressions (SQL) (CTEs)

CASE WHEN Statements (SQL) - Conditional Logic (If Then)

How to Write Basic SQL Statements (SELECT, FROM)

Subqueries in SQL (Inner Queries, Nested Queries)

What is SQL? (Structured Query Language)

GROUP BY Clause (SQL) - Summarize Results into Groups

HAVING Clause (SQL) - Filtering Groups

COUNT, SUM, AVG, MIN, MAX (SQL) - Aggregating Data

ORDER BY Clause (SQL) - Sorting Results

What is a Database? (SQL)

INSERT INTO Statement (SQL) - Adding Records

UPDATE Statement (SQL) - Modifying Records

Introduction to Estimators (Statistics)

Introduction to Hypothesis Testing (Statistics)

Basics of Probability

Rules of Probability

Introduction to Confidence Intervals (Statistics)

Correlation vs Causation (Statistics)

Introduction to Python using Jupyter Notebooks

Introduction to Markdown (Jupyter Notebooks)