liveBook · Manning

Database table

Also called relations, relational table, SQL table

A database table is a relational data structure that organizes records into rows whose values correspond to defined columns.

How 14 Manning books explain it

D3.js in Action, Third Edition

An HTML table is a structured HTML element that represents data in rows and columns.

How it is used
Provides an accessible, extractable alternative to a chart and serves as a source of data for another visualization.
How deep it goes
Works through constructing and toggling a table, then extracting rows from existing tables; does not develop table layout in depth.
Examples
Uses a cetacean chart with a switchable data table and a script that extracts painting records from Wikipedia tables.
What you can do after
Build it from scratch as a selectable chart alternative, or extract records from existing HTML tables with browser JavaScript.

Read how D3.js in Action, Third Edition explains database table →

Data Analysis with LLMs

Relational data is data organized as collections of tables whose rows and columns represent related records and attributes.

How it is used
Organizes records for analysis and gives natural-language questions a structure that can be translated into database queries.
How deep it goes
Defines rows, named columns, and column types, then walks through loading tabular data into SQLite.
Examples
Uses customer records, product reviews, video games, survey results, and extracted email attributes as tabular data.
What you can do after
Operate/configure it in SQLite by creating a table and loading data, then evaluate/understand queries generated from natural-language questions.

Read how Data Analysis with LLMs explains database table →

Rust Servers, Services, and Apps

A database table is a structured relational-data object consisting of rows organized under defined columns and constraints.

How it is used
Stores course and tutor records for SQL-backed web APIs and their deployment checks.
How deep it goes
Walks through SQL creation, constraints, seed data, psql checks, model alignment, and container verification without detailing database storage internals.
Examples
Uses seeded course rows, an expanded course schema, a tutor table, and psql checks inside a PostgreSQL container.
What you can do after
Build it from scratch with SQL scripts, then verify tables and rows with psql and check persistence after a container restart.

Read how Rust Servers, Services, and Apps explains database table →

Build Python Web Apps with Streamlit

A table is a relational data structure consisting of rows and columns that stores records about related entities.

How it is used
Stores persistent application records and makes them available for retrieval.
How deep it goes
Explains rows, columns, schemas, and keys, then walks through table creation and inspection.
Examples
Uses users and haikus tables and a sales CSV uploaded to BigQuery.
What you can do after
Apply it via PostgreSQL or BigQuery to create and inspect tables.

Read how Build Python Web Apps with Streamlit explains database table →

Build Financial Software with Generative AI (From Scratch)

A database table is a structured collection of rows and columns that stores related records in a relational database.

How it is used
Stores parsed ACH records, processing exceptions, and API audit events for a financial application.
How deep it goes
Walks through table creation, insertion, testing, and later schema refinements, while deferring more detailed exception relationships.
Examples
Uses ACH file headers, exception descriptions, API request logs, and international ACH batch headers as table designs.
What you can do after
Apply table design and SQL insertion to persist parsed records and verify them with unit tests.

Read how Build Financial Software with Generative AI (From Scratch) explains database table →

Building Web APIs with ASP.NET Core

A database table is a relational data structure consisting of rows and named columns that store records of a particular type.

How it is used
Organizes board-game API record types as separate structures in a relational database.
How deep it goes
Defines fixed-schema tables and explains identifier-based relationships, but does not provide a worked table definition.
Examples
Illustrates Users, Roles, BoardGames, and Comments tables, including a BoardGameID column that associates comments with board games.
What you can do after
Evaluate/understand how separate tables and identifier-based references differ from documents containing related information.

Read how Building Web APIs with ASP.NET Core explains database table →

BDD in Action, Second Edition

A table is a structured arrangement of related values in rows and columns that can represent complex scenario data.

How it is used
Uses tabular flight and account data to clarify business rules and express scenario preconditions and expected results.
How deep it goes
Works through evolving eligibility columns, scenario table shapes, and Cucumber row conversion; does not address database storage design.
Examples
Contrasts eligible flights with old, partner, canceled, and future flights, then shows account balances and flight-crediting scenarios.
What you can do after
Apply it via Cucumber data tables to express scenario data and map flight rows into domain objects.

Read how BDD in Action, Second Edition explains database table →

Graph Neural Networks in Action

Information describing how entities are connected or related to one another.

