Databases

Databases, Schemas, and Warehouses

How Snowflake organizes data into databases and schemas, and how virtual warehouses exist independently as compute resources.

SQL Server vs Other Databases

How SQL Server compares to PostgreSQL, MySQL, and Oracle across architecture, tooling, licensing, and everyday development experience.

Ecto and Databases

How Ecto's Repo, Schema, Changeset, and Query modules work together to safely model, validate, and query data in Elixir.

Perl and Databases (DBI)

Learn how Perl's DBI module provides a uniform interface for connecting to databases, running parameterized queries, and managing transactions safely.

PostgreSQL vs Other Databases

Compare PostgreSQL against MySQL, MongoDB, and other popular databases to understand where it excels and where alternatives may fit better.

Testing APIs and Databases

Learn practical techniques for testing HTTP APIs and the databases behind them, including request assertions, schema validation, and reliable data setup.

What Is MongoDB?

An introduction to MongoDB as a document-oriented NoSQL database, how it differs from relational databases, and when it makes sense to use it.

Connecting to SQL Databases in Node.js

Learn how to connect Node.js to SQL databases like PostgreSQL and MySQL using connection pools and parameterized queries.

Introduction to Databases

Learn what a database is, why software applications need one, and how databases evolved from flat files to modern systems.

Managed Databases Overview

Learn what a cloud provider handles for you in a managed database service versus running your own database on a VM.

SQL vs NoSQL Cloud Databases

Understand the practical differences between relational (SQL) and NoSQL databases and when to choose each in the cloud.

Project: Build a Full-Stack To-Do App with React, Node.js and MongoDB

A full-stack to-do app is the perfect first MERN project — it covers every concept you'll use in production: REST APIs, database CRUD operations, JWT authentic…

Project: Build a REST API with Python and FastAPI

FastAPI is the fastest-growing Python web framework — and for good reason. In this hands-on project you'll build a fully functional REST API with auto-generate…

Vector Databases Explained: The Memory Layer Powering AI Apps

Vector databases are the storage layer behind RAG systems, semantic search, and AI- powered recommendations. This guide explains what they are, how they differ…

Async Python: asyncio Explained for Beginners

Async Python lets a single thread handle hundreds of concurrent I/O operations — making it essential for web APIs, database calls, and AI integrations. This gu…

AWS for Beginners: Cloud Computing Fundamentals

Amazon Web Services is the world's most widely used cloud platform. This guide covers the core services every developer needs — EC2 (virtual servers), S3 (stor…

SQL Cheat Sheet

Common SQL queries, joins, clauses, and database operations.

MongoDB Cheat Sheet

MongoDB CRUD operations, aggregation pipeline, and indexing strategies.

C# Cheat Sheet

Core C# syntax, LINQ queries, generic collections, async/await patterns, and object-oriented features for building .NET applications.

Prolog Cheat Sheet

Core Prolog concepts covering facts, rules, queries, list operations, and built-in predicates for logic programming.

ABAP Cheat Sheet

Core ABAP syntax for SAP development, covering data declarations, control flow, internal tables, and Open SQL statements.

APL Cheat Sheet

Core APL array-language notation covering arithmetic, indexing, custom dfns, and reduction/scan operators for concise array programming.

Python Django Cheat Sheet

Covers Django project and app setup, models, migrations, views, URL routing, and common ORM query patterns for building web applications.

Python FastAPI Cheat Sheet

Covers FastAPI route definitions, path and query parameters, Pydantic request/response models, and the dependency injection system.

Java Hibernate Cheat Sheet

Details Hibernate entity mapping annotations, session CRUD operations, HQL and Criteria queries, fetch types, and entity lifecycle states.

C++ Concurrency (std::thread) Cheat Sheet

Covers creating and managing std::thread objects, passing arguments safely, join versus detach semantics, and thread lifecycle pitfalls.

C# LINQ Cheat Sheet

Covers LINQ query and method syntax in C#, common operators like Where, Select and GroupBy, joins, and deferred versus immediate execution.

C# Entity Framework Cheat Sheet

Covers Entity Framework Core basics: DbContext, DbSet, CRUD operations, eager loading with Include, and managing schema migrations from the CLI.

PHP PDO Database Access Cheat Sheet

Covers connecting with PDO, writing prepared statements, handling transactions, and key fetch and error mode configuration options.

Apache Spark (PySpark) Cheat Sheet

PySpark reference covering SparkSession setup, DataFrame transformations and actions, Spark SQL queries, caching, and writing partitioned output.

SQL for Data Science Cheat Sheet

Reference for SQL aggregations, window functions, joins, and CTEs commonly used to analyze and reshape data during exploratory data science work.

Pandas Time Series Cheat Sheet

Covers datetime indexing, resampling, rolling windows, and shifting operations for analyzing and transforming time series data in pandas.

dplyr & tidyr Cheat Sheet

Covers dplyr's data manipulation verbs, table joins, and tidyr's pivot_longer/pivot_wider reshaping functions for tidy data workflows.

Power BI Basics Cheat Sheet

Covers Power BI's data model, DAX measures, star schema design, and common visuals for building interactive business intelligence reports.

Google Sheets Formulas Cheat Sheet

Covers Google Sheets lookup, aggregation, QUERY, and ARRAYFORMULA functions for building dynamic, spreadsheet-based data analysis.

Vector Databases for AI Cheat Sheet

Explains embeddings, approximate nearest neighbor search, and indexing strategies like HNSW, with code for storing and querying vectors using common libraries.

React Query (TanStack Query) Cheat Sheet

A reference for TanStack Query's useQuery and useMutation hooks, cache keys, and invalidation strategies for server-state management.

Responsive Web Design Cheat Sheet

Covers mobile-first media queries, fluid layout units, responsive images with srcset, and core responsive design concepts.

GraphQL Cheat Sheet

Covers GraphQL schema definition, queries, mutations, resolvers, and common patterns like fragments and batching for flexible APIs.

Redux Toolkit Cheat Sheet

Covers Redux Toolkit's configureStore, createSlice reducers, createAsyncThunk for async logic, React-Redux hooks, and RTK Query data fetching.

What is a B-Tree?

A B-tree is a self-balancing, multi-way search tree where each node can hold multiple keys and multiple children, keeping the tree shallow so search, insert, a…

Sharding vs. Partitioning: What is the Difference?

Partitioning is the general act of splitting a dataset into smaller pieces by some rule, while sharding is a specific form of horizontal partitioning where tho…

What is Database Indexing at Scale?

Database indexing at scale is the practice of building auxiliary data structures, typically B-trees or hash indexes, that let queries locate rows without scann…

What is a Bloom Filter and When Would You Use One?

A Bloom filter is a space-efficient probabilistic data structure that tells you whether an element is definitely not in a set or possibly in a set, trading a s…

What Are the Main Data Replication Strategies?

Data replication strategies fall into three broad approaches — synchronous, asynchronous, and semi-synchronous — which trade off consistency, latency, and dura…

How Do Docker Volumes Persist Data?

Docker volumes are storage areas managed by the Docker engine, living outside any single container’s writable layer, so data written to a volume survives conta…

What is a Kubernetes StatefulSet?

A StatefulSet manages Pods that need a stable, unique network identity and stable, persistent storage across restarts — each Pod gets a predictable name and it…