SQL Query Optimization - Tips for More Efficient Queries

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