Media Summary: Learn more about PlanetScale at —————————————————— 00:00 Intro 01:04 ... Are you deleting data when you should just be checking it? Or worse—are you trying to clean up a database When you create an ETL or a metric that has ratios or division in general, it is important to consider that fact that at some point in ...

Stop Using Count Wrong Sql - Detailed Analysis & Overview

Learn more about PlanetScale at —————————————————— 00:00 Intro 01:04 ... Are you deleting data when you should just be checking it? Or worse—are you trying to clean up a database When you create an ETL or a metric that has ratios or division in general, it is important to consider that fact that at some point in ... NULLs are interesting values. While they fill an important need in the database, it's not always intuitive how different

Photo Gallery

Stop using COUNT(id) to count rows
Stop Using the Wrong SQL Method! (Check vs Clean vs Analyze)
Don’t Get Tricked by SQL COUNT! | COUNT vs COUNT(*) vs COUNT(DISTINCT)
Count NULL Values in SQL (Most People Get This Wrong) | SQL Interview Question | Q13
How to Count records in Query SQL Server database with and without duplicate values
Avoid Divide By Zero Errors In SQL - SQL Best Practices
SQL : SQL column count does not match value count error
COUNT, DISTINCT, and NULLs in SQL Server
How NOT TO learn SQL: Avoid these 4 mistakes
Problem with Running SUM in SQL | Watch it to Avoid The Mistake
7 Mistakes Beginners Make with SQL
"Count With No Count" SQL Puzzle
View Detailed Profile
Stop using COUNT(id) to count rows

Stop using COUNT(id) to count rows

Learn more about PlanetScale at https://planetscale.com/youtube. —————————————————— 00:00 Intro 01:04 ...

Stop Using the Wrong SQL Method! (Check vs Clean vs Analyze)

Stop Using the Wrong SQL Method! (Check vs Clean vs Analyze)

Are you deleting data when you should just be checking it? Or worse—are you trying to clean up a database

Don’t Get Tricked by SQL COUNT! | COUNT vs COUNT(*) vs COUNT(DISTINCT)

Don’t Get Tricked by SQL COUNT! | COUNT vs COUNT(*) vs COUNT(DISTINCT)

Don't Get Tricked by

Count NULL Values in SQL (Most People Get This Wrong) | SQL Interview Question | Q13

Count NULL Values in SQL (Most People Get This Wrong) | SQL Interview Question | Q13

How do you

How to Count records in Query SQL Server database with and without duplicate values

How to Count records in Query SQL Server database with and without duplicate values

How to

Avoid Divide By Zero Errors In SQL - SQL Best Practices

Avoid Divide By Zero Errors In SQL - SQL Best Practices

When you create an ETL or a metric that has ratios or division in general, it is important to consider that fact that at some point in ...

SQL : SQL column count does not match value count error

SQL : SQL column count does not match value count error

SQL

COUNT, DISTINCT, and NULLs in SQL Server

COUNT, DISTINCT, and NULLs in SQL Server

NULLs are interesting values. While they fill an important need in the database, it's not always intuitive how different

How NOT TO learn SQL: Avoid these 4 mistakes

How NOT TO learn SQL: Avoid these 4 mistakes

My honest take on the 4

Problem with Running SUM in SQL | Watch it to Avoid The Mistake

Problem with Running SUM in SQL | Watch it to Avoid The Mistake

There is a specific issue

7 Mistakes Beginners Make with SQL

7 Mistakes Beginners Make with SQL

Get my free

"Count With No Count" SQL Puzzle

"Count With No Count" SQL Puzzle

A simple interview question: How to