Tag: Programming
Cleaning Messy Data with Pure SQL: A Beginner's Guide
Learn how to clean messy data with pure SQL, from trimming whitespace to fixing duplicates, with no extra tools needed.
100 Days of Python: Day 011 Blackjack Game
Explore Day 011 of the 100 Days of Python challenge, a command-line Blackjack game with card scoring, dealer logic, and game statistics.
100 Days of Python: Day 010 Calculator
Explore Day 010 of the 100 Days of Python challenge, a calculator that uses functions, dictionaries, validation, and chained operations.
100 Days of Python: Day 009 Secret Auction
Explore Day 009 of the 100 Days of Python challenge, a secret auction program using dictionaries, loops, validation, and sorting.
100 Days of Python: Day 008 Caesar Cipher
Explore Day 008 of the 100 Days of Python challenge, a Caesar Cipher encoder and decoder using functions, parameters, and modular arithmetic.
100 Days of Python: Day 007 Dragon Ball Hangman
Explore Day 007 of the 100 Days of Python challenge, a Dragon Ball Hangman game using modules, loops, lists, and game-state tracking.
100 Days of Python: Day 006 Age Calculator
Explore Day 006 of the 100 Days of Python challenge, an age calculator using datetime, while loops, parsing, and date arithmetic.
100 Days of Python: Day 005 Number Guessing Game
Explore Day 005 of the 100 Days of Python challenge, a number guessing game using random values, while loops, and input validation.
100 Days of Python: Day 004 Password Generator
Explore Day 004 of the 100 Days of Python challenge, a random password generator using lists, loops, and shuffling.
100 Days of Python: Day 003 Rock Paper Scissors
Explore Day 003 of the 100 Days of Python challenge, a terminal Rock Paper Scissors game using random choices, lists, and conditionals.
100 Days of Python: Day 002 Pyramid Escape Room
Explore Day 002 of the 100 Days of Python challenge, an interactive Pyramid Escape Room built with conditional logic and nested decisions.
100 Days of Python: Day 001 Tip Calculator
Explore Day 001 of the 100 Days of Python challenge, a tip calculator that practices numeric input, percentages, and formatted output.
100 Days of Python: Day000 Band Name Generator
Explore Day 000 of the 100 Days of Python challenge, a beginner Band Name Generator built with variables, user input, and string concatenation.
100 Days of Python Challenge: A Beginner's Guide
Learn how the 100 Days of Python challenge works, what projects it includes, and how daily practice can strengthen your Python skills.
SQL Window Functions: Running Totals & Rankings
Learn SQL window functions for running totals, rankings, and moving averages, with clear beginner examples.
Mastering SQL Subqueries: A Beginner-to-Advanced Guide
A guide to SQL subqueries: syntax, types, and real examples for cleaner, faster queries.
Build a Raspberry Pi DIY Photobooth (Full Guide)
Learn how to build a DIY Raspberry Pi photobooth with live preview, countdown capture, background removal, and event galleries.
Python Pandas: Cleaning Data for Analysis
Learn how to clean messy data with Python Pandas — handle missing values, duplicates, data types, outliers, and merging datasets.
Python Virtual Environments: Setup Guide & Best Practices
Learn how to create and manage Python virtual environments with venv, plus setup steps for Windows, macOS, Linux, and a cheat sheet.
Python for Data Analysis: Accessing Your Data
Learn how to access data in Python for data analysis — from CSV and Excel files to SQL databases, APIs, and web scraping.
MySQL with Docker: A Beginner’s Guide to Running Databases in Containers
Run MySQL in Docker: pull the official image, persist data with volumes, set environment variables, and connect from a client or app — a step-by-step beginner's guide.
Why Your SQL Query Is Slow (And How to Fix It)
Wondering why your SQL query is slow? Learn the most common causes — missing indexes, SELECT *, bad WHERE clauses — and how to fix them.
Database Design: A Beginner's Guide to Planning It Right
Learn database design step by step — requirements, entities, relationships, and normalization — built for beginner web designers.
SQL JOINs Explained: A Beginner's Guide
Learn SQL JOINs with clear examples: INNER, LEFT, RIGHT, and FULL JOIN explained for absolute beginners.
DAX Functions Every Power BI Analyst Should Know
Learn the DAX functions every Power BI analyst should know, from SUM and CALCULATE to DIVIDE, with simple beginner examples.
Python uv: A Faster Way to Manage Projects and Dependencies
Learn how to use Python uv to create projects, manage dependencies, and keep reproducible lockfiles with a fast, modern workflow.
Docker for Beginners: Your First Steps into Containers
New to containers? Learn Docker basics for beginners, then build a Flask and MySQL app with Docker Compose step by step.
Mastering Git: Basic Commands for Version Control
Learn essential Git basic commands for version control, from git init to git log, with simple beginner-friendly examples.
SQL Injection: How It Works and How to Prevent It
Learn what SQL injection is, how attackers exploit it, and how to prevent it with parameterized queries and input validation.
The Importance of the .env File in Python Projects
Learn why .env files matter in Python projects — keeping API keys and secrets out of your code, with setup steps and best practices.
The Role of Databases and Dashboards in Today's Business
Discover the role of databases and dashboards in modern business, from raw data storage to visual, decision-ready reporting.
Python Basics: What Every Beginner Should Know
New to Python? Learn the core Python basics every beginner should know — variables, data types, loops, functions, and more.
How to Use HTML and CSS: A Beginner's Guide for the AI Era
Learn how to use HTML and CSS with this beginner-friendly guide. Step-by-step examples show you how to structure and style your first web page.
How to Host a Static HTML Website on GitHub Pages for Free
Host a static HTML website on GitHub Pages for free. A step-by-step guide to publishing your site with a custom domain and HTTPS.
Raspberry Pi for Beginners: First Steps in DIY Computing
New to Raspberry Pi? Learn what it is, how to set it up, and beginner project ideas for your first DIY computing board.
Web Accessibility 101: A Beginner's Guide to Why It Matters
Learn web accessibility basics and why every beginner web designer should build accessible, inclusive websites.
Learn JavaScript: A Beginner's Guide and Key Benefits
Learn JavaScript basics and discover the key benefits it brings to beginner web designers and their projects.