DEV Community

Databases and SQL from Scratch Series' Articles

Back to Jessica Aki's Series
Databases & SQL Basics As A Beginner: A Practical Introduction
Cover image for Databases & SQL Basics As A Beginner: A Practical Introduction
mazinocodes profile

Databases & SQL Basics As A Beginner: A Practical Introduction

#database #sql #beginners #postgressql
26
Comments 1
3 min read
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL
Cover image for Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL
mazinocodes profile

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

#sql #postgres #database #beginners
24
Comments
3 min read
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY
Cover image for Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY
mazinocodes profile

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

#database #sql #postgres #beginners
25
Comments
3 min read
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t
Cover image for Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t
mazinocodes profile

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

#sql #database #beginners #postgres
25
Comments
3 min read
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)
Cover image for SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)
mazinocodes profile

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

#sql #postgres #beginners #database
20
Comments
3 min read
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL
Cover image for I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL
mazinocodes profile

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

#postgres #beginners #database #sql
25
Comments 1
3 min read
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG
Cover image for SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG
mazinocodes profile

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

#database #postgres #beginners #sql
25
Comments 3
3 min read
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
Cover image for SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
mazinocodes profile

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

#sql #postgres #database #beginners
30
Comments
3 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
mazinocodes profile

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

#sql #database #postgres #beginners
31
Comments
3 min read
How SQL JOINs Finally Clicked for Me (and How They Can for You Too)
Cover image for How SQL JOINs Finally Clicked for Me (and How They Can for You Too)
mazinocodes profile

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

#database #sql #postgres #beginners
28
Comments
4 min read
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
Cover image for ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
mazinocodes profile

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

#sql #postgres #database #beginners
14
Comments
3 min read
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL
mazinocodes profile

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

#database #postgres #sql #beginners
7
Comments
3 min read