Table

Dataverse Tables and Relationships

Learn how Microsoft Dataverse organizes data into tables, columns, and relationships that power Model-Driven and Canvas apps.

The Table API and Flink SQL

Learn how Flink's Table API and SQL layer let you express streaming and batch pipelines declaratively on top of the DataStream engine.

Materializations: View, Table, Incremental

Understand how dbt's view, table, and incremental materializations trade off build cost against query performance, and when to use each.

Temp Tables and Table Variables

Compare local temp tables, global temp tables, and table variables in SQL Server, and learn when each is the right tool for intermediate result sets.

Tables and Data Import

Work with MATLAB's table data type for organizing heterogeneous data with named columns, and use the Import Tool and related functions to bring in external dat…

Erlang and Mnesia

Understand Mnesia, Erlang's built-in distributed database, its table types, transactions, and how it fits into OTP applications.

ETS Tables

ETS (Erlang Term Storage) provides fast, in-memory tables for sharing large amounts of data between processes without the overhead of message passing.

Common Table Expressions

Learn how PostgreSQL's WITH clause structures complex queries into named, readable building blocks, including recursive CTEs for hierarchical data.

Common Table Expressions (CTEs)

A named, temporary result set defined with WITH that improves readability and enables recursive queries.

Go Testing Cheat Sheet

Covers writing unit tests and table-driven tests with the testing package, subtests, benchmarks, and running tests with the go test CLI.

Supabase Basics Cheat Sheet

Introduces Supabase's Postgres database, auto-generated REST API, authentication, Row Level Security, and realtime subscriptions using the CLI and JS client.