Final Exam Review: AWS, Security, ERD, SQL, and Tableau

Comprehensive vocabulary flashcards covering AWS infrastructure, information security, ERD core components, SQL syntax, and Tableau visualization workspace fundamentals.

Cloud Computing

The delivery of computing services over the internet instead of using local computers or servers.

CapEx

Traditional IT model where businesses buy and maintain equipment.

OpEx

Cloud model where businesses rent and scale as needed.

Region

A geographic location

Availability Zone (AZ)

A group of data centers within the AWS infrastructure.

Edge Location

AWS infrastructure component used for faster content delivery.

IaaS

Infrastructure as a Service; provides the most control as you manage the infrastructure, exemplified by EC2.

PaaS

Platform provided ex. by Elastic Beanstalk.

SaaS

Software as a Service; ready-to-use software, exemplified by Gmail.

EC2

Virtual servers providing compute power; charged per hour.

S3

File storage service; charged per storage used.

RDS

AWS service for relational databases.

Lambda

Serverless automation service; charged per request.

Confidentiality

CIA Triad principle ensuring only authorized users can access data.

Integrity

CIA Triad principle ensuring data is accurate and not altered.

Availability

CIA Triad principle ensuring data is accessible when needed.

MFA

Multi-Factor Authentication; a security tool for authentication.

ACL

Access Control List; user-based permissions used for access control.

RBAC

Role-based permissions used for access control.

Symmetric Encryption

Protecting data using one key.

Asymmetric Encryption

Protecting data using public/private keys.

Phishing

A common password security attack involving fake emails.

Pretexting

A common password security attack involving impersonation.

3-2-1 Rule

Backup strategy requiring 3 copies of data, 2 different storage types, and 1 offsite copy.

Incremental Backup

A backup type that records changes since the last backup.

Differential Backup

A backup type that records changes since the last full backup.

ERD

Entity Relationship Diagram; a visual representation of database structure showing Tables, Columns, and Connections.

Entity

ERD component representing a Table (e.g., Student, Course).

Attribute

representing a Column (e.g., Student_ID, Name).

Relationship

A core ERD component acting as a Verb to connect entities (e.g., enrolls in, teaches).

Cardinality

Shows how many records relate between tables, such as 1:1, 1:M, or M:M.

Primary Key (PK)

A unique identifier for a record in a database table.

Foreign Key (FK)

A key that links tables together in a database structure.

VARCHAR

A data type used for text.

Conceptual ERD

A high-level ERD used to design databases.

Logical ERD

A detailed ERD that adds attributes and keys.

SQL

Structured Query Language; used to manage and retrieve data.

Schema

The table structure including columns and data types.

ORDER BY

The SQL clause used to sort results.

FETCH FIRST 'XX' ROWS ONLY

SQL syntax used to display only a specific number of rows.

Dimensions

Blue, categorical fields in Tableau such as names, dates, or categories.

Measures

Green, numerical values in Tableau used for mathematical calculations.

Marks Card

Tableau workspace part that controls color, size, shape, labels, detail, and tooltip.

Inner Join

Returns matching records from both tables.

Union

Combines rows from two datasets with the same structure.

Stories

Tableau feature used to create guided, interactive presentations using snapshots of dashboards.

Steps to create an ERD

1. Identify Entities

2. Identify Relationships

3. Determine Cardinality

4. Add Attributes

5. Draw Diagram

INT

numbers

BOOLEAN

True/False

Conceptual ERD

High level

Logical ERD

Detailed

Physical ERD

Actual database implementation

Query Order

Select, from, where, order by