Relational database management system
A relational database management system is software that stores and manages data organized as relations, typically represented as tables, and supports querying and updating that data.
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 →
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
- Positions SQL databases as the persistence foundation whose Java access costs motivate ORM and Spring Data.
- How deep it goes
- Explains SQL interfaces, data independence, integrity, and JDBC chores, but stops short of schema design or database configuration.
- Examples
- Uses data-entry and reporting applications sharing data, plus JDBC parameter binding, query execution, and result retrieval.
- What you can do after
- Evaluate/understand when an SQL database fits Java persistence needs and when scale or specialized data may justify another approach.
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.
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 →
Related concepts
- SQL Serverincludes · SQL Server is Microsoft's relational database management system for storing, querying, transforming, and managing structured data.
- object-oriented programmingcontrasts with · Object-oriented programming is a programming paradigm that organizes software around objects combining state and behavior, commonly using encapsulation, classes, inheritance, or polymorphism.
- Elasticsearchcontrasts with · Elasticsearch is a distributed search and analytics engine that indexes data for searching, retrieval, and analysis.
- databasekind of · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- SQLuses · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
- NoSQL databasealternative to · A NoSQL database is a database system organized primarily around nonrelational data models or access patterns rather than relational tables.
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.