Query

Query Syntax vs Method Syntax

LINQ offers two equivalent ways to write the same query — SQL-like query syntax and fluent, chainable method syntax — and knowing when to reach for each makes…

LINQ to SQL and LINQ to Entities

Learn how LINQ to SQL and LINQ to Entities translate C# query expressions into database SQL, and how their architectures differ.

Avoiding the N+1 Query Problem

How lazy loading silently causes one query per entity in a loop, and how Include, projection, and split queries fix it in EF Core.

Your First Query

Writing and executing your first LINQ query against EF Core, including deferred execution, projections, async queries, and the N+1 pitfall.

Query Performance and Caching

Explore Snowflake's layered caching model, including result cache, local disk cache, and metadata cache, and how each speeds up repeated queries.

Your First Snowflake Query

A hands-on guide to running your first SQL query in Snowsight, including context, syntax, and Snowflake's free sample dataset.

Power Query Basics

Learn how Power Query lets you connect, shape, and clean data before it ever reaches your Power BI model, using a repeatable, no-code ETL workflow.

Building a Reporting Query

A step-by-step walkthrough of designing a real-world T-SQL reporting query using joins, aggregation, window functions, and pivoting.

Your First T-SQL Query

Write, run, and understand your first SELECT statement in SQL Server, from filtering rows to sorting results.

LINQ in VB.NET

Explore Language Integrated Query (LINQ) in VB.NET, from query syntax and lambda-based method syntax to deferred execution and aggregate operations.

The Query Planner and Cost Estimation

Understand how PostgreSQL's planner generates candidate execution plans and estimates their cost so it can pick the cheapest one.

The Query DSL

A guide to Elasticsearch's JSON-based Query DSL, the request language used to build every search, filter, and aggregation.

Querying with Flask-SQLAlchemy

Master filtering, joining, and optimizing database queries using Flask-SQLAlchemy's query interface.

Query Operators

Master MongoDB's comparison, logical, element, and array query operators like $gt, $in, $and, $exists, and $elemMatch for precise filtering.

The Query Planner and explain()

Learn how MongoDB's query planner selects an execution plan and how to use explain() to diagnose slow queries.

Query Arguments and Variables

Learn how GraphQL fields accept arguments to parameterize what they return, and how variables keep queries reusable, safe, and cacheable.

Writing Queries

Learn how to construct GraphQL queries that ask a single endpoint for exactly the fields you need, nested through the schema graph.

Route Parameters and Query Strings

Understand how to capture dynamic URL segments and optional query data in Express routes.

Query Optimization Basics

Foundational techniques for writing queries the optimizer can execute efficiently.

Route Parameters and Query Params

Understand how to pass dynamic data through the URL using required route parameters and optional query parameters, and how to read them reactively in a compone…

SQL Injection Prevention Cheat Sheet

Explains how SQL injection works and shows concrete, language-specific techniques to prevent it using parameterized queries and validation.

Vector Embeddings Cheat Sheet

Generate, store, and search dense vector embeddings for semantic search, covering models, distance metrics, and vector databases.

Polars (DataFrame Library) Cheat Sheet

Manipulate large tabular datasets fast with Polars' expression API, lazy execution, and multi-threaded query engine in Python and Rust.

DuckDB Cheat Sheet

Run fast in-process analytical SQL queries directly on CSV, Parquet, and pandas data with DuckDB's embedded OLAP engine.

CSS Container Queries Cheat Sheet

Syntax for container-type, container-name, and @container rules to style elements based on their parent container's size.

HTTPie Cheat Sheet

Command syntax, headers, auth, and JSON shorthand for making human-friendly HTTP requests from the terminal with HTTPie.