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.
📝 TOPIC-WISE TIMED MCQ PRACTICE HUB Up to 2 Free Attempts / Topic / Day

Python Backend Developer – Industry-Ready Career Program Online Mock Test (Free 50-MCQ Topic Practice)

Select any course and syllabus topic below to launch a timed topic MCQ engineering exam (up to 2 free attempts per topic daily) with instant code-level explanations.

Daily Free Quota 2 / Topic / Day

Timed code-output & architecture MCQs with instant scorecard. Want spoken viva practice too?

Step 1 of 2 • Choose Course Track

Select Any IT Course (21 Courses • 100% Topics Covered)

Python Backend Developer – Industry-Ready Career Program Logo
PBCP Python Backend, Django & FastAPI Engineering • Beginner to Job-Ready • 24 Weeks (6 Months) • Beginner to Job-Ready (Weekend-Only Batch: Sat–Sun • 2 Hrs/Day (7:00 AM – 8:00 PM IST • Working Pro Trainers))

Python Backend Developer – Industry-Ready Career Program — Topic-Wise Mock Tests

Expand any module below to start a live timed MCQ exam across 610 Mock Test sets (max 2 free attempts per topic per day).

Step 2 of 2 • Click Any Module to Expand & Start Exam

All Modules & Topics in Python Backend Developer – Industry-Ready Career Program

✓ 100% Topic Coverage (610/610 Topics Active) Daily Quota Policy: Max 2 Attempts / Topic / Day
1.1 1 Set • 20m • Pass 70% 0/2 Today
Introduction to Programming

Programming concepts, step-by-step algorithms, flowcharts, dry-running, and structured problem-solving

1.2 1 Set • 20m • Pass 70% 0/2 Today
Python Introduction

Python history, readability philosophy (PEP 8 / Zen of Python), backend/API/automation/data applications, and...

1.3 1 Set • 20m • Pass 70% 0/2 Today
Python Installation

Installing Python 3.12 on Windows (`PATH` & `py` launcher) and Linux (`apt`/`pyenv`), verifying `python3` and...

1.4 1 Set • 20m • Pass 70% 0/2 Today
Environment Setup

Configuring VS Code (Python + Pylance + Ruff extensions), PyCharm, integrated terminal, and selecting the work...

1.5 1 Set • 20m • Pass 70% 0/2 Today
Python Execution

Interactive REPL mode vs `.py` script mode, source -> bytecode (`.pyc` in `__pycache__`) -> Python Virtual Mac...

1.6 1 Set • 20m • Pass 70% 0/2 Today
Python Syntax

4-space block indentation rules (PEP 8), logical vs physical lines, docstrings, and meaningful single-line `#`...

1.7 1 Set • 20m • Pass 70% 0/2 Today
Variables

Dynamic variable binding, object references, `snake_case` naming rules, multiple assignment, and tuple swappin...

1.8 1 Set • 20m • Pass 70% 0/2 Today
Data Types

Built-in scalar types (`int` arbitrary precision, `float` IEEE-754, `complex`, `bool`, `str`, `NoneType`) and...

1.9 1 Set • 20m • Pass 70% 0/2 Today
Type Conversion

Implicit numeric promotion (`int` -> `float`) vs explicit constructors (`int()`, `float()`, `str()`, `bool()`)...

1.10 1 Set • 20m • Pass 70% 0/2 Today
Input and Output

Reading console text via `input()`, `print()` (`sep`, `end`, `flush`), and formatted f-string numeric/alignmen...

1.11 1 Set • 20m • Pass 70% 0/2 Today
Operators

Arithmetic (`+`, `-`, `*`, `/` true division, `//` floor division, `%` modulo, `**` power), comparison, logica...

1.12 1 Set • 20m • Pass 70% 0/2 Today
Bitwise Operators

Bitwise AND (`&`), OR (`|`), XOR (`^`), NOT (`~`), left shift (`<<`), and right shift (`>>`) on integers

1.13 1 Set • 20m • Pass 70% 0/2 Today
Membership Operators

`in` and `not in` across strings, lists, tuples, sets, and dictionary keys, plus `O(1)` `set` vs `O(n)` `list`...

1.14 1 Set • 20m • Pass 70% 0/2 Today
Identity Operators

`is` and `is not`, `id()` memory address checks, singleton `None` checks (`x is None`), vs `==` value comparis...

1.15 1 Set • 20m • Pass 70% 0/2 Today
Operator Precedence

Python evaluation order (`**`, unary `-`, `* / // %`, `+ -`, shifts, bitwise, comparisons, `not`, `and`, `or`)...

1.16 1 Set • 20m • Pass 70% 0/2 Today
Conditional Statements

