Tag: SQL
11 items found
Projects
Glossary Terms
Database Indexing
Database indexing creates auxiliary data structures on selected columns so queries find rows faster without scanning every record.
Database Normalization
Database normalization organizes relational tables around dependencies to reduce duplication and protect consistency as data changes.
Database Transaction
A database transaction groups reads and writes into one unit of work that either commits completely or rolls back safely.
Foreign Key
A foreign key links a value in one table to a key in another table, preserving referential integrity in relational databases.
MySQL
MySQL is a relational database that stores SQL data in tables, indexes, and transactions, widely used behind web applications and services.
PostgreSQL
PostgreSQL is an open-source ACID-compliant relational database that combines SQL, JSON support, indexing, and extensibility.
Primary Key
A primary key is a non-null, non-repeating column or column set that uniquely identifies each row in a database table.
Query Optimization
Query optimization improves database queries by reducing reads, choosing useful indexes, and shaping efficient execution plans.
SQL (Structured Query Language)
SQL is the standard language for querying, changing, and reporting on structured data stored in relational database tables.
Stored Procedure
A stored procedure is a named SQL block saved in the database and called with parameters to run repeatable data operations.