Database management tool
A database management system is software that defines, stores, retrieves, modifies, and administers database data and controls access to it.
100 SQL Server Mistakes and How to Avoid Them
A database engine is the subsystem that processes queries, manages transactions, and accesses stored database data.
- How it is used
- Provides the core service for building and hosting relational databases and processing application queries.
- How deep it goes
- Traces protocol entry, parsing, algebraization, normalization, and optimization while stopping short of a complete execution treatment.
- Examples
- Uses a MagicChoc product query against dbo.Products, including stock logic, product imagery, and a cautioned NOLOCK hint.
- What you can do after
- Evaluate query flow and recognize how Database Engine choices can contribute to performance, data-loss, or security problems.
Read how 100 SQL Server Mistakes and How to Avoid Them explains database management tool →
Building Web APIs with ASP.NET Core
A database management system is software that stores, organizes, retrieves, and manages access to structured data.
- How it is used
- Uses a DBMS as the persistent data source behind a web API and as an infrastructure choice for backend applications.
- How deep it goes
- Defines core DBMS properties and compares deployment options, but stops short of detailed database administration or transaction implementation.
- Examples
- Uses board-game data, static sample-data replacement, web API clients, on-premise servers, and cloud-hosted database services.
- What you can do after
- Evaluate and configure a DBMS choice for a web API, then connect it through Entity Framework Core.
Read how Building Web APIs with ASP.NET Core explains database management tool →
Related concepts
- storage enginehas part · A storage engine is the database subsystem that reads and writes persistent data and transaction information.
- relational enginehas part · The SQL Server Database Engine component that processes relational queries and applies relational query-processing logic.
- SQL Serverpart of · SQL Server is Microsoft's relational database management system for storing, querying, transforming, and managing structured data.
- databaseuses · A database is an organized collection of persistent data managed by software for storage, retrieval, querying, and modification.
- web serviceused by · A web service is a programmatic software interface that exposes functionality or data through web technologies or network protocols, typically HTTP.
- Entity Framework Coreused by · Entity Framework Core is a cross-platform object-relational mapping framework for .NET that enables applications to query and persist data through .NET objects and APIs.
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.