DEV Community

Mohamed Idris profile picture

Education

BCS @ Alexandria University

Work

Web Developer

4 Week Community Wellness Streak
2 Week Community Wellness Streak
Five Year Club
Four Year Club
Writing Debut
Three Year Club
Two Year Club
1 Week Community Wellness Streak
One Year Club
Part 14: Window Functions (Ninja Mode)

Part 14: Window Functions (Ninja Mode)

Comments 1
5 min read

Want to connect with Mohamed Idris?

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

Already have an account? Sign in
Part 13: SQL Injection and Staying Safe

Part 13: SQL Injection and Staying Safe

Comments 1
4 min read
Part 12: Transactions

Part 12: Transactions

Comments 1
4 min read
Part 11: Indexes and Performance

Part 11: Indexes and Performance

Comments 1
5 min read
Part 10: Subqueries and CTEs

Part 10: Subqueries and CTEs

Comments 1
5 min read
Part 09: Relationships and Normalization

Part 09: Relationships and Normalization

Comments 1
5 min read
Part 08: Designing Tables, Data Types and Constraints

Part 08: Designing Tables, Data Types and Constraints

Comments 1
5 min read
Part 07: Writing Data with INSERT, UPDATE, DELETE

Part 07: Writing Data with INSERT, UPDATE, DELETE

Comments 1
5 min read
Part 06: JOINs, Connecting Tables

Part 06: JOINs, Connecting Tables

Comments 1
5 min read
Part 05: Counting and Grouping (Aggregates)

Part 05: Counting and Grouping (Aggregates)

Comments 1
4 min read
Part 04: ORDER BY and LIMIT, Sorting and Paging

Part 04: ORDER BY and LIMIT, Sorting and Paging

Comments 1
4 min read
Part 03: WHERE, Filtering Rows

Part 03: WHERE, Filtering Rows

Comments 1
4 min read
Part 02: SELECT, Your First Questions

Part 02: SELECT, Your First Questions

Comments 1
4 min read
Part 01: What is a Database and SQL?

Part 01: What is a Database and SQL?

Comments 1
4 min read
LEFT JOIN, Explained Like You Are Five

LEFT JOIN, Explained Like You Are Five

1
Comments
3 min read
For ambitious devs who also feel tired

For ambitious devs who also feel tired

1
Comments 1
2 min read
Learning NestJS As If You Built It Yourself

Learning NestJS As If You Built It Yourself

1
Comments
9 min read
Learning Express.js As If You Built It Yourself

Learning Express.js As If You Built It Yourself

1
Comments
12 min read
Learning Prisma As If You Built It Yourself

Learning Prisma As If You Built It Yourself

1
Comments 1
8 min read
Learning MongoDB As If You Built It Yourself

Learning MongoDB As If You Built It Yourself

Comments
12 min read
Learning SQL As If You Built It Yourself

Learning SQL As If You Built It Yourself

1
Comments
12 min read
Learning Frontend Testing As If You Built It Yourself

Learning Frontend Testing As If You Built It Yourself

1
Comments
10 min read
Learning Web Performance As If You Built It Yourself

Learning Web Performance As If You Built It Yourself

2
Comments 1
11 min read
Learning the Web Platform APIs As If You Built Them Yourself

Learning the Web Platform APIs As If You Built Them Yourself

2
Comments 3
10 min read
How to Actually Log Out a User When You Use JWT

How to Actually Log Out a User When You Use JWT

1
Comments
11 min read
Learning HTTP, APIs, and Auth As If You Built It Yourself

Learning HTTP, APIs, and Auth As If You Built It Yourself

1
Comments
12 min read
Learning Next.js As If You Built It Yourself

Learning Next.js As If You Built It Yourself

1
Comments
9 min read
Learning React As If You Built It Yourself

Learning React As If You Built It Yourself

1
Comments
12 min read
Learning TailwindCSS As If You Built It Yourself

Learning TailwindCSS As If You Built It Yourself

Comments
11 min read
Learning TypeScript As If You Built It Yourself

Learning TypeScript As If You Built It Yourself

1
Comments
14 min read
Learning JavaScript As If You Built It Yourself

Learning JavaScript As If You Built It Yourself

1
Comments
10 min read
JavaScript .sort(), "Why b - a, Not a - b"

