Discutindo sobre Banco de Dados - Dos primórdios a Big Data

You can't be a good programmer without truly understanding how databases work. And you can't understand databases without understanding algorithms and data structures. Today, I'll show you how we went from the first databases of the 80s to current SQL and NoSQL systems. This video complements my previous video "Did I Make a SQL Server?" and other videos that I'll be referencing throughout this one. Take notes and watch afterwards. Errata 27:50 I think I got confused, the speed at the edge is faster than in the center, so theoretically on the same rotation it would give you more data to read from the edges than from the center, then C should be on the edge and D in the center Chapters 00:00:00 - Intro 00:01:15 - CAP 01 - What is a Database? The Era of dBase 00:10:04 - CAP 02 - Searching with Indices - NDX and B-Tree 00:18:53 - CAP 03 - From DBF to SQLite3 - The Most Used Database in the World 00:23:42 - CAP 04 - Everything is Trees B - The Most Important Structure in Computing 00:28:51 - CAP 05 - JSON in SQL?? You're Not Understanding It 00:31:45 - CAP 06 - Protection and Consistency - The Guarantees of Databases 00:35:38 - CAP 07 - From xBase to Client-Server - The Three Layers 00:38:59 - CAP 08 - Programming Wrongly - You Don't Know How to Use the Server 00:45:26 - CAP 09 - Constraints - Using It Correctly 00:48:13 - CAP 10 - Monitoring - Always Monitor Everything! 00:50:23 - CAP 11 - Big Data - Growing Up 00:53:40 - CAP 12 - Dividing to Conquer - Accelerating Your Web App 00:56:28 - CAP 13 - Big Data Part 2 - Why NoSQL? 01:00:39 - CAP 14 - The CAP Theorem - The Important Parts 01:07:12 - CAP 15 - Strategies for Primary Keys - Surrogate Keys 01:11:25 - CAP 16 - Consistent Hashing - Sharding 01:18:42 - CAP 17 - The Cloud Problem - Calculating Pricing 01:24:51 - CAP 18 - Recommendation for Beginners - Rice with Beans 01:27:39 - Bloopers Links [Heroku](https://www.heroku.com/postgres) [Amazon ElastiCache](https://aws.amazon.com/elasticache/) [Amazon RDS](https://aws.amazon.com/rds/) [Amazon Aurora](https://aws.amazon.com/pt/rds/aurora/) [Amazon S3 Glacier Storage Classes | AWS](https://aws.amazon.com/s3/storage-cla...) [Astra DB | DataStax](https://www.datastax.com/products/dat...) [Scylla Cloud](https://www.scylladb.com/product/scyl...) [SAP HANA Cloud](https://www.sap.com/products/technolo...) [Big Data SQL Cloud Service | Oracle](https://www.oracle.com/big-data/big-d...) [Azure SQL Database](https://azure.microsoft.com/en-us/pro...) [Google Cloud](https://cloud.google.com/sql) [Pricing | MongoDB](https://www.mongodb.com/pricing) [Valentina SQLite Server](https://valentina-db.com/en/valentina...) [Configure Amazon DynamoDB (calculator.aws)](https://calculator.aws/#/addService/D...) [CAP Twelve Years Later: How the "Rules" Have Changed (infoq.com)](https://www.infoq.com/articles/cap-tw...) [Dynamo: Amazon’s highly available key-value store - Amazon Science](https://www.amazon.science/publicatio... [PostgreSQL JSON Tutorial (postgresqltutorial.com)](https://www.postgresqltutorial.com/po...) [GitHub - azadkuh/sqlite-amalgamation: The SQLite amalgamation mirror with cmake](https://github.com/azadkuh/sqlite-ama...) Transcript: https://www.akitaonrails.com/2023/07/... Podcast: https://podcasters.spotify.com/pod/sh...