IT Interview Preparation

Core database concepts: relational vs non-relational, SQL, indexing, transactions, normalization, and scaling.

PostgreSQL end to end: types, joins, CTEs, window functions, JSONB, indexes, MVCC, vacuum, partitioning, replication, and performance tuning.

Non-relational databases end to end: data models, storage engines, consistency, replication, sharding, transactions, and the main engines (MongoDB, Redis, DynamoDB, Cassandra, Neo4j).

MongoDB from CRUD and the aggregation pipeline to indexing, schema design, replica sets, sharding, transactions, and the WiredTiger storage engine.

Core JavaScript from the ground up: types, scope, closures, prototypes, this, the event loop, async patterns, and modern language features.

TypeScript from the type system's basics to advanced patterns: generics, utility types, narrowing, conditional and mapped types, and idioms for real-world code.

React from components and hooks to reconciliation, concurrent rendering, server components, and performance patterns.

Node.js runtime from fundamentals to production: the event loop, streams, async patterns, clustering, worker threads, memory, and performance.

HTML end to end: semantic structure, forms, accessibility, metadata, performance hints, security attributes, and web components.

CSS from box model and selectors to flexbox, grid, custom properties, stacking contexts, container queries, cascade layers, and modern features.