03:22

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

04:10

Introduction to Data Privacy & Security

05:21

Introduction to Data Quality Management

02:49

ETL vs ELT - Extracting, Transforming, & Loading Data

07:56

Introduction to Data Modeling

03:44

Introduction to Data Governance

03:05

Incremental vs Full Data Loads

04:12

Kimball vs Inmon - The History of Data Warehousing

05:09

Introduction to Database Normalization

03:25

Introduction to Entity Relationship Diagrams (ERDs)

02:15

Introduction to the Snowflake & Star Schemas

04:19

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

02:03

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

02:01

CAST Function (SQL) - Converting Data Types

04:40

Introduction to Robotic Process Automation (RPA)

03:59

Introduction to Process Mining

02:52

Introduction to Machine Learning

03:13

Introduction to Big Data

03:27

Introduction to Data Warehouses

03:38

Introduction to Cloud Computing

01:11

CREATE INDEX Statement (SQL) - Creating New Database Indexes

01:38

CREATE VIEW Statement (SQL) - Creating Virtual Tables

02:25

CREATE TABLE Statement (SQL) - Creating Database Tables

02:49

WHERE Clause (SQL) - Filtering Records

03:18

SQL Query Optimization - Tips for More Efficient Queries

02:25

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

04:13

Window Functions in SQL - Performing Calculations across Rows

01:22

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

06:04

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

02:29

SQL Style Guide (for Readability, Portability, Consistency)

02:30

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

03:24

Common Table Expressions (SQL) (CTEs)

01:40

How to Write Basic SQL Statements (SELECT, FROM)

02:20

Subqueries in SQL (Inner Queries, Nested Queries)

01:43

What is SQL? (Structured Query Language)

01:02

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

01:40

GROUP BY Clause (SQL) - Summarize Results into Groups

00:59

HAVING Clause (SQL) - Filtering Groups

00:58

INSERT INTO Statement (SQL) - Adding Records

01:08

ORDER BY Clause (SQL) - Sorting Results

01:07

UPDATE Statement (SQL) - Modifying Records

02:13

What is a Database? (SQL)

03:52

Introduction to Confidence Intervals (Statistics)

03:34

Rules of Probability

05:04

Basics of Probability

02:31

Introduction to Hypothesis Testing (Statistics)

03:32

Introduction to Estimators (Statistics)

02:11

Correlation vs Causation (Statistics)

14:41

Introduction to Python using Jupyter Notebooks

02:59

Introduction to Markdown (Jupyter Notebooks)

35:31

Introduction to Pandas (Python)

16:47

Introduction to Seaborn (Python) for Data Visualization

06:00

Introduction to Functions in Python

07:12

Loops in Python (For Loop, While Loop)

05:41

If Statements in Python (Conditional Logic) (IF, ELIF, ELSE)

02:07

How to Remove Duplicates in Microsoft Excel

02:38

How to Create Drop-Down Menus in Microsoft Excel (Data Validation)

05:57

How to Create an Amortization Schedule in Microsoft Excel (PMT, IPMT, & PPMT Functions)

01:44

How to Use the SEARCH Function in Microsoft Excel (Find Text)

02:29

How to Use Absolute & Relative Cell References in Microsoft Excel