DataBases 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: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

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