READ. UNDERSTAND. PRACTICE.
Articles
Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.
2,099 resources · Page 76 of 88
Articles
SQL Query Optimization Interview Questions: EXPLAIN Plans, Joins, and Indexes
Prepare for SQL query optimization interviews with an EXPLAIN workflow, join diagnostics, index trade-offs, and a worked slow-query example.
Articles
SQL Relational Division: Find Customers Who Bought Every Required Product
Solve SQL relational division with NOT EXISTS and coverage counts, including duplicate purchases, extra products, empty requirements, and NULL keys.
Articles
SQL Retention Interview Questions: Cohort Definitions, Incomplete Windows, and Correct Denominators
Practice SQL retention interview questions with a complete dataset, verified D7 queries, incomplete cohort windows, and user-level denominator checks.
Articles
SQL Revenue Reconciliation Interview Questions: Orders, Payments, Refunds, and Mismatches
Practise SQL revenue reconciliation with orders, payments, partial refunds, cutoffs, currencies, missing records, and reason-coded mismatch checks.
Articles
SQL Server Deadlock Interview Questions: Read the Graph and Choose a Fix
Practice SQL Server deadlock interview questions with XML graph analysis, lock ordering, victim selection, row-versioning limits, and safe retry scope.
Articles
SQL Server Execution Plan Interview Questions: Estimates, Lookups, and Parameter Sensitivity
Practice SQL Server execution plan questions by tracing row estimates, Key Lookups, parameter skew, and measured trade-offs before changing indexes.
Articles
SQL Server MERGE Interview Questions: Duplicate Matches, Locking, and Concurrent Upserts
Practise SQL Server MERGE interview questions on duplicate source matches, missing-key races, HOLDLOCK, explicit upserts, and retry-safe state changes.
Articles
SQL Server Snapshot Isolation Interview Questions: Version Stores and Update Conflicts
Compare RCSI and SNAPSHOT with a two-session SQL Server timeline; learn where row versions live, when writes conflict, and how to retry safely.
Articles
SQL String Functions: SUBSTRING, SPLIT_PART, CONCAT, and LIKE in Interviews
Use PostgreSQL string functions for normalization, SUBSTRING and SPLIT_PART parsing, NULL-safe labels, ordered lists, LIKE, and row splitting.
Articles
SQL vs. NoSQL: Stop Guessing and Learn How to Choose the Right Database
This advanced guide compares relational (SQL) and non-relational (NoSQL) databases, detailing consistency models, internal storage engines, data…
Articles
SQLAlchemy Interview Questions: Session State, Flush, and Rollback
Practice SQLAlchemy interview questions with a tested Session trace covering pending objects, autoflush, failed flushes, rollback, and expiration.
Articles
SQLite Interview Questions: WAL, Busy Errors, and Concurrent Transactions
Practice SQLite interview questions with WAL snapshots, writer contention, busy errors, checkpoint timelines, and transaction-level retry decisions.
Articles
SQS FIFO Interview Questions: Message Groups, Deduplication, and Blocked Consumers
Prepare for SQS FIFO interviews with message-group ordering, deduplication limits, visibility timeouts, blocked consumers, and side-effect safety.
Articles · Squarepoint
Squarepoint Software Engineer OA 2027: C++ Hiring Test, Deadline, and Interview Process
Prepare for the Squarepoint Software Engineer OA 2027: C++ topics, reported deadline, test strategy, and what may happen after the hiring test.
Articles
SRE Interview Guide 2026: Coding, Troubleshooting, System Design, and Incidents
Prepare for SRE interviews in 2026 with practical frameworks for coding, troubleshooting, system design, incident response, and mock practice.
Articles
SRE vs DevOps Engineer: Which Interviews Should You Prepare For?
Compare SRE and DevOps interviews through SLOs, on-call response, CI/CD, and release safety, then choose the preparation track that fits your goals.
Articles
SSAS Tabular Interview Questions: Partitions, Processing, and Deployment Safety
Practice SSAS Tabular interview questions with a partition gap and overlap, TMSL processing choices, deployment safeguards, and row-count reconciliation.
Articles
SSIS Interview Questions: Incremental Loads, Error Outputs, and Package Recovery
SSIS interview questions: work through realistic examples, debug common failure modes, and explain the trade-offs with a clear verification plan.
Articles
SSRF Interview Questions for Defenders: URL Validation, Redirects, and Network Boundaries
Prepare for SSRF defense interviews with URL parsing, DNS and IP checks, redirect revalidation, outbound controls, and adversarial test cases.
Articles
SSRS Interview Questions: Parameters, Dataset Filters, and Report Totals
Practice SSRS interviews with nullable and multi-value parameters, filter-order diagnostics, a five-order total ledger, and export reconciliation.
Articles
Staff-Level System Design Interviews: How to Show Judgment, Depth, and Technical Leadership
Learn how to ace staff-level system design interviews with frameworks, trade-off examples, failure-mode prep, and practice strategies.
Articles
Staff Software Engineer Interview Guide 2026: Coding, System Design, Technical Retrospective, and Leadership
Prepare for Staff SWE interviews with a worked technical retrospective, decision record, cross-team disagreement, canary gates and scope calibration.
Articles
Staff System Design Interview Guide: Scope, Ambiguity, Platforms, and Technical Strategy
Prepare for Staff system design interviews by scoping ambiguity, defining platform boundaries, sequencing migrations, and explaining technical strategy.
Articles
工程師行為面試怎麼準備？用 STAR 講清楚決策、衝突與失敗
工程師行為面試怎麼準備？用 STAR 整理真實經歷，講清楚個人責任、技術決策、團隊衝突與失敗後的改變。本文提供三個原創教學情境、結果證據表、中英文試講與五道英文練習題，幫助你接受追問。區分官方建議、候選人分享與編輯建議，保留未驗證的範圍，不用虛構數字或把團隊成果全算成個人貢獻。