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.
SQL
Intermediate
PostgreSQL JSONB: Query, Index, and Operators
Learn JSONB operators, GIN indexes, jsonb_set, and performance patterns.
SQL
Intermediate
MySQL Indexing: B-Tree, Hash, and Composite
Learn B-Tree, hash, composite, and covering indexes — when each type helps.
Laravel Eloquent ORM: Relationships, Eager Loading and Query Builder
32 views
SQL Window Functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD Explained
30 views
System Design Interview: Design a Chat Application Like WhatsApp
24 views
PHP File Handling: Read, Write, and Manage Files
20 views
Git Conflict Resolution
19 views
PHP Input Validation: Never Trust User Data
Jun 3, 2026
PHP Magic Methods: __construct, __get, __set, __toString and More
Jun 2, 2026
PHP Static Methods and Properties Explained
Jun 1, 2026
PHP Abstract Classes vs Interfaces: Know the Difference
May 31, 2026
PHP Arrow Functions and Closures Explained
May 30, 2026