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

2 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