Все публикации

Introduction to Wide0:03:22

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

Introduction to Data0:07:56

Introduction to Data Modeling

ETL vs ELT0:02:49

ETL vs ELT - Extracting, Transforming, & Loading Data

Introduction to Data0:05:21

Introduction to Data Quality Management

Kimball vs Inmon0:04:12

Kimball vs Inmon - The History of Data Warehousing

Incremental vs Full0:03:05

Incremental vs Full Data Loads

Introduction to Database0:05:09

Introduction to Database Normalization

Introduction to Entity0:03:25

Introduction to Entity Relationship Diagrams (ERDs)

Introduction to the0:02:15

Introduction to the Snowflake & Star Schemas

Cleaning Strings (SQL)0:02:03

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

CAST Function (SQL)0:02:01

CAST Function (SQL) - Converting Data Types

Working with Dates0:04:19

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

Introduction to Robotic0:04:40

Introduction to Robotic Process Automation (RPA)

Introduction to Process0:03:59

Introduction to Process Mining

Introduction to Machine0:02:52

Introduction to Machine Learning

Introduction to Big0:03:13

Introduction to Big Data

Introduction to Data0:03:27

Introduction to Data Warehouses

Introduction to Cloud0:03:38

Introduction to Cloud Computing

CREATE TABLE Statement0:02:25

CREATE TABLE Statement (SQL) - Creating Database Tables

CREATE VIEW Statement0:01:38

CREATE VIEW Statement (SQL) - Creating Virtual Tables

CREATE INDEX Statement0:01:11

CREATE INDEX Statement (SQL) - Creating New Database Indexes

WHERE Clause (SQL)0:02:49

WHERE Clause (SQL) - Filtering Records

SQL Query Optimization0:03:18

SQL Query Optimization - Tips for More Efficient Queries

UNION Operator (SQL)0:01:22

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