Database Administration and MySQL Review

Flashcards for reviewing database administration concepts, including data, databases, database management systems, SQL, and AWS.

Data

Facts, figures, values, or statistics.

Database

A structured collection of data, mostly consisting of recordable facts, made up of tables containing columns and rows.

Advantages of using a database

Avoid redundancy, easily modify information, keep many organized records, easily retrieve records, better data integration, greater data integrity.

Database Basics

Data is stored in tables, a table contains individual records, and records consist of fields.

Relational Database

A collection of data items with pre-defined relationships between them.

Primary Key

Uniquely identifies a record in the table.

Foreign Key

A field in the table that is a primary key in another table.

Database Management System (DBMS)

A system software used to create, delete, and manipulate data within a database, allowing users to store, process, and analyze data easily.

SQL – Structure Query Language

A database query language used to store, manage, and manipulate data within a database.

DDL: Data Definition Language

Commands used to define and modify the structure of a database (Create, Alter, Truncate, Drop, Rename).

DML: Data Manipulation Language

Commands used to manipulate data stored in a database (Insert, Update, Delete, Merge).

DCL: Data Control Language

Commands used to grant or remove privileges from a database user (Grant, Revoke).

Basic Data Retrieval

Commands used to fetch data from tables (Select, From, Where).

MySQL

A widely-used open-source relational database management system.

SELECT (SQL)

Used to query from tables.

WHERE (SQL)

Used to limit data when Querying.

Accessing Data

User account with privileges needed to access or change data.

Amazon Web Services (AWS)

Market leader in IaaS (Infrastructure-as-a-Service) and PaaS (Platform-as-a-Service).

Amazon Relational Database Service (Amazon RDS)

Makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS database engines

PostgreSQL, MySQL, MariaDB, Oracle Database, SQL Server

COUNT (SQL)

The COUNT function allows you to count all rows in a table or rows that match a particular condition.

DISTINCT (SQL)

To count unique rows in the demos table, you add the DISTINCT operator to the COUNT function.

TABLES

FIELDS

Records consist of _____