Skip to content

SQL

SQL (Structured Query Language) = A standardized programming language used to manage and manipulate relational databases, enabling data retrieval, insertion, updating, and deletion.
Relational database = A type of database that stores data in structured tables, using rows and columns, and employs relationships between tables for data management.
Query = A request for data or information from a database, often written in SQL, to retrieve, modify, or delete data.
SELECT statement = A SQL command used to retrieve data from a database, often with specific criteria like filtering or sorting.
INSERT statement = A SQL command used to add new records (rows) into a table within a relational database.
UPDATE statement = A SQL command used to modify existing records in a table by changing one or more fields.
DELETE statement = A SQL command used to remove records from a database table.
JOIN = A SQL operation that combines rows from two or more tables based on a related column, enabling data from multiple tables to be queried together.
Primary key = A unique identifier for each record in a database table, ensuring that no two records have the same key value.
Foreign key = A field in one table that uniquely identifies a row in another table, establishing a relationship between the two tables.
Normalization = The process of organizing database structures to reduce redundancy and dependency by splitting tables and ensuring data consistency.
Index = A database structure that improves the speed of data retrieval operations on a table, often created on columns frequently queried.
Stored procedure = A precompiled SQL code that can be executed to perform a specific task, like modifying records, on the database.
Trigger = A database object that automatically executes a specified action when a certain event (such as inserting or updating a record) occurs in a table.
Transaction = A sequence of SQL operations that are executed as a single unit, ensuring data integrity by committing or rolling back changes as needed.
ACID properties = A set of properties (Atomicity, Consistency, Isolation, Durability) that ensure database transactions are processed reliably and securely.
Database schema = The structure that defines the organization of data in a database, including tables, relationships, and constraints.
SQL injection = A security vulnerability in which malicious SQL code is inserted into an input field to execute unauthorized queries on the database.
Data integrity = The accuracy, consistency, and reliability of data in a database, ensured through constraints, normalization, and validation rules.
View = A virtual table in SQL created by a query that joins or selects data from one or more tables, often used for simplifying complex queries.

#SQL, #Relational database, #Query, #SELECT statement, #INSERT statement, #UPDATE statement, #DELETE statement, #JOIN, #Primary key, #Foreign key, #Normalization, #Index, #Stored procedure, #Trigger, #Transaction, #ACID properties, #Database schema, #SQL injection, #Data integrity, #View

SQL Cluster

Microsoft SQL Cluster project description: Microsoft SQL Cluster project’s purpose is to implement a two-node SQL Cluster to increase the availability of SQL databases. SQL… Read More »SQL Cluster