Data Science Tutorials

Master SQL data types in MySQL, PostgreSQL & SQL Server. Learn to choose the right numeric, text, and date formats to optimize performance and data integrity.

Learn to automate image editing with Python. Use Qwen-Image-Layered to decompose images into editable RGBA layers and rebuild them in a Streamlit app.

Learn how hook-based automation works and get started using Claude Code hooks to automate coding tasks like testing, formatting, and receiving notifications.

Learn about how to create MongoDB indexes and some tips and tricks to get the best performance out of them.

Docker mounts connect containers to persistent storage through three types - volumes for production data, bind mounts for development workflows, and tmpfs for temporary files.

Understand how SQL ON DELETE RESTRICT protects data integrity. Learn how it blocks unsafe deletes and when to choose it over CASCADE or SET NULL rules.

Understand how SQL ON DELETE CASCADE automates dependent deletes in SQL, keeps tables consistent, and helps prevent accidental data loss.

Learn what Claude Cowork is and how to use for file organization, document generation, and browser automation. Hands-on tutorial with real examples and limitations.

Learn how to show formulas for a full worksheet, check individual cells, prepare files for review or printing, and avoid common issues.

Learn how to update Docker Engine, Docker Desktop, and container images — all without breaking your setup.

Learn to build a Multimodal RAG pipeline for a visual Q&A system on IKEA assembly instructions using the OpenAI API and ChromaDB vector database.

Discover how frozensets bring immutability and hashability to Python collections. Learn when to choose frozensets over regular sets.