Lecture 16: SQL Databases

Content locked

The catalog is public. Reading this content requires approved access.

Overview

Learning Objectives

Databases

Tables and Queries

SQL

Database Architecture

Files vs. Databases

Transactions vs. Analytics

ETL: Combining Transactions and Analytics

Creating and Designing Tables

Data Modeling

Keys and Normalization

Normalization Tradeoffs

Transactions

Queries

SQL Query Structure

Query Execution Pipeline

Conclusion

Source