ViewTube

ViewTube
Sign inSign up
Author thumbnail

Cody Baldwin

SQL

24,267 views
26 items
Last updated on Dec 9, 2023
public playlist
Cody Baldwin
What is a Database? (SQL)
2:13
What is a Database? (SQL)

Cody Baldwin
What is SQL? (Structured Query Language)
1:43
What is SQL? (Structured Query Language)

Cody Baldwin
How to Write Basic SQL Statements (SELECT, FROM)
1:40
How to Write Basic SQL Statements (SELECT, FROM)

Cody Baldwin
WHERE Clause (SQL) - Filtering Records
2:49
WHERE Clause (SQL) - Filtering Records

Cody Baldwin
COUNT, SUM, AVG, MIN, MAX (SQL) - Aggregating Data
1:02
COUNT, SUM, AVG, MIN, MAX (SQL) - Aggregating Data

Cody Baldwin
ORDER BY Clause (SQL) - Sorting Results
1:08
ORDER BY Clause (SQL) - Sorting Results

Cody Baldwin
GROUP BY Clause (SQL) - Summarize Results into Groups
1:40
GROUP BY Clause (SQL) - Summarize Results into Groups

Cody Baldwin
HAVING Clause (SQL) - Filtering Groups
0:59
HAVING Clause (SQL) - Filtering Groups

Cody Baldwin
CREATE TABLE Statement (SQL) - Creating Database Tables
2:25
CREATE TABLE Statement (SQL) - Creating Database Tables

Cody Baldwin
CREATE VIEW Statement (SQL) - Creating Virtual Tables
1:38
CREATE VIEW Statement (SQL) - Creating Virtual Tables

Cody Baldwin
CREATE INDEX Statement (SQL) - Creating New Database Indexes
1:11
CREATE INDEX Statement (SQL) - Creating New Database Indexes

Cody Baldwin
INSERT INTO Statement (SQL) - Adding Records
0:58
INSERT INTO Statement (SQL) - Adding Records

Cody Baldwin
UPDATE Statement (SQL) - Modifying Records
1:07
UPDATE Statement (SQL) - Modifying Records

Cody Baldwin
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)

Cody Baldwin
UNION Operator (SQL) - Combining Results (UNION, UNION ALL)
1:22
UNION Operator (SQL) - Combining Results (UNION, UNION ALL)

Cody Baldwin
CASE WHEN Statements (SQL) - Conditional Logic (If Then)
2:30
CASE WHEN Statements (SQL) - Conditional Logic (If Then)

Cody Baldwin
Subqueries in SQL (Inner Queries, Nested Queries)
2:20
Subqueries in SQL (Inner Queries, Nested Queries)

Cody Baldwin
Common Table Expressions (SQL) (CTEs)
3:24
Common Table Expressions (SQL) (CTEs)

Cody Baldwin
Window Functions in SQL - Performing Calculations across Rows
4:13
Window Functions in SQL - Performing Calculations across Rows

Cody Baldwin
LAG and LEAD Functions (SQL) - Accessing Data in Other Rows
2:25
LAG and LEAD Functions (SQL) - Accessing Data in Other Rows

Cody Baldwin
SQL Style Guide (for Readability, Portability, Consistency)
2:29
SQL Style Guide (for Readability, Portability, Consistency)

Cody Baldwin
SQL Query Optimization - Tips for More Efficient Queries
3:18
SQL Query Optimization - Tips for More Efficient Queries

Cody Baldwin
Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF
4:19
Working with Dates (SQL) - EXTRACT, DATE_PART, DATE_TRUNC, DATEDIFF

Cody Baldwin
Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT
2:03
Cleaning Strings (SQL) - LEFT, RIGHT, TRIM, UPPER, LOWER, CONCAT

Cody Baldwin
CAST Function (SQL) - Converting Data Types
2:01
CAST Function (SQL) - Converting Data Types