READ. UNDERSTAND. PRACTICE.
Articles
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
2,099 resources · Page 60 of 88
Articles · Pinterest
Pinterest SWE Intern CodeSignal Guide: Score Verification, Resume Re-Screening, and What Comes Next
Pinterest SWE intern CodeSignal guide covering score verification, 600/600 rejections, resume review, phone screens, and technical interviews.
Articles
Pivot in SQL: Rows to Columns with Conditional Aggregation, FILTER, and PIVOT
Learn SQL pivot logic with conditional aggregation, zero-safe counts, PostgreSQL FILTER, dynamic JSON keys, and an unpivot example.
Articles
PL/SQL Interview Questions: Cursors, Bulk Operations, Exceptions, and Transactions
Prepare for PL/SQL interviews with cursor examples, BULK COLLECT LIMIT, FORALL, SAVE EXCEPTIONS, error handling, and transaction boundaries.
Articles · Plaid
Plaid Software Engineer Interview Guide 2026: APIs, Coding, and System Design
Prepare for Plaid SWE interviews with API contracts, a worked webhook sync, cursor recovery, tested code, system design and project ownership.
Articles
Platform Engineer Interview Guide 2026: Kubernetes, Developer Experience, and Reliability
Prepare for platform engineer interviews with Kubernetes scenarios, DevEx product judgment, reliability trade-offs, questions, and a 7-day plan.
Articles
Playwright Interview Questions for SDETs: Debugging Flaky Tests with Traces
Practise Playwright SDET interview questions with a tested trace lab, flaky-test diagnosis, locator fixes, retrying assertions, and server-data isolation.
Articles
Playwright Visual Testing Interview Questions: Baselines, Rendering Noise, and Meaningful Diffs
Practice Playwright visual testing interviews with a baseline-review fixture, rendering-noise controls, and meaningful-diff decisions.
Articles
Plum Assessment Guide 2026: 25-Minute Talent Survey, Problem Solving, and Match Scores
Learn the Plum Assessment format, 25-minute Discovery Survey, problem-solving puzzles, Match Scores, employer results, and preparation tips.
Articles
PM Interview Rubric: Score Product Sense, Metrics, and Leadership Answers
Use an original PM interview rubric to score product sense, metrics, and leadership with evidence anchors, contrasting answers, and a focused replay exercise.
Articles
PM Vibe Coding Interview: Build a Small Prototype and Defend Your Product Decisions
Prepare for a PM vibe coding interview with a small prototype, prompt revisions, acceptance tests, failure states, and product decisions you can defend.
Articles
Point-in-Time Feature Join Interview Questions: Event Time, Availability, and Leakage
Solve point-in-time feature joins with event and availability clocks, revision ranking, TTL, Feast behavior, and original SQL leakage-detection exercises.
Articles · Point72
Point72 Quantitative Developer Intern 2027: Coding Assessment, Math, and Interview Timeline
Prepare for Point72's 2027 Quant Developer internship: coding, systems, applied math, reported interview stages, timelines, and role-specific practice.
Articles
Poisson Process Interview Questions: Arrival Times, Thinning, and Conditional Counts
Practise Poisson arrivals, waiting times, fixed-total counts and thinning. Work through unit conversions, conditional dependence and a Python simulation.
Articles
Poisson Regression Interview Questions: Exposure, Overdispersion, and Count Predictions
Practice Poisson regression interview answers with unequal exposure, log offsets, count and rate predictions, and an original overdispersion diagnostic.
Articles
Polars Interview Questions: Expressions, Window Functions, and Time-Based Joins
Practice Polars interview questions on expressions, window functions, lazy execution, join_asof direction, tolerance, sorting, and verification.
Articles
Positional Encoding Interview Questions: RoPE, ALiBi, and Long-Context Limits
Prepare for positional encoding interviews with RoPE rotations, ALiBi score examples, context-extension limits, cache bugs, and useful evaluation designs.
Articles
PostgreSQL Advisory Lock Interview Questions: Session Scope, Transactions, and Pooling
Practice PostgreSQL advisory lock interview questions with session ownership, transaction scope, pooling failures, key design, and safe recovery examples.
Articles
PostgreSQL Exclusion Constraint Interview Questions: Range Overlap and Concurrent Reservations
Practice PostgreSQL exclusion constraints with half-open ranges, finite bounds, competing transactions, conflict handling, and confirmed reservation rules.
Articles
PostgreSQL Interview Questions: MVCC, Indexes, Query Plans, and Transactions
Prepare for PostgreSQL interview questions on MVCC, autovacuum, indexes, EXPLAIN plans, isolation, deadlocks, and safe transaction retries in production.
Articles
PostgreSQL JSONB Interview Questions: Operators, GIN Indexes, and Schema Trade-Offs
PostgreSQL JSONB interview questions: practice a realistic scenario, troubleshoot common failures, and explain the trade-offs with a verification plan.
Articles
PostgreSQL Row-Level Security Interview Questions: Policies, Roles, and Tenant Isolation
Practice PostgreSQL row-level security interview questions with policies, USING, WITH CHECK, owner bypass, tenant context, and isolation tests.
Articles
PostgreSQL Serializable Interview Questions: Write Skew, Serialization Failures, and Retries
Practice PostgreSQL Serializable interview questions with write skew, dependency tracking, serialization failures, whole-transaction retries, and recovery.
Articles
PostgreSQL UPSERT Interview Questions: Concurrent Inserts, Unique Constraints, and Lost Updates
Practice PostgreSQL UPSERT interview questions with concurrent-insert timelines, unique-key decisions, lost-update examples, and safe request retry patterns.
Articles
PostgreSQL VACUUM Troubleshooting Interview Questions: Long Transactions and Bloat
Diagnose PostgreSQL VACUUM interview scenarios with long transactions, dead tuples, bloat, autovacuum progress, freezing risks, and verification queries.