A tag is a keyword or label that categorizes your question with other, similar questions. Using the right tags makes it easier for others to find and answer your question.
A core SQL statement, SELECT retrieves data from one or more tables or other sources of row set data such as views or table-valued functions.
A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a d…
Splitting a database table into multiple segments for performance or manageability.
UPDATE changes the values of the specified columns in all rows that satisfy the condition. Only the columns to be modified need be mentioned in the SET clause; columns not explicitly modified retain t…
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
A widely-used open-source operating system that is particularly popular on servers.
Oracle Database 12c. Please also tag oracle for search purposes.
Performance issues with PostgreSQL queries
A type of integrity constraint used in a RDBMS platform to ensure that a value in a column matches one of a range of key values from another table.
the process of moving databases or data from one place to another
Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
The process of determining which indexes are useful and which are not.
A mechanism for managing concurrent access to shared data or resources by granting temporarily exclusive access to the processes requesting the lock.
Db2 is a family of relational database management servers developed by IBM. It runs on multiple platforms, including Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows.
Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
A core statement in SQL that does what it says on the tin: inserts data into a table.
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
MySQL's Standard Dump/Backup Utility
A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.
When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.
GROUP BY : SQL Aggregation for Common Values
A function performs some specified work, usually taking parameters as input. In terms of databases these may be specific to SQL or to the database vendor.
A mechanism for committing a consistent set of changes into a database atomically.
Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
The choice of settings for hardware, firmware, software or other components of a database system.
Use ONLY if PHP is directly relevant to the question and likely to be the source of your problem, not just because you're using a PHP library to connect to a database. PHP stands for Professional Hype…
SQL term used to describe when a `SELECT` statement is used as part of a larger SQL statement. The larger statement may be DML and is always found within brackets or parenthesis.
A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
Normalization is the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.
A virtual table that represents the data in one or more tables in an alternative way.
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.
Improving the performance characteristics of a database application or system.
In relational database design, a primary key can uniquely identify each row in a table. A primary key comprises a single column or a set of columns.
PostgreSQL version 9.3