Skip to main content
MockAttempt App Icon

Install MockAttempt App

Launch full-screen from your iPhone / iPad Home Screen

  1. Step 1: Tap the Safari Share icon โ†‘ at the bottom of your screen.
  2. Step 2: Scroll down and tap โ€œAdd to Home Screenโ€, then tap Add.
๐ŸŽ™๏ธ SPOKEN MOCKATTEMPT AI INTERVIEW HUB Up to 2 Free AI Interviews / Topic / Day โœจ MockAttempt AI (MockAttempt-AI v2.5) Active

Complete Node.js, Express.js & TypeScript Backend Course AI Mock Interview & Free Spoken Viva Practice

Experience realistic engineering interviews powered by our proprietary MockAttempt AI (MockAttempt-AI v2.5) model โ€” our AI Interviewer speaks questions aloud, transcribes your spoken answer via microphone, and evaluates your technical depth across a 4-axis rubric (up to 2 free sessions per topic daily).

MockAttempt AI Viva 2 / Topic / Day

Live Speech-to-Text + 4-axis technical readiness radar. Prefer timed MCQ screening practice?

Step 1 of 2 โ€ข Choose Course Track

Select Any IT Course (21 Courses โ€ข 100% Topics Covered)

Complete Node.js, Express.js & TypeScript Backend Course Logo
NODE Node.js, TypeScript & Express Backend Engineering โ€ข Beginner to Job-Ready Backend Engineer โ€ข 10 Weeks โ€ข Weekend Live (Satโ€“Sun โ€ข 2h/Day) + Coding Lab (Weekend-Only Batch: Satโ€“Sun โ€ข 2 Hrs/Day (7:00 AM โ€“ 8:00 PM IST โ€ข Working Pro Trainers))

Complete Node.js, Express.js & TypeScript Backend Course โ€” Topic-Wise Spoken MockAttempt AI Interviews

Expand any module below to launch a live spoken technical interview across 170 MockAttempt AI rounds (max 2 free sessions per topic per day).

Step 2 of 2 โ€ข Click Any Module to Expand & Enter AI Studio

All Modules & Topics in Complete Node.js, Express.js & TypeScript Backend Course

โœ“ 100% Topic Coverage (170/170 Topics Active) Daily Quota Policy: Max 2 AI Interviews / Topic / Day
1.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Conditional Statements and Guard Clauses

`if / else if / else`, early-return guard clauses flattening nested arrow-antipatterns, and exhaustive `switch...

1.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Loops: for, while, do-while, for...of and for...in

Indexed `for`, condition-driven `while`/`do-while`, iterable `for...of` (`Array`, `Map`, `Set`, `String`), why...

1.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Strings and String Methods

Immutable UTF-16 strings, `slice`, `trim`, `toLowerCase`, `includes`, `startsWith`, `split`/`join`, `replaceAl...

1.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Arrays and Functional Array Methods

