SQL for Analysts Series' Articles

Michael Nocito

Jul 24

How to Comment SQL So It Teaches

#sql #database #tutorial #beginners

12 min read

Michael Nocito

Aug 8

How to Set Up a SQL Database for Beginners

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 9

The SQL CASE Expression, Explained for Beginners

#sql #database #tutorial #beginners

9 min read

Michael Nocito

Aug 10

COUNT in SQL, Explained for Beginners

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 11

SQL JOINs: How to Join Two Tables Without Losing or Doubling Rows

#sql #database #tutorial #beginners

1

17 min read

Michael Nocito

Aug 11

SQL Aliases: How to Read a Query Out Loud

#sql #database #tutorial #beginners

13 min read

Michael Nocito

Aug 12

SQL CTEs: How to Build a Query in Steps You Can Check

#sql #database #tutorial #beginners

12 min read

Michael Nocito

Aug 12

SQL Foundations, Start to Finish

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 12

GROUP BY and HAVING: How to Summarize Rows Without Getting a Fake Answer

#sql #database #tutorial #beginners

13 min read

Michael Nocito

Aug 12

SQL Window Functions: How to Get the Top Row Per Group

#sql #database #tutorial #beginners

16 min read

Michael Nocito

Aug 21

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners

9 min read

Michael Nocito

Aug 21

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 21

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners

5 min read

Michael Nocito

Aug 21

How to Find Duplicate Rows in SQL (and Decide What Counts as One)

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 21

Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 21

NULL in SQL: Why = NULL Finds Nothing and What to Write Instead

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 21

Which SQL Database Should You Install?

#sql #database #tutorial #beginners

6 min read

Michael Nocito

Aug 22

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 22

Where to Get a Sample Database to Practice SQL (And How to Check It Loaded)

#sql #database #tutorial #beginners

13 min read

Michael Nocito

Aug 22

How to Practice SQL Online With Nothing Installed (And Where Your Data Goes)

#sql #database #tutorial #beginners

11 min read

Michael Nocito

Aug 26

How to Export SQL Results to CSV and Excel (Without Wrecking the Data)

#sql #database #tutorial #beginners

10 min read

Michael Nocito

Aug 27

How to Install PostgreSQL for Beginners (And Whether You Need To)

#sql #database #tutorial #beginners

11 min read

Michael Nocito

Aug 29

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

#sql #database #tutorial #beginners

10 min read

Michael Nocito

Aug 30

Cohort Retention Analysis in SQL, Step by Step

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 30

SQL Date Functions: How to Group by Month Without Losing One

#sql #database #tutorial #beginners

16 min read

Michael Nocito

Aug 30

Funnel Conversion in SQL, and the Step That Shows 100%

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 30

When to Index a Table: A Practical Guide for Analysts

#sql #database #tutorial #beginners

15 min read

Michael Nocito

Aug 31

How to Reconcile Two Tables in SQL When the Row Counts Match

#sql #database #tutorial #beginners

1

14 min read

Michael Nocito

Aug 31

Running Total in SQL: The Window Frame That Decides the Answer

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 31

Subquery vs CTE in SQL: Same Logic, One You Can Check

#sql #database #tutorial #beginners

14 min read

Michael Nocito

Aug 31

Temp Table vs View in SQL: A Saved Answer or a Saved Question

#sql #database #tutorial #beginners

13 min read

Michael Nocito

Sep 7

LIKE in SQL, Explained for Beginners

#sql #database #tutorial #beginners

7 min read

Michael Nocito

Sep 8

One Cell, Many Values: When a Column Holds a List

#sql #database #tutorial #beginners

8 min read