DEV Community

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

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

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

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

29
Comments
3 min read
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

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)

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

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

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

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)

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

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

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

Learning SQL in Practice: LeetCode Challenges and Setting Up PostgreSQL

24
Comments
3 min read
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...