`if`, `elif`, `else` branching, mutually exclusive grade/slab ladders, and concise conditional expressions (`x...

1.17 1 Set • 20m • Pass 70% 0/2 Today
Nested Conditions

Multi-criteria decision trees vs early-return guard clauses to flatten deeply indented nested `if` blocks

1.18 1 Set • 20m • Pass 70% 0/2 Today
Loops

Definite iteration with `for` over iterables and indefinite condition-driven `while` loops (including loop `el...

1.19 1 Set • 20m • Pass 70% 0/2 Today
Loop Control Statements

Exiting early with `break`, skipping iterations with `continue`, placeholder `pass`, and `for ... else` search...

1.20 1 Set • 20m • Pass 70% 0/2 Today
Range Function

`range(stop)`, `range(start, stop)`, `range(start, stop, step)`, negative reverse steps, `O(1)` lazy memory fo...

1.21 1 Set • 20m • Pass 70% 0/2 Today
Pattern Programming

Nested row/column loop invariants for right triangles, pyramids, Floyd’s number triangle, and character patter...

1.22 1 Set • 20m • Pass 70% 0/2 Today
Basic Debugging

Reading Python tracebacks bottom-up, distinguishing `SyntaxError` vs `NameError`/`TypeError`/`ValueError`/`Zer...

2.1 1 Set • 20m • Pass 70% 0/2 Today
Strings

Unicode UTF-8 string literals, raw strings `r"..."`, multiline strings, positive `0..n-1` and negative `-1..-n...

2.2 1 Set • 20m • Pass 70% 0/2 Today
String Slicing

Slice notation `s[start:stop:step]`, omitting bounds, negative steps `s[::-1]` reversal, and out-of-range slic...

2.3 1 Set • 20m • Pass 70% 0/2 Today
String Methods

`upper()`, `lower()`, `casefold()`, `strip()`/`lstrip()`/`rstrip()`, `removeprefix()`, `removesuffix()`, `spli...

2.4 1 Set • 20m • Pass 70% 0/2 Today
String Searching

`find()` / `rfind()` (`-1` on miss) vs `index()` / `rindex()` (`ValueError` on miss) and non-overlapping `coun...

2.5 1 Set • 20m • Pass 70% 0/2 Today
String Validation

`startswith()` (accepting a tuple of prefixes!), `endswith()`, `isdigit()`, `isalpha()`, `isalnum()`, and `iss...

2.6 1 Set • 20m • Pass 70% 0/2 Today
String Formatting

Modern f-strings `f"{expr}"`, debug `f"{var=}"`, numeric formatting `:.2f`, `:,`, ISO dates, vs `.format()` te...

2.7 1 Set • 20m • Pass 70% 0/2 Today
String Immutability

Why `str` objects cannot be mutated in-place, `O(n^2)` loop `+=` concatenation penalty vs `O(n)` `"".join(part...

2.8 1 Set • 20m • Pass 70% 0/2 Today
Lists

Dynamic array internals of `list`, literal/constructor creation, indexing, slicing, slice assignment, and `len...

2.9 1 Set • 20m • Pass 70% 0/2 Today
List Operations

`append()` (`O(1)` amortized), `extend()`, `insert(0, x)` (`O(n)` shift!), and `remove(val)` (`ValueError` if...

2.10 1 Set • 20m • Pass 70% 0/2 Today
List Methods

`pop()` (`O(1)` tail vs `O(n)` index), `clear()`, in-place `sort(key=..., reverse=...)` vs non-mutating `sorte...

2.11 1 Set • 20m • Pass 70% 0/2 Today
List Comprehension

`[expr for x in iterable if cond]`, conditional transformations, flattening 2D matrices, and readability limit...

2.12 1 Set • 20m • Pass 70% 0/2 Today
Tuples

Immutable fixed-structure `tuple` records, single-element trailing comma `(42,)`, tuple packing/unpacking, and...

2.13 1 Set • 20m • Pass 70% 0/2 Today
Tuple Methods

`.count(value)`, `.index(value)`, memory efficiency of tuples vs lists (`sys.getsizeof`), and immutability of...

2.14 1 Set • 20m • Pass 70% 0/2 Today
Sets

Hash-table backed `set` and immutable `frozenset`, `set()` empty set creation (NOT `{}`!), `O(1)` membership a...

2.15 1 Set • 20m • Pass 70% 0/2 Today
Set Operations

Union (`|` / `.union()`), intersection (`&` / `.intersection()`), difference (`-`), symmetric difference (`^`)...

2.16 1 Set • 20m • Pass 70% 0/2 Today
Set Methods

`add()`, `update()`, `discard()` (no error if missing) vs `remove()` (`KeyError` if missing), and `pop()`

2.17 1 Set • 20m • Pass 70% 0/2 Today
Dictionaries

Insertion-ordered hash map (`dict`, guaranteed since Python 3.7+), hashable keys, `O(1)` read/write/delete, an...

2.18 1 Set • 20m • Pass 70% 0/2 Today
Dictionary Methods

`.keys()`, `.values()`, `.items()` dynamic views, `.get(k, default)`, `.pop(k, default)`, `.setdefault()`, and...

2.19 1 Set • 20m • Pass 70% 0/2 Today
Dictionary Comprehension

`{k_expr: v_expr for item in iterable if cond}`, inverting unique maps, and filtering sensitive keys from logs

2.20 1 Set • 20m • Pass 70% 0/2 Today
Nested Collections

Lists of dictionaries, dictionaries of lists/dicts, safe chained `.get()` navigation, and grouping records by...

2.21 1 Set • 20m • Pass 70% 0/2 Today
Mutable and Immutable Objects

Immutable (`int`, `float`, `bool`, `str`, `tuple`, `frozenset`) vs mutable (`list`, `dict`, `set`) types, hash...

2.22 1 Set • 20m • Pass 70% 0/2 Today
Shallow Copy

`list.copy()`, `dict.copy()`, `s[:]`, and `copy.copy()` — duplicating the outer container while sharing nested...

2.23 1 Set • 20m • Pass 70% 0/2 Today
Deep Copy

`copy.deepcopy()`, recursive cloning of nested graphs, memoization of cyclic references, and memory/CPU trade-...

2.24 1 Set • 20m • Pass 70% 0/2 Today
Collection Use Cases

Decision matrix: `list` (ordered mutable sequence), `tuple` (immutable fixed record), `set` (`O(1)` unique mem...

3.1 1 Set • 20m • Pass 70% 0/2 Today
Functions

`def` declaration, docstrings (PEP 257), single-responsibility design, invocation, and implicit `None` return

3.2 1 Set • 20m • Pass 70% 0/2 Today
Function Parameters

Positional arguments, keyword arguments, positional-only (`/`) and keyword-only (`*`) parameter markers

3.3 1 Set • 20m • Pass 70% 0/2 Today
Default Parameters

Default parameter evaluation at `def` definition time (ONCE!) and the `None` sentinel pattern for mutable defa...

3.4 1 Set • 20m • Pass 70% 0/2 Today
Variable Arguments

Variadic positional `*args` (packed as `tuple`), variadic keyword `**kwargs` (packed as `dict`), and call-site...

3.5 1 Set • 20m • Pass 70% 0/2 Today
Return Statements

Early-return guard clauses, returning multiple values via tuple packing/unpacking, and consistent return types

3.6 1 Set • 20m • Pass 70% 0/2 Today
Variable Scope (LEGB)

Local -> Enclosing -> Global -> Built-in (LEGB) name resolution, `global` vs `nonlocal`, and why mutable globa...

3.7 1 Set • 20m • Pass 70% 0/2 Today
Lambda Functions

Single-expression anonymous `lambda params: expr` functions for inline sort keys and callbacks vs named `def`...

3.8 1 Set • 20m • Pass 70% 0/2 Today
Recursion

Base case + progress toward base case, call stack frames, `sys.getrecursionlimit()` (~1000 in CPython, no tail...

3.9 1 Set • 20m • Pass 70% 0/2 Today
Higher-Order Functions

First-class functions passed as arguments (strategy/validator callbacks) and returned from factory functions

3.10 1 Set • 20m • Pass 70% 0/2 Today
map() Function

Lazy iterator `map(func, *iterables)` transformation vs list/generator comprehensions

3.11 1 Set • 20m • Pass 70% 0/2 Today
filter() Function

Lazy predicate filtering `filter(pred, iterable)`, `filter(None, iterable)` truthy filtering, vs comprehension...

3.12 1 Set • 20m • Pass 70% 0/2 Today
functools.reduce()

`functools.reduce(fn, iterable, initializer)` cumulative folding vs Pythonic built-ins (`sum`, `min`, `max`, `...

3.13 1 Set • 20m • Pass 70% 0/2 Today
Python Modules

Creating reusable `.py` modules, module namespace isolation, `sys.modules` import cache, and avoiding circular...

3.14 1 Set • 20m • Pass 70% 0/2 Today
Python Packages

Multi-directory package hierarchy (`banking/models/`, `banking/services/`), `__init__.py`, `__all__`, and expl...

3.15 1 Set • 20m • Pass 70% 0/2 Today
Import System

Absolute imports (`from app.services.auth import verify`), explicit relative imports, `sys.path`, and why `fro...

3.16 1 Set • 20m • Pass 70% 0/2 Today
Main Execution Guard (__name__)

How Python sets `__name__ == "__main__"` on direct execution vs module path on `import`, protecting CLI entryp...

3.17 1 Set • 20m • Pass 70% 0/2 Today
Python Standard Library

Practical backend usage of `os`, `sys`, `math`, `random`/`secrets`, and timezone-aware `datetime` (`datetime.n...

3.18 1 Set • 20m • Pass 70% 0/2 Today
Exception Handling

`try` and `except SpecificError as exc:` blocks, exception hierarchy (`BaseException` vs `Exception`), and pre...

3.19 1 Set • 20m • Pass 70% 0/2 Today
Multiple Exceptions

Handling distinct failure modes with separate `except` clauses vs grouped tuples `except (ConnectionError, Tim...

3.20 1 Set • 20m • Pass 70% 0/2 Today
else and finally Clauses

Why `try ... except ... else ... finally` keeps the `try` scope narrow (`else` runs only if no exception; `fin...

3.21 1 Set • 20m • Pass 70% 0/2 Today
Raising Exceptions (raise)

Validating invariants with `raise ValueError(...)`, re-raising active exceptions via bare `raise`, and chainin...

3.22 1 Set • 20m • Pass 70% 0/2 Today
Custom Exceptions

Designing a project base exception (`BankingError(Exception)`) and rich domain subclasses (`InsufficientFundsE...

3.23 1 Set • 20m • Pass 70% 0/2 Today
Assertions

`assert condition, message` for internal developer invariants vs explicit `if ...: raise ValueError(...)` for...

3.24 1 Set • 20m • Pass 70% 0/2 Today
Debugging with pdb

Python 3.7+ `breakpoint()`, `pdb` commands (`n` next, `s` step, `c` continue, `l` list, `p` print, `w` where s...

3.25 1 Set • 20m • Pass 70% 0/2 Today
Application Logging

`logging` module (`DEBUG`, `INFO`, `WARNING`, `ERROR`, `CRITICAL`), `getLogger(__name__)`, formatters, `Stream...

4.1 1 Set • 20m • Pass 70% 0/2 Today
OOP Introduction

Procedural vs object-oriented design, coupling data + behavior, and the 4 OOP pillars in Python backend archit...

4.2 1 Set • 20m • Pass 70% 0/2 Today
Classes

`class` statement, `CapWords` (`PascalCase`) PEP 8 naming, class namespace dictionary (`__dict__`), and docstr...

4.3 1 Set • 20m • Pass 70% 0/2 Today
Objects

Class instantiation `obj = ClassName(...)`, unique object identity (`id(obj)`), `isinstance()`, and attribute...

4.4 1 Set • 20m • Pass 70% 0/2 Today
Constructors (__init__)

Object initialization via `__init__(self, ...)` (vs `__new__` allocator), validating invariants at constructio...

4.5 1 Set • 20m • Pass 70% 0/2 Today
self Instance Reference

How Python binds `instance.method(x)` to `Class.method(instance, x)` and why explicit `self` is first paramete...

4.6 1 Set • 20m • Pass 70% 0/2 Today
Instance Variables

Object-specific attributes bound on `self.attr` inside `__init__`, dynamic attribute storage in `obj.__dict__`

4.7 1 Set • 20m • Pass 70% 0/2 Today
Class Variables

Class-level attributes shared across all instances (`company_name`, constants), lookup fallback `obj.__dict__`...

4.8 1 Set • 20m • Pass 70% 0/2 Today
Instance Methods

Behavior operating on `self` state, mutator vs query methods, and calling sibling methods via `self.`

4.9 1 Set • 20m • Pass 70% 0/2 Today
Class Methods (@classmethod)

`@classmethod` decorator, `cls` class binding (subclass-aware!), and named alternative constructors (`from_dic...

4.10 1 Set • 20m • Pass 70% 0/2 Today
Static Methods (@staticmethod)

`@staticmethod` decorator for namespace-grouped pure helper functions requiring neither `self` nor `cls`

4.11 1 Set • 20m • Pass 70% 0/2 Today
Encapsulation

Public attributes, `_protected` convention, `__private` name mangling (`_ClassName__attr`), and invariant prot...

4.12 1 Set • 20m • Pass 70% 0/2 Today
Single Inheritance

Deriving specialized `class Sub(Base):` (`is-a` relationship), `super().__init__(...)`, and extending base beh...

4.13 1 Set • 20m • Pass 70% 0/2 Today
Multiple Inheritance

Inheriting from multiple bases `class View(AuthMixin, AuditMixin, BaseView):` and cooperative `super()` mixin...

4.14 1 Set • 20m • Pass 70% 0/2 Today
Multilevel Inheritance

Chained `GrandParent -> Parent -> Child` hierarchies (`Exception -> BankingError -> InsufficientFundsError`) a...

4.15 1 Set • 20m • Pass 70% 0/2 Today
Hierarchical Inheritance

Multiple sibling subclasses (`SavingsAccount`, `CurrentAccount`, `SalaryAccount`) sharing one common parent (`...

4.16 1 Set • 20m • Pass 70% 0/2 Today
Polymorphism and Duck Typing

Method overriding across subtypes and Pythonic duck typing ("if it implements `.send()`, treat it as a sender"...

4.17 1 Set • 20m • Pass 70% 0/2 Today
Abstraction

Separating WHAT a repository/gateway contract promises from HOW PostgreSQL, Redis, or JSON files implement it

4.18 1 Set • 20m • Pass 70% 0/2 Today
abc Module (Abstract Base Classes)

`from abc import ABC, abstractmethod`, preventing instantiation of incomplete subclasses at instantiation time

4.19 1 Set • 20m • Pass 70% 0/2 Today
Composition

Strong `has-a` ownership (`Order` owns `OrderLine` items; `EmployeeService` composes a `Repository` + `Logger`...

4.20 1 Set • 20m • Pass 70% 0/2 Today
Aggregation

Loose `has-a` relationship where child objects (`Employee`) have an independent lifecycle from the container (...

4.21 1 Set • 20m • Pass 70% 0/2 Today
Method Resolution Order (MRO)

C3 Linearization algorithm, inspecting `ClassName.mro()` / `__mro__`, and how `super()` follows MRO in diamond...

4.22 1 Set • 20m • Pass 70% 0/2 Today
Magic / Dunder Methods (__str__, __repr__, __len__, __eq__)

Unambiguous developer `__repr__` vs user-friendly `__str__`, container `__len__`, value equality `__eq__` (ret...

4.23 1 Set • 20m • Pass 70% 0/2 Today
Properties (@property and Setters)

`@property` computed getters, `@attr.setter` validation mutators, and read-only attributes without breaking `o...

4.24 1 Set • 20m • Pass 70% 0/2 Today
Dataclasses (@dataclass)

`from dataclasses import dataclass, asdict`, auto-generated `__init__`, `__repr__`, `__eq__`, type annotations...

4.25 1 Set • 20m • Pass 70% 0/2 Today
File Handling (open, read, write, append)

`open(path, mode, encoding="utf-8")`, `.read()`, `.readline()`, `.readlines()`, line-by-line lazy iteration `f...

4.26 1 Set • 20m • Pass 70% 0/2 Today
File Modes (r, w, a, x and Binary)

Read `r`, truncate-write `w`, append `a`, exclusive-create `x` (`FileExistsError`), binary `rb`/`wb` for image...

4.27 1 Set • 20m • Pass 70% 0/2 Today
Context Managers (with Statement)

`with open(...) as f:` deterministic `__enter__` / `__exit__` cleanup even when exceptions are raised mid-bloc...

4.28 1 Set • 20m • Pass 70% 0/2 Today
CSV Reading and Writing

`csv.reader`, `csv.writer`, `csv.DictReader`, `csv.DictWriter`, `writeheader()`, and `newline=""` requirement

4.29 1 Set • 20m • Pass 70% 0/2 Today
JSON Serialization and Deserialization

`json.dumps()` / `json.dump(..., indent=2)` and `json.loads()` / `json.load()`, `json.JSONDecodeError`, and cu...

4.30 1 Set • 20m • Pass 70% 0/2 Today
Pickle Object Serialization Fundamentals

Binary Python object serialization (`pickle.dumps`/`loads`), Python-only format limitations, and arbitrary cod...

4.31 1 Set • 20m • Pass 70% 0/2 Today
pathlib File and Path Management

`from pathlib import Path`, `/` path joining, `.resolve()`, `.exists()`, `.is_file()`, `.mkdir(parents=True, e...

5.1 1 Set • 20m • Pass 70% 0/2 Today
Iterables

Objects implementing `__iter__` (or sequence `__getitem__`), reusable multi-pass containers (`list`, `dict`) v...

5.2 1 Set • 20m • Pass 70% 0/2 Today
Iterators

Stateful Iterator Protocol (`__iter__` returning `self` + `__next__` raising `StopIteration` when exhausted)

5.3 1 Set • 20m • Pass 70% 0/2 Today
iter() and next()

Manual iteration via `it = iter(obj)` and `next(it, default)` sentinel handling without `StopIteration` crashe...

5.4 1 Set • 20m • Pass 70% 0/2 Today
Generators (yield)

Generator functions pausing frame state at `yield`, `yield from` delegation, and `O(1)` memory streaming

5.5 1 Set • 20m • Pass 70% 0/2 Today
Generator Expressions

Lazy `(expr for x in iterable if cond)` parenthesized expressions passed directly into `sum()`, `any()`, `all(...

5.6 1 Set • 20m • Pass 70% 0/2 Today
Function Decorators

`@decorator` syntactic sugar (`fn = decorator(fn)`), preserving `__name__`/`__doc__` metadata with `@functools...

5.7 1 Set • 20m • Pass 70% 0/2 Today
Nested Decorators

Parameterized decorator factories (`@retry(max_attempts=3)`) and bottom-up composition order of stacked `@d1`...

5.8 1 Set • 20m • Pass 70% 0/2 Today
Closures

Lexical scope capture (`__closure__` cell objects) and late-binding loop variable pitfalls in closures

5.9 1 Set • 20m • Pass 70% 0/2 Today
Custom Context Managers (__enter__ and __exit__)

Class-based context manager protocol (`__enter__` resource acquisition, `__exit__(exc_type, exc_val, tb)` clea...

5.10 1 Set • 20m • Pass 70% 0/2 Today
contextlib (@contextmanager)

`from contextlib import contextmanager, suppress, ExitStack` generator-based context managers (`try: yield res...

5.11 1 Set • 20m • Pass 70% 0/2 Today
Advanced Comprehensions

Set comprehensions `{...}`, dict comprehensions `{k: v ...}`, and nested comprehensions with filtering

5.12 1 Set • 20m • Pass 70% 0/2 Today
Extended Iterable Unpacking

Starred target unpacking `first, *middle, last = seq`, nested tuple unpacking, and `{**d1, **d2}` / `[*a, *b]`...

5.13 1 Set • 20m • Pass 70% 0/2 Today
Walrus Operator (:=)

Assignment expressions `if (m := pattern.search(line)):` and `while (chunk := f.read(8192)):` avoiding duplica...

5.14 1 Set • 20m • Pass 70% 0/2 Today
Structural Pattern Matching (match and case)

Python 3.10+ `match subject:` with sequence, mapping (`case {"type": "paid", "amount": amt}:`), class, OR (`|`...

5.15 1 Set • 20m • Pass 70% 0/2 Today
Type Hints and Annotations

PEP 484/585/604 modern Python 3.12 syntax (`list[str]`, `dict[str, int]`, `str | None`), return `-> None`, and...

5.16 1 Set • 20m • Pass 70% 0/2 Today
typing Module (List, Dict, Optional, Union, Callable)

`Any` vs `object`, `Literal`, `TypedDict`, `Final`, `Collections.abc.Callable`, and legacy `Optional`/`Union`/...

5.17 1 Set • 20m • Pass 70% 0/2 Today
Generic Typing (TypeVar and Generic)

Python 3.12 PEP 695 generic syntax `class Page[T]:` and `def first[T](items: list[T]) -> T:` (plus `TypeVar`/`...

5.18 1 Set • 20m • Pass 70% 0/2 Today
Protocols (Structural Subtyping)

`from typing import Protocol, runtime_checkable` — static duck typing without forcing nominal `ABC` inheritanc...

5.19 1 Set • 20m • Pass 70% 0/2 Today
Advanced Dataclasses (field, frozen, slots)

`@dataclass(frozen=True, slots=True, kw_only=True)`, `field(default_factory=..., repr=False)`, and `replace()`...

5.20 1 Set • 20m • Pass 70% 0/2 Today
Enums (Enum and IntEnum)

`from enum import Enum, IntEnum, StrEnum, auto` for type-safe finite states (`ApplicationStatus`, `UserRole`)

5.21 1 Set • 20m • Pass 70% 0/2 Today
collections Module (Counter, defaultdict, namedtuple, deque)

`Counter.most_common()`, `defaultdict(list)` grouping, `namedtuple` lightweight records, and `deque(maxlen=N)`...

5.22 1 Set • 20m • Pass 70% 0/2 Today
functools (partial, lru_cache, wraps)

`@lru_cache(maxsize=256)` / `@cache` memoization, `cache_info()`, `partial()` argument pre-binding, and `@wrap...

5.23 1 Set • 20m • Pass 70% 0/2 Today
itertools (chain, combinations, permutations, groupby)

`itertools.chain.from_iterable`, `islice`, `batched` (Python 3.12!), `combinations`, `permutations`, and `grou...

5.24 1 Set • 20m • Pass 70% 0/2 Today
Regular Expressions (re Module)

`re.compile()`, raw patterns `r"..."`, `search` vs `match` vs `fullmatch`, `findall`, `sub`, named groups `(?P...

5.25 1 Set • 20m • Pass 70% 0/2 Today
Environment Variables (os.environ)

`os.environ.get("KEY", default)` vs mandatory `os.environ["SECRET_KEY"]` fail-fast startup validation, `.env`...

5.26 1 Set • 20m • Pass 70% 0/2 Today
Application Configuration Management

Layered `BaseConfig` -> `DevConfig` / `TestConfig` / `ProdConfig` dataclasses, `.env.example` templates, and f...

5.27 1 Set • 20m • Pass 70% 0/2 Today
Python Packaging (pyproject.toml)

Modern PEP 621 `pyproject.toml` metadata, `src/` vs flat layout, editable installs `pip install -e .`, and too...

5.28 1 Set • 20m • Pass 70% 0/2 Today
Virtual Environments (venv)

`python -m venv .venv`, activation on Windows (`.venv\Scripts\activate`) and Linux (`source .venv/bin/activate...

5.29 1 Set • 20m • Pass 70% 0/2 Today
Dependency Management (pip, requirements.txt and Poetry)

Pinned deterministic `requirements.txt` vs `requirements-dev.txt`, semantic version constraints, and `Poetry`...

6.1 1 Set • 20m • Pass 70% 0/2 Today
Python Execution Model

Source parsing -> AST -> code objects -> bytecode evaluation loop on the Python Virtual Machine stack frame

6.2 1 Set • 20m • Pass 70% 0/2 Today
CPython Runtime Architecture

CPython reference interpreter vs PyPy/Cython, C extension ABI, and why NumPy/psycopg release the GIL in C code

6.3 1 Set • 20m • Pass 70% 0/2 Today
Python Bytecode Compilation (dis)

Inspecting stack-machine opcodes (`LOAD_FAST`, `BINARY_OP`, `RETURN_VALUE`), `.pyc` caching, and Python 3.11+...

6.4 1 Set • 20m • Pass 70% 0/2 Today
Memory Allocation in Python

Private CPython heap, `PyObject` header (`ob_refcnt` + `ob_type`), `pymalloc` small-object arenas, and `tracem...

6.5 1 Set • 20m • Pass 70% 0/2 Today
Reference Counting

Immediate deterministic deallocation when `ob_refcnt` drops to `0`, inspecting `sys.getrefcount()`, and strong...

6.6 1 Set • 20m • Pass 70% 0/2 Today
Cyclic Garbage Collection (gc)

Why reference cycles (`a.peer = b; b.peer = a`) never hit refcount `0`, generational `gc` (Gen 0/1/2), and `gc...

6.7 1 Set • 20m • Pass 70% 0/2 Today
Mutable Object References in Memory

Shared references across containers, in-place mutation (`+=` on `list` calls `__iadd__`) vs rebinding (`+=` on...

6.8 1 Set • 20m • Pass 70% 0/2 Today
Shallow vs Deep Copying in Memory

Memory graph topology of alias (`=`), shallow copy (`copy.copy`), and deep copy (`copy.deepcopy`) on nested st...

6.9 1 Set • 20m • Pass 70% 0/2 Today
Global Interpreter Lock (GIL)

What the CPython GIL protects, why CPU-bound Python bytecode runs 1 thread at a time per process, and why I/O...

6.10 1 Set • 20m • Pass 70% 0/2 Today
Threading Fundamentals

OS threads inside a single shared-memory process, main thread vs daemon threads, and preemptive context switch...

6.11 1 Set • 20m • Pass 70% 0/2 Today
Creating and Managing Threads

`threading.Thread(target=..., args=...)`, `.start()`, `.join(timeout=...)`, and collecting results via thread-...

6.12 1 Set • 20m • Pass 70% 0/2 Today
Thread Synchronization (Lock and RLock)

Mutual exclusion with `threading.Lock()` (`with lock:`), re-entrant `RLock()` when a locked method calls anoth...

6.13 1 Set • 20m • Pass 70% 0/2 Today
Race Conditions

Check-then-act (`if balance >= amt: balance -= amt`) and read-modify-write (`counter += 1` is multiple bytecod...

6.14 1 Set • 20m • Pass 70% 0/2 Today
Deadlocks and Prevention

Circular lock wait (`Thread 1 locks A -> waits B`, `Thread 2 locks B -> waits A`) and prevention via canonical...

6.15 1 Set • 20m • Pass 70% 0/2 Today
Thread Pools (ThreadPoolExecutor)

`from concurrent.futures import ThreadPoolExecutor, as_completed`, `executor.submit()`, `executor.map()`, `Fut...

6.16 1 Set • 20m • Pass 70% 0/2 Today
Multiprocessing (Process-Based Parallelism)

Separate OS processes, separate Python heaps + separate GILs for true multi-core CPU parallelism, `spawn` vs `...

6.17 1 Set • 20m • Pass 70% 0/2 Today
Process Pools (ProcessPoolExecutor)

`concurrent.futures.ProcessPoolExecutor` unified `Future` API, pickling overhead vs chunk size (`chunksize`),...

6.18 1 Set • 20m • Pass 70% 0/2 Today
Inter-Process Communication (Queue and Pipe)

Why separate processes do NOT share global variables, passing messages safely via `multiprocessing.Queue` and...

6.19 1 Set • 20m • Pass 70% 0/2 Today
Threading vs Multiprocessing Comparison

Memory footprint, startup latency, GIL impact, crash isolation, and state-sharing trade-offs between threads a...

6.20 1 Set • 20m • Pass 70% 0/2 Today
Asynchronous Programming Model

Cooperative single-threaded multitasking vs preemptive OS threads, non-blocking sockets (`epoll`/`IOCP`), and...

6.21 1 Set • 20m • Pass 70% 0/2 Today
Coroutines with async and await

`async def` coroutine functions, coroutine objects (do nothing until awaited!), and `await` suspension points

6.22 1 Set • 20m • Pass 70% 0/2 Today
Asyncio Event Loop

`asyncio.run()` lifecycle, ready queue vs I/O selector callbacks, `asyncio.get_running_loop()`, and `asyncio.t...

6.23 1 Set • 20m • Pass 70% 0/2 Today
asyncio Core Module

`asyncio.sleep`, `asyncio.wait_for(coro, timeout=...)`, `asyncio.Semaphore` concurrency throttling, and `async...

6.24 1 Set • 20m • Pass 70% 0/2 Today
Concurrent Tasks (asyncio.create_task)

Scheduling coroutines eagerly on the loop with `asyncio.create_task()`, task cancellation (`task.cancel()`), a...

6.25 1 Set • 20m • Pass 70% 0/2 Today
Parallel Awaitables (asyncio.gather)

`await asyncio.gather(*aws, return_exceptions=True)` result ordering and partial failure handling across concu...

6.26 1 Set • 20m • Pass 70% 0/2 Today
Async Context Managers (async with)

`__aenter__` and `__aexit__` protocol and `@contextlib.asynccontextmanager` for async DB sessions and HTTP cli...

6.27 1 Set • 20m • Pass 70% 0/2 Today
Async Iterators (__aiter__ and async for)

`__aiter__` and `async def __anext__` (`StopAsyncIteration`) consumed via `async for item in stream:`

6.28 1 Set • 20m • Pass 70% 0/2 Today
Async Generators

`async def` containing `yield`, async generator comprehensions, and `contextlib.aclosing()` deterministic clea...

6.29 1 Set • 20m • Pass 70% 0/2 Today
Async HTTP Requests (httpx)

Using `httpx.AsyncClient(timeout=...)`, connection pooling, `raise_for_status()`, and concurrent outbound REST...

6.30 1 Set • 20m • Pass 70% 0/2 Today
Choosing the Right Concurrency Model

Architecture decision matrix: `asyncio` vs `ThreadPoolExecutor` vs `ProcessPoolExecutor` vs Celery/Kafka distr...

7.1 1 Set • 20m • Pass 70% 0/2 Today
DSA Introduction

Why algorithmic efficiency matters in backend APIs (10ms vs 30s timeout on 100k rows) and structured interview...

7.2 1 Set • 20m • Pass 70% 0/2 Today
Time Complexity Analysis

Counting dominant operations across single loops, nested loops, halving loops, and hidden Python library costs...

7.3 1 Set • 20m • Pass 70% 0/2 Today
Space Complexity Analysis

Auxiliary memory vs input memory, recursion call-stack depth `O(h)`, slice copy allocations `arr[i:j]`, and in...

7.4 1 Set • 20m • Pass 70% 0/2 Today
Big O Notation (O(1), O(log n), O(n), O(n log n), O(n^2))

Asymptotic growth hierarchy, dropping constants/lower-order terms, best/average/worst cases, and amortized `O(...

7.5 1 Set • 20m • Pass 70% 0/2 Today
Dynamic Arrays in Python Lists

Over-allocated C pointer array backing Python `list`, `O(1)` indexing & tail `append`/`pop`, `O(n)` middle `in...

7.6 1 Set • 20m • Pass 70% 0/2 Today
Array Traversal and In-Place Manipulation

Single-pass read/write index pointers, Dutch National Flag 3-way partition (`0, 1, 2`), and cyclic index place...

7.7 1 Set • 20m • Pass 70% 0/2 Today
String Problem-Solving Patterns

Character frequency arrays (`ord(c) - ord("a")`) / `Counter`, two-pointer palindrome checks, anagram grouping,...

7.8 1 Set • 20m • Pass 70% 0/2 Today
Hashing with Python Dictionaries

Complement lookup (`target - x` in `seen`), index mapping, frequency counting, and `OrderedDict` `O(1)` LRU ca...

7.9 1 Set • 20m • Pass 70% 0/2 Today
Set-Based Lookup and Deduplication

`O(1)` `set` existence checks, sequence-start detection (`x - 1 not in num_set`), and cycle/duplicate detectio...

7.10 1 Set • 20m • Pass 70% 0/2 Today
Two-Pointer Technique

Converging opposite-end pointers (`l = 0, r = n - 1`) on sorted arrays, Container With Most Water, 3Sum, and T...

7.11 1 Set • 20m • Pass 70% 0/2 Today
Sliding Window (Fixed and Variable)

Fixed-size `k` rolling window and variable `[l..r]` window expanding `r` and shrinking `l` while invariant is...

7.12 1 Set • 20m • Pass 70% 0/2 Today
Prefix Sums and Range Queries

`pref[i + 1] = pref[i] + nums[i]` for `O(1)` range sums, prefix-sum + hashmap (`pref - k`) subarray counting,...

7.13 1 Set • 20m • Pass 70% 0/2 Today
Linear and Binary Search (bisect)

Iterative binary search (`l <= r` vs lower-bound `l < r`), `bisect_left` / `bisect_right`, rotated sorted sear...

7.14 1 Set • 20m • Pass 70% 0/2 Today
Elementary Sorting (Bubble, Selection, Insertion)

In-place comparison sorts, stability definition, and why Insertion Sort runs in `O(n)` on nearly-sorted data

7.15 1 Set • 20m • Pass 70% 0/2 Today
Divide-and-Conquer Sorting (Merge Sort and Quick Sort)

Stable `O(n log n)` Merge Sort, randomized Quick Sort partitioning, Python Timsort `key=` functions, and inter...

7.16 1 Set • 20m • Pass 70% 0/2 Today
Recursive Problem-Solving

Recurrence relations, divide-and-conquer fast modular exponentiation, recursion trees, and call-stack space an...

7.17 1 Set • 20m • Pass 70% 0/2 Today
Backtracking Search and Pruning

Choose -> Explore -> Unchoose (`path.append` / `dfs` / `path.pop`) template for Subsets, Permutations, Combina...

7.18 1 Set • 20m • Pass 70% 0/2 Today
Singly and Doubly Linked Lists

`ListNode` pointer rewiring, dummy sentinel heads, Floyd’s fast/slow tortoise-hare cycle & middle detection, a...

7.19 1 Set • 20m • Pass 70% 0/2 Today
Stacks and Monotonic Stacks

LIFO stack via Python `list` (`append`/`pop`), balanced brackets, `MinStack`, and monotonic stack (`Next Great...

7.20 1 Set • 20m • Pass 70% 0/2 Today
Queues and collections.deque

FIFO queue with `collections.deque` (`append` + `popleft` in `O(1)`), circular queues, and monotonic deque (`S...

7.21 1 Set • 20m • Pass 70% 0/2 Today
Binary Tree Fundamentals

`TreeNode(val, left, right)`, height/depth, diameter, balanced check, symmetric tree, and path sum recursion

7.22 1 Set • 20m • Pass 70% 0/2 Today
Binary Search Trees (BST)

Strict BST range invariant `(min_val < node.val < max_val)`, `O(h)` search/insert/delete, Kth smallest via ino...

7.23 1 Set • 20m • Pass 70% 0/2 Today
Tree Traversals (Inorder, Preorder, Postorder, Level-Order)

Recursive & iterative DFS traversals (`inorder`, `preorder`, `postorder`) and `deque` BFS `levelOrder` / right...

7.24 1 Set • 20m • Pass 70% 0/2 Today
Min-Heap and Max-Heap (heapq)

`heapq.heappush`, `heappop`, `heapify` (`O(n)`!), max-heap via `-val` negation, Top-K Frequent, Kth Largest, a...

7.25 1 Set • 20m • Pass 70% 0/2 Today
Graph Representations (Adjacency List and Matrix)

Directed vs undirected, weighted vs unweighted graphs, `defaultdict(list)` adjacency lists (`O(V + E)` space)...

7.26 1 Set • 20m • Pass 70% 0/2 Today
Breadth-First Search (BFS)

Shortest unweighted path via `deque`, multi-source BFS (`Rotting Oranges`), and Kahn’s in-degree Topological S...

7.27 1 Set • 20m • Pass 70% 0/2 Today
Depth-First Search (DFS)

Recursive and explicit-stack DFS, connected components, grid flood-fill, and 3-color (`0=unvisited, 1=visiting...

7.28 1 Set • 20m • Pass 70% 0/2 Today
Greedy Algorithm Fundamentals

Greedy-choice property vs DP, earliest-finish-time interval scheduling, Jump Game reachability, and Gas Statio...

7.29 1 Set • 20m • Pass 70% 0/2 Today
Dynamic Programming (Memoization and Tabulation)

Overlapping subproblems + optimal substructure, top-down `@lru_cache` memoization vs bottom-up 1D/2D tabulatio...

7.30 1 Set • 20m • Pass 70% 0/2 Today
Bit Manipulation Problems

XOR self-cancellation (`Single Number`), `n & (n - 1)` Brian Kernighan set-bit clearing, `(n & -n)` lowest set...

8.1 1 Set • 20m • Pass 70% 0/2 Today
Version Control Fundamentals

Distributed Version Control (DVCS), auditability, blame history, safe experimentation, and team rollback guara...

8.2 1 Set • 20m • Pass 70% 0/2 Today
Git Architecture (Working Directory, Staging, Repository)

Three-tree model: Working Tree -> Staging Area (`.git/index`) -> Local `.git/objects` DAG (`blob`, `tree`, `co...

8.3 1 Set • 20m • Pass 70% 0/2 Today
Git Installation and Configuration

`git config --global user.name`, `user.email`, `init.defaultBranch main`, `core.autocrlf` (Windows `true` vs L...

8.4 1 Set • 20m • Pass 70% 0/2 Today
git init (Repository Initialization)

Initializing `.git` at project root, verifying repository boundaries, and immediate `.gitignore` creation befo...

8.5 1 Set • 20m • Pass 70% 0/2 Today
git status (Inspecting Working Tree)

Interpreting untracked, unstaged, staged, ahead/behind remote tracking indicators before every commit

8.6 1 Set • 20m • Pass 70% 0/2 Today
git add (Staging Changes)

Explicit file staging `git add src/models.py`, interactive hunk staging `git add -p`, and unstaging via `git r...

8.7 1 Set • 20m • Pass 70% 0/2 Today
git commit (Atomic Commits)

Conventional Commits (`feat:`, `fix:`, `refactor:`, `test:`, `docs:`) explaining WHY a change was made in smal...

8.8 1 Set • 20m • Pass 70% 0/2 Today
git log (Inspecting Commit History)

`git log --oneline --graph --decorate --all`, `-p` patch view, `-S "symbol"` pickaxe search, and file history

8.9 1 Set • 20m • Pass 70% 0/2 Today
git diff (Comparing Changes)

Unstaged `git diff`, staged `git diff --staged`, and branch-to-branch `git diff main...feat/search` self-revie...

8.10 1 Set • 20m • Pass 70% 0/2 Today
git branch (Branch Creation)

Lightweight 41-byte `HEAD` pointer mechanics, naming conventions (`feat/...`, `fix/...`, `chore/...`), `-a` li...

8.11 1 Set • 20m • Pass 70% 0/2 Today
git switch (Switching Branches)

Modern `git switch <branch>` and `git switch -c <new-branch>` vs `git restore` (replacing ambiguous overloaded...

8.12 1 Set • 20m • Pass 70% 0/2 Today
git merge (Fast-Forward and 3-Way Merges)

Fast-forward pointer advance vs 3-way merge commit (`--no-ff`) vs Squash & Merge on Pull Requests

8.13 1 Set • 20m • Pass 70% 0/2 Today
Merge Conflict Resolution

Reading `<<<<<<< HEAD`, `=======`, `>>>>>>> branch` markers, resolving semantic intent, running `pytest`, and...

8.14 1 Set • 20m • Pass 70% 0/2 Today
git rebase Fundamentals

Replaying feature commits linearly atop latest `origin/main` (`git rebase main`), `--continue`/`--abort`, and...

8.15 1 Set • 20m • Pass 70% 0/2 Today
git stash (Saving Work in Progress)

`git stash push -u -m "wip: ..."`, `git stash list`, `git stash pop` vs `apply`, and `git stash drop`

8.16 1 Set • 20m • Pass 70% 0/2 Today
git reset (Soft, Mixed and Hard)

`--soft` (moves `HEAD` only), `--mixed` (unstages too), `--hard` (DESTROYS working changes!), and `git reflog`...

8.17 1 Set • 20m • Pass 70% 0/2 Today
git revert (Safe Public Rollbacks)

Creating a new inverse commit via `git revert <sha>` to undo broken commits safely on shared `main` without re...

8.18 1 Set • 20m • Pass 70% 0/2 Today
Remote Repositories Configuration

`git remote -v`, `origin` vs `upstream`, SSH (`git@github.com:...`) vs HTTPS PAT remotes, and `git remote set-...

8.19 1 Set • 20m • Pass 70% 0/2 Today
git clone

Cloning full history vs shallow CI clones `git clone --depth 1`, automatic `origin` remote setup, and post-clo...

8.20 1 Set • 20m • Pass 70% 0/2 Today
git fetch

Safely downloading remote commits/refs (`origin/main`) via `git fetch --prune` WITHOUT mutating your local wor...

8.21 1 Set • 20m • Pass 70% 0/2 Today
git pull

`git pull --ff-only` vs `git pull --rebase` and avoiding accidental merge-bubble commits on local branches

8.22 1 Set • 20m • Pass 70% 0/2 Today
git push

Publishing feature branches `git push -u origin feat/search`, branch protection rules, and `--force-with-lease...

8.23 1 Set • 20m • Pass 70% 0/2 Today
GitHub Repository Management

Branch protection on `main`, required status checks, Issue templates, Releases/tags (`v1.0.0`), and Dependabot...

8.24 1 Set • 20m • Pass 70% 0/2 Today
Pull Requests and Review Workflow

Draft vs Ready PRs, concise PR descriptions (Summary, Changes, Test Plan), linking Issues (`Closes #12`), and...

8.25 1 Set • 20m • Pass 70% 0/2 Today
Python .gitignore Best Practices

Excluding `__pycache__/`, `*.py[cod]`, `.venv/`, `.env`, `.pytest_cache/`, `.mypy_cache/`, `.ruff_cache/`, `*....

8.26 1 Set • 20m • Pass 70% 0/2 Today
Technical Documentation with README.md

Writing recruiter- and engineer-ready `README.md`: architecture overview, tech stack, setup commands, `.env` t...

8.27 1 Set • 20m • Pass 70% 0/2 Today
Feature Branching Strategy

GitHub Flow (short-lived feature branches -> PR -> CI -> `main`) vs GitFlow release branches and trunk-based d...

8.28 1 Set • 20m • Pass 70% 0/2 Today
Reviewing Python Code in PRs

Checking SQL injection/secrets, mutable defaults, `N+1` queries, missing timeouts, bare `except:`, edge cases,...

8.29 1 Set • 20m • Pass 70% 0/2 Today
Agile Fundamentals (Sprints, Backlog, Task Tracking)

User stories, acceptance criteria, backlog refinement, 1–2 week Sprints, Definition of Done (code + tests + do...

9.1 1 Set • 20m • Pass 70% 0/2 Today
Database and DBMS Introduction

Why flat JSON/CSV files fail under concurrent multi-user writes, durability, crash recovery, and DBMS responsi...

9.2 1 Set • 20m • Pass 70% 0/2 Today
Relational Database Architecture (RDBMS)

Relations (tables), tuples (rows), attributes (columns), schemas, catalog metadata, client-server TCP protocol...

9.3 1 Set • 20m • Pass 70% 0/2 Today
Relational vs NoSQL Databases (PostgreSQL, MySQL, SQLite)

PostgreSQL (primary production RDBMS), SQLite (embedded file DB for local/tests), MySQL fundamentals, vs docum...

9.4 1 Set • 20m • Pass 70% 0/2 Today
PostgreSQL Installation and Configuration

Installing PostgreSQL 16 (native & Docker), roles/users, `postgresql.conf`, `pg_hba.conf`, port `5432`, and le...

9.5 1 Set • 20m • Pass 70% 0/2 Today
Database Tools (psql and pgAdmin)

`psql` CLI meta-commands (`\l`, `\c`, `\dt`, `\d+ table`, `\timing`) and visual schema/explain inspection in `...

9.6 1 Set • 20m • Pass 70% 0/2 Today
CREATE DATABASE

`CREATE DATABASE ... ENCODING 'UTF8'`, `DROP DATABASE IF EXISTS`, and isolated `dev` / `test` / `prod` databas...

9.7 1 Set • 20m • Pass 70% 0/2 Today
CREATE TABLE

`CREATE TABLE IF NOT EXISTS`, `GENERATED ALWAYS AS IDENTITY` (modern SQL standard over legacy `SERIAL`), `ALTE...

9.8 1 Set • 20m • Pass 70% 0/2 Today
SQL Data Types (Numeric, Character, Date/Time, Boolean, UUID)

`BIGINT`/`INTEGER`, exact `NUMERIC(12, 2)` vs `DOUBLE PRECISION`, `VARCHAR(n)`/`TEXT`, `DATE`/`TIMESTAMPTZ` (a...

9.9 1 Set • 20m • Pass 70% 0/2 Today
Relational Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE)

Single & composite `PRIMARY KEY`, `FOREIGN KEY ... REFERENCES ... ON DELETE RESTRICT/CASCADE/SET NULL`, and `U...

9.10 1 Set • 20m • Pass 70% 0/2 Today
Domain Constraints (NOT NULL, CHECK, DEFAULT)

`NOT NULL` mandatory columns, `CHECK (salary >= 0 AND max_salary >= min_salary)` domain invariants, and server...

9.11 1 Set • 20m • Pass 70% 0/2 Today
INSERT Statements

Single-row and multi-row batch `INSERT INTO ... VALUES`, PostgreSQL `RETURNING id`, and idempotent `ON CONFLIC...

9.12 1 Set • 20m • Pass 70% 0/2 Today
SELECT Queries

Explicit column projection `SELECT id, emp_code, email` vs `SELECT *`, computed expressions, `CASE WHEN ... EN...

9.13 1 Set • 20m • Pass 70% 0/2 Today
WHERE Filtering

Comparison predicates (`=`, `<>`, `<`, `<=`, `>`, `>=`), 3-valued `NULL` logic (`IS NULL` / `IS NOT NULL`), an...

9.14 1 Set • 20m • Pass 70% 0/2 Today
DISTINCT Deduplication

`SELECT DISTINCT col1, col2` and PostgreSQL `SELECT DISTINCT ON (department_id) ... ORDER BY ...` latest-per-g...

9.15 1 Set • 20m • Pass 70% 0/2 Today
ORDER BY Sorting

Multi-column `ASC`/`DESC` sorting, `NULLS LAST` / `NULLS FIRST`, and deterministic tie-breaker `ORDER BY creat...

9.16 1 Set • 20m • Pass 70% 0/2 Today
LIMIT and OFFSET Pagination

Offset pagination (`LIMIT 20 OFFSET 40`) vs Keyset/Cursor pagination (`WHERE (created_at, id) < (...) LIMIT 20...

9.17 1 Set • 20m • Pass 70% 0/2 Today
UPDATE Statements

Targeted `UPDATE ... SET ... WHERE ... RETURNING *`, atomic in-place increments `SET stock = stock - 1 WHERE i...

9.18 1 Set • 20m • Pass 70% 0/2 Today
DELETE Statements

Guarded `DELETE FROM ... WHERE ... RETURNING id`, `TRUNCATE` vs `DELETE`, and soft-delete (`deleted_at TIMESTA...

9.19 1 Set • 20m • Pass 70% 0/2 Today
Logical Operators (AND, OR, NOT, IN)

`AND` binds tighter than `OR` (always parenthesize `OR`!), `IN (...)`, and `NOT EXISTS` vs `NOT IN` null safet...

9.20 1 Set • 20m • Pass 70% 0/2 Today
BETWEEN Range Filtering

Inclusive `BETWEEN low AND high` (`col >= low AND col <= high`) vs half-open `[start, next_day)` timestamp ran...

9.21 1 Set • 20m • Pass 70% 0/2 Today
LIKE and ILIKE Pattern Matching

`%` (0+ chars) and `_` (1 char) wildcards, PostgreSQL case-insensitive `ILIKE`, escaping literal `%`/`_`, and...

9.22 1 Set • 20m • Pass 70% 0/2 Today
Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)

`COUNT(*)` (all rows) vs `COUNT(col)` (non-null only!) vs `COUNT(DISTINCT col)`, `SUM`, `AVG`, `MIN`, `MAX`, a...

9.23 1 Set • 20m • Pass 70% 0/2 Today
GROUP BY Aggregation

Grouping by one or multiple columns/expressions and the SQL functional-dependency rule (every non-aggregated `...

9.24 1 Set • 20m • Pass 70% 0/2 Today
HAVING Group Filtering

SQL logical execution order (`FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> DISTINCT -> ORDER BY -> LIMIT`)...

9.25 1 Set • 20m • Pass 70% 0/2 Today
Column and Table Aliases

Readable column aliases (`AS monthly_ctc`) and concise table aliases (`employees AS e`, `departments AS d`) ac...

10.1 1 Set • 20m • Pass 70% 0/2 Today
INNER JOIN

Equi-joins across 2+ tables (`JOIN ... ON e.department_id = d.id`) returning rows with matching keys in both t...

10.2 1 Set • 20m • Pass 70% 0/2 Today
LEFT JOIN

Preserving all left-table rows (`NULL`-extending unmatched right columns), anti-join `WHERE r.id IS NULL`, and...

10.3 1 Set • 20m • Pass 70% 0/2 Today
RIGHT JOIN

`RIGHT OUTER JOIN` mechanics and why rewriting `A RIGHT JOIN B` as `B LEFT JOIN A` improves query readability

10.4 1 Set • 20m • Pass 70% 0/2 Today
FULL OUTER JOIN

Preserving unmatched rows from BOTH sides (`FULL OUTER JOIN`) with `COALESCE(a.key, b.key)` for financial reco...

10.5 1 Set • 20m • Pass 70% 0/2 Today
CROSS JOIN

Intentional `M x N` Cartesian product (`CROSS JOIN` + `generate_series`) for date-spine matrix reports vs acci...

10.6 1 Set • 20m • Pass 70% 0/2 Today
SELF JOIN

Joining a table to itself using mandatory distinct aliases (`employees AS emp LEFT JOIN employees AS mgr ON mg...

10.7 1 Set • 20m • Pass 70% 0/2 Today
Single-Row and Multi-Row Subqueries

Scalar subqueries (`= (SELECT AVG(salary) ...)`), multi-row `IN` / `ANY` / `ALL`, and derived inline tables in...

10.8 1 Set • 20m • Pass 70% 0/2 Today
Correlated Subqueries

Inner subqueries referencing outer-row columns (`EXISTS (SELECT 1 FROM job_applications a WHERE a.job_id = j.i...

10.9 1 Set • 20m • Pass 70% 0/2 Today
Common Table Expressions (CTE)

`WITH cte_name AS (...)` modular named sub-queries for readable multi-stage analytical pipelines and data-modi...

10.10 1 Set • 20m • Pass 70% 0/2 Today
Recursive CTEs for Hierarchical Data

`WITH RECURSIVE` anchor member + `UNION ALL` recursive member + depth guard for org charts and nested category...

10.11 1 Set • 20m • Pass 70% 0/2 Today
Window Functions (OVER and PARTITION BY)

Computing per-partition metrics via `AVG(salary) OVER (PARTITION BY department_id)` WITHOUT collapsing detail...

10.12 1 Set • 20m • Pass 70% 0/2 Today
Ranking Window Functions (ROW_NUMBER, RANK, DENSE_RANK)

Exact tie differences: `ROW_NUMBER()` (`1,2,3,4`), `RANK()` (`1,2,2,4` gap), `DENSE_RANK()` (`1,2,2,3` no gap)...

10.13 1 Set • 20m • Pass 70% 0/2 Today
Analytical Window Functions (LAG, LEAD, Running Totals)

`LAG(col, 1, 0) OVER (...)`, `LEAD()`, cumulative running totals `SUM(amt) OVER (ORDER BY dt ROWS BETWEEN UNBO...

10.14 1 Set • 20m • Pass 70% 0/2 Today
Database Views

`CREATE OR REPLACE VIEW` stored virtual queries for reusable joins, column masking, and stable reporting contr...

10.15 1 Set • 20m • Pass 70% 0/2 Today
Materialized Views

`CREATE MATERIALIZED VIEW`, physical precomputed storage, indexing materialized views, and `REFRESH MATERIALIZ...

10.16 1 Set • 20m • Pass 70% 0/2 Today
B-Tree Indexes and Query Performance

B-Tree balanced tree `O(log N)` lookups vs `O(N)` `Seq Scan`, indexing foreign keys, partial indexes (`WHERE i...

10.17 1 Set • 20m • Pass 70% 0/2 Today
Composite Multi-Column Indexes

Leftmost-prefix rule `(a, b, c)`, equality columns BEFORE range/sort columns (`(status, city, created_at DESC)...

10.18 1 Set • 20m • Pass 70% 0/2 Today
Query Execution Plans (EXPLAIN and EXPLAIN ANALYZE)

Reading `EXPLAIN (ANALYZE, BUFFERS)` bottom-up: `Seq Scan`, `Index Scan`, `Index Only Scan`, `Bitmap Heap Scan...

10.19 1 Set • 20m • Pass 70% 0/2 Today
SQL Transactions (BEGIN, COMMIT, ROLLBACK)

All-or-nothing multi-statement units (`BEGIN`, `COMMIT`, `ROLLBACK`, `SAVEPOINT`), auto-commit pitfalls, and k...

10.20 1 Set • 20m • Pass 70% 0/2 Today
ACID Properties

Atomicity (undo/rollback), Consistency (constraints/invariants), Isolation (MVCC snapshots), and Durability (W...

10.21 1 Set • 20m • Pass 70% 0/2 Today
Transaction Isolation Levels

Dirty Read, Non-Repeatable Read, Phantom Read, Write Skew anomalies across `READ COMMITTED` (PostgreSQL defaul...

10.22 1 Set • 20m • Pass 70% 0/2 Today
Row-Level and Table-Level Locking

Pessimistic `SELECT ... FOR UPDATE` / `FOR UPDATE SKIP LOCKED` row locks vs optimistic `version` counter check...

10.23 1 Set • 20m • Pass 70% 0/2 Today
Database Deadlock Fundamentals

Why two concurrent transactions updating rows `(1, 2)` vs `(2, 1)` deadlock, PostgreSQL deadlock detector (`de...

10.24 1 Set • 20m • Pass 70% 0/2 Today
Database Normalization (1NF, 2NF, 3NF)

1NF (atomic columns, no comma-separated `"Python,SQL"` lists!), 2NF (no partial composite-key dependency), 3NF...

10.25 1 Set • 20m • Pass 70% 0/2 Today
Entity Relationships (One-to-One, One-to-Many, Many-to-Many)

1:1 (`UNIQUE` FK on `candidate_profiles.user_id`), 1:N (`employees.department_id`), and M:N junction tables (`...

10.26 1 Set • 20m • Pass 70% 0/2 Today
ER Diagrams and Schema Design

Crow’s Foot cardinality notation (`||--o{`, `}o--o{`), associative entities carrying metadata (`applied_at`, `...

10.27 1 Set • 20m • Pass 70% 0/2 Today
Referential Integrity and Cascading Rules

Choosing deliberately between `ON DELETE RESTRICT` (financial/orders), `ON DELETE CASCADE` (owned child items)...

10.28 1 Set • 20m • Pass 70% 0/2 Today
Stored Procedures and Functions Fundamentals

PL/pgSQL `CREATE FUNCTION` vs `CREATE PROCEDURE`, when DB routines help vs why business logic primarily lives...

10.29 1 Set • 20m • Pass 70% 0/2 Today
Database Triggers Fundamentals

`BEFORE UPDATE` / `AFTER INSERT` row-level triggers (`NEW`, `OLD`) for automatic `updated_at` stamps and immut...

10.30 1 Set • 20m • Pass 70% 0/2 Today
PostgreSQL Backup and Restore (pg_dump and pg_restore)

Logical backups via `pg_dump -Fc` custom compressed format, `pg_restore`, point-in-time WAL concepts, and veri...

11.1 1 Set • 20m • Pass 70% 0/2 Today
Python Database Drivers (DB-API 2.0)

PEP 249 DB-API 2.0 standard (`connect`, `cursor`, `execute`, `commit`, `rollback`), `sqlite3` built-in vs `psy...

11.2 1 Set • 20m • Pass 70% 0/2 Today
PostgreSQL Connectivity with psycopg 3

`psycopg.connect(conninfo)`, `dict_row` row factories returning typed dicts instead of positional tuples, and...

11.3 1 Set • 20m • Pass 70% 0/2 Today
Database Connection Lifecycle Management

TCP + TLS + PostgreSQL backend process cost per connection, `connect_timeout`, idle-in-transaction timeouts, a...

11.4 1 Set • 20m • Pass 70% 0/2 Today
Cursors and Executing SQL Statements

`with conn.cursor() as cur:`, `cur.execute()`, `executemany()`, `fetchone()`, `fetchall()`, `fetchmany(size)`,...

11.5 1 Set • 20m • Pass 70% 0/2 Today
CRUD Operations Using Raw Python

Implementing clean repository `create`, `get_by_id`, `list_paginated`, `update`, and `delete` methods over DB-...

11.6 1 Set • 20m • Pass 70% 0/2 Today
Parameterized Queries and SQL Injection Prevention

Driver parameter binding (`%s` / `%(name)s` in `psycopg`, `?` in `sqlite3`) keeping SQL AST separate from untr...

11.7 1 Set • 20m • Pass 70% 0/2 Today
Explicit Transaction Commit and Rollback

Grouping multi-table mutations inside `with conn.transaction():` so exceptions automatically `ROLLBACK` all pa...

11.8 1 Set • 20m • Pass 70% 0/2 Today
Database Connection Pooling

`psycopg_pool.ConnectionPool` and SQLAlchemy `QueuePool` (`pool_size`, `max_overflow`, `pool_pre_ping=True`, `...

11.9 1 Set • 20m • Pass 70% 0/2 Today
Context Managers for Database Resources

Nested `with pool.connection() as conn:` and `with Session(engine) as session:` guaranteeing connection return...

11.10 1 Set • 20m • Pass 70% 0/2 Today
SQLAlchemy 2.0 Introduction and Architecture

Unified SQLAlchemy 2.0 architecture: Dialect + Pool -> Core SQL Expression Language -> ORM Unit of Work & Iden...

11.11 1 Set • 20m • Pass 70% 0/2 Today
SQLAlchemy Core (SQL Expression Language)

`MetaData`, `Table`, composable Pythonic `select()`, `insert()`, `update()`, `join()`, and `func.count()` with...

11.12 1 Set • 20m • Pass 70% 0/2 Today
SQLAlchemy ORM Concepts

Data Mapper pattern (unlike Active Record), Identity Map (`1` Python instance per PK per `Session`), dirty tra...

11.13 1 Set • 20m • Pass 70% 0/2 Today
Database Engine Configuration (create_engine)

`create_engine(DATABASE_URL, pool_pre_ping=True, pool_size=10, echo=False)` — creating ONE module-singleton `E...

11.14 1 Set • 20m • Pass 70% 0/2 Today
ORM Session Lifecycle (Session and sessionmaker)

`SessionLocal = sessionmaker(bind=engine, autoflush=False, expire_on_commit=False)`, one `Session` per request...

11.15 1 Set • 20m • Pass 70% 0/2 Today
Declarative Models (DeclarativeBase and Mapped)

`class Base(DeclarativeBase): pass`, `__tablename__`, `Mapped[int] = mapped_column(primary_key=True)`, `Mapped...

11.16 1 Set • 20m • Pass 70% 0/2 Today
ORM Relationships (relationship and ForeignKey)

`ForeignKey("departments.id")`, bidirectional `relationship(back_populates=...)`, `1:1` (`uselist=False`), `1:...

11.17 1 Set • 20m • Pass 70% 0/2 Today
Querying with select(), where() and scalars()

`session.scalars(select(Employee).where(...).order_by(...)).all()`, `.scalar_one_or_none()`, `session.get(Empl...

11.18 1 Set • 20m • Pass 70% 0/2 Today
Lazy Loading Mechanics

How default `lazy="select"` fires an extra SQL query on attribute access `emp.department.name`, and `DetachedI...

11.19 1 Set • 20m • Pass 70% 0/2 Today
Eager Loading (joinedload and selectinload)

`options(joinedload(Employee.department))` (`LEFT OUTER JOIN` for many-to-one/1:1) vs `options(selectinload(De...

11.20 1 Set • 20m • Pass 70% 0/2 Today
Identifying and Fixing the N+1 Query Problem

Spotting `1` list query + `N` per-row loop queries (`101` SQL roundtrips for `100` items!) via SQL logging/eve...

11.21 1 Set • 20m • Pass 70% 0/2 Today
Alembic Database Migrations Fundamentals

`alembic init`, configuring `env.py` (`target_metadata = Base.metadata` + `DATABASE_URL` from env), `alembic.i...

11.22 1 Set • 20m • Pass 70% 0/2 Today
Evolving Models and Autogenerating Schema Migrations

`alembic revision --autogenerate -m "add_employee_phone"`, ALWAYS reviewing autogenerated `upgrade()`/`downgra...

11.23 1 Set • 20m • Pass 70% 0/2 Today
Testing Database Repositories in Python

Nested SAVEPOINT transaction rollback fixtures per test (`session.begin_nested()`), factory helpers, and testi...

12.1 1 Set • 20m • Pass 70% 0/2 Today
NoSQL Introduction (Relational vs Document Databases)

Document, Key-Value (Redis), Wide-Column, and Graph NoSQL families vs relational PostgreSQL tables & PostgreSQ...

12.2 1 Set • 20m • Pass 70% 0/2 Today
MongoDB Architecture (Databases, Collections, Documents)

Databases -> Collections -> JSON-like Documents, Replica Sets (high availability), and Sharding (horizontal pa...

12.3 1 Set • 20m • Pass 70% 0/2 Today
BSON Document Storage Format

Binary JSON (`BSON`), 12-byte `ObjectId` (timestamp + random + counter), `Date`, `Decimal128` for money, and t...

12.4 1 Set • 20m • Pass 70% 0/2 Today
Database and Collection Operations

Lazy database/collection creation on first write, explicit `create_collection` with `$jsonSchema` validator ru...

12.5 1 Set • 20m • Pass 70% 0/2 Today
MongoDB CRUD (insertOne, find, updateOne, deleteOne)

`insert_one` / `insert_many`, `find_one` / `find`, atomic `$set` / `$inc` / `$push` in `update_one`, and `dele...

12.6 1 Set • 20m • Pass 70% 0/2 Today
Comparison and Logical Query Operators

`$eq`, `$ne`, `$gt`, `$gte`, `$lt`, `$lte`, `$in`, `$nin`, `$and`, `$or`, `$exists`, and array `$all` / `$elem...

12.7 1 Set • 20m • Pass 70% 0/2 Today
Field Projection

Inclusion projection `{"title": 1, "company": 1, "_id": 0}` vs exclusion `{"raw_resume_text": 0}` to cut netwo...

12.8 1 Set • 20m • Pass 70% 0/2 Today
Sorting, Skip and Limit Pagination

`.sort([("created_at", -1), ("_id", -1)]).skip(offset).limit(page_size)` vs range-based `_id < last_id` cursor...

12.9 1 Set • 20m • Pass 70% 0/2 Today
Embedded Nested Documents

Co-locating `1:1` and bounded `1:few` data (`company.headquarters_address`, `order.shipping_snapshot`) for sin...

12.10 1 Set • 20m • Pass 70% 0/2 Today
Document References

Storing `employer_id` / `user_id` references across separate collections for `1:many` (unbounded) and `many:ma...

12.11 1 Set • 20m • Pass 70% 0/2 Today
MongoDB Indexing

Single-field, compound `(tenant_id: 1, created_at: -1)` (ESR rule: Equality, Sort, Range), `unique=True`, TTL...

12.12 1 Set • 20m • Pass 70% 0/2 Today
Aggregation Pipeline ($match, $group, $project, $sort)

Multi-stage pipeline `[ {"$match": ...}, {"$group": ...}, {"$sort": ...}, {"$limit": ...} ]` placing indexed `...

12.13 1 Set • 20m • Pass 70% 0/2 Today
$lookup Cross-Collection Joins

Left-outer collection join via `{"$lookup": {"from": ..., "localField": ..., "foreignField": ..., "as": ...}}`...

12.14 1 Set • 20m • Pass 70% 0/2 Today
Multi-Document Transactions Fundamentals

Replica-set `with client.start_session() as s: with s.start_transaction():` vs single-document atomicity desig...

12.15 1 Set • 20m • Pass 70% 0/2 Today
Python Integration with PyMongo

`from pymongo import MongoClient, ASCENDING, DESCENDING`, singleton `MongoClient` thread-safe pooling, Pydanti...

12.16 1 Set • 20m • Pass 70% 0/2 Today
Asynchronous MongoDB Driver Fundamentals (Motor)

`motor.motor_asyncio.AsyncIOMotorClient` (and PyMongo async API) for non-blocking `await collection.find_one(....

12.17 1 Set • 20m • Pass 70% 0/2 Today
Data Modelling (Embedding vs Referencing)

Practical decision checklist: cardinality (`1:few` bounded -> embed; `1:many` unbounded -> reference), read/wr...

12.18 1 Set • 20m • Pass 70% 0/2 Today
Selecting PostgreSQL SQL vs MongoDB NoSQL

Polyglot persistence architecture: PostgreSQL (users, auth, orders, wallets, HR, strict relations) + Redis (ca...

13.1 1 Set • 20m • Pass 70% 0/2 Today
Django Framework Architecture (MTV)

Model-Template-View (MTV) mapping to MVC, URL dispatcher -> Middleware -> View -> ORM Model -> Response lifecy...

13.2 1 Set • 20m • Pass 70% 0/2 Today
Django vs Flask vs FastAPI Comparison

Batteries-included Django + DRF (ORM, Admin, Auth, Migrations) vs ASGI type-driven FastAPI (Pydantic, async mi...

13.3 1 Set • 20m • Pass 70% 0/2 Today
Python Virtual Environment Setup for Django

Isolated `.venv`, installing `Django>=5.1,<5.2` + `psycopg[binary]` + `python-dotenv`, and freezing determinis...

13.4 1 Set • 20m • Pass 70% 0/2 Today
Django Installation and Version Management

Django LTS vs feature release cadence, `python -m django --version`, security patch upgrades, and compatibilit...

13.5 1 Set • 20m • Pass 70% 0/2 Today
Project Creation with django-admin

`django-admin startproject config .` clean root-level `manage.py` layout (avoiding double-nested `project/proj...

13.6 1 Set • 20m • Pass 70% 0/2 Today
Application Creation with startapp

`python manage.py startapp jobs`, cohesive bounded Django apps (`accounts`, `companies`, `jobs`, `applications...

13.7 1 Set • 20m • Pass 70% 0/2 Today
Django Project Structure (settings, urls, wsgi, asgi)

Responsibilities of `manage.py`, `config/settings.py`, root `config/urls.py`, synchronous `wsgi.py` (Gunicorn)...

13.8 1 Set • 20m • Pass 70% 0/2 Today
Environment-Specific Settings Configuration

Loading `SECRET_KEY`, `DEBUG`, `ALLOWED_HOSTS`, and PostgreSQL `DATABASES` strictly from environment variables...

13.9 1 Set • 20m • Pass 70% 0/2 Today
URL Routing and Path Converters

`path()`, `include()` app URL delegation, `app_name` namespaces, typed converters (`<int:pk>`, `<slug:slug>`,...

13.10 1 Set • 20m • Pass 70% 0/2 Today
Function-Based Views (FBVs)

Explicit `def view(request, ...):` handlers, `@require_http_methods(["GET", "POST"])`, and `JsonResponse`

13.11 1 Set • 20m • Pass 70% 0/2 Today
Class-Based Views (CBVs) Fundamentals

`django.views.View`, HTTP method dispatch (`.get()`, `.post()`), `View.as_view()`, `ListView`/`DetailView`, an...

13.12 1 Set • 20m • Pass 70% 0/2 Today
HttpRequest and HttpResponse Lifecycle

`request.method`, `request.GET` (`QueryDict`), `request.POST`, `request.body`, `request.headers`, `request.MET...

13.13 1 Set • 20m • Pass 70% 0/2 Today
Django Template Engine Fundamentals

DTL context variables `{{ var }}`, auto-escaping XSS protection, filters (`|date`, `|default`), and tags (`{%...

13.14 1 Set • 20m • Pass 70% 0/2 Today
Template Inheritance and Base Layouts

`base.html` master skeleton, `{% block content %}`, `{% extends "base.html" %}`, and reusable `{% include %}`...

13.15 1 Set • 20m • Pass 70% 0/2 Today
Static and Media Files Configuration

`STATIC_URL`, `STATIC_ROOT`, `collectstatic` (WhiteNoise/Nginx/CDN) vs user-uploaded `MEDIA_URL` / `MEDIA_ROOT...

13.16 1 Set • 20m • Pass 70% 0/2 Today
Django Forms

`forms.Form` vs `forms.ModelForm`, explicit `fields = [...]` allowlists, `{% csrf_token %}`, and `form.is_vali...

13.17 1 Set • 20m • Pass 70% 0/2 Today
Form Validation Lifecycle (clean and clean_<field>)

Field validators -> `clean_<fieldname>()` single-field normalization -> `clean()` cross-field validation (`max...

13.18 1 Set • 20m • Pass 70% 0/2 Today
Django Models Introduction

`models.Model` subclasses, implicit `BigAutoField` PK (`DEFAULT_AUTO_FIELD`), `class Meta` (`db_table`, `order...

13.19 1 Set • 20m • Pass 70% 0/2 Today
Model Field Types and Options

`CharField`, `SlugField`, `TextField`, `DecimalField(max_digits=12, decimal_places=2)`, `BooleanField`, `DateT...

13.20 1 Set • 20m • Pass 70% 0/2 Today
Schema Migrations (makemigrations and migrate)

`makemigrations`, `sqlmigrate <app> <num>` (inspecting exact SQL!), `migrate`, `showmigrations`, data migratio...

13.21 1 Set • 20m • Pass 70% 0/2 Today
Django Admin Panel Customization

`@admin.register(JobPosting)`, `list_display`, `list_filter`, `search_fields`, `readonly_fields`, `raw_id_fiel...

13.22 1 Set • 20m • Pass 70% 0/2 Today
Django ORM and QuerySet Evaluation

Lazy `QuerySet` chaining, exact evaluation triggers (iteration, slicing with step, `len()`, `list()`, `bool()`...

13.23 1 Set • 20m • Pass 70% 0/2 Today
ORM CRUD Operations

`objects.create()`, `bulk_create()`, `get_or_create()`, `update_or_create()`, `.save(update_fields=[...])`, Qu...

13.24 1 Set • 20m • Pass 70% 0/2 Today
Filtering QuerySets (filter, exclude, get, Q, F)

Field lookups (`__iexact`, `__icontains`, `__in`, `__gte`, `__isnull`), `Q()` boolean OR/NOT composition, `F()...

13.25 1 Set • 20m • Pass 70% 0/2 Today
Model Relationships (ForeignKey, OneToOneField, ManyToManyField)

Explicit `on_delete=models.CASCADE / PROTECT / SET_NULL`, explicit `related_name="jobs"`, `OneToOneField` (`Ca...

13.26 1 Set • 20m • Pass 70% 0/2 Today
Django Query Optimization (select_related and prefetch_related)

`select_related("company", "company__owner")` (`SQL INNER/LEFT JOIN` for FK/OneToOne) vs `prefetch_related("sk...

14.1 1 Set • 20m • Pass 70% 0/2 Today
REST Architecture Principles

Statelessness, resource-noun URLs (`/jobs`, NOT `/getAllJobs`), uniform interface, representations, and idempo...

14.2 1 Set • 20m • Pass 70% 0/2 Today
HTTP Methods (GET, POST, PUT, PATCH, DELETE)

Safe (`GET`, `HEAD`, `OPTIONS`) vs Idempotent (`GET`, `PUT`, `DELETE`) vs Non-idempotent (`POST`), and full re...

14.3 1 Set • 20m • Pass 70% 0/2 Today
HTTP Status Codes (2xx, 3xx, 4xx, 5xx)

`200 OK`, `201 Created` (+ `Location`), `204 No Content`, `400 Bad Request`, `401 Unauthorized` (unauthenticat...

14.4 1 Set • 20m • Pass 70% 0/2 Today
HTTP Request Headers (Content-Type, Accept, Authorization)

`Content-Type: application/json` vs `multipart/form-data`, `Accept`, `Authorization: Bearer <jwt>`, `X-Request...

14.5 1 Set • 20m • Pass 70% 0/2 Today
JSON Request and Response Payloads

Consistent `snake_case` (or camelCase adapter) field naming, ISO-8601 UTC timestamps (`2026-11-18T06:30:00Z`),...

14.6 1 Set • 20m • Pass 70% 0/2 Today
Django REST Framework (DRF) Installation and Architecture

Installing `djangorestframework`, `REST_FRAMEWORK` central settings dict, DRF `Request` (`request.data`, `requ...

14.7 1 Set • 20m • Pass 70% 0/2 Today
DRF Serializers Fundamentals

`serializers.Serializer` for non-model inputs (login, password reset, search filters), `is_valid(raise_excepti...

14.8 1 Set • 20m • Pass 70% 0/2 Today
ModelSerializer

`serializers.ModelSerializer`, explicit `fields` + `read_only_fields` (`id`, `employer`, `created_at`), `write...

14.9 1 Set • 20m • Pass 70% 0/2 Today
Field-Level and Object-Level Serializer Validation

`validate_<field>(self, value)` single-field rules, `validate(self, attrs)` cross-field checks (handling parti...

14.10 1 Set • 20m • Pass 70% 0/2 Today
DRF APIView

`rest_framework.views.APIView` (auth -> permission -> throttle pipeline BEFORE `get`/`post`/`patch`/`delete` r...

14.11 1 Set • 20m • Pass 70% 0/2 Today
GenericAPIView and Concrete Generic Views

`GenericAPIView` (`get_queryset()`, `get_serializer_class()`, `lookup_field`) and concrete `ListCreateAPIView`...

14.12 1 Set • 20m • Pass 70% 0/2 Today
DRF Mixins for Reusable API Behaviour

`ListModelMixin`, `CreateModelMixin`, `RetrieveModelMixin`, `UpdateModelMixin`, `DestroyModelMixin` and `perfo...

14.13 1 Set • 20m • Pass 70% 0/2 Today
ViewSets and ModelViewSet

`ViewSet`, `ReadOnlyModelViewSet`, `ModelViewSet`, switching serializers per action (`if self.action == "list"...

14.14 1 Set • 20m • Pass 70% 0/2 Today
DRF Routers (DefaultRouter and SimpleRouter)

`SimpleRouter` vs `DefaultRouter`, `router.register("jobs", JobViewSet, basename="job")`, trailing slash confi...

14.15 1 Set • 20m • Pass 70% 0/2 Today
Complete CRUD REST API Endpoints

End-to-end `POST 201`, `GET 200` list/detail, `PATCH 200`, `PUT 200`, and `DELETE 204` with PostgreSQL persist...

14.16 1 Set • 20m • Pass 70% 0/2 Today
API Filtering with django-filter

Installing `django-filter`, `DjangoFilterBackend`, custom `FilterSet` (`min_salary = NumberFilter(field_name="...

14.17 1 Set • 20m • Pass 70% 0/2 Today
Full-Text Search with SearchFilter

`filters.SearchFilter`, `search_fields = ["title", "company__name", "=job_code"]` (`^` prefix, `=` exact, `@`...

14.18 1 Set • 20m • Pass 70% 0/2 Today
Dynamic Sorting with OrderingFilter

`filters.OrderingFilter`, explicit `ordering_fields = ["published_at", "min_salary"]` allowlist, and default `...

14.19 1 Set • 20m • Pass 70% 0/2 Today
Pagination (PageNumberPagination and LimitOffsetPagination)

Custom `StandardResultsSetPagination(PageNumberPagination)` (`page_size = 20`, `page_size_query_param = "page_...

14.20 1 Set • 20m • Pass 70% 0/2 Today
DRF Permission Classes

`IsAuthenticated`, `IsAuthenticatedOrReadOnly`, `IsAdminUser`, custom `BasePermission` (`has_permission` view-...

14.21 1 Set • 20m • Pass 70% 0/2 Today
API Rate Throttling (AnonRateThrottle, UserRateThrottle)

`AnonRateThrottle`, `UserRateThrottle`, `ScopedRateThrottle` (`login: "5/min"`), Redis cache backing, `X-Forwa...

14.22 1 Set • 20m • Pass 70% 0/2 Today
API Versioning Strategies

`URLPathVersioning` (`/api/v1/jobs/`) vs `NamespaceVersioning` vs `AcceptHeaderVersioning`, `request.version`,...

14.23 1 Set • 20m • Pass 70% 0/2 Today
Standardized JSON API Response Envelopes

Consistent pagination (`count`, `next`, `previous`, `results`) and error envelope (`{"error": {"code": "...",...

14.24 1 Set • 20m • Pass 70% 0/2 Today
Custom DRF Exception Handling

Writing a custom `EXCEPTION_HANDLER` wrapping DRF `exception_handler(exc, context)`, translating domain/Django...

15.1 1 Set • 20m • Pass 70% 0/2 Today
Django Built-In Authentication System

`django.contrib.auth` architecture: `User`, `AuthenticationBackend`, `authenticate()`, `Permission`, and `Grou...

15.2 1 Set • 20m • Pass 70% 0/2 Today
Default Django User Model

Fields on default `auth.User` (`username`, `email`, `password`, `is_active`, `is_staff`, `is_superuser`, `last...

15.3 1 Set • 20m • Pass 70% 0/2 Today
Custom User Model (AbstractUser and AbstractBaseUser)

Defining `class User(AbstractUser):` (`USERNAME_FIELD = "email"`, unique case-insensitive email, `role` enum)...

15.4 1 Set • 20m • Pass 70% 0/2 Today
User Registration REST API

`POST /api/v1/auth/register/` (`write_only=True` password, `validate_password()` strength validators, normaliz...

15.5 1 Set • 20m • Pass 70% 0/2 Today
User Login and Credential Verification API

`POST /api/v1/auth/login/` generic `"Invalid email or password"` error (preventing account enumeration!), rate...

15.6 1 Set • 20m • Pass 70% 0/2 Today
Secure Password Hashing (PBKDF2 and Argon2)

`PASSWORD_HASHERS` (`Argon2PasswordHasher` primary, `PBKDF2PasswordHasher`), per-user cryptographic salt, work...

15.7 1 Set • 20m • Pass 70% 0/2 Today
Password Reset Token Workflow

`PasswordResetTokenGenerator` (`default_token_generator`), `urlsafe_base64_encode(uid)`, single-use time-bound...

15.8 1 Set • 20m • Pass 70% 0/2 Today
Session-Based Authentication

Stateful `sessionid` (`HttpOnly`, `Secure`, `SameSite=Lax`) cookie + Redis session store (`SESSION_ENGINE`) +...

15.9 1 Set • 20m • Pass 70% 0/2 Today
DRF Token Authentication

`rest_framework.authtoken` opaque DB-backed token vs stateless JWT trade-offs (1 DB lookup per request & singl...

15.10 1 Set • 20m • Pass 70% 0/2 Today
JSON Web Token (JWT) Structure and Signing

`header.payload.signature` Base64URL anatomy (`alg`, `sub`, `exp`, `iat`, `jti`), HMAC `HS256` vs asymmetric `...

15.11 1 Set • 20m • Pass 70% 0/2 Today
SimpleJWT Integration in DRF

Installing `djangorestframework-simplejwt`, `JWTAuthentication`, `TokenObtainPairView`, `TokenRefreshView`, an...

15.12 1 Set • 20m • Pass 70% 0/2 Today
Short-Lived Access Token Handling

Setting `ACCESS_TOKEN_LIFETIME = timedelta(minutes=15)`, skew leeway, `Bearer <token>` verification, and minim...

15.13 1 Set • 20m • Pass 70% 0/2 Today
Refresh Token Rotation and Blacklisting

`ROTATE_REFRESH_TOKENS = True`, `BLACKLIST_AFTER_ROTATION = True`, `rest_framework_simplejwt.token_blacklist`,...

15.14 1 Set • 20m • Pass 70% 0/2 Today
Authentication vs Authorization

Clear architectural separation: Authentication (`request.user` identity -> `401`) vs Authorization (role + res...

15.15 1 Set • 20m • Pass 70% 0/2 Today
Role-Based Access Control (RBAC) Permissions

`IsCandidate`, `IsEmployer`, `IsPlatformAdmin` DRF permission classes + object-level ownership (`application.j...

15.16 1 Set • 20m • Pass 70% 0/2 Today
Django Groups and Object-Level Permissions

`Group`, `Permission` (`jobs.publish_jobposting`), `user.has_perm()`, and seeding standard staff roles (`Moder...

15.17 1 Set • 20m • Pass 70% 0/2 Today
Cross-Origin Resource Sharing (django-cors-headers)

Same-Origin Policy, `OPTIONS` preflight requests, `django-cors-headers` middleware placement (top of `MIDDLEWA...

15.18 1 Set • 20m • Pass 70% 0/2 Today
Cross-Site Request Forgery (CSRF) Protection

How browsers auto-attach cookies cross-site, `CsrfViewMiddleware`, `SameSite=Lax/Strict`, and why `Authorizati...

15.19 1 Set • 20m • Pass 70% 0/2 Today
Cross-Site Scripting (XSS) Prevention

Stored vs Reflected XSS, HTML escaping, sanitizing rich-text Markdown/HTML descriptions (`nh3` / `bleach`), an...

15.20 1 Set • 20m • Pass 70% 0/2 Today
SQL Injection Prevention in Django ORM

Parameterized Django `QuerySet` safety vs dangerous escape hatches (`raw()`, `extra()`, `RawSQL`) when develop...

15.21 1 Set • 20m • Pass 70% 0/2 Today
HTTP Security Headers (HSTS, CSP, X-Frame-Options)

`SecurityMiddleware`: `SECURE_SSL_REDIRECT`, `SECURE_HSTS_SECONDS = 31536000`, `SECURE_CONTENT_TYPE_NOSNIFF =...

15.22 1 Set • 20m • Pass 70% 0/2 Today
Environment Variables and Secret Management

Zero secrets in Git, rotating leaked keys immediately, `django-environ` / `pydantic-settings`, AWS Secrets Man...

15.23 1 Set • 20m • Pass 70% 0/2 Today
Multipart File and Resume Upload APIs

`MultiPartParser` & `FormParser`, `FileField(upload_to=...)` with UUID randomized filenames (preventing path t...

15.24 1 Set • 20m • Pass 70% 0/2 Today
Upload File Size, MIME and Extension Validation

3-layer upload validation: max size (`<= 5 MB`), extension allowlist (`.pdf`, `.docx`), AND magic-byte header...

15.25 1 Set • 20m • Pass 70% 0/2 Today
Transactional Email Integration via SMTP

`EMAIL_BACKEND` (`console` in dev, `locmem` in tests, `smtp`/SES in prod), `EmailMultiAlternatives` (plain tex...

15.26 1 Set • 20m • Pass 70% 0/2 Today
Swagger Interactive API Documentation

Serving interactive `/api/schema/swagger-ui/` and `/api/schema/redoc/` with Bearer JWT `Authorize` button for...

15.27 1 Set • 20m • Pass 70% 0/2 Today
OpenAPI 3 Schema Generation (drf-spectacular)

Installing `drf-spectacular`, `AutoSchema`, `@extend_schema(summary=..., request=..., responses={201: ...})` a...

15.28 1 Set • 20m • Pass 70% 0/2 Today
API Testing and Environments with Postman

Organizing Postman Collections (`Auth`, `Companies`, `Jobs`, `Applications`), Environment variables (`{{base_u...

16.1 1 Set • 20m • Pass 70% 0/2 Today
Scalable Django Project Structure

Organizing `config/settings/{base,dev,test,prod}.py`, `apps/{accounts,companies,jobs,applications,notification...

16.2 1 Set • 20m • Pass 70% 0/2 Today
Feature-Based Application Separation

Bounded domain cohesion per app, unidirectional dependency rules (`applications` -> `jobs` -> `companies` -> `...

16.3 1 Set • 20m • Pass 70% 0/2 Today
Service Layer Pattern in Django

Extracting business write rules (`submit_job_application(*, candidate, job, resume_file)`) into `services.py`...

16.4 1 Set • 20m • Pass 70% 0/2 Today
Repository / Selector Data Access Abstraction

Centralizing optimized read queries (`list_published_jobs`, `get_employer_job_detail`) in `selectors.py` with...

16.5 1 Set • 20m • Pass 70% 0/2 Today
Custom Request-Response Middleware

Writing sync/async-compatible middleware (`__init__(get_response)` + `__call__(request)`), injecting `X-Reques...

16.6 1 Set • 20m • Pass 70% 0/2 Today
Django Signals and Decoupled Hooks

`post_save`, `pre_delete`, `@receiver`, and why explicit `services.py` calls are strongly preferred over hidde...

16.7 1 Set • 20m • Pass 70% 0/2 Today
Custom Model Managers and QuerySets

Writing `class JobQuerySet(models.QuerySet): def published(self): ... def with_relations(self): ...` exposed v...

16.8 1 Set • 20m • Pass 70% 0/2 Today
Eliminating N+1 Queries in DRF Serializers

Spotting `SerializerMethodField` per-row queries (`obj.applications.count()` firing `N` `SELECT COUNT(*)` quer...

16.9 1 Set • 20m • Pass 70% 0/2 Today
Database Atomicity with transaction.atomic

`@transaction.atomic` / `with transaction.atomic():`, nested savepoints, `select_for_update()` row locks, and...

16.10 1 Set • 20m • Pass 70% 0/2 Today
Django Cache Framework

`CACHES` configuration, low-level `cache.get(key)` / `cache.set(key, val, timeout=300)` / `cache.get_or_set()`...

16.11 1 Set • 20m • Pass 70% 0/2 Today
Redis Cache Backend Integration

Configuring `django.core.cache.backends.redis.RedisCache` (`REDIS_URL`), TTL tuning, atomic `cache.incr()`, an...

16.12 1 Set • 20m • Pass 70% 0/2 Today
Background Jobs with Celery Fundamentals

Installing `celery[redis]`, configuring `config/celery.py`, `@shared_task`, `CELERY_TASK_SERIALIZER = "json"`...

16.13 1 Set • 20m • Pass 70% 0/2 Today
Asynchronous Task Queues in Django

Starting `celery -A config worker -l info`, idempotent task design, `autoretry_for=(TimeoutError,)`, `retry_ba...

16.14 1 Set • 20m • Pass 70% 0/2 Today
Background Transactional Email Processing

Offloading registration welcome, password reset, and application-shortlisted emails to Celery via `transaction...

16.15 1 Set • 20m • Pass 70% 0/2 Today
Structured Production Logging

Configuring Django `LOGGING` dict (`version: 1`, JSON/structured formatters, `request_id` filter, `django.requ...

16.16 1 Set • 20m • Pass 70% 0/2 Today
Django Automated Test Framework

`django.test.TestCase` (per-test DB transaction rollback!) vs `SimpleTestCase` (no DB), `setUpTestData` class-...

16.17 1 Set • 20m • Pass 70% 0/2 Today
REST Endpoint Testing with DRF APIClient

`rest_framework.test.APITestCase` & `APIClient`, `client.force_authenticate(user=...)` vs real JWT header test...

16.18 1 Set • 20m • Pass 70% 0/2 Today
Isolated Test Database Lifecycle

How Django creates/destroys `test_<dbname>`, `--keepdb` local iteration speedup, `--parallel`, and testing rea...

16.19 1 Set • 20m • Pass 70% 0/2 Today
Split Development, Staging and Production Settings

`config/settings/base.py`, `dev.py`, `test.py`, `prod.py` selected via `DJANGO_SETTINGS_MODULE`, `CONN_MAX_AGE...

16.20 1 Set • 20m • Pass 70% 0/2 Today
WSGI vs ASGI Application Server Interfaces

Synchronous PEP 3333 WSGI (`config.wsgi:application` with Gunicorn sync/gthread workers) vs asynchronous ASGI...

16.21 1 Set • 20m • Pass 70% 0/2 Today
Django Production Deployment Checklist

Pre-launch verification: `DEBUG=False`, rotated `SECRET_KEY`, `ALLOWED_HOSTS`, `CSRF_TRUSTED_ORIGINS`, `migrat...

17.1 1 Set • 20m • Pass 70% 0/2 Today
FastAPI Architecture, Starlette and ASGI Use Cases

How FastAPI combines Starlette (ASGI routing/WebSockets/middleware) + Pydantic v2 (Rust `pydantic-core` valida...

17.2 1 Set • 20m • Pass 70% 0/2 Today
FastAPI and Uvicorn Environment Setup

Installing `fastapi` + `uvicorn[standard]` (`uvloop` + `httptools`), running `uvicorn app.main:app --reload` i...

17.3 1 Set • 20m • Pass 70% 0/2 Today
Scalable FastAPI Project Organization

Domain/layered layout: `app/{main.py, core/, api/v1/routers/, schemas/, models/, repositories/, services/}` vs...

17.4 1 Set • 20m • Pass 70% 0/2 Today
Path Operations (GET, POST, PUT, PATCH, DELETE)

`@router.get()`, `.post()`, `.put()`, `.patch()`, `.delete()`, operation `summary`/`tags`, and top-to-bottom r...

17.5 1 Set • 20m • Pass 70% 0/2 Today
Typed Path Parameters

Automatic conversion & `422` validation for `int`, `UUID`, `StrEnum` path parameters, plus `Annotated[int, Pat...

17.6 1 Set • 20m • Pass 70% 0/2 Today
Query Parameters and Filtering

Optional defaults (`q: str | None = None`), required queries, `Annotated[int, Query(ge=1, le=100)]`, and multi...

17.7 1 Set • 20m • Pass 70% 0/2 Today
JSON Request Bodies

Automatic JSON parsing into Pydantic `BaseModel` parameters, combining Path + Query + Body parameters cleanly,...

17.8 1 Set • 20m • Pass 70% 0/2 Today
Pydantic v2 Data Validation Engine

Pydantic v2 Rust `pydantic-core` speed, `model_validate()`, `model_dump(exclude_unset=True)`, `ValidationError...

17.9 1 Set • 20m • Pass 70% 0/2 Today
Defining Schemas with BaseModel

Separating `ProductBase`, `ProductCreate`, `ProductPatch` (all fields optional `| None = None`), `ProductOut`...

17.10 1 Set • 20m • Pass 70% 0/2 Today
Field Constraints with Pydantic Field()

`Field(min_length=2, max_length=120, pattern=...)`, `gt=0`, `ge=0`, `max_digits=12, decimal_places=2`, `EmailS...

17.11 1 Set • 20m • Pass 70% 0/2 Today
Custom Validators (@field_validator and @model_validator)

Pydantic v2 `@field_validator("email", mode="before")` (`@classmethod`) normalization and `@model_validator(mo...

17.12 1 Set • 20m • Pass 70% 0/2 Today
Response Models and Output Filtering (response_model)

`response_model=ProductOut` (or `-> ProductOut` return annotation), `ConfigDict(from_attributes=True)` ORM ser...

17.13 1 Set • 20m • Pass 70% 0/2 Today
Explicit HTTP Status Codes

`status_code=status.HTTP_201_CREATED` on `POST`, `status.HTTP_204_NO_CONTENT` (returning `None`) on `DELETE`,...

17.14 1 Set • 20m • Pass 70% 0/2 Today
Dependency Injection with Depends()

`from fastapi import Depends`, `Annotated[PaginationParams, Depends()]`, sub-dependencies, per-request depende...

17.15 1 Set • 20m • Pass 70% 0/2 Today
Reusable Service and Auth Dependencies

Chaining `get_db -> get_product_repo -> get_product_service`, router-level `dependencies=[Depends(require_auth...

17.16 1 Set • 20m • Pass 70% 0/2 Today
Header and Cookie Parameters

`Annotated[str | None, Header()] = None` (auto hyphen-to-underscore `x_idempotency_key` <- `X-Idempotency-Key`...

17.17 1 Set • 20m • Pass 70% 0/2 Today
Asynchronous File Uploads (UploadFile)

`file: UploadFile = File(...)` (`SpooledTemporaryFile` spilling to disk), streaming chunk validation (`await f...

17.18 1 Set • 20m • Pass 70% 0/2 Today
In-Process Background Tasks (BackgroundTasks)

`background_tasks.add_task(fn, *args)` running AFTER HTTP response is sent vs when durable Celery + Redis/Rabb...

17.19 1 Set • 20m • Pass 70% 0/2 Today
HTTPException and Custom Exception Handlers

`raise HTTPException(status_code=..., detail=...)`, `@app.exception_handler(DomainError)` translating pure dom...

17.20 1 Set • 20m • Pass 70% 0/2 Today
Custom ASGI / HTTP Middleware

`@app.middleware("http")` (`call_next(request)`), adding `X-Request-ID` & `X-Process-Time-Ms` headers, and pur...

17.21 1 Set • 20m • Pass 70% 0/2 Today
CORS Middleware Configuration

`from fastapi.middleware.cors import CORSMiddleware`, explicit `allow_origins` list, `allow_methods`, `allow_h...

17.22 1 Set • 20m • Pass 70% 0/2 Today
Automatic OpenAPI 3 Schema Generation

Customizing `FastAPI(title=..., version="1.0.0", openapi_tags=...)`, `responses={404: {"model": ErrorOut}, 409...

17.23 1 Set • 20m • Pass 70% 0/2 Today
Interactive API Testing with Swagger UI (/docs)

Testing OAuth2/Bearer endpoints directly in `/docs`, `swagger_ui_parameters={"persistAuthorization": True}`, a...

17.24 1 Set • 20m • Pass 70% 0/2 Today
API Reference Documentation with ReDoc (/redoc)

Clean 3-pane `/redoc` reference docs, Markdown descriptions in route docstrings, and exporting static `openapi...

17.25 1 Set • 20m • Pass 70% 0/2 Today
Environment Configuration Fundamentals

Centralizing `APP_ENV`, `CORS_ORIGINS`, `MAX_UPLOAD_MB` with startup validation and `@lru_cache` singleton inj...

18.1 1 Set • 20m • Pass 70% 0/2 Today
Modular FastAPI Application Architecture

Application factory `def create_app() -> FastAPI:`, clean layering (`api` -> `services` -> `repositories` -> `...

18.2 1 Set • 20m • Pass 70% 0/2 Today
Feature Routing with APIRouter

`APIRouter(prefix="/products", tags=["Products"])`, aggregating into `api_v1_router`, and shared router-level...

18.3 1 Set • 20m • Pass 70% 0/2 Today
Service Layer Business Logic Separation

`OrderService` orchestrating inventory checks, pricing math, repository writes, and transaction commit/rollbac...

18.4 1 Set • 20m • Pass 70% 0/2 Today
Repository Pattern for Data Access

Encapsulating `AsyncSession` `select()`, `add()`, `flush()`, eager `selectinload`/`joinedload` queries inside...

18.5 1 Set • 20m • Pass 70% 0/2 Today
SQLAlchemy 2.0 Integration with FastAPI

Mapping SQLAlchemy `DeclarativeBase` models cleanly to Pydantic `ConfigDict(from_attributes=True)` schemas wit...

18.6 1 Set • 20m • Pass 70% 0/2 Today
Request-Scoped Database Session Dependency (yield)

`async def get_db() -> AsyncIterator[AsyncSession]: async with AsyncSessionLocal() as session: yield session`...

18.7 1 Set • 20m • Pass 70% 0/2 Today
Database-Backed CRUD REST APIs

Implementing async `POST` (`201`), `GET` list/detail (`200`/`404`), `PATCH` (`exclude_unset=True`), and `DELET...

18.8 1 Set • 20m • Pass 70% 0/2 Today
Alembic Schema Migrations in FastAPI

Async Alembic template (`alembic init -t async migrations`), importing all `models` into `migrations/env.py` s...

18.9 1 Set • 20m • Pass 70% 0/2 Today
Async Route Functions (async def vs def)

Exact FastAPI concurrency execution rule: `async def` runs directly on the single event loop (non-blocking `aw...

18.10 1 Set • 20m • Pass 70% 0/2 Today
Async SQLAlchemy (AsyncSession and asyncpg)

`create_async_engine("postgresql+asyncpg://...", pool_pre_ping=True)`, `async_sessionmaker(expire_on_commit=Fa...

18.11 1 Set • 20m • Pass 70% 0/2 Today
Typed Settings with pydantic-settings

`from pydantic_settings import BaseSettings, SettingsConfigDict`, `SecretStr` (prevents accidental secret prin...

18.12 1 Set • 20m • Pass 70% 0/2 Today
FastAPI Security Utilities

`HTTPBearer`, `OAuth2PasswordBearer(tokenUrl="/api/v1/auth/token")`, `OAuth2PasswordRequestForm`, and automati...

18.13 1 Set • 20m • Pass 70% 0/2 Today
OAuth2 Password Bearer Flow Fundamentals

Form-encoded `username` + `password` -> `{"access_token": "...", "token_type": "bearer"}` RFC 6749 contract vs...

18.14 1 Set • 20m • Pass 70% 0/2 Today
Stateless JWT Access and Refresh Tokens

Encoding/verifying JWTs with `PyJWT` (`jwt.encode` / `jwt.decode(..., algorithms=["HS256"])`), `typ` claim (`"...

18.15 1 Set • 20m • Pass 70% 0/2 Today
Secure Password Hashing (Argon2 / Bcrypt)

Modern `pwdlib` (`PasswordHash.recommended()` using Argon2id, recommended by FastAPI docs over unmaintained `p...

18.16 1 Set • 20m • Pass 70% 0/2 Today
Role-Based Authorization Checks

Checking `user.is_active` + `user.role` (`customer`, `vendor`, `admin`) + resource ownership (`order.user_id =...

18.17 1 Set • 20m • Pass 70% 0/2 Today
Dependency-Based Security Guards

Composable `CurrentUser = Annotated[User, Depends(get_current_active_user)]` and `AdminUser = Annotated[User,...

18.18 1 Set • 20m • Pass 70% 0/2 Today
Paginated API Responses

Generic `PaginatedResponse[T]` (`items: list[T]`, `total: int`, `limit: int`, `offset: int`, `has_more: bool`)...

18.19 1 Set • 20m • Pass 70% 0/2 Today
Dynamic Query Filtering

Typed `ProductFilterParams` dependency building conditional `.where(...)` clauses (`category_id`, `in_stock`,...

18.20 1 Set • 20m • Pass 70% 0/2 Today
Dynamic Multi-Column Sorting

Mapping validated `Literal["created_at", "price", "name"]` sort keys + `Literal["asc", "desc"]` to whitelisted...

18.21 1 Set • 20m • Pass 70% 0/2 Today
Versioned FastAPI Routers (/api/v1)

Prefixing `/api/v1` via `APIRouter`, sub-application `app.mount("/api/v2", app_v2)` option for separate OpenAP...

18.22 1 Set • 20m • Pass 70% 0/2 Today
External API Integration with httpx.AsyncClient

Creating ONE pooled `httpx.AsyncClient(timeout=httpx.Timeout(5.0, connect=2.0))` in `app.state` via `lifespan`...

18.23 1 Set • 20m • Pass 70% 0/2 Today
Global Exception Handling Middleware

Unified RFC 7807 Problem Details / structured error JSON across `DomainError`, `HTTPException`, `RequestValida...

18.24 1 Set • 20m • Pass 70% 0/2 Today
Structured JSON Application Logging

Formatting every log record as single-line JSON (`timestamp`, `level`, `service`, `request_id`, `method`, `pat...

19.1 1 Set • 20m • Pass 70% 0/2 Today
Monolithic Application Design

Well-structured Modular Monolith strengths: single ACID database transaction, in-memory function calls (`ns` v...

19.2 1 Set • 20m • Pass 70% 0/2 Today
Microservices and Service-Oriented Architecture

Independently deployable, business-capability-aligned services owning their own data and communicating over we...

19.3 1 Set • 20m • Pass 70% 0/2 Today
Monolith vs Microservices Architectural Trade-Offs

Fallacies of Distributed Computing: network latency, partial failures, eventual consistency, distributed debug...

19.4 1 Set • 20m • Pass 70% 0/2 Today
Service Boundaries and Bounded Contexts

Cutting boundaries along business capabilities (high internal cohesion, low external chatty coupling) rather t...

19.5 1 Set • 20m • Pass 70% 0/2 Today
Domain-Driven Design (DDD) Fundamentals

Ubiquitous Language, Entities (identity), Value Objects (`Money`, `Address`), Aggregates (transactional consis...

19.6 1 Set • 20m • Pass 70% 0/2 Today
Independent Service Deployment

Backward-compatible API & event schema evolution (Expand-and-Contract), independent Git/CI pipelines, and zero...

19.7 1 Set • 20m • Pass 70% 0/2 Today
Synchronous Inter-Service Communication

Request-response blocking chains (`Gateway -> Order -> Inventory -> Payment`), latency addition, and availabil...

19.8 1 Set • 20m • Pass 70% 0/2 Today
HTTP/REST Service Integration

Internal REST contracts with `httpx.AsyncClient`, typed Pydantic client response validation, connection poolin...

19.9 1 Set • 20m • Pass 70% 0/2 Today
gRPC and Protocol Buffers Fundamentals

Contract-first `.proto` schemas, binary Protobuf serialization, HTTP/2 multiplexing, generated Python stubs, a...

19.10 1 Set • 20m • Pass 70% 0/2 Today
API Gateway Architecture

Single north-south entry point (Nginx / Kong / Traefik / FastAPI Gateway): path routing, TLS termination, JWT...

19.11 1 Set • 20m • Pass 70% 0/2 Today
Service Registration and Discovery Fundamentals

Dynamic container IP resolution via Docker Compose DNS / Kubernetes CoreDNS (`http://inventory-service:8003`)...

19.12 1 Set • 20m • Pass 70% 0/2 Today
Centralized and Distributed Configuration

12-Factor environment injection, ConfigMaps/Secrets, startup schema validation via `pydantic-settings`, and dy...

19.13 1 Set • 20m • Pass 70% 0/2 Today
Data Ownership (Database-per-Service)

Strict rule: ONLY `inventory-service` reads/writes `inventory_db`! Other services access inventory strictly vi...

19.14 1 Set • 20m • Pass 70% 0/2 Today
Distributed Transaction Consistency Challenges

Why 2-Phase Commit (`2PC` / XA) locks struggle across independent services/brokers, eventual consistency, and...

19.15 1 Set • 20m • Pass 70% 0/2 Today
Saga Pattern (Choreography and Orchestration)

Sequencing local ACID transactions across services (`Order PENDING -> Reserve Stock -> Charge Payment -> Order...

19.16 1 Set • 20m • Pass 70% 0/2 Today
Event-Driven Architecture

Decoupled producers & consumers (`OrderPlaced`, `StockReserved`, `PaymentCaptured`), Event Notification vs Eve...

19.17 1 Set • 20m • Pass 70% 0/2 Today
Message Broker Fundamentals

Smart broker / flexible routing (`RabbitMQ` AMQP task/work queues) vs distributed append-only commit log (`Apa...

19.18 1 Set • 20m • Pass 70% 0/2 Today
Retry Mechanisms with Exponential Backoff

Retrying ONLY transient errors (`502/503/504`, `ConnectTimeout`) — NEVER `400/401/403/404/422`! — with exponen...

19.19 1 Set • 20m • Pass 70% 0/2 Today
Request Timeouts and Deadline Propagation

Explicit connect timeout (`2s`) + read timeout (`3s`) on EVERY outbound socket (HTTP, DB, Redis, SMTP) so hung...

19.20 1 Set • 20m • Pass 70% 0/2 Today
Circuit Breaker Failure Isolation

State machine: `CLOSED` (normal) -> failure threshold exceeded -> `OPEN` (fail fast `< 1ms` without calling de...

19.21 1 Set • 20m • Pass 70% 0/2 Today
Idempotency Keys for Safe Retries

Storing `Idempotency-Key` (`UNIQUE (user_id, idempotency_key)`) + request payload hash + cached response in Po...

19.22 1 Set • 20m • Pass 70% 0/2 Today
Observability Pillars (Logs, Metrics, Traces)

Three pillars: Structured Logs (what happened), Metrics — RED rate/errors/duration histograms (`prometheus-cli...

19.23 1 Set • 20m • Pass 70% 0/2 Today
Correlation IDs for Distributed Request Tracing

Generating `X-Correlation-ID` at the API Gateway and forwarding it automatically on every outbound `httpx` hea...

19.24 1 Set • 20m • Pass 70% 0/2 Today
Service-to-Service Authentication

Zero-trust internal security: verifying `aud` (audience) + `iss` (issuer) claims on internal service JWTs, HMA...

20.1 1 Set • 20m • Pass 70% 0/2 Today
Redis In-Memory Data Store Introduction

Single-threaded event-loop command execution (atomic individual commands!), sub-millisecond RAM latency, RDB s...

20.2 1 Set • 20m • Pass 70% 0/2 Today
Redis Data Types (Strings, Lists, Sets, Hashes, Sorted Sets)

`STRING` (JSON cache, atomic `INCR`), `HASH` (field maps), `LIST` (queues), `SET` (unique tags/online users),...

20.3 1 Set • 20m • Pass 70% 0/2 Today
Core Redis CLI and redis-py Commands

`redis.asyncio.from_url(REDIS_URL, decode_responses=True)`, connection pooling, `pipeline()` batching multiple...

20.4 1 Set • 20m • Pass 70% 0/2 Today
Application Response and Query Caching

Namespaced versioned cache keys (`prod:v1:product:{id}`), JSON Pydantic `model_dump_json()` / `model_validate_...

20.5 1 Set • 20m • Pass 70% 0/2 Today
Cache Expiration and TTL Management

Mandatory `ex=` TTL on every cache key, TTL jitter (`300 + random.randint(0, 45)`) preventing Cache Avalanche...

20.6 1 Set • 20m • Pass 70% 0/2 Today
Cache Invalidation and Consistency

Explicit `await redis.delete(key)` AFTER PostgreSQL commit on `PATCH`/`DELETE` (delete rather than overwrite t...

20.7 1 Set • 20m • Pass 70% 0/2 Today
Cache-Aside Strategy

Read-through vs Write-through vs lazy Cache-Aside (`1. Check Redis -> 2. Miss: Query DB -> 3. SET Redis with T...

20.8 1 Set • 20m • Pass 70% 0/2 Today
Distributed Locks with Redis

`SET lock_key unique_token NX PX 10000` acquisition AND atomic Lua compare-and-delete release (`if redis.call(...

20.9 1 Set • 20m • Pass 70% 0/2 Today
Celery Distributed Task Queue Architecture

Producer (FastAPI/Django) -> Message Broker (Redis/RabbitMQ) -> Celery Worker Pool -> Result Backend architect...

20.10 1 Set • 20m • Pass 70% 0/2 Today
Celery Worker Configuration and Concurrency

Prefork (`--concurrency=4`) vs I/O pools, `task_acks_late = True` + `worker_prefetch_multiplier = 1` for fair,...

20.11 1 Set • 20m • Pass 70% 0/2 Today
Defining Background Celery Tasks

Idempotent task functions taking primitive JSON arguments (`order_id: str`), explicit `soft_time_limit` / `tim...

20.12 1 Set • 20m • Pass 70% 0/2 Today
Periodic Task Scheduling with Celery Beat

`beat_schedule` (`crontab(minute="*/15")`), expiring unpaid pending orders after 30 minutes, and running STRIC...

20.13 1 Set • 20m • Pass 70% 0/2 Today
Task Retries and Failure Backoff

`autoretry_for=(httpx.TransportError,)`, `retry_backoff=True`, `retry_jitter=True`, `max_retries=5`, and handl...

20.14 1 Set • 20m • Pass 70% 0/2 Today
Celery Result Backends

`AsyncResult(task_id)` polling (`PENDING`, `STARTED`, `SUCCESS`, `FAILURE`), `result_expires = 3600` (preventi...

20.15 1 Set • 20m • Pass 70% 0/2 Today
RabbitMQ Message Broker Architecture

AMQP 0-9-1 model: Producer -> Exchange -> Binding (Routing Key) -> Durable Queue -> Consumer, virtual hosts (`...

20.16 1 Set • 20m • Pass 70% 0/2 Today
AMQP Exchanges (Direct, Topic, Fanout)

`Direct` (exact routing key), `Topic` (wildcard `order.*`, `#.failed` pattern matching!), and `Fanout` (broadc...

20.17 1 Set • 20m • Pass 70% 0/2 Today
Durable Queues and Bindings

`durable=True` queue declaration, `DeliveryMode.PERSISTENT` (`delivery_mode=2`) messages, idempotent startup t...

20.18 1 Set • 20m • Pass 70% 0/2 Today
Message Routing Keys

Designing hierarchical `<domain>.<entity>.<event>` routing keys (`ecom.order.placed`, `ecom.payment.captured`)...

20.19 1 Set • 20m • Pass 70% 0/2 Today
RabbitMQ Producers and Consumers (aio-pika / pika)

`aio_pika.connect_robust()` auto-reconnecting async channels, publishing Pydantic JSON bytes with `message_id`...

20.20 1 Set • 20m • Pass 70% 0/2 Today
Message Acknowledgements (ack and nack)

Manual acknowledgement AFTER DB commit (`async with message.process(requeue=False):`) vs `auto_ack=True` data-...

20.21 1 Set • 20m • Pass 70% 0/2 Today
Dead-Letter Queues (DLQ)

Configuring `x-dead-letter-exchange` + `x-dead-letter-routing-key` on primary queues so rejected/expired messa...

20.22 1 Set • 20m • Pass 70% 0/2 Today
Apache Kafka Distributed Event Streaming Introduction

Immutable append-only distributed commit log vs traditional queue (consuming a Kafka event does NOT delete it...

20.23 1 Set • 20m • Pass 70% 0/2 Today
Kafka Architecture (Brokers, Topics, Partitions)

KRaft mode (modern ZooKeeper-less Kafka!), Brokers, Topics split into ordered Partitions (`P0, P1, P2`), Parti...

20.24 1 Set • 20m • Pass 70% 0/2 Today
Publishing Events with Kafka Producers

`aiokafka.AIOKafkaProducer` / `confluent-kafka`, `acks="all"` durability, `enable_idempotence=True`, batching...

20.25 1 Set • 20m • Pass 70% 0/2 Today
Reading Events with Kafka Consumers

`AIOKafkaConsumer`, `auto_offset_reset="earliest"`, deserializing + validating Pydantic schemas, error isolati...

20.26 1 Set • 20m • Pass 70% 0/2 Today
Consumer Groups for Parallel Scaling

`group_id` partition assignment: 1 partition is assigned to AT MOST 1 consumer within the same `group_id` (so...

20.27 1 Set • 20m • Pass 70% 0/2 Today
Kafka Offsets and At-Least-Once Delivery

Disable `enable_auto_commit=False` and call `await consumer.commit()` ONLY AFTER your PostgreSQL transaction c...

20.28 1 Set • 20m • Pass 70% 0/2 Today
Event-Driven Integration Across FastAPI Services

Wiring the complete 6-service E-Commerce workflow (`User`, `Product`, `Inventory`, `Order`, `Payment`, `Notifi...

21.1 1 Set • 20m • Pass 70% 0/2 Today
Software Testing Fundamentals

Arrange-Act-Assert (AAA) structure, deterministic repeatability (no sleep/network/clock flakiness!), and catch...

21.2 1 Set • 20m • Pass 70% 0/2 Today
Testing Pyramid (Unit, Integration, Functional)

Fast pure-Python Unit tests (70%) + real-DB/API Integration tests (25%) + end-to-end smoke workflows (5%)

21.3 1 Set • 20m • Pass 70% 0/2 Today
Test-Driven Development (TDD) Fundamentals

Red (write failing test specifying requirement) -> Green (minimal passing implementation) -> Refactor (clean u...

21.4 1 Set • 20m • Pass 70% 0/2 Today
Python Built-In unittest Framework

`unittest.TestCase`, `setUp`/`tearDown`, `self.assertEqual`/`assertRaises`, and why Django’s `django.test.Test...

21.5 1 Set • 20m • Pass 70% 0/2 Today
Pytest Setup, Configuration and Execution

Installing `pytest` + `pytest-asyncio` + `pytest-cov`, configuring `[tool.pytest.ini_options]` in `pyproject.t...

21.6 1 Set • 20m • Pass 70% 0/2 Today
Writing Expressive Pytest Test Functions

Descriptive `test_<unit>_<scenario>_<expected>()` naming (`test_apply_job_when_already_applied_returns_409`),...

21.7 1 Set • 20m • Pass 70% 0/2 Today
Assertions and Exception Checks (pytest.raises)

Rich `pytest` diffing on dicts/lists, `pytest.approx()` for floats, and `with pytest.raises(InsufficientFundsE...

21.8 1 Set • 20m • Pass 70% 0/2 Today
Reusable Test State with Pytest Fixtures

`@pytest.fixture(scope="function" | "module" | "session")` in `conftest.py`, composable dependency injection,...

21.9 1 Set • 20m • Pass 70% 0/2 Today
Data-Driven Testing (@pytest.mark.parametrize)

Running 12 boundary/invalid input cases cleanly via `@pytest.mark.parametrize("payload,expected_status", [...]...

21.10 1 Set • 20m • Pass 70% 0/2 Today
Test Doubles and Mocking Concepts

Dummy, Fake (`FakePaymentGateway`), Stub, Spy, and Mock — choosing lightweight in-memory Fakes/Protocol implem...

21.11 1 Set • 20m • Pass 70% 0/2 Today
unittest.mock (Mock, MagicMock and patch)

`patch("app.services.orders.payment_client", autospec=True)`, `MagicMock`, `AsyncMock` (for `await` coroutines...

21.12 1 Set • 20m • Pass 70% 0/2 Today
REST API Endpoint Testing Principles

Verifying HTTP status code + response JSON schema + response headers + actual database state mutation + queued...

21.13 1 Set • 20m • Pass 70% 0/2 Today
Django Test Client

Testing Django views, middleware headers, redirects, and template context using `django.test.Client` and `pyte...

21.14 1 Set • 20m • Pass 70% 0/2 Today
DRF APIClient Testing

`APIClient()` `format="json"` requests, multipart `SimpleUploadedFile("resume.pdf", b"%PDF-1.7...", content_ty...

21.15 1 Set • 20m • Pass 70% 0/2 Today
FastAPI TestClient and AsyncClient Testing

Sync `TestClient(app)` vs native async `async with httpx.AsyncClient(transport=ASGITransport(app=app), base_ur...

21.16 1 Set • 20m • Pass 70% 0/2 Today
Isolated Test Databases and Transaction Rollbacks

Nested SAVEPOINT rollback per test: create tables once per session, open outer transaction + SAVEPOINT per tes...

21.17 1 Set • 20m • Pass 70% 0/2 Today
Multi-Component Integration Testing

Testing full vertical slices (`HTTP Router -> Pydantic -> Service -> SQLAlchemy -> PostgreSQL -> Redis Cache`)...

21.18 1 Set • 20m • Pass 70% 0/2 Today
Testing JWT-Protected Authentication Endpoints

Testing valid Bearer JWT, missing header (`401`), malformed token (`401`), expired `exp` token (`401`), wrong...

21.19 1 Set • 20m • Pass 70% 0/2 Today
Testing Role-Based Authorization Boundaries

Systematic RBAC & BOLA/IDOR matrix testing: Candidate calling Employer route (`403`), Employer B editing Emplo...

21.20 1 Set • 20m • Pass 70% 0/2 Today
Negative Testing for Invalid Payloads and Edge Cases

Testing missing required fields, extra forbidden fields, negative quantities, empty strings, oversized `10 MB`...

21.21 1 Set • 20m • Pass 70% 0/2 Today
Measuring Test Coverage with Coverage.py

`pytest --cov=app --cov-branch --cov-report=term-missing --cov-fail-under=80`, branch coverage vs line coverag...

21.22 1 Set • 20m • Pass 70% 0/2 Today
Fast Python Linting with Ruff

Configuring `Ruff` (10–100x faster Rust linter replacing Flake8 + isort + pyupgrade + bandit rules: `E`, `F`,...

21.23 1 Set • 20m • Pass 70% 0/2 Today
Deterministic Code Formatting with Black

`black --check .` / `ruff format --check .` zero-debate PEP 8 formatting (`line-length = 88/100`) eliminating...

21.24 1 Set • 20m • Pass 70% 0/2 Today
Static Type Checking with mypy Fundamentals

Running `mypy app`, `disallow_untyped_defs = true`, `check_untyped_defs = true`, catching `None` attribute err...

21.25 1 Set • 20m • Pass 70% 0/2 Today
Static Code Analysis in Pre-Commit Hooks

`.pre-commit-config.yaml` (`ruff`, `black`/`ruff-format`, `mypy`, `detect-secrets`, `check-yaml`, `no-commit-t...

21.26 1 Set • 20m • Pass 70% 0/2 Today
Maintainability and Code Review Best Practices

Small cohesive functions, explicit typing, cyclomatic complexity bounds, structured error handling, security c...

22.1 1 Set • 20m • Pass 70% 0/2 Today
Linux Operating System Fundamentals

Kernel vs user space, FHS directory layout (`/etc`, `/var/log`, `/opt`, `/tmp`, `/home`), package manager (`ap...

22.2 1 Set • 20m • Pass 70% 0/2 Today
Essential Linux File Commands (pwd, ls, cd, mkdir, rm, cp)

`pwd`, `ls -lah`, `cd`, `mkdir -p`, `cp -r`, `mv`, `rm` (careful with `-rf`!), `cat`, `head`, `tail -f`, `grep...

22.3 1 Set • 20m • Pass 70% 0/2 Today
Linux File Ownership and Permissions (chmod and chown)

Octal bits (`r=4, w=2, x=1`): `chmod 600` (`~/.ssh/id_ed25519`, `.env`), `chmod 755` (`entrypoint.sh`), `chown...

22.4 1 Set • 20m • Pass 70% 0/2 Today
Process Management (ps, top, kill, systemctl)

`ps aux`, `top`/`htop`, graceful `SIGTERM` (`kill -15`) vs last-resort `SIGKILL` (`kill -9`), exit codes (`0`...

22.5 1 Set • 20m • Pass 70% 0/2 Today
Networking Diagnostics (curl, ping, ss/netstat)

`curl -i -f http://localhost:8000/healthz`, inspecting headers (`curl -I`), listening sockets `ss -tulpn`, `12...

22.6 1 Set • 20m • Pass 70% 0/2 Today
Linux Environment Variables and Shell Profiles

`export KEY=VAL`, `env`/`printenv`, subshell inheritance, `EnvironmentFile=` in `systemd`, and avoiding secret...

22.7 1 Set • 20m • Pass 70% 0/2 Today
Secure Remote Server Access with SSH

`ssh-keygen -t ed25519`, `~/.ssh/authorized_keys`, disabling password auth & root login in `/etc/ssh/sshd_conf...

22.8 1 Set • 20m • Pass 70% 0/2 Today
Basic Linux Server Administration

`ufw` firewall (`allow OpenSSH`, `allow 80,443/tcp`, keep `5432`/`6379` private!), disk usage (`df -h`, `du -s...

22.9 1 Set • 20m • Pass 70% 0/2 Today
Containers vs Virtual Machines (Docker Introduction)

Shared Linux kernel namespaces (`pid`, `net`, `mnt`, `user`) + `cgroups` resource limits vs full guest-OS hype...

22.10 1 Set • 20m • Pass 70% 0/2 Today
Docker Engine Setup

Docker Desktop (WSL 2 backend on Windows) & Docker Engine CE on Ubuntu Linux, verifying `docker info` and Buil...

22.11 1 Set • 20m • Pass 70% 0/2 Today
Docker Architecture (Client, Daemon, Registry)

`docker` CLI -> REST socket -> `dockerd`/`containerd` -> OCI runtime (`runc`), UnionFS copy-on-write layers, a...

22.12 1 Set • 20m • Pass 70% 0/2 Today
Pulling and Tagging Docker Images

Choosing `python:3.12-slim-bookworm` over bloated `python:3.12` (`~1 GB` vs `~130 MB`) or musl `alpine` (break...

22.13 1 Set • 20m • Pass 70% 0/2 Today
Running and Managing Containers

Ephemeral stateless containers, PID 1 signal forwarding (`exec` form `CMD ["gunicorn", ...]`, NEVER shell stri...

22.14 1 Set • 20m • Pass 70% 0/2 Today
Writing Multi-Stage Python Dockerfiles

Stage 1 (`builder` compiling wheels into `/opt/venv`) -> Stage 2 (`runtime` copying `/opt/venv` + `app/`), `.d...

22.15 1 Set • 20m • Pass 70% 0/2 Today
Docker CLI Lifecycle Commands (build, run, stop, rm, logs)

`docker build -t ... .`, `docker run --rm -e ... -p ...`, `docker ps -a`, `docker logs -f --tail 100`, `docker...

22.16 1 Set • 20m • Pass 70% 0/2 Today
Persistent Storage with Docker Volumes

Named Docker volumes (`postgres_data:/var/lib/postgresql/data`, `redis_data:/data`, `media_uploads`) surviving...

22.17 1 Set • 20m • Pass 70% 0/2 Today
User-Defined Container Networks

Custom bridge networks (`frontend_net` for `nginx <-> api`, `backend_net` internal for `api <-> db/redis`), au...

22.18 1 Set • 20m • Pass 70% 0/2 Today
Multi-Container Stacks with Docker Compose

Authoring `compose.yaml` (`api`, `worker`, `beat`, `db`, `redis`, `nginx`) with `depends_on: db: condition: se...

22.19 1 Set • 20m • Pass 70% 0/2 Today
.env Configuration and Secrets Handling

Docker Compose variable substitution `${POSTGRES_PASSWORD:?required}`, `env_file`, Docker/GitHub Secrets, and...

22.20 1 Set • 20m • Pass 70% 0/2 Today
Containerizing PostgreSQL with Healthchecks

`postgres:16-alpine`, `pg_isready -U $POSTGRES_USER -d $POSTGRES_DB` healthcheck, `postgres_data` named volume...

22.21 1 Set • 20m • Pass 70% 0/2 Today
Containerizing Redis for Cache and Queues

`redis:7-alpine`, `redis-cli ping` healthcheck, `--appendonly yes` AOF durability for Celery/rate-limit state,...

22.22 1 Set • 20m • Pass 70% 0/2 Today
Nginx Reverse Proxy Fundamentals

Why Nginx sits in front of Gunicorn/Uvicorn: TLS 1.3 termination, slow-client buffering (`client_max_body_size...

22.23 1 Set • 20m • Pass 70% 0/2 Today
Uvicorn ASGI Production Server

`uvicorn` event loop (`uvloop`), HTTP parser (`httptools`), `--proxy-headers`, `--timeout-keep-alive`, and gra...

22.24 1 Set • 20m • Pass 70% 0/2 Today
Gunicorn Process Manager with Uvicorn Workers

Running `gunicorn app.main:app -k uvicorn_worker.UvicornWorker --workers 2 --graceful-timeout 30 --max-request...

22.25 1 Set • 20m • Pass 70% 0/2 Today
End-to-End Python Backend Deployment

Zero-surprise release sequence: Pull image -> Run DB migrations (backward-compatible!) -> Healthcheck new cont...

22.26 1 Set • 20m • Pass 70% 0/2 Today
CI/CD Concepts (Continuous Integration and Delivery)

Automated quality gates on every PR (CI) vs automated staging/production artifact promotion on `main` merge/ta...

22.27 1 Set • 20m • Pass 70% 0/2 Today
GitHub Actions Workflows (.github/workflows)

Triggers (`on: [push, pull_request]`), Ubuntu runners, `actions/setup-python@v5` (`cache: "pip"`), PostgreSQL...

22.28 1 Set • 20m • Pass 70% 0/2 Today
Automated Lint, Pytest, Build and Deploy Pipeline

Chaining `lint` (`ruff check`, `ruff format --check`, `mypy`) + `test` (`alembic upgrade head`, `pytest --cov-...

22.29 1 Set • 20m • Pass 70% 0/2 Today
AWS Cloud Fundamentals (EC2, S3, IAM, RDS)

Practical backend AWS literacy: `IAM` least-privilege roles (no root keys!), `EC2` + Security Groups, `S3` pri...

22.30 1 Set • 20m • Pass 70% 0/2 Today
Application Logs, Readiness and /health Checks

Separating Liveness `/healthz` (is Python process alive? `200`) from Readiness `/readyz` (can it query Postgre...

23.1 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Core Python Types, Mutability and Operators

`is` vs `==`, small-int interning trap, mutable vs immutable types, pass-by-object-reference, `Decimal` vs `fl...

23.2 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Lists, Tuples, Sets and Dictionary Internals

Over-allocated `list` array, `dict` open-addressing compact hash table (`O(1)` avg), hashability requirements...

23.3 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Functions, *args/**kwargs, LEGB Scope and Recursion

Mutable default argument trap, late-binding closure trap, LEGB + `nonlocal`, keyword-only `*` args, and recurs...

23.4 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Python OOP, MRO, Duck Typing and ABCs

`__new__` vs `__init__`, `@classmethod` vs `@staticmethod`, `@property`, C3 MRO + cooperative `super()`, `ABC`...

23.5 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Decorators, Generators, Iterators and Context Managers

Parameterized `@decorator(arg)` 3-level function structure, `@wraps`, `Iterator` vs `Iterable`, `yield` memory...

23.6 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: CPython Memory, Reference Counting, GC and GIL

`ob_refcnt` + generational cyclic `gc`, `__slots__` memory optimization, what the GIL locks, and why C extensi...

23.7 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Threading vs Multiprocessing vs Asyncio

Exact comparison across memory sharing, OS context switching, CPU-bound vs blocking I/O vs high-concurrency no...

23.8 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Python DSA Patterns (Arrays, Strings, Trees, Graphs)

Pattern recognition: sorted array -> Two Pointers / Binary Search; contiguous subarray -> Sliding Window / Pre...

23.9 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Complex SQL Joins, Subqueries, CTEs and Window Functions

Top-N per department (`DENSE_RANK`), running totals, YoY/MoM `LAG`, `LEFT JOIN` anti-joins, `EXISTS` vs `IN`/`...

23.10 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: PostgreSQL Indexing, ACID Isolation and Normalization

Composite B-Tree leftmost prefix, `EXPLAIN ANALYZE`, MVCC, `READ COMMITTED` vs `REPEATABLE READ`, `SELECT ......

23.11 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Django ORM, Middleware, Signals and N+1 Tuning

Lazy QuerySets, `select_related` vs `prefetch_related`, `F()` / `Q()` / `annotate()`, `transaction.atomic()` +...

23.12 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: DRF Serializers, ViewSets, Permissions and Throttling

`Serializer` vs `ModelSerializer`, `validate_<field>` vs `validate`, `APIView` vs `ModelViewSet`, `has_permiss...

23.13 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: FastAPI Depends(), Pydantic v2 and Async SQLAlchemy

`async def` vs `def` event-loop behavior, Pydantic v2 `ConfigDict`/`response_model`, `Depends` caching & `yiel...

23.14 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: REST API Design, Idempotency and HTTP Status Semantics

Resource naming, `PUT` vs `PATCH`, `401` vs `403`, `400` vs `422`, `409` conflict, `429` rate limit, cursor vs...

23.15 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Stateless JWT, Refresh Rotation and OAuth2 Flows

Access + Refresh token lifecycle, token rotation & reuse detection, `HttpOnly` cookie vs memory storage, RBAC...

23.16 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Microservices Boundaries, Saga and Circuit Breakers

Database-per-service, Dual-Write & Transactional Outbox, Choreography vs Orchestration Saga, Circuit Breaker s...

23.17 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: Reusable JWT Auth & RBAC Middleware Module

Machine-coding challenges #1, #2 & #5: Python Employee Management App + Reusable JWT Authentication Module + R...

23.18 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: Cursor/Offset Paginated & Filtered Search API

Machine-coding challenges #3 & #4: Complete CRUD REST API + Dynamic Multi-Filter, Full-Text Search, Whiteliste...

23.19 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: Redis Cache-Aside & Sliding-Window API Rate Limiter

Machine-coding challenges #7 & #10: Redis Cache-Aside wrapper with TTL/invalidation + Sliding-Window / Token-B...

23.20 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: Celery + Redis Background Email & Order Workflow

Machine-coding challenges #6 & #11: Background Email Notification Service (retries + idempotency) + Transactio...

23.21 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: Validated Resume/File Upload & Async Aggregator API

Machine-coding challenges #8 & #9: Non-Blocking Async Aggregator API (`asyncio.gather` + `httpx` timeouts) + S...

23.22 1 Set • 20m • Pass 70% 0/2 Today
Machine-Coding Lab: URL Shortener Backend with Analytics & TTL

Machine-coding challenge #12: Designing & coding a URL Shortener (`POST /shorten` Base62 short code, `GET /{co...

23.23 1 Set • 20m • Pass 70% 0/2 Today
Interview Review: Pytest Fixtures, Mocking, Docker & Git PR Troubleshooting

`conftest.py` fixtures, `patch` lookup rule, `AsyncMock`, multi-stage non-root `Dockerfile`, `compose.yaml` he...

23.24 1 Set • 20m • Pass 70% 0/2 Today
Backend System Design Walkthroughs for Junior/Mid Python Roles

Structured 5-step System Design method: 1) Functional & Non-Functional Requirements, 2) Back-of-Envelope Traff...

24.1 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 1: Authentication Service (Registration, Login, JWT & Refresh Rotation)

Email registration, Argon2id password hashing, enumeration-safe login, `15m` JWT access tokens, `7d` rotated/b...

24.2 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 2: User Management & Role-Based Profiles

Account profile (`GET/PATCH /users/me`), role assignment (`CANDIDATE`, `EMPLOYER`, `ADMIN`), active-account st...

24.3 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 3: Candidate Profile & Skills Management

Headline, bio, experience years, current/expected CTC, notice period, portfolio links, and normalized Many-to-...

24.4 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 4: Employer & Verified Company Profile Management

Company onboarding, slug generation, website/industry/headquarters metadata, recruiter ownership, and Admin ve...

24.5 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 5: Job Lifecycle Management (Draft, Publish, Update, Archive)

Job creation (`DRAFT`), validation (`max_salary >= min_salary`), state machine (`DRAFT -> PUBLISHED -> CLOSED...

24.6 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 6: High-Speed Job Search, Multi-Facet Filtering & Redis Caching

Keyword search, `city`, `is_remote`, `skills`, `experience`, `salary_min` filters, whitelisted sorting, bounde...

24.7 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 7: Idempotent Job Application & Status Tracking Workflow

`POST /jobs/{id}/apply` (`UNIQUE (job_id, candidate_id)` preventing duplicate applications -> `409`), cover no...

24.8 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 8: Secure Resume Upload, Validation & Storage Service

Chunked `UploadFile` streaming (`<= 5 MB`), `.pdf`/`.docx` allowlist, `%PDF-` magic-byte header verification,...

24.9 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 9: Celery + RabbitMQ/Kafka Background Email Notifications

Post-commit Outbox/on-commit dispatch to Celery + Redis/RabbitMQ/Kafka sending Application Confirmation, Emplo...

24.10 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 10: Admin Moderation & Platform Governance APIs

Admin-only endpoints (`/api/v1/admin/*`): verifying companies, suspending abusive users (`is_active=False`), m...

24.11 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 11: Hiring Funnel & Application Reporting Analytics

SQL `GROUP BY` / `FILTER` / Window aggregations reporting applications per job, stage conversion rates (`Appli...

24.12 1 Set • 20m • Pass 70% 0/2 Today
Capstone Module 12: OpenAPI 3 / Swagger UI Specification & Postman Suite

Complete tagged OpenAPI 3 documentation (`/docs` & `/redoc`), typed request/response/error schemas, ER diagram...

24.13 1 Set • 20m • Pass 70% 0/2 Today
Capstone Pytest Suite, Multi-Container Docker Compose & GitHub Actions CI

Unit + Integration `pytest` suite (`>= 80%` coverage across Auth, RBAC, Search, Apply, Upload, Analytics), mul...

24.14 1 Set • 20m • Pass 70% 0/2 Today
Final Architecture Presentation, Live API Demo & Line-by-Line Technical Viva

Presenting ER schema, service/repository architecture, JWT/RBAC security, Redis/Celery/Broker flows, query exe...

🎓 Free 1st Live Demo + Study & Interview Pack • Instant Email OTP Access

Want Unlimited PBCP Mock Exams + Weekend Live Mentorship With Working IT Pros?

Train live on weekends with active Working IT Professionals • All-Inclusive Fee: $160 USD All-Incl. (3 × $53 0% Split • Get Placement or 100% Net Refund*)

Assessment Guide

Frequently Asked Questions — Topic-Wise Mock Tests

Explore Live Cohorts →

Are Python Backend Developer Topic Mock Tests free on MockAttempt Tech Academy?

Yes! Visitors can attempt up to 2 free timed 50-MCQ Python Backend Developer – Industry-Ready Career Program Mock Tests per topic daily across 610 topics with instant answers. Enrolled live-batch students (₹15,000 All-Inclusive) unlock unlimited daily attempts.

Can I also practice Spoken AI Interviews for Python Backend Developer?

Yes — every Python Backend Developer – Industry-Ready Career Program topic also includes up to 2 free daily Spoken MockAttempt AI Technical Interviews (https://mockattempt.com/ai-interviews/course/python-backend-developer-career-program) with 4-axis voice evaluation.

⚡ Free 1st Live Demo • All-Inclusive Fees (Incl. 18% GST)

Book Free Live Demo or Reserve Batch Seat

+ Add Background, Location or Questions (Optional)