SQL
Beginner
SQL Indexes: Speed Up Your Queries 100x
Learn indexes, EXPLAIN, when to add them, and why over-indexing slows writes.
SQL
Beginner
SQL Subqueries: Queries Inside Queries
Learn scalar subqueries, IN, NOT IN, EXISTS, correlated subqueries, and derived tables.
SQL
Beginner
PHP PDO: Connect to MySQL the Right Way
Learn PHP PDO — connecting to MySQL, fetching rows, and preventing SQL injection with prepared statements.
SQL
Intermediate
PostgreSQL Full-Text Search
Learn tsvector, tsquery, GIN indexes, ranking, and multi-language search.
SQL
Intermediate
MySQL EXPLAIN: Reading Query Plans
Learn EXPLAIN FORMAT=JSON, EXPLAIN ANALYZE, and identifying bottlenecks.
SQL
Beginner
SQL Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
Learn aggregate functions, GROUP BY to group results, and HAVING to filter groups.
Laravel Eloquent ORM: Relationships, Eager Loading and Query Builder
88 views
SQL Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD Explained
81 views
System Design Interview: Design a Chat Application Like WhatsApp
79 views
PHP File Handling: Read, Write, and Manage Files
33 views
Git Conflict Resolution
31 views
