Fundamentals

Question 1

What is a Database (DB)

Answer 1

Any collection of related information

Question 2

Database Management System (DBMS)

Answer 2

Special software intended for creating and maintaining massive bundles of information. Security, Backups, Importing/exporting, and interacts with other programs/websites

Question 3

CRUD

Answer 3

Create, read/retrieve, update and delete. Four core abilities of a DBMS

Question 4

Types of Databases

Answer 4

Relational (SQL) and Non-Relational (noSQL)

Question 5

Relational DB (SQL)

Answer 5

Organizes data into tables. Each with columns and rows. Unique keys identify each row (entry/instance)

Question 6

Non-Relational DB

Answer 6

Any DB that is not a relational table. Key/Values stores, Documents, Graphs

Question 7

Relational DBMS

Answer 7

mySQL, Oracle, postgreSQL, mariaDB

Question 8

Structured Query Language (SQL)

Answer 8

Standardized language for interacting with RDBMS software.

Question 9

Non-Relational DBMS

Answer 9

mongoDB, dynamoDB, apache cassandra, firebase, etc. There isn’t a standard language for interacting with these systems.

Question 10

Database Queries

Answer 10

Request to the DBMS for specific information. The more complex the Database, the more specific the query needs to be to write a query. (in SQL)