liveBook · Manning

Relational database management system

Also called RDBMS, RDBMSs, SQL databases

A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data.

How 7 Manning books explain it

Data Analysis with LLMs

A relational database management system is software that stores, manages, and processes relational data organized in tables.

How it is used
Processes tabular data while a language model translates natural-language questions into SQL queries.
How deep it goes
Defines the tool and walks through querying SQLite in a notebook, but defers SQL basics and detailed notebook code.
Examples
Uses survey-response aggregation and a SQLite database queried through a Google Colab notebook.
What you can do after
Operate SQLite in a Colab notebook to execute SQL generated from a plain-English question, while checking generated queries.

Read how Data Analysis with LLMs explains relational database management system →

Grokking Software Architecture

A relational database management system is software that stores and manages data in related tables and supports relational queries.

How it is used
Frames relational databases as an architectural choice for structured data and enforced integrity.
How deep it goes
Explains schemas, normalization, primary keys, and explicitly defined foreign key constraints through their effects on writes and deletes.
Examples
Uses customer and order tables to illustrate linked records and prevention of orphaned orders.
What you can do after
Evaluate relational database integrity by recognizing why a named column alone does not enforce a relationship.

Read how Grokking Software Architecture explains relational database management system →

Building Web APIs with ASP.NET Core

A relational database management system is software that stores structured data in related tables and supports querying and transactional updates.

How it is used
Guides the board-game API's choice of a structured SQL data store and supports later EF Core integration.
How deep it goes
Defines tables, fixed schemas, and primary-key relationships, then stops short of product-specific implementation.
Examples
Uses Users, Roles, BoardGames, Comments, and authors as concrete table and schema examples.
What you can do after
Evaluate a relational design and select an EF Core-supported database product for the board-game API.

Read how Building Web APIs with ASP.NET Core explains relational database management system →

Java Persistence with Spring Data and Hibernate epub

A relational database management system (RDBMS) stores and manages structured data in related tables and provides relational query and transaction processing.

How it is used
Frames relational databases as a persistence foundation for Java applications and the motivation for ORM tools.
How deep it goes
Explains data independence, SQL interfaces, and low-level Java access tasks without implementing a database.
Examples
Uses shared data-entry and reporting applications alongside internet-scale and scientific-data scenarios.
What you can do after
Evaluate relational databases against alternative persistence approaches and recognize Java data-access and portability concerns.

Read how Java Persistence with Spring Data and Hibernate epub explains relational database management system →

The Well-Grounded Python Developer: How the pros use Python and Flask

A relational database management system is software that stores and manages data in related tables and provides operations for defining and querying that data.

How it is used
Persists structured application data and maintains relationships outside application code.
How deep it goes
Explains tables, keys, normalization, SQL queries, joins, and trade-offs, but stops short of detailed database administration.
Examples
Uses customer, order, address, item, and product tables with SELECT, COUNT, ORDER BY, GROUP BY, and JOIN queries.
What you can do after
Apply it via SQL to store related data, query across tables, and evaluate relational versus document-oriented storage.

Read how The Well-Grounded Python Developer: How the pros use Python and Flask explains relational database management system →

Learn SQL in a Month of Lunches

A relational database management system is software that stores, organizes, and manages structured data represented in related tables.

How it is used
Organizes structured data into related tables and retrieves connected records through SQL queries.
How deep it goes
Explains tables, relationships, joins, storage, and basic data operations without descending into implementation internals.
Examples
Demonstrates left joins, unmatched promotions, filtered queries, table inserts, and practice with sample order and sales data.
What you can do after
Apply SQL to query related tables, manipulate table data, and adapt syntax for different RDBMS products.

Read how Learn SQL in a Month of Lunches explains relational database management system →

Rust Servers, Services, and Apps

A relational database is a database that organizes data into related tables with defined schemas and relationships.

How it is used
Persists course data for a Rust web service and preserves records across service restarts.
How deep it goes
Builds through asynchronous connections, pooling, service tests, and handlers for creating and querying records.
Examples
Uses EzyTutors course data and upgrades a web service from in-memory storage to persistent Postgres storage.
What you can do after
Build and test an asynchronous Postgres-backed web service that creates and queries records.

Read how Rust Servers, Services, and Apps explains relational database management system →

Also covered in

What to know first

Related concepts

Questions about relational database management system

What is relational database management system?

A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data.

Which Manning books explain relational database management system?

Data Analysis with LLMs, Grokking Software Architecture, Building Web APIs with ASP.NET Core, Java Persistence with Spring Data and Hibernate epub, The Well-Grounded Python Developer: How the pros use Python and Flask, Learn SQL in a Month of Lunches and Rust Servers, Services, and Apps.

What should I know before learning relational database management system?

Manning books that teach relational database management system usually introduce SQL, database table, join and container first.

What is the difference between relational database management system and Elasticsearch?

A relational database management system is software that stores and manages data organized according to the relational model and supports operations for defining, querying, and updating that data. Elasticsearch is a distributed search and analytics engine for indexing, querying, and analyzing structured and unstructured data.

What kinds of relational database management system are there?

Kinds of relational database management system include SQL Server.

What is relational database management system a kind of?

Relational database management system is a kind of database management system. A database management system is software that defines, stores, retrieves, modifies, and manages access to data in databases.

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.