Skip to content
PHP2Shell: The PHP Bug
Akshay Thakare

#interview

36 notes, from beginner to advanced.

  1. Medallion Architecture: Bronze, Silver, Golddatabricks · beginner · 1 min
  2. Airflow Core Concepts: DAGs, Tasks, Operators and Runsapache-airflow · beginner · 2 min
  3. CTEs vs Subqueries vs Temp Tablessql · beginner · 2 min
  4. Designing an S3 Data Lake Layoutaws · beginner · 2 min
  5. ETL vs ELT: Where the Transformation Happensetl-elt · beginner · 2 min
  6. Lazy Evaluation: Transformations vs Actions in Sparkapache-spark · beginner · 2 min
  7. Normalization in Plain English: 1NF, 2NF, 3NFdata-modeling · beginner · 2 min
  8. NULL in SQL: The Rules That Break Queriessql · beginner · 2 min
  9. OLTP vs OLAP: Why Analytics Needs a Different Databasedata-warehousing · beginner · 2 min
  10. Reading and Writing JSON, CSV and Parquet in Pythonpython · beginner · 2 min
  11. Snowflake Virtual Warehouses and Cost Controlsnowflake · beginner · 2 min
  12. Tokens, Context Windows and Samplinggenerative-ai · beginner · 2 min
  13. Window Functions Every Data Engineer Usessql · beginner · 3 min
  14. SQL Logical Query Order: Why WHERE Can't See Your Aliassql · beginner · 4 min
  15. Hallucinations and How to Ground an LLMgenerative-ai · intermediate · 2 min
  16. Hybrid Search and Reranking for Better RAGrag · intermediate · 2 min
  17. IAM for Data Pipelines: Least Privilege in Practiceaws · intermediate · 2 min
  18. Incremental Loads and Watermarksetl-elt · intermediate · 2 min
  19. Indexes and Query Plans: Why a Query Is Slowsql · intermediate · 2 min
  20. Kimball vs Inmon vs Data Vaultdata-warehousing · intermediate · 2 min
  21. Python UDFs vs Built-in Functions vs Pandas UDFspyspark · intermediate · 2 min
  22. RAG vs Fine-Tuning vs Prompting: Which One?llms · intermediate · 2 min
  23. Slowly Changing Dimensions Type 2, Explained Honestlydata-warehousing · intermediate · 2 min
  24. Surrogate Keys vs Natural Keysdata-modeling · intermediate · 2 min
  25. System Design: A Daily Batch Pipeline, Step by Stepsystem-design · intermediate · 2 min
  26. Testing Data Pipelines with pytestpython · intermediate · 2 min
  27. Upserts with Delta Lake MERGEdatabricks · intermediate · 2 min
  28. Batch vs Streaming: Choosing the Right Pipelinesystem-design · intermediate · 3 min
  29. Designing Idempotent, Replayable Pipelinesetl-elt · intermediate · 3 min
  30. Join Fan-Out: How a Correct Query Returns Wrong Revenuesql · intermediate · 3 min
  31. Three Kinds of Fact Tables: Transaction, Snapshot and Accumulatingdata-modeling · intermediate · 3 min
  32. Change Data Capture: Moving Only What Changedetl-elt · intermediate · 4 min
  33. Exactly-Once Is a Myth; Idempotency Is the Answersystem-design · advanced · 2 min
  34. Guardrails for AI Agents in Productionagentic-ai · advanced · 2 min
  35. Late-Arriving Data: Facts and Dimensionsetl-elt · advanced · 2 min
  36. Multi-Agent Systems: When One Agent Is Not Enoughagentic-ai · advanced · 2 min