All tutorials

66 published tutorials across 19 topics.

Artificial Intelligence AI Agents Python SQL Power BI Tableau Excel Git ChatGPT Scala Julia Spreadsheets Machine Learning Data Visualization Business Intelligence Snowflake Google Cloud Platform OpenAI Ollama

Git Diamond

Git Switch vs Checkout: Understanding the Difference

Upgrade your Git workflow by mastering git switch. Explore how it differs from git checkout, prevents detached HEAD states, and makes branch management safe.

Srujana Maddula 5 min 3,762Mar 19, 2026

Google Cloud Platform Diamond

BigQuery Sandbox: A Guide to Google's Free SQL Playground

Spin up a no-cost BigQuery environment, practice real-world SQL on public and private data, and build dashboards while staying within generous free-tier limits.

Aryan Irani 8 min 2,380Mar 15, 2026

SQL Diamond

Correlated Subquery in SQL: How It Works with Examples

Learn how correlated subqueries do row-by-row comparisons in SQL. Discover use cases and how they differ from JOINs, window functions, or non-correlated queries.

Allan Ouko 10 min 1,798Mar 10, 2026

SQL Diamond

Relational Algebra: The Logic Behind Every SQL Query

A practical guide to relational algebra covering fundamental operators, join types, and derived operations, with SQL comparisons and examples that show how database engines process queries internally.

Dario Radecic 7 min 2,801Feb 25, 2026

Snowflake Diamond

Snowflake and Streamlit: A Complete Guide to Building Data Apps

A comprehensive walkthrough of building, deploying, and optimizing Streamlit apps directly within Snowflake. Leverage the popular open-source Python framework through its integration with a powerful cloud platform.

Tim Lu 10 min 1,881Feb 11, 2026

Machine Learning Diamond

How to Normalize Data: A Complete Guide With Examples

Stop vanishing gradients and biased models. Learn how to normalize data using min-max and z-score in Scikit-learn to improve machine learning models.

Josep Ferrer 10 min 1,798Jan 27, 2026

SQL Star

SQL Data Types: Essential Guide for Beginners

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

Amberle McKee 11 min 258Jan 19, 2026

SQL Diamond

SQL ON DELETE RESTRICT: Prevent Accidental Data Loss

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.

Allan Ouko 9 min 2,516Jan 16, 2026

Spreadsheets Star