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