BROADCASTS.com

Published: Feb. 16, 2021, 2:03 p.m.

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.

\nGuests\n

\n

• Taoufik Khamouli

\n

• Anouar Boukhatem

\n

• El Housseine Jaafari

\n

\nNotes\n

0:00 - Introduction.

\n

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

\n

0:10 - Why do we need databases?

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

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

\n

1:56 - Advice about Performance Optimization.

\n

2:19 - Wrap up and goodbye.

\nLinks\n

Books:

\n

\n

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

\n

• Designing Data-Intensive Applications

\n

\nPrepared and Presented by\n

\n

• Meriem Zaid

\n

• Mohammed Aboullaite

\n

• Hamza Makraz

\n