17 articles

📰 Dev.to · Jessica Aki

Articles from Dev.to · Jessica Aki · 17 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (9011) ArXiv cs.AIDev.to · FORUM WEBForbes InnovationOpenAI NewsDev.to AIHugging Face Blog
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL
Dev.to · Jessica Aki 2mo ago
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL
When I first learned SQL, everything was very… static. I wrote queries. They ran. They returned...
Read article → + Playlist
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
Dev.to · Jessica Aki 2mo ago
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
When I first ran into ROLLUP and CUBE in SQL, I genuinely thought I understood them. I didn’t. I...
Read article → + Playlist
Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It
Dev.to · Jessica Aki 2mo ago
Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It
When I first encountered Oracle’s old join syntax using the (+) operator, I was confused — not...
Read article → + Playlist
How SQL JOINs Finally Clicked for Me (and How They Can for You Too)
Dev.to · Jessica Aki 2mo ago
How SQL JOINs Finally Clicked for Me (and How They Can for You Too)
Today's post is not a “perfect” explanation of SQL joins. It’s the explanation I wish I had when...
Read article → + Playlist
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
Dev.to · Jessica Aki 2mo ago
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
Up until now, SQL felt very… solid. Numbers are numbers. Strings are strings. GROUP BY either works...
Read article → + Playlist
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
Dev.to · Jessica Aki 2mo ago
SQL Nulls Finally Made Sense: COALESCE, NULLIF, and Safer Calculations
This was one of those learning days where SQL didn’t look hard… but kept quietly breaking my...
Read article → + Playlist
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
Dev.to · Jessica Aki 2mo ago
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
Today felt like one of those quiet but important SQL days. No new tables. No fancy joins. Just...
Read article → + Playlist
Table Design: Database Fundamentals to Know as a Beginner
Dev.to · Jessica Aki 2mo ago
Table Design: Database Fundamentals to Know as a Beginner
This post is part of my Learning Databases Beyond SQL journey. I’m starting to realize that writing...
Read article → + Playlist
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Dev.to · Jessica Aki 2mo ago
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Day 2 of learning Oracle SQL was less about writing fancy queries and more about understanding what...
Read article → + Playlist
Learning Databases Beyond SQL: My First Day with Oracle Tables
Dev.to · Jessica Aki 2mo ago
Learning Databases Beyond SQL: My First Day with Oracle Tables
Well today didn’t go the way I expected. I planned to continue my usual PostgreSQL + SQL practice,...
Read article → + Playlist
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG
Dev.to · Jessica Aki 2mo ago
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG
Today was one of those SQL days where things look simple… until you actually write the query. I...
Read article → + Playlist
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL
Dev.to · Jessica Aki 3mo ago
I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL
Today, I built a User Analytics Database in PostgreSQL. The goal was to simulate a real-world...
Read article → + Playlist
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)
Dev.to · Jessica Aki 3mo ago
SQL Pattern Matching As A Beginner (LIKE, ILIKE, IN, BETWEEN)
Today was one of those SQL days where things didn’t feel flashy, but they finally felt...
Read article → + Playlist
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t
Dev.to · Jessica Aki 3mo ago
Learning SQL Subqueries as a Beginner: What Made Sense and What Didn’t
Today I stopped just watching SQL videos and finally went hands-on. Instead of passively following...
Read article → + Playlist
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY
Dev.to · Jessica Aki 3mo ago
Practicing SQL with Real Data: INSERT, WHERE, ORDER BY, and GROUP BY
Day three was all about reinforcing the basics, not rushing forward, but getting comfortable with...
Read article → + Playlist
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL
Dev.to · Jessica Aki 3mo ago
Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL
Day Two with SQL: From LeetCode Challenges to My First PostgreSQL Tables Today’s learning...
Read article → + Playlist
Databases & SQL Basics As A Beginner: A Practical Introduction
Dev.to · Jessica Aki 3mo ago
Databases & SQL Basics As A Beginner: A Practical Introduction
Databases & SQL Basics: What I Learned on Day One Today I officially started my...
Read article → + Playlist