Lambda Material:
- https://github.com/LambdaSchool/DS-Unit-3-Sprint-2-SQL-and-Databases/tree/master/module4-acid-and-database-scalability-tradeoffs
- https://learn.lambdaschool.com/ds/module/rec9c9nW20Sn6TBAO/
Agenda:
- ACID
- Database Tradeoffs and Distributed Computing
- Database Design - Tables
- Database Design - ERDs
- SQL Review (Lightning Round)
Database Transactions and ACID Properties:
- https://www.essentialsql.com/what-is-meant-by-acid/
- https://www.techopedia.com/definition/23949/atomicity-consistency-isolation-durability-acid
- https://pynative.com/python-mysql-transaction-management-using-commit-rollback/
MongoDB and ACID:
- https://stackoverflow.com/questions/7149890/what-did-mongodb-not-being-acid-compliant-before-v4-really-mean
- https://techcrunch.com/2018/02/15/mongodb-gets-support-for-multi-document-acid-transactions/
- https://www.mongodb.com/blog/post/multi-document-transactions-in-mongodb
Normalization / Database Design Practice (FYI / BONUS):
- https://github.com/prof-rossetti/gwu-istm-4121-201509/blob/master/notes/database-design/logical-design.md
- https://en.wikipedia.org/wiki/Database_normalization
- https://en.wikipedia.org/wiki/File:Update_anomaly.svg
- https://docs.google.com/spreadsheets/d/1xZ98yXEieMtaWuVQh3lQjCuP5aIqhinQcnzbnux52tY/edit?usp=sharing
- https://www.lucidchart.com/
SQL Review: