Database Management Systems Relational Database
SQL Normalization
Index Backup
Query Transaction

 

A type of database that organizes data into tables with predefined relationships between them. A software system that manages databases and allows users to access and manipulate data.
The process of organizing data in a database to eliminate redundancy and improve efficiency. Structured Query Language, a programming language used to manage and manipulate databases.
The process of creating copies of data to ensure its availability in case of data loss or corruption. A data structure that improves the speed of data retrieval operations in a database.
An atomic set of database operations that must be executed as a whole, ensuring data consistency. A request for data from a database using a specific set of criteria.

 

Data Warehousing Database Administrator
Database Storage Engine Sqlite
Database Security Query Optimization
Indexing Data Redundancy

 

A professional responsible for managing and maintaining a database system. The process of collecting and managing data from various sources for business intelligence and analysis purposes.
A lightweight relational database management system (RDBMS) that uses its own storage engine and is contained in a single disk file without a separate server process. A software program or module that is responsible for managing how data is stored, organized, and accessed in a database.
The process of selecting the most efficient execution plan for a query in a database management system. The protection of electronic databases from unauthorized access, use, disclosure, disruption, modification, or destruction.
The storage of the same data in multiple places within a database, which can lead to inconsistency and inefficiency. The technique of creating data structures, called indexes, to improve the speed of data retrieval operations in a database.

 

Data Integrity

 

The accuracy, consistency, and reliability of data stored in a database, ensuring it is valid and trustworthy.