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

b'

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.

\\n

Guests

\\n

\\n

• Taoufik Khamouli

\\n

• Anouar Boukhatem

\\n

• El Housseine Jaafari

\\n

\\n

Notes

\\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.

\\n

Links

\\n

Books:

\\n

\\n

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

\\n

• Designing Data-Intensive Applications

\\n

\\n

Prepared and Presented by

\\n

\\n

• Meriem Zaid

\\n

• Mohammed Aboullaite

\\n

• Hamza Makraz

\\n

'