GeeksBlaBla artwork

#70 - DataBases deep dive

GeeksBlaBla

Arabic - February 16, 2021 14:03 - 2 hours - 65.5 MB - ★★★★ - 5 ratings
Technology Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed

Previous Episode: #69 - Python Deep Dive

In this episode of GeeksBlabla, we invited Taoufik Khamouli, Anouar Boukhatem and El Housseine Jaafari to talk about Databases, different types and, some advanced topics.


Guests

Taoufik Khamouli


Anouar Boukhatem


El Housseine Jaafari

Notes

0:00 - Introduction.


0:06 - What do we mean by a Database?


0:10 - Why do we need databases?


0:20 - What are the different types of databases and why we have more than one?


0:39 - What are ACID properties, and why are they important?


0:51 - What is denormalization and, when we need it?


0:55 - What consideration to decide between database types?


1:29 - Open-source vs. proprietary database, Which one is better?


1:34 - What is Indexing and how to use it well?


1:37 - What is CAP theorem, and why is it important?


1:42 - What are the requirements to have High Availability & Data Replication in databases?


1:49 - What are Backup & Restore Policies best practices?


1:56 - Advice about Performance Optimization.


2:19 - Wrap up and goodbye.


Links

Books:

Building Secure and Reliable Systems: Best Practices for Designing, Implementing, and Maintaining Systems


Designing Data-Intensive Applications

Prepared and Presented by

Meriem Zaid


Mohammed Aboullaite


Hamza Makraz