SQL (Structured Query Language)
Explore the Flashcards:
1 of 56
A programming language used for managing and manipulating relational databases.
2 of 56
Database Managers
Professionals responsible for managing and overseeing database management systems (DBMS).
3 of 56
Data Manipulation
The process of modifying data to make it more organized and readable.
4 of 56
Database
An organized collection of structured information, stored electronically.
5 of 56
Database Designer
A professional responsible for designing the structure, architecture,
and layout of a database, ensuring it meets user requirements and business needs.
6 of 56
Data Integrity
The accuracy, consistency and reliability of the data stored in a database.
7 of 56
Data Extraction
The process of retrieving data from various sources for further data processing or analysis.
8 of 56
Data Consistency
Ensuring that data across a database remains accurate and uniform throughout various operations and transactions.
9 of 56
Data Security
Measures and practices implemented to protect data from unauthorized access, corruption, or theft throughout its lifecycle.
10 of 56
Database Administration
The process of managing, maintaining, and overseeing a database system.
11 of 56
Database Administrator
A professional responsible for managing, maintaining, and overseeing a database,
ensuring its optimal performance, security, and reliability.
12 of 56
Database Management System (DBMS)
Software enables users to store, modify, extract, and query data in a database.
13 of 56
Relational Database
A type of database that organizes data into tables related to each other through common data columns, providing a way to establish relationships between different data points.
14 of 56
Non-relational Database
A type of database that stores and retrieves data without requiring data to be stored in tables.
15 of 56
Relational Algebra
A set of operations used to manipulate and retrieve data from relational databases based on set theory.
16 of 56
Efficiency in Data Retrieval
The effectiveness and speed at which data can be accessed from a database.
17 of 56
Data Storage and Memory Space
The way data is saved in a database and the amount of disk space it occupies.
18 of 56
Common Fields in Database Tables
Fields that appear in multiple database tables, often used to create relationships between tables.
19 of 56
Database Schema
The structure of a relational or non-relational database defined in terms of database tables, views, and constraints.
20 of 56 
Relational Schema
A blueprint of a relational database that outlines how data is organized into tables.
21 of 56 
Client-Server Model
An application structure distributing the tasks of an operation between a server (where the server hosts, delivers and manages most
of the resources and services to be consumed by the client) and a client (where the client requests the services).
22 of 56 
Entity-Relationship Model
A diagrammatic representation of entities and their relationships, applicable mainly to relational databases.
23 of 56 
Entity-Relationship Diagram (ER Diagram)
A visual representation of the relationships between different entities in a database.
24 of 56
Database Server
A server that provides database services to other computer programs or computers.
25 of 56
Client Application
Software that accesses a service made available by a server.
26 of 56
Open-source
Software for which the original source code is made freely available to users and may be redistributed and modified.
27 of 56
Open-source Software
Software for which the original source code is made freely available to users and may be redistributed and modified.
28 of 56
MySQL
An open-source relational database management system.
29 of 56
MySQL Workbench
A visual database interface for MySQL that integrates data modelling, SQL development, and
comprehensive administration tools.
30 of 56
MySQL Server
A relational database management system that uses MySQL for data management, storage, and retrieval.
31 of 56
MySQL User
An account in MySQL that has specific privileges, allowing the user to perform actions like query execution,
database management, or more.
32 of 56
MySQL Connection
A link established between a MySQL client and a MySQL server to facilitate communication and data exchange.
33 of 56
Result Grid/Result Set
The visual representation in MySQL of the data returned by a SELECT query, displayed in a tabular format.
34 of 56
Oracle
A multinational computer technology corporation that sells database software and technology, cloud engineered systems
and enterprise software products.
35 of 56
SQLite
A C-library that implements a small, fast, self-contained SQL database engine.
36 of 56
PostgreSQL
An open-source relational database system
with an emphasis on extensibility and standards compliance.
37 of 56
MariaDB
A commercially supported version of MySQL intended to remain free under the GNU GPL.
38 of 56
Microsoft Access
A Microsoft relational database management system intended for working with relatively smaller datasets.
39 of 56
Record
A single, implicitly structured data item in a table.
40 of 56
Entity
An object, concept, person, or thing with an independent existence in the user's domain of interest.
41 of 56
Entity Instance
A single occurrence of an entity.
42 of 56
Localhost
A hostname that refers to the current device used to access the database.
43 of 56
Table Fields in Relational Schema
Columns in a table of a relational database, representing individual attributes of the records in the table.
44 of 56
SQL's syntax
Comprises SQL rules, statements and expressions that allow you to perform various commands and operations.
45 of 56
Data Definition Language (DDL)
A set of statements that allow the user to define or modify data structures and objects, such as tables.
46 of 56
Data Manipulation Language (DML)
Allows manipulation of data in tables of a database.
47 of 56
Data Control Language (DCL)
Manages user rights in a database.
48 of 56
Transaction
A sequence of one or more SQL operations executed as a single logical unit of work.
49 of 56
Transaction Control Language (TCL)
Manages the way changes are saved in a database.
Not necessarily every change made is saved automatically.
50 of 56
Committed State
A state in a database transaction where all changes have been saved and the transaction is complete.
51 of 56
Non-Committed State
A state in a database transaction where changes have not been saved and can be undone.
52 of 56
DDL Tab
A section in database interfaces for data definition language operations.
53 of 56
Comments (in SQL)
Annotations or explanations within the SQL code, ignored during execution.
54 of 56
Beautify Option
A feature in SQL tools to format code for better readability.
55 of 56 
Relational Database vs. Non-Relational Database
56 of 56
Logical Connection (for Database Relationships)
The association established between tables in a database through the use of primary and foreign keys,
facilitating data integrity and consistency.