cswork / libraryOpen practice workspace

READ. UNDERSTAND. PRACTICE.

Articles

Explore algorithm tutorials, coding and system design questions, interview experiences, and computer science study guides.

2,099 resources · Page 23 of 88

  1. Articles

    Data Engineer Resume Examples: Show Pipeline Reliability and Data Ownership

    Write a data engineer resume with credible pipeline examples, reliability evidence, clear ownership, and metrics you can defend in an interview.

  2. Articles

    Data Engineer vs Analytics Engineer: Pipelines, Models, and Interview Skills

    Compare data engineer and analytics engineer responsibilities through CDC, model grain, and metric tests, then choose practical interview preparation.

  3. Articles

    Data Engineer vs Data Scientist: Compare the Work and Choose Your Interview Prep

    Compare data engineer and data scientist responsibilities through official role examples, retry and leakage checks, and practical interview preparation choices.

  4. Articles

    Data Engineer vs Database Administrator: Responsibilities, SQL Skills, and Interviews

    Compare data engineer and DBA responsibilities, SQL interviews, retry failures, database recovery, and portfolio projects to choose the work you want to own.

  5. Articles

    Data Engineering Projects for Interviews: Build, Break, and Explain a Pipeline

    Build a data engineering interview project with tested reruns, late events, schema checks, and rollback. Download a small Python and SQLite pipeline example.

  6. Articles

    Data Engineering System Design Interview Guide: Pipelines, Trade-Offs, and Scoring

    Prepare for a data engineering system design interview: pipelines, batch vs. streaming, reliability, trade-offs, scoring, and a practical prep framework.

  7. Articles

    Data Lineage Interview Questions: Impact Analysis, Column Lineage, and Missing Metadata

    Prepare for data lineage interviews with worked impact analysis, column dependencies, missing metadata recovery, and practical coverage checks for engineers.

  8. Articles

    Data Modeling Interview Questions for Data Engineers: Facts, Dimensions, and Slowly Changing Dimensions

    Practise data modeling interview questions on grain, fact tables, dimensions, surrogate keys, SCD Type 2 joins, late data, and warehouse validation checks.

  9. Articles

    Data Pipeline Backfill Interview Questions: Dependencies, Cutovers, and Reconciliation

    Practice data pipeline backfill interview questions with dependency windows, replay-safe writes, live cutovers, reconciliation examples, and rollback checks.

  10. Articles

    The Data Science Case Study Interview: A 4-Step Framework With Worked Examples

    A 4-step framework for the data science case study interview, with worked walkthroughs of real cases asked at PayPal, Capital One, and Yahoo.

  11. Articles

    Data Science Interview Questions: SQL, Statistics, ML, and Cases

    Prepare for Data Scientist interviews with metric-first SQL, precise statistics, experiment diagnosis, leakage-safe modeling, and decision cases.

  12. Articles

    Data Science Manager Interview Cases: Prioritization, Technical Review, and Team Development

    Practice a data science manager case with a ten-day portfolio, model-review evidence packet, delegation checkpoints, and team-development decisions.

  13. Articles

    Data Science Resume Examples: Projects, Metrics, and Technical Impact That Earn Interviews

    See data science resume examples that show projects, model metrics, business impact, SQL, experimentation, and technical ownership that earn interviews.

  14. Articles

    Data Scientist Statistics Screen: Short Questions With Follow-Up Reasoning

    Practice short statistics answers with follow-ups on p-values, intervals, base rates, sample independence, conversion lift, and bootstrap assumptions.

  15. Articles

    Data Table Coding Interview: Sorting, Selection, and Server Pagination

    Practice data table interview design with server sorting, stable row selection, Select all semantics, pagination resets, and race-safe requests.

  16. Articles

    Data Vault Interview Questions: Business Keys, Hubs, Links, and History You Can Rebuild

    Answer Data Vault interviews using a CRM/ERP fixture, hub-link-satellite model, incremental loads, late data, and history reconstruction checks.

  17. Articles

    Database Design Interview Guide: Schemas, Access Patterns, and Trade-Offs

    Prepare for a database design interview with a practical framework for schemas, access patterns, indexes, consistency, scaling, migrations, and trade-offs.

  18. Articles

    Database Indexing for Interviews: B-Trees, Planner Traps, and the Write Tax

    Learn database indexing for backend interviews: B-tree access paths, composite key order, planner decisions, covering reads, and write costs.

  19. Articles

    Database Replication Interview Questions: Leaders, Quorums, Lag, and Failover

    Practice database replication interview questions on leaders, quorums, replica lag, consistency, failover, split brain, and repair.

  20. Articles

    Database Sharding and Partitioning, Explained for System Design

    Learn database sharding and partitioning with consistent hashing, shard keys, hotspot mitigation, and interview-ready system design strategies.

  21. Articles

    Database Transactions and Isolation Levels: Interview Questions with Real Anomalies

    Master transaction isolation interview questions with dirty reads, lost updates, write skew, locking choices, Serializable retries, and real examples.

  22. Articles · Databricks

    Databricks Asset Bundles Interview Questions: Targets, Deployment State, and Existing Jobs

    Answer Databricks Asset Bundles interview questions with target selection, deployment-state identity, existing-job binding, and deploy versus run evidence.

  23. Articles · Databricks

    Databricks Auto Loader Interview Questions: Schema Changes, Rescued Data, and Recovery

    Practice Auto Loader interviews with schema-change examples, rescued-data expectations, checkpoint recovery, and safe rerun decisions for file ingestion.

  24. Articles · Databricks

    Databricks 面试准备:Coding、System Programming 与架构讨论怎么区分

    Databricks 面试准备指南:用官方资料区分 Coding、System Programming 与 Architecture 的边界。围绕事件写入器,练习容量、接纳、并发关闭、持久确认、崩溃恢复与跨服务重试,明确内存模型不能证明磁盘耐久性。标注 PDF 的版本与岗位范围,不把产品知识或邻近角色面经当成统一流程。