93. Databases Introduction

Databases

optimized for a purpose and come with different features, shapes and constraints

• You can structure the data

• You build indexes to efficiently query / search through the data

• You define relationships between your datasets

Relational Databases

• Looks just like Excel spreadsheets, with links between them!

• Can use the SQL language to perform queries / lookups

NoSQL Databases

purpose built for specific data models and have flexible schemas for building modern applications.

NoSQL Benefits

• Flexibility: easy to evolve data model

• Scalability: designed to scale-out by using distributed clusters • High-performance: optimized for a specific data model

• Highly functional: types optimized for the data model

JSONs are NoSQL

True

Benefits of AWS Managed Database

• Quick Provisioning, High Availability,Vertical and Horizontal Scaling

• Automated Backup & Restore, Operations, Upgrades

• Operating System Patching is handled by AWS

• Monitoring, alerting