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.

Hosted by: Meriem Zaid Mohammed Aboullaite Hamza Makraz
Guests: Taoufik Khamouli Anouar Boukhatem El Housseine Jaafari

Play episode on:

Share episode:

Notes:

0:00:00 - Introduction.

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

0:10:00 - Why do we need databases?

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

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

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

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

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

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

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

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

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

1:56:00 - Advice about Performance Optimization.

2:19:00 - Wrap up and goodbye.

Links:

Building Secure and Reliable Systems: Best Practices for Designing, Implementing, and Maintaining Systems Designing Data-Intensive Applications
Edit on GitHub – PRs welcome
Illustration

Anything you want us to talk about?

If you have any topics, questions, guests to invite, concepts, books, or technologies you want us to explore, don’t hesitate updating our episodes planning :D

Check planning