JavaScript .sort(), "Why b - a, Not a - b"

1
Comments
4 min read
Recursion in 5 Minutes (with examples)

Recursion in 5 Minutes (with examples)

Comments
3 min read
Learning CSS As If You Built It Yourself

Learning CSS As If You Built It Yourself

Comments
11 min read
Cursor Pagination Step by Step

Cursor Pagination Step by Step

Comments
6 min read
Offset Pagination Step by Step (with Sharding)

Offset Pagination Step by Step (with Sharding)

1
Comments 1
8 min read
Learning HTML As If You Built It Yourself

Learning HTML As If You Built It Yourself

1
Comments
11 min read
Prisma relationships, finally explained (with MySQL side by side)

Prisma relationships, finally explained (with MySQL side by side)

Comments 1
12 min read
What is Prisma Client, and why do I have to keep running prisma generate?

What is Prisma Client, and why do I have to keep running prisma generate?

Comments
5 min read
Prisma vs Eloquent, how to think about the two

Prisma vs Eloquent, how to think about the two

Comments
5 min read
What is a database adapter, and why does Prisma 7 need one?

What is a database adapter, and why does Prisma 7 need one?

2
Comments 3
4 min read
ts-node vs tsc, and the TypeScript commands you actually need

ts-node vs tsc, and the TypeScript commands you actually need

1
Comments
4 min read
What does "type" in package.json actually do?

What does "type" in package.json actually do?

1
Comments
3 min read
JWT for Beginners, Plus Where to Store It Safely

JWT for Beginners, Plus Where to Store It Safely

1
Comments 1
7 min read
Stop Fighting Your AI About shadcn Components: Install the Skill

Stop Fighting Your AI About shadcn Components: Install the Skill

Comments
4 min read
shadcn vs Radix vs Base UI: Which One Should a Junior Pick in 2026?

shadcn vs Radix vs Base UI: Which One Should a Junior Pick in 2026?

1
Comments 1
4 min read
Web Accessibility (A11y) for Juniors: What It Is and Why It Matters

Web Accessibility (A11y) for Juniors: What It Is and Why It Matters

1
Comments 1
4 min read
A No-Build Markdown Site for Study Notes (or any docs)

A No-Build Markdown Site for Study Notes (or any docs)

1
Comments
9 min read
How to Reset Your MySQL Root Password on Ubuntu (When Nothing Works)

How to Reset Your MySQL Root Password on Ubuntu (When Nothing Works)

1
Comments
4 min read
I made a swing boat that reacts to doom scrolling

I made a swing boat that reacts to doom scrolling

1
Comments
2 min read
My bot stopped sending questions the day Egypt turned on Daylight Saving Time

My bot stopped sending questions the day Egypt turned on Daylight Saving Time

Comments 1
6 min read
Stop arguing about formatting in code reviews. Use Husky and lint-staged instead.

Stop arguing about formatting in code reviews. Use Husky and lint-staged instead.

1
Comments
3 min read
Resume Update!

Resume Update!

1
Comments
1 min read
How to Undo a Git Commit Without Losing History

How to Undo a Git Commit Without Losing History

Comments
2 min read
The 3-Second Rule: How to Write a Freelance Proposal That Gets Read (and Gets Replies)

The 3-Second Rule: How to Write a Freelance Proposal That Gets Read (and Gets Replies)

Comments
7 min read
If You Were a Server: How to Detect Issues and Keep Things Running Smoothly

If You Were a Server: How to Detect Issues and Keep Things Running Smoothly

1
Comments
10 min read
How to Remove a File from Git History (And What to Watch Out For)

How to Remove a File from Git History (And What to Watch Out For)

Comments
3 min read
JavaScript Promises — Understand what a Promise actually is, how .then() chaining works under the hood, and how async/await connects to all of it

JavaScript Promises — Understand what a Promise actually is, how .then() chaining works under the hood, and how async/await connects to all of it

Comments
3 min read
Dim Other Cards on Hover with Pure CSS

Dim Other Cards on Hover with Pure CSS

1
Comments
2 min read
I Built a Web App to Burn Bad Memories and Grow From Them

I Built a Web App to Burn Bad Memories and Grow From Them

Comments
1 min read
loading...