Skip to content
Library

All Guides

Every free guide on AI, data engineering, data science, SQL and Python, newest first.

SQL SQL Window Functions: 15 Practice Problems with Answers 15 SQL window function practice problems with ready-to-run answers: ROW_NUMBER, RANK, SUM OVER, LAG, LEAD, NTILE. Learn by doing. November 2, 2026 · 2 min read
AI Agent Orchestration Platform Guide 2026 AI AI Agent Orchestration Platform Guide 2026 AI agent orchestration platforms compared: frameworks vs managed platforms vs no-code tools, evaluation criteria, production failure patterns, and which fits your team. July 21, 2026 · 16 min read
dbt Tutorial for Beginners: Complete Step-by-Step Guide (2026) Data Engineering dbt Tutorial for Beginners: Complete Step-by-Step Guide (2026) Learn dbt from scratch, models, ref(), sources, tests, documentation, and macros explained simply. The complete dbt tutorial for beginners in 2026. June 29, 2026 · 20 min read
What Is MCP (Model Context Protocol)? Best Guide 2026 AI What Is MCP (Model Context Protocol)? Best Guide 2026 MCP (Model Context Protocol) is the open standard that lets AI agents connect to any tool or database. Learn how it works,… June 23, 2026 · 14 min read
What Is the Complete Data Analyst Roadmap (Beginner to Advanced) in 2026? Data Science What Is the Complete Data Analyst Roadmap (Beginner to Advanced) in 2026? Introduction: The Data Analyst Roadmap is an easy and structured pathway which helps to those who are completely beginners to learn about… March 24, 2026 · 16 min read
Complete Data Engineer Roadmap (Beginner to Advanced) in 2026? Data Engineering Complete Data Engineer Roadmap (Beginner to Advanced) in 2026? Quick Answer: The data engineer roadmap in 2026 starts with fundamental skills, which are SQL and Python, and then proceeds into the… March 24, 2026 · 12 min read
Data Science Roadmap 2026: A Complete Global Career Guide Blogs Data Science Roadmap 2026: A Complete Global Career Guide Data Science Roadmap 2026 covers skills, tools, careers, salaries, and learning paths for the US, UK, EU, Canada, and Australia. December 29, 2025 · 7 min read
SQL Course: Learn SQL and Databases From Beginner to Advanced SQL SQL Course: Learn SQL and Databases From Beginner to Advanced Free SQL course on PostgreSQL: 40 short lessons from your first SELECT to joins, window functions and database design, with real query… December 15, 2025 · 5 min read
Write Your Own Python Modules and Packages: __init__.py and if __name__ == “__main__” Python Write Your Own Python Modules and Packages: __init__.py and if __name__ == “__main__” Python __name__ == "__main__" explained: write your own modules and packages, __init__.py, relative imports, python -m and how to fix a circular… November 17, 2026 · 14 min read
SQL Window Functions: OVER and PARTITION BY SQL SQL Window Functions: OVER and PARTITION BY Learn SQL window functions in PostgreSQL: OVER, PARTITION BY, running sums with ORDER BY, where they run in a query, and the… November 17, 2026 · 12 min read
Python Modules: import and the Standard Library Python Python Modules: import and the Standard Library Python import module guide for beginners: import, from-import and as, why to avoid import *, dir(), sys.path, stdlib modules and ModuleNotFoundError fixes. November 17, 2026 · 13 min read
SQL Views: CREATE VIEW and Materialized Views in PostgreSQL SQL SQL Views: CREATE VIEW and Materialized Views in PostgreSQL Learn SQL views in PostgreSQL: CREATE VIEW, updatable views and CHECK OPTION, materialized views, REFRESH CONCURRENTLY with its unique index, and DROP… November 16, 2026 · 13 min read
Python Recursion: Base Case, Call Stack and RecursionError Python Python Recursion: Base Case, Call Stack and RecursionError Python recursion for beginners: base case and recursive case, factorial, nested list sum, the call stack, RecursionError, sys.getrecursionlimit() and loops. November 16, 2026 · 11 min read
SQL Recursive CTE: WITH RECURSIVE for Hierarchies, Trees and Date Series SQL SQL Recursive CTE: WITH RECURSIVE for Hierarchies, Trees and Date Series Learn the SQL recursive CTE (WITH RECURSIVE): walk a category tree with depth and path, build date series vs generate_series, and stop… November 15, 2026 · 14 min read
Python Lambda Functions: sorted() with key, map() and filter() Python Python Lambda Functions: sorted() with key, map() and filter() Python lambda functions with real examples: sort tuples and dicts with sorted(key=...), reverse=True and itemgetter, plus map() and filter() vs comprehensions. November 15, 2026 · 12 min read
SQL CTE: WITH Clause and CTE vs Subquery SQL SQL CTE: WITH Clause and CTE vs Subquery Learn the SQL CTE (WITH clause) in PostgreSQL: chain several CTEs, rewrite nested subqueries, use MATERIALIZED in PostgreSQL 12+, and CTEs with… November 15, 2026 · 13 min read
Python Variable Scope: LEGB, global and nonlocal Python Python Variable Scope: LEGB, global and nonlocal Python variable scope for beginners: local vs global, the LEGB rule, UnboundLocalError with a real fix, global, nonlocal, closures and why to… November 14, 2026 · 13 min read
SQL Subqueries: Scalar, IN, EXISTS and Correlated Subqueries SQL SQL Subqueries: Scalar, IN, EXISTS and Correlated Subqueries Learn SQL subqueries in PostgreSQL: scalar subqueries, IN and NOT IN, EXISTS, correlated subqueries and subqueries in FROM, with real results and… November 14, 2026 · 11 min read
Python Function Arguments: Defaults, Keyword Arguments, *args and **kwargs Python Python Function Arguments: Defaults, Keyword Arguments, *args and **kwargs Python function arguments explained: defaults, keyword arguments, *args, **kwargs, keyword-only and positional-only parameters, and the mutable default trap. November 14, 2026 · 11 min read
SQL Transactions: BEGIN, COMMIT, ROLLBACK and SAVEPOINT SQL SQL Transactions: BEGIN, COMMIT, ROLLBACK and SAVEPOINT Learn SQL transactions in PostgreSQL: BEGIN, COMMIT, ROLLBACK and SAVEPOINT, autocommit in psql, ACID in plain words, and what an aborted transaction… November 13, 2026 · 12 min read