table
A named set of rows that all have the same columns, where each row records one fact about one thing.
In more detail
A table is declared with CREATE TABLE, which lists its columns, their types and their constraints. Rows in a table have no built-in order; you ask for an order with ORDER BY.
Examples
In AWS: A named collection of records in a database: rows in a relational database, or items in DynamoDB.An order and its outbox event are written to two tables in one transaction.The SQL course fixture has tables for customers, products, categories, orders, order items and employees.Related terms
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- Amazon DynamoDB — Amazon's fully managed key-value and document database, which stores items in tables without any servers for you to run.
- column — A named, typed field that every row of a database table has, such as name or price.
- entity — A thing in an application's domain with its own identity, such as a user, account or product, usually stored in a database.
- schema — A formal description of the structure of data: which fields or columns exist, their types and which are required.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
- transaction — A group of database changes that succeed or fail together, so the data is never left half-updated.
- row — One entry in a table, holding one value for each of the table's columns.
- CREATE TABLE — The SQL statement that defines a new table: its name, columns, types and constraints.
Taught in
- Managed Relational Databases (RDS) — Cloud Infrastructure & Hyperscaler Architecture
- NoSQL and DynamoDB — Cloud Infrastructure & Hyperscaler Architecture
- When to Pick Which Database — Cloud Infrastructure & Hyperscaler Architecture
- Entity Framework Core: Code First and Migrations — Modern .NET Core, C# & Enterprise Microservices
- Querying, Change Tracking, and Saving Data — Modern .NET Core, C# & Enterprise Microservices
- The Repository Pattern — Modern .NET Core, C# & Enterprise Microservices
- Database Access & Migrations: ORM & Data Layers — Production Full-Stack Engineering
- Multi-Tenant Identity: Tenant Isolation & Middleware — Production Full-Stack Engineering
- Asynchronous Event Processing: Outbox Pattern & Queues — Production Full-Stack Engineering
- Why Tables And Relations Beat Files — PostgreSQL, Indexing & Relational Data Modeling
- Ordering And Limiting Results — PostgreSQL, Indexing & Relational Data Modeling