Forem

Jessica Aki profile picture

Jessica Aki

Learning databases, data engineering, and building in public

Location Abuja, FCT, Nigeria Joined Joined on 

Education

B. Eng Computer Engineering at Covenant University

Pronouns

She/Her

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

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

7
Comments
3 min read

Want to connect with Jessica Aki?

Create an account to connect with Jessica Aki. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
ROLLUP vs CUBE: How I Finally Understood SQL Subtotals
Cover image for ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

ROLLUP vs CUBE: How I Finally Understood SQL Subtotals

14
Comments
3 min read
Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

Old Oracle Joins vs ANSI JOINs: Why I Chose One and Stuck With It

16
Comments
2 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)

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

28
Comments
4 min read
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird

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

31
Comments
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

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

30
Comments
3 min read
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
Cover image for Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner

30
Comments 1
4 min read
Table Design: Database Fundamentals to Know as a Beginner
Cover image for Table Design: Database Fundamentals to Know as a Beginner

Table Design: Database Fundamentals to Know as a Beginner

27
Comments 2
4 min read
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Cover image for Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)

29
Comments 2
3 min read
Learning Databases Beyond SQL: My First Day with Oracle Tables
Cover image for Learning Databases Beyond SQL: My First Day with Oracle Tables

Learning Databases Beyond SQL: My First Day with Oracle Tables

25
Comments 2
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

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

25
Comments 3
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

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

25
Comments 1
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)

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

20
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

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

25
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

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

25
Comments
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

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

24
Comments
3 min read
Databases & SQL Basics As A Beginner: A Practical Introduction
Cover image for Databases & SQL Basics As A Beginner: A Practical Introduction

Databases & SQL Basics As A Beginner: A Practical Introduction

26
Comments 1
3 min read
loading...