Skip to content

DEV Community

Databases and SQL from Scratch Series' Articles

Back to Jessica Aki's Series

Cover image for Databases & SQL Basics As A Beginner: A Practical Introduction

Jan 6

Databases & SQL Basics As A Beginner: A Practical Introduction

#database #sql #beginners #postgressql

3 min read

Cover image for Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

Jan 7

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

#sql #postgres #database #beginners

3 min read

Cover image for Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

Jan 7

Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY

#database #sql #postgres #beginners

3 min read

Cover image for Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

Jan 9

Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t

#sql #database #beginners #postgres

3 min read

Cover image for SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

Jan 9

SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)

#sql #postgres #beginners #database

3 min read

Cover image for I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

Jan 9

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

#postgres #beginners #database #sql

3 min read

Cover image for SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

Jan 13

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

#database #postgres #beginners #sql

3 min read

Cover image for SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

Jan 20

SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations

#sql #postgres #database #beginners

3 min read

Jan 21

SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

#sql #database #postgres #beginners

3 min read

Cover image for How SQL JOINs Finally Clicked for Me (and How They Can for You Too)

Jan 22

How SQL JOINs Finally Clicked for Me (and How They Can for You Too)

#database #sql #postgres #beginners

4 min read

Cover image for ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

Jan 26

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

#sql #postgres #database #beginners

3 min read

Feb 1

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

#database #postgres #sql #beginners

3 min read