Mutating (`push`, `pop`, `splice`, `sort`) vs non-mutating ES2023+ (`toSorted`, `map`, `filter`, `reduce`, `fi...

1.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Objects and Object Manipulation

Object literals, computed keys `[key]`, dynamic property lookup (`Object.hasOwn(obj, key)`), `Object.keys`, `O...

1.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Functions, Parameters and Return Values

First-class functions, arity, default parameter expressions (evaluated per call!), rest parameters `(...items)...

1.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Function Declarations, Expressions and Arrow Functions

Hoisted declarations vs `const fn = function() {}` expressions vs concise `=>` arrow functions (lexical `this`...

1.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Scope and Hoisting

Global, module, function, and `{}` block scopes, scope-chain resolution, function declaration hoisting vs `let...

1.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Execution Context and the Call Stack

Global & Function Execution Contexts (Creation Phase vs Execution Phase), Variable Environment, Lexical Enviro...

1.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Lexical Scope and Closures

How inner functions retain live references to outer lexical environments even after the outer function returns...

1.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
The this Keyword and Binding Rules

4 `this` binding rules in priority order: (1) `new` binding, (2) explicit `call`/`apply`/`bind`, (3) implicit...

1.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
call(), apply() and bind()

Invoking functions immediately with explicit `this` (`fn.call(ctx, a, b)` vs `fn.apply(ctx, argsArray)`) vs cr...

1.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Prototypes and Prototypal Inheritance

`Object.getPrototypeOf()`, `Fn.prototype` vs instance `[[Prototype]]`, property lookup delegation along the pr...

1.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Constructor Functions and ES6 Classes

How `new` works in 4 steps (create object -> link `[[Prototype]]` -> bind `this` -> return object) and modern...

1.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Object-Oriented Programming in JavaScript

Modelling cohesive backend entities, value objects, services, and repositories with clear responsibilities rat...

1.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Inheritance and Polymorphism

`extends`, `super()`, method overriding, polymorphic dispatch across notification/payment strategies (`EmailNo...

1.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Encapsulation (#private Fields) and Abstraction

True runtime-enforced ECMAScript `#private` fields & `#private` methods (inaccessible even via `Object.keys` o...

1.18 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Object and Array Destructuring

Nested destructuring, property aliasing (`{ user_id: userId }`), default values (`= 20` triggered ONLY on `und...

2.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
TypeScript Introduction, Installation and Build/Run Workflow

Static structural type system + full type erasure at runtime, installing `typescript` + `@types/node`, running...

2.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Type Annotations and Type Inference

When TypeScript infers local constants/variables cleanly vs why explicit parameter and public function/method...

2.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Primitive and Special Types: unknown, never, void and any

Why `unknown` is the type-safe top type (forces narrowing before property access!) vs unsafe `any` (disables t...

2.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Typed Arrays, Readonly Arrays, Tuples and Enums vs Const Unions

`string[]`, `readonly string[]` (prevents accidental `.push()`/`.sort()` mutation!), fixed-position tuples `[n...

2.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Function Types, Call Signatures and Overloads

Function type aliases `(req: AuthReq) => Promise<ResponseDto>`, callback typing, and function overload signatu...

2.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Optional and Default Parameters in TypeScript

`limit?: number` (`number | undefined`) vs `limit = 20` (`number`), ordering required params before optional p...

2.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Union and Intersection Types + Discriminated Unions

Tagged **Discriminated Unions** (`type Result<T, E = string> = { ok: true; data: T } | { ok: false; error: E }...

2.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Type Aliases vs Interfaces

Structural compatibility, `interface` `extends` & declaration merging (needed for augmenting `Express.Request....

2.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Type Narrowing and Custom Type Guards

Control-flow narrowing (`typeof`, `instanceof`, `"code" in err`, `Array.isArray`), user-defined type predicate...

2.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Literal Types and Template Literal Types

Exact literal types (`HttpMethod = "GET" | "POST" | "PUT" | "PATCH" | "DELETE"`), template literal types (``Ev...

2.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Generics and Generic Constraints

Type parameters `<T>`, `<K, V>`, constraining `<T extends { readonly id: string }>`, and default generic param...

2.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Generic Functions, Interfaces and Classes

Designing `interface Repository<T, CreateInput, UpdateInput>` implemented identically by `InMemoryRepo` (unit...

2.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Classes and Access Modifiers in TypeScript

Constructor parameter properties (`constructor(private readonly repo: UserRepo) {}`), `public` / `private` / `...

2.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Inheritance and Abstract Classes

`abstract class BaseRepository<T>` sharing common pagination/logging helpers while enforcing `protected abstra...

2.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Interfaces with Classes (Dependency Inversion)

`class RedisCacheService implements CachePort`, programming Services against `CachePort` / `MailPort` interfac...

2.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Utility Types: Partial, Pick, Omit, Record, Required, Readonly

Deriving `PublicUser = Omit<UserEntity, "passwordHash">`, `UpdateEmployeeDto = Partial<Pick<Employee, "departm...

3.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Introduction to Node.js and Backend Engineering Strengths

Why event-driven non-blocking Node.js excels at I/O-intensive REST APIs, API gateways, real-time WebSockets, a...

3.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Installing Node.js LTS, Version Managers and Lockfile Discipline

Active LTS releases (Node 22 LTS), `.nvmrc` / `"engines": { "node": ">=22.0.0" }`, semantic versioning (`^` vs...

3.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Node.js Layered Runtime Architecture

4-layer stack: Your TypeScript/JS App -> Node.js Standard Library (`node:fs`, `node:http`) -> C++ Node Binding...

3.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
V8 JavaScript Engine Internals

Parsing AST -> `Ignition` bytecode interpreter -> profiling hot functions -> `Sparkplug`/`Maglev`/`TurboFan` o...

3.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
libuv and Asynchronous I/O Delegation

How `libuv` routes TCP/HTTP sockets directly to non-blocking OS kernel multiplexers (`epoll` on Linux, `kqueue...

3.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Single-Threaded JS Execution Model and Event-Loop Safety

Why shared-memory mutex races disappear in single-threaded JS, YET logical async interleaving races (`read bal...

3.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Event-Driven Architecture in Node.js

Observer pattern across Node servers, sockets, streams, and domain buses (`server.on("request")`, `stream.on("...

3.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Non-Blocking vs Blocking I/O in Practice

`fs.readFileSync` / `crypto.pbkdf2Sync` / `execSync` (acceptable ONLY once before `server.listen()` at cold bo...

3.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
CommonJS Module System Internals

How Node wraps CJS files `(function(exports, require, module, __filename, __dirname) { ... })`, synchronous lo...

3.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
ES Module System in Node.js

`"type": "module"` in `package.json`, `.mjs`/`.cjs` explicit extensions, asynchronous 3-phase loading (`Constr...

3.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Module Exports, Imports and Subpath Exports

Named exports (preferred for refactoring & explicit contracts) vs default exports, and `package.json` `"export...

3.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Module Resolution and Singleton Caching

How Node caches evaluated modules by resolved real file path (case-sensitivity trap: `./User.js` vs `./user.js...

3.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
File System Module (node:fs/promises)

`readFile`, `writeFile`, atomic temp-write + `rename`, `mkdir({ recursive: true })`, `stat`, `opendir` async d...

3.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Path Module and Directory Traversal Defense (node:path)

`path.join`, `path.resolve`, `path.basename`, `path.extname`, `path.sep` (`\` vs `/`), and verifying `resolved...

3.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
OS Module Diagnostics (node:os)

`os.availableParallelism()` (cgroup/container-aware CPU count in Node 19.4+ โ€” better than `os.cpus().length` i...

3.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Raw HTTP and HTTPS Modules (node:http / node:https)

Building a framework-free `http.createServer((req, res) => ...)` understanding `IncomingMessage` (Readable str...

3.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Events and Typed EventEmitter (node:events)

`on`, `once`, `off`, `emit` (synchronous listener invocation!), special `"error"` event (crashes process if un...

4.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Introduction to Express.js and Minimalist Request Pipeline

How Express wraps `node:http` with routing tables, `req`/`res` prototype helpers, and a linear middleware stac...

4.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Express Installation, TypeScript Types and Express 5 Readiness

Installing `express` + `@types/express`, strict `tsconfig.json`, and how Express 5 automatically forwards reje...

4.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Creating an HTTP Server Cleanly (app.ts vs server.ts)

Wiring `const server = http.createServer(app)` with explicit `keepAliveTimeout` (`65s` > Nginx/ALB `60s` idle...

4.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Scalable Express Application Folder Structure

Feature-first modular layout: `src/modules/employees/{employee.routes.ts, employee.controller.ts, employee.ser...

4.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Routing and Route Parameters (req.params)

Route methods (`get`, `post`, `put`, `patch`, `delete`), `:id` parameters, route registration order (specific...

4.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Query Parameters and Safe Coercion (req.query)

Why every `req.query.*` arrives as `string | string[] | ParsedQs | undefined` (`?role=a&role=b` becomes an ARR...

4.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Express Request and Response Objects

`req.headers`, `req.get("Idempotency-Key")`, `req.ip`, `res.status(201).location(...).json(...)`, `res.set()`,...

4.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Request Body Parsing and Payload Size Limits

`express.json({ limit: "100kb", strict: true })`, `express.urlencoded({ extended: false, limit: "100kb" })`, a...

4.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Middleware Architecture and Execution Order

Exact production middleware order: (1) `requestId` + `pino-http` logger -> (2) `helmet` + `cors` -> (3) Rate l...

4.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
REST Principles and Resource Modelling

Turning imperative business actions (`"promote employee"`, `"deactivate account"`, `"issue refund"`) into clea...

4.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
REST vs RPC (gRPC / tRPC) Trade-Offs

When public/partner/CRUD HTTP resource APIs favor REST + OpenAPI vs when ultra-low-latency internal service-to...

4.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Resource Naming Conventions

Lowercase kebab-case plural nouns (`/api/v1/purchase-orders`, never `/getPurchaseOrders` or `/Purchase_Order`)...

4.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
HTTP Methods and Idempotency Keys

Natural idempotency of `GET`, `PUT`, `DELETE` vs non-idempotent `POST` โ€” and making `POST /orders` or `POST /p...

4.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Status Codes and Actionable Error Contracts

Machine-parsable `error.code` (`EMAIL_ALREADY_EXISTS`, `DEPARTMENT_HAS_ACTIVE_EMPLOYEES`), human `message`, `r...

4.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Request and Response DTO Contracts

Strict separation between `EmployeeCreateRequest`, `EmployeeDbRecord`, and `EmployeeResponse` (never exposing...

4.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
API Versioning Strategies in Production

URI prefix (`/api/v1`) vs Header (`Api-Version: 2026-01-01`), shared domain services serving both `v1Controlle...

4.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Pagination Strategies: Offset vs Keyset Cursor

Why `OFFSET 100000 LIMIT 20` scans & discards `100,000` rows (`O(offset)` latency + skipped/duplicate rows on...

4.18 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Filtering and Sorting Contract Design

Consistent filter query grammar (`status=ACTIVE`, `minSalary=50000`, `joinedAfter=2025-01-01`) and multi-colum...

5.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Database Fundamentals: Storage Engines, Durability and Workload Fit

OLTP vs OLAP, write-ahead journaling, read/write amplification, working-set RAM sizing, and access-pattern ana...

5.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
SQL vs NoSQL Architectural Trade-Offs

Relational ACID tables (schema-on-write, arbitrary ad-hoc joins, foreign keys) vs Document/Key-Value/Wide-Colu...

5.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
MongoDB WiredTiger Architecture

WiredTiger cache (~50% of available RAM), document-level concurrency control, snappy/zstd block compression, `...

5.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Databases, Collections and 16 MB BSON Documents

Dynamic vs JSON-Schema validated collections (`validator: { $jsonSchema: ... }`), `_id` immutability, and the...

5.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
BSON Data Types in Depth

12-byte `ObjectId` (`4B timestamp + 5B random + 3B counter` โ€” naturally roughly time-ordered!), `Int32`/`Int64...

5.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
MongoDB Local & Docker Installation + mongosh

Running `mongo:7` in Docker with a single-node replica set (`--replSet rs0`, required locally to test multi-do...

5.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
MongoDB Atlas Fundamentals

Replica-set `M0/M10+` clusters, `mongodb+srv://` DNS seedlist connection strings, SCRAM auth, IP/VPC peering a...

5.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
MongoDB Compass Visual Explain & Schema Profiling

Inspecting document schema distributions, index usage hit counts, and visual Explain Plans (`Keys Examined` vs...

5.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Introduction to Mongoose ODM vs Native MongoDB Driver

What Mongoose adds (schema enforcement, TypeScript inference, middleware hooks, population, query builders) vs...

5.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Connecting Node.js to MongoDB Resiliently

`mongoose.connect(uri, { maxPoolSize: 20, serverSelectionTimeoutMS: 5000, socketTimeoutMS: 45000, autoIndex: !...

5.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Mongoose Schema Definition and Strict Mode

`new Schema<IProduct>({ ... }, { strict: "throw", timestamps: true, versionKey: "__v" })` rejecting undeclared...

5.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Models and Hydrated Documents

`model<IProduct>("Product", ProductSchema)`, model collection pluralization (`collection: "products"` explicit...

5.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
SchemaTypes and Built-In Validation

`String` (`trim`, `lowercase`, `minLength`, `maxLength`, `enum`, `match`), `Number` (`min`, `max`), `Boolean`,...

5.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Required, Conditional and Custom Validators

Custom `validate: { validator: (v) => ..., message: ... }` functions, SKU format checks, and why uniqueness (`...

5.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Default Values, Immutable Fields and Timestamps

Function defaults (`default: () => randomUUID()` vs static value trap!), `immutable: true` (`tenantId`, `creat...

5.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Instance Methods, Static Methods and Query Helpers

Adding domain methods on `schema.methods` (`function` keyword โ€” NEVER arrow `() =>` which loses `this`!), `sch...

5.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Mongoose Middleware and Hooks Architecture

4 distinct middleware types: **Document** (`validate`, `save`, `deleteOne`), **Query** (`find`, `findOneAndUpd...

6.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Relational Database Concepts

Relations (tables), tuples (rows), attributes (columns), domains, set-based declarative SQL vs imperative loop...

6.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
PostgreSQL Architecture (MVCC, Shared Buffers & WAL)

Client backend processes, `shared_buffers` page cache, Multi-Version Concurrency Control (**MVCC**: readers ne...

6.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Database, Schema and Table Creation (DDL)

`CREATE SCHEMA`, `CREATE TABLE`, `GENERATED ALWAYS AS IDENTITY` (modern SQL standard over legacy `SERIAL`!), s...

6.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
PostgreSQL Data Types Selection

`BIGINT` / `UUID` (`gen_random_uuid()`), `NUMERIC(14, 2)` (exact decimal currency โ€” NEVER `REAL`/`DOUBLE PRECI...

6.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Primary Keys and Foreign Keys

Surrogate keys (`BIGINT` / `UUIDv7`/`v4`) vs natural keys, composite primary keys, `REFERENCES ... ON DELETE R...

6.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Constraints (NOT NULL, UNIQUE, CHECK)

Enforcing domain invariants inside the database engine (`CHECK (qty_on_hand >= 0)`, `CHECK (reserved_qty <= qt...

6.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
INSERT, SELECT, UPDATE, DELETE and Upserts

Multi-row `INSERT ... VALUES ... RETURNING *`, atomic upsert `INSERT ... ON CONFLICT (warehouse_id, sku) DO UP...

6.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
WHERE, ORDER BY and GROUP BY

Sargable predicates (`created_at >= $1 AND created_at < $2` uses index vs `EXTRACT(YEAR FROM created_at) = 202...

6.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Introduction to Prisma ORM Architecture

Declarative `schema.prisma` -> `prisma generate` -> 100% compile-time type-safe `PrismaClient` query builder +...

6.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Prisma Installation and Multi-Environment Configuration

Installing `prisma` (devDependency) + `@prisma/client` (dependency), configuring `DATABASE_URL` via `.env`, an...

6.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Prisma Schema Anatomy and Database Naming (@map & @@map)

Idiomatic camelCase TypeScript fields (`qtyOnHand`, `createdAt`) mapped cleanly onto PostgreSQL `snake_case` c...

6.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Models, Scalar Fields, Enums and Defaults

`@id @default(uuid())` vs `@default(autoincrement())`, `@updatedAt`, native Postgres `enum` mapping, optional...

6.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Native PostgreSQL Data Types (@db.*) and Decimal Precision

`Decimal @db.Decimal(12, 2)` (`Prisma.Decimal` exact decimal math โ€” never JS `float`!), `@db.Timestamptz(6)`,...

6.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Modelling Relationships in Prisma (@relation)

Relation fields vs foreign-key scalar fields, explicit `onDelete: Restrict | Cascade | SetNull`, and disambigu...

6.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
One-to-One, One-to-Many and Explicit Many-to-Many Relations

`1:1` (`@unique` FK), `1:N`, and why **Explicit Join Models** (`OrderItem` with `qty`, `unitPricePaise`, `crea...

6.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Singleton PrismaClient Lifecycle Management

Creating ONE shared `PrismaClient` per Node process (caching on `globalThis` during `tsx watch` dev hot-reload...

6.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Type-Safe CRUD Operations with Prisma Client

`create`, `createManyAndReturn`, `findUnique` / `findFirst`, `findMany`, `update`, `updateMany` (conditional a...

7.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Authentication vs Authorization

`Authentication (AuthN)` = verifying identity (`"Who are you?"` -> `401 Unauthorized` when missing/invalid) vs...

7.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
User Registration and Enumeration-Safe Login

Canonicalizing email (`trim().toLowerCase()`), constant-message `"Invalid email or password"` responses, and p...

7.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Password Hashing Fundamentals

Why fast cryptographic hashes (`SHA-256` runs billions/sec on GPUs!) are catastrophic for passwords vs slow, s...

7.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
bcrypt and Argon2id in Node.js

OWASP #1 recommended **`argon2` (`argon2id`, `memoryCost: 65536`)** vs `bcrypt` (`cost = 12`), async threadpoo...

7.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Password Reset Workflows

Generating `32-byte` CSPRNG token (`crypto.randomBytes(32).toString("hex")`), emailing raw token in link, stor...

7.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Email Verification Workflows

Issuing hashed verification tokens on signup, rate-limiting resend requests (`1 / 60s`), marking `emailVerifie...

7.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
JWT Fundamentals

Compact URL-safe `base64url(header).base64url(payload).base64url(signature)` tokens โ€” **SIGNED (tamper-evident...

7.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
JWT Structure and Strict Signature Verification

Symmetric `HS256` (`>= 256-bit` high-entropy secret) vs asymmetric `RS256`/`EdDSA` (Auth Service signs with pr...

7.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Access Tokens and Refresh Tokens Architecture

Pairing short-lived stateless `Access Token` (`10โ€“15 min` in `Authorization: Bearer`) with long-lived revocabl...

7.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
OWASP API Security Top 10 Overview

API1 BOLA, API2 Broken Auth, API3 Broken Object Property Level Auth (Mass Assignment & Excessive Data Exposure...

7.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Input Validation and Sanitization

Allowlist validation (strict types, lengths, regexes, enums via Zod) OVER blocklist string stripping, plus Uni...

7.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
SQL Injection Prevention

Why parameterized placeholders (`$1, $2` in `pg`, Prisma ORM methods, and `prisma.$queryRaw\`...\`` tagged tem...

7.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
NoSQL Injection Prevention

Blocking JSON operator objects (`{ "$ne": null }`, `{ "$gt": "" }`, `$where` JS execution!) via Zod `z.string(...

7.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Cross-Site Scripting (XSS) Fundamentals for Backend Engineers

Enforcing `Content-Type: application/json; charset=utf-8` + `X-Content-Type-Options: nosniff` on APIs, escapin...

7.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Cross-Site Request Forgery (CSRF) Defense

When CSRF applies (cookie-authenticated state-changing endpoints; NOT pure `Authorization: Bearer` header APIs...

7.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Production CORS Configuration

Dynamic `origin(reqOrigin, cb)` checking an explicit `Set<string>` allowlist, `credentials: true`, explicit `m...

7.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Helmet Security Headers

`Strict-Transport-Security` (`HSTS`), `X-Content-Type-Options: nosniff`, `X-Frame-Options: DENY`, `Referrer-Po...

7.18 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Rate Limiting Architecture

Multi-layer rate limits: Nginx edge IP burst limit + Express Redis-backed per-user/per-IP sliding windows (`ex...

8.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Redis Architecture and Docker Setup

Why single-threaded in-memory Redis executes `100,000+ ops/sec` at sub-millisecond latency (zero context-switc...

8.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Redis Data Types Overview

Choosing the right native structure (`String`, `Hash`, `List`, `Set`, `Sorted Set / ZSET`, `Stream`) instead o...

8.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Strings, Hashes, Lists and Sets

`SET key val EX 300 NX` (atomic set-if-not-exists + expiry!), `INCR`/`DECR`, `HSET`/`HMGET`, `LPUSH`/`RPOP`, a...

8.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Sorted Sets (ZSET) for Leaderboards & Sliding Windows

`ZADD key score member`, `ZINCRBY`, `ZREVRANGE` top-K rankings in `O(log N + K)`, `ZREMRANGEBYSCORE` pruning e...

8.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Redis Commands, Expiration, SCAN and Pipelining

`EXPIRE`/`PEXPIRE`, `TTL`/`PTTL`, cursor-based `SCAN 0 MATCH prefix:* COUNT 100`, `UNLINK` (async non-blocking...

8.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Key Naming Conventions and Memory Modelling

Colon-delimited hierarchical keys `{service}:{version}:{entity}:{id}` (`catalog:v1:product:SKU-101` โ€” bump `v1...

8.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Node.js Redis Integration (ioredis & Lua Atomicity)

`new Redis(url, { maxRetriesPerRequest: 3, enableReadyCheck: true, lazyConnect: true })`, error event handling...

8.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Caching Fundamentals (When to Cache & Hit-Ratio Math)

Effective latency `L_eff = hit_rate * L_cache + (1 - hit_rate) * L_db` (`95%` hit @ `0.5ms` + `5%` miss @ `40m...

8.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Cache-Aside (Lazy Loading) Pattern

Read path: `1) Check Redis -> Hit? Return parsed -> 2) Miss? Query DB -> 3) Populate Redis w/ TTL -> Return` +...

8.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Read-Through, Write-Through and Write-Behind Concepts

Comparing **Cache-Aside** (only requested items cached), **Write-Through** (write updates DB + Cache synchrono...

8.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Advanced Validation Using Zod and Joi

`Zod` (`z.object`, `.strict()`/`.strip()`, `.refine()`, `.transform()`, `z.infer<typeof Schema>` zero-duplicat...

8.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Request Schema Validation Middleware (params, query, body)

`z.coerce.number().int().min(1).max(100).default(20)` for query strings, `z.string().uuid()` for params, forma...

8.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Outbound Response Validation

Running `PublicUserDtoSchema.parse(data)` before `res.json()` (or in tests/staging) as a hard data-leakage fir...

8.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Centralized API Error Mapping (Zod, Prisma, Mongoose, Multer, JWT)

Unified error normalizer converting `ZodError` (`422`), `Prisma P2002` (`409`), `Mongoose 11000` (`409`), `Mul...

8.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
API Versioning Lifecycle & Deprecation Headers

Router-level `/api/v1` vs `/api/v2`, RFC 8594 `Sunset` & `Deprecation: true` headers, and tracking per-version...

8.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Offset Pagination vs Opaque Cursor Pagination

Implementing tamper-checked base64url cursors `{ sortValue, id }` supporting forward (`after`) pagination with...

9.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Synchronous vs Asynchronous Processing

Keeping user-facing HTTP critical path minimal (`validate + write order = 25ms`) while pushing non-blocking si...

9.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Background Job Architecture

Producer (API container enqueues compact JSON `{ orderId }` โ€” NEVER `10 MB` blobs!) -> Durable Broker -> Indep...

9.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Job Queues and Isolated Worker Pools

Separating fast high-priority queues (`otp-emails` SLA `< 3s`) from slow bulk queues (`monthly-csv-exports`) s...

9.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Scheduled and Recurring Jobs

Cron-driven recurring maintenance vs per-entity delayed timers (`check unpaid order #901 in 15m`)

9.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Job Retries and Exponential Backoff

`attempts: 5`, `backoff: { type: "exponential", delay: 2000 }` (`2s -> 4s -> 8s -> 16s -> 32s`) vs failing imm...

9.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Failed Jobs and Dead-Letter Handling (DLQ)

Routing poison-pill messages that exhaust all `attempts` into a retained Dead-Letter Queue (`DLQ`) with error...

9.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Idempotent Job Processing

Why EVERY queue guarantees **At-Least-Once** delivery (worker crash right after sending email / charging card...

9.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Job Queue Monitoring and Operational Health

Tracking `waiting`, `active`, `delayed`, `failed` counts, oldest-waiting job age (`queue lag`), and stalled-jo...

9.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
BullMQ Installation and Architecture

Modern TypeScript-native `bullmq` (`Redis Streams` + atomic Lua scripts replacing legacy `bull`), separate `io...

9.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Real-Time Application Architecture

Bidirectional low-latency use cases (chat, collaborative cursors, live bidding) vs unidirectional server-push...

9.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Short Polling, Long Polling and SSE vs WebSockets

Short Polling (high wasted overhead), HTTP Long Polling (held request), Server-Sent Events (`text/event-stream...

9.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
WebSocket Protocol (RFC 6455 Handshake & Framing)

`GET / HTTP/1.1` + `Upgrade: websocket` + `Sec-WebSocket-Key` -> `101 Switching Protocols` + `Sec-WebSocket-Ac...

9.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Managing Stateful WebSocket Connections & Heartbeats

Detecting half-open "zombie" TCP connections (mobile tunnel drop without FIN packet!) via `pingInterval` (`25s...

9.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Socket.IO Architecture vs Raw ws

What `Socket.IO` adds on top of WebSockets: automatic reconnection with backoff, packet buffering, acknowledgm...

9.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Typed Server-Side Socket.IO Integration in TypeScript

Attaching `new Server<ClientToServerEvents, ServerToClientEvents, InterServerEvents, SocketData>(httpServer, {...

9.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Connection and Disconnection Lifecycle Events

`io.on("connection", socket => ...)`, `socket.on("disconnecting")` (`socket.rooms` is STILL populated here!) v...

10.1 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Software Testing Fundamentals & the Backend Testing Trophy

Static Type/Lint checks (`tsc` + `ESLint`) -> Fast Pure Unit Tests -> High-Confidence API + Real-DB Integratio...

10.2 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Unit Testing Pure Domain Logic and Services

Arrange-Act-Assert (`AAA`) structure, testing pure pricing/coupon/token calculators and Services injected with...

10.3 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Integration Testing Repositories and Persistence

Verifying actual Prisma/PostgreSQL and Mongoose/MongoDB queries, unique/check constraints, cascade rules, and...

10.4 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
HTTP API Testing Principles

Asserting HTTP status code, `Content-Type`, security/rate/location headers, response JSON schema, AND post-req...

10.5 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
End-to-End Backend Flow Testing

Multi-step stateful user journeys (`Register -> Capture OTP from FakeMailer -> Verify Email -> Login -> Access...

10.6 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Test-Driven Development (TDD) Fundamentals

`Red` (write failing test specifying exact behavior) -> `Green` (write minimal clean code to pass) -> `Refacto...

10.7 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Jest and Vitest Configuration for TypeScript + ESM

Configuring `vitest.config.ts` / `jest.config.ts` (`ts-jest` / native ESM), separating fast `test:unit` from D...

10.8 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Node.js Testing Best Practices & Handle Cleanup

Closing Prisma (`$disconnect`), Mongoose (`disconnect`), and Redis (`quit`) in `afterAll`, using `--detectOpen...

10.9 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Linux Server Filesystems and Production Directory Layout

Structuring `/srv/backend` or `/opt/app`, `/etc/nginx/sites-available`, `/var/log/nginx`, swap sizing, and che...

10.10 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Linux Users, Groups and Least-Privilege Permissions

Creating dedicated unprivileged system user `useradd --system --create-home --shell /usr/sbin/nologin nodeapp`...

10.11 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Linux Process Management and systemd Service Units

Writing `/etc/systemd/system/backend-api.service` (`Restart=on-failure`, `RestartSec=5`, `User=nodeapp`, `Envi...

10.12 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Linux Networking Commands and Firewall Hardening (ufw)

`ss -tulpn`, `ip addr`, `curl -I http://127.0.0.1:3000/healthz`, `nc -zv`, and `ufw default deny incoming` all...

10.13 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
SSH Hardening and Secure Remote Administration

Ed25519 SSH keys, `PasswordAuthentication no`, `PermitRootLogin no`, SSH bastion/port forwarding (`ssh -L 5433...

10.14 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Production Server Environment Variable Management

Storing `/etc/backend/api.env` (`chmod 0600`, `chown root:nodeapp` or `nodeapp:nodeapp`) outside the Git worki...

10.15 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Server Logs, logrotate and Diagnostics

`journalctl -u backend-api --since "10 min ago"`, configuring `/etc/logrotate.d/` (`daily`, `rotate 14`, `comp...

10.16 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Linux Server Tuning (File Descriptors & TCP Backlog)

Raising `ulimit -n` (`nofile = 65535`, default `1024` crashes Node with `EMFILE: too many open files` at ~900...

10.17 1 AI Round โ€ข 4 Spoken Qs 0/2 Today
Containerization Concepts vs Virtual Machines

Linux kernel `namespaces` (isolated PID, net, mount, user views) + `cgroups` (CPU/RAM caps) sharing the host k...

๐ŸŽ“ Free 1st Live Demo + Study & Interview Pack โ€ข Instant Email OTP Access

Want Unlimited Spoken NODE AI Vivas + Live Weekend Mentorship With Working IT Pros?

Train live on weekends with active Working IT Professionals โ€ข All-Inclusive Fee: $43 USD All-Incl. (Includes 30-Day 100% Upgrade Credit)

โšก Free 1st Live Demo โ€ข All-Inclusive Fees (Incl. 18% GST)

Book Free Live Demo or Reserve Batch Seat

+ Add Background, Location or Questions (Optional)