Common Table Expressions (SQL) (CTEs)
4:16
Common Table Expressions (SQL) (CTEs)
Introduction to Wide Tables -- One Big Table (OBT)
3:22
Introduction to Wide Tables -- One Big Table (OBT)
Introduction to Data Privacy & Security
4:10
Introduction to Data Privacy & Security
Introduction to Data Quality Management
5:21
Introduction to Data Quality Management
ETL vs ELT - Extracting, Transforming, & Loading Data
2:49
ETL vs ELT - Extracting, Transforming, & Loading Data
Introduction to Data Modeling
7:56
Introduction to Data Modeling
Introduction to Data Governance
3:44
Introduction to Data Governance
Incremental vs Full Data Loads
3:05
Incremental vs Full Data Loads
Kimball vs Inmon - The History of Data Warehousing
4:12
Kimball vs Inmon - The History of Data Warehousing
Introduction to Database Normalization
5:09
Introduction to Database Normalization
Introduction to Entity Relationship Diagrams (ERDs)
3:25
Introduction to Entity Relationship Diagrams (ERDs)
Introduction to the Snowflake & Star Schemas
2:15
Introduction to the Snowflake & Star Schemas
Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF
4:19
Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF
Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT
2:03
Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT
CAST Function (SQL) - Converting Data Types
2:01
CAST Function (SQL) - Converting Data Types
Introduction to Robotic Process Automation (RPA)
4:40
Introduction to Robotic Process Automation (RPA)
Introduction to Process Mining
3:59
Introduction to Process Mining
Introduction to Machine Learning
2:52
Introduction to Machine Learning
Introduction to Big Data
3:13
Introduction to Big Data
Introduction to Data Warehouses
3:27
Introduction to Data Warehouses
Introduction to Cloud Computing
3:38
Introduction to Cloud Computing
CREATE INDEX Statement (SQL) - Creating New Database Indexes
1:11
CREATE INDEX Statement (SQL) - Creating New Database Indexes
CREATE VIEW Statement (SQL) - Creating Virtual Tables
1:38
CREATE VIEW Statement (SQL) - Creating Virtual Tables
CREATE TABLE Statement (SQL) - Creating Database Tables
2:25
CREATE TABLE Statement (SQL) - Creating Database Tables
WHERE Clause (SQL) - Filtering Records
2:49
WHERE Clause (SQL) - Filtering Records
SQL Query Optimization - Tips for More Efficient Queries
3:18
SQL Query Optimization - Tips for More Efficient Queries
LAG and LEAD Functions (SQL) - Accessing Data in Other Rows
2:25
LAG and LEAD Functions (SQL) - Accessing Data in Other Rows
Window Functions in SQL - Performing Calculations across Rows
4:13
Window Functions in SQL - Performing Calculations across Rows
UNION Operator (SQL) - Combining Results (UNION, UNION ALL)
1:22
UNION Operator (SQL) - Combining Results (UNION, UNION ALL)
Introduction to Joins (SQL) - Combining Data (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)
6:04
Introduction to Joins (SQL) - Combining Data (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)