How it is used
Identifies relationship information that makes graph-based learning useful when connections between entities matter to prediction.
How deep it goes
Works through nodes, edges, binary adjacency matrices, symmetry, and weighted connections, then sketches how GNNs use graph features.
Examples
Uses a five-node adjacency matrix and mechanical graphs of connected body parts or interacting objects.
What you can do after
Evaluate/understand when relationships warrant a graph neural network rather than treating data as standalone entries.

Read how Graph Neural Networks in Action explains database table →

Tiny CSS Projects

A table is a structured HTML presentation of data organized into rows and columns for tabular relationships.

How it is used
Uses a checkout-cart table to present item details and totals while adapting their display to screen width.
How deep it goes
Works through CSS changes for mobile rows, cells, labels, and totals, then shows where standard table display resumes.
Examples
Uses a checkout cart with an item image, unit price, quantity, total, actions, and a footer total.
What you can do after
Practice/perform it: style one cart table as labeled cards on narrow screens and a standard table on wider screens.

Read how Tiny CSS Projects explains database table →

Effective Data Analysis

A table is a structured data collection arranged in rows representing records and columns representing attributes.

How it is used
Organizes warehouse data into records and attributes that analysts can query.
How deep it goes
Defines rows and columns, then illustrates practical querying and table-structuring considerations.
Examples
Uses a city-population table for state totals and a weather table for daily forecasts, retention, and joins.
What you can do after
Apply SQL to group table records by state and calculate summed population.

Read how Effective Data Analysis explains database table →

Functional Design and Architecture: Examples in Haskell

A relation in the relational model is a set of tuples described by a common set of attributes.

How it is used
Represents relational database tables as Haskell schema declarations used with Beam.
How deep it goes
Defines table fields, names, primary keys, and backend-supported column types, including compile-time checks for unsupported types.
Examples
Uses a DBMeteor table with integer fields for size and mass and a timestamp field.
What you can do after
Build a Beam table declaration by assigning column types and specifying its name and primary key.

Read how Functional Design and Architecture: Examples in Haskell explains database table →

Amazon Web Services in Action, Third Edition: An in-depth guide to AWS

A database table is a relational data structure consisting of rows and columns that stores records of a defined schema.

How it is used
Stores application records as named DynamoDB item collections, such as users and tasks in a to-do application.
How deep it goes
Defines items, attributes, flexible schemas, and primary keys, then demonstrates table creation with a partition key.
Examples
Uses separate user and task tables in a terminal to-do application, with `todo-user` keyed by `uid`.
What you can do after
Configure a DynamoDB table with a name, primary-key schema, and provisioned-throughput settings using the AWS CLI.

Read how Amazon Web Services in Action, Third Edition: An in-depth guide to AWS explains database table →

.NET in Action, Second Edition

A table is a database structure that stores related records in rows and columns.

How it is used
Persists related book records in an EF Core application.
How deep it goes
Explains entity mapping and primary-key conventions, then demonstrates table access through DbContext.
Examples
Uses a Book entity, a Books table, and an in-memory database.
What you can do after
Build a code-first EF Core entity-to-table mapping and access its rows through DbContext.

Read how .NET in Action, Second Edition explains database table →

WordPress Power Toolkit: Harness AI to build next-level websites

An HTML table is a structured arrangement of data in rows and columns represented with HTML elements for rows, columns, and cells.

How it is used
Uses HTML tables to display organized information on website pages.
How deep it goes
Shows table markup and styling refinements, without explaining HTML table structure in depth.
Examples
Uses a five-largest-US-lakes table and requests for styled headings and alternating row backgrounds.
What you can do after
Apply generated HTML by pasting it into WordPress’s Text tab, checking the display, and requesting refinements.

Read how WordPress Power Toolkit: Harness AI to build next-level websites explains database table →

Also covered in

What to know first

Related concepts

Questions about database table

What is database table?

A database table is a relational data structure that organizes records into rows whose values correspond to defined columns.

Which Manning books explain database table?

D3.js in Action, Third Edition, Data Analysis with LLMs, Rust Servers, Services, and Apps, Build Python Web Apps with Streamlit, Build Financial Software with Generative AI (From Scratch), Building Web APIs with ASP.NET Core, BDD in Action, Second Edition, Graph Neural Networks in Action and 6 more.

What should I know before learning database table?

Manning books that teach database table usually introduce SQL, CSV, JSON and data warehouse first.

What kinds of database table are there?

Kinds of database table include structured data and view.

What are the parts of database table?

Database table includes primary key, DynamoDB item and tuple.

What is database table also called?

Database table is also called relations, relational table or SQL table.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.