READ. UNDERSTAND. PRACTICE.
Computer science concepts
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
601 resources · Page 23 of 26
Computer science concepts
SQL Event Analytics
Meta-style event analytics SQL tests whether you can turn raw product logs into trustworthy behavioral metrics under realistic data conditions.…
Computer science concepts
SQL Experiment Analysis And Data Quality
These problems test practical experiment analysis skills in SQL: writing reliable aggregation queries, validating metric definitions, and spotting data…
Computer science concepts
SQL Joins, Aggregation, And Window Functions
Interviewers are testing whether you can translate messy product data into correct, efficient metrics using SQL, not whether you can memorize syntax. At…
Computer science concepts
SQL Joins And Aggregations
What's being tested — 2-3 sentences. Candidates must show correct use of join types and aggregation to produce accurate, de-duplicated metrics across…
Computer science concepts
SQL Joins, Aggregations, And Deduplication
You’re being tested on whether you can turn messy event-level data into reliable metrics without overcounting. Strong answers show command of join…
Computer science concepts
SQL Joins, Aggregations, And Window Functions
Interviewers are testing whether you can translate a product or logging question into correct relational logic under messy real-world data conditions. For…
Computer science concepts
SQL Joins, Deduplication, and Event Attribution
1. What it is SQL joins combine rows across tables on matching keys. Deduplication removes repeated records, usually keeping a single “best” row per entity…
Computer science concepts
SQL Log, Time-Window, And Graph Queries
These problems test relational data manipulation skills: deriving graph relationships from directed-edge tables and computing time-windowed event metrics…
Computer science concepts
SQL, Pandas, And dplyr Data Manipulation
These problems test vectorized conditional logic and robust dtype-aware feature engineering in pandas, plus SQL skills for aggregation, deduplication, and…
Computer science concepts
SQL Product Analytics
These problems test SQL product analytics: turning raw event tables into trustworthy metrics such as conversion, retention, CTR, frequency, revenue, and…
Computer science concepts
SQL Query Planning And Optimization
Demonstrates reading and reasoning about a execution plan to find bottlenecks, choose better join strategies, and rewrite SQL for lower cost. Interviewers…
Computer science concepts
SQL Window Functions, Cohorts, And Retention
Two skills: the ability to translate product questions into cohort-based SQL analyses and to implement them using window functions and date-bucketing so…
Computer science concepts
Stakeholder Influence And Analytical Integrity
What's being tested Ability to translate stakeholder requests into rigorous, reproducible analyses while resisting pressure to compromise methods or…
Computer science concepts
Stakeholder Leadership And Prioritization
Interviewers are probing your ability to influence cross-functional stakeholders and to choose the right analytical work under resource and time…
Computer science concepts
Stakeholder Leadership And STAR Storytelling
Interviewers expect a Product Manager to show STAR storytelling with precise stakeholder leadership: define the decision, align cross-functional partners…
Computer science concepts
Stateful Event-Driven Simulation And Allocation
These questions test deterministic event-driven simulation and time-ordered state management: advancing a timeline, processing timestamped events, and…
Computer science concepts
Stateful In-Memory Data Structures And Temporal Semantics
These problems test managing stateful in-memory data structures with correct temporal semantics: point/interval updates, versioning/TTL, merge/re-creation…
Computer science concepts
Stateful In-Memory Domain APIs
Candidates must model stateful in-memory domain APIs: correct domain objects, invariants (balances, ownership), and safe state transitions under…
Computer science concepts
Stateful In-Memory Ledgers and Versioned Stores
These problems test implementing stateful in-memory ledgers and versioned stores: deterministic, time-ordered mutation application, per-key version history…
Computer science concepts
Stateful Simulation And Event Ordering
These problems test stateful simulation and precise event ordering: you must model system state over time and produce correct outcomes as events (arrivals…
Computer science concepts
Statistical Inference For Experiments
Interviewers are probing whether you can design and interpret experiments under real product constraints, not just recite p-values. For a Meta Data…
Computer science concepts
Statistical Inference For Product Analytics
Interviewers probe a candidate’s ability to design, analyse, and interpret randomized experiments in product contexts—translating business questions into a…
Computer science concepts
Statistical Inference, Hypothesis Testing, And Power
Interviewers are probing whether you can make reliable product decisions under uncertainty, not whether you can mechanically define a p-value. At Meta…
Computer science concepts
Statistical Inference, Hypothesis Tests, And Power
Interviewers are probing whether you can turn noisy product data into a defensible decision: ship, iterate, or stop. At Meta, Data Scientists routinely…