Side Quest

DBA - Database Administration

• Describe and Define

### Database Types

• nosql
• Relational Database

### Information Structure

• table
• collection
• schema
• queries

### Database Engines

• mongodb
• sqlite
• mysql
• postgres
• ssms

### Database Command Types

• DDL
• DQL
• DML
• DCL
• TCL

### Database Queries - INSERT - SELECT - UPDATE - DELETE

### Query Filters - WHERE - ORDER BY

### Joins - JOIN - INNER JOIN - LEFT JOIN - RIGHT JOIN - OUTER JOIN