Skip to content

DEV Community

SQL for Analysts Series' Articles

Back to Michael Nocito's Series

Jul 24

How to Comment SQL So It Teaches

#sql #database #tutorial #beginners

12 min read

Aug 8

How to Set Up a SQL Database for Beginners

#sql #database #tutorial #beginners

6 min read

Aug 9

The SQL CASE Expression, Explained for Beginners

#sql #database #tutorial #beginners

9 min read

Aug 10

COUNT in SQL, Explained for Beginners

#sql #database #tutorial #beginners

6 min read

Aug 11

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

#sql #database #tutorial #beginners

17 min read

Aug 11

SQL Aliases: How to Read a Query Out Loud

#sql #database #tutorial #beginners

13 min read

Aug 12

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

#sql #database #tutorial #beginners

12 min read

Aug 12

SQL Foundations, Start to Finish

#sql #database #tutorial #beginners

15 min read

Aug 12

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

#sql #database #tutorial #beginners

13 min read

Aug 12

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

#sql #database #tutorial #beginners

16 min read

Aug 21

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

#sql #database #tutorial #beginners

9 min read

Aug 21

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

#sql #database #tutorial #beginners

6 min read

Aug 21

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

#sql #database #tutorial #beginners

5 min read

Aug 21

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

#sql #database #tutorial #beginners

15 min read

Aug 21

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

#sql #database #tutorial #beginners

15 min read

Aug 21

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

#sql #database #tutorial #beginners

14 min read

Aug 21

Which SQL Database Should You Install?

#sql #database #tutorial #beginners

6 min read

Aug 22

Customer Segmentation in SQL With CASE WHEN

#sql #database #tutorial #beginners

14 min read

Aug 22

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

#sql #database #tutorial #beginners

13 min read

Aug 22

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

#sql #database #tutorial #beginners

11 min read

Aug 26

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

#sql #database #tutorial #beginners

10 min read

Aug 27

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

#sql #database #tutorial #beginners

11 min read

Aug 29

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

#sql #database #tutorial #beginners

10 min read