Intro to SQL Review

class: middle,

# .eight[CSET 155:]
## .eight[Database Design]

---
class: middle

# Intro to SQL Review

---
class: middle

# Agenda

- [ ] [Review Terms](#terms)
- [ ] [Review pgAdmin UI](#pgadmin)
- [ ] [Review SQL](#sql)

---
name: terms

# Terms

1. Database
2. Database Management System
3. Data Type
4. CRUD Operations
5. Data Modeling

???
1. An organized collection of data.
2. Software that interacts with the database, applications, and users.
3. The data's role; how it is stored and how it can be processed.
4. Create, Read, Update, Delete
5. A formal process for finding required data and relationships.

---
class: middle, center

# .seven[Generic Category  ->  ???]
## .eight[Specific Example  ->  ???]
### .nine[Aspect of Example  ->  ???]

???
Entity Type, Entity, Attribute

---
class: middle, center

# .seven[Sheet  ->  ???]
## .eight[Row  ->  ???]
### .nine[Column  ->  ???]

???
Table, Record, Field

---
name: pgadmin

# pgAdmin UI

- What is running on localhost server?
- What does a database icon look like?
- Where do you find the tables for a database?
- Where do you enter and edit queries?
- How do you run them?

---
name: sql

# SQL

- What does it stand for?
- What is a query?
- What keywords do you know?

???
Structured Query Language
a statement to extract data or perform an action

---

# Tables

- Define a table.
- When you create a table, what else do you create?
- What data types have you seen?

???
Where data lives and relationships are defined