October 2 - 4 - Devoxx Morocco 2024 - 🇲🇦 Palm Plaza hotel - Marrakech 🌞🌴
Follow Us On

Talk details

Ever wondered how databases are managed behind the scenes? Their architecture insights, file types, or the SQL query lifecycle? 
Well, many like me, who enjoy building applications using different database management systems, always wonder: how my "INSERT INTO..." query is executed? How, out of millions of rows, does my "SELECT * FROM table WHERE id = 579030" returns the correct result in a blink of an eye?
Unfortunately, the available information about databases often assumes that readers already have an idea about these subjects, making it challenging to understand for new learners.
This talk "Database Internals 101" is designed to be beginner friendly, and addresses the challenges and questions that we talked about by providing clear and engaging explanations.
We begin with an overview of common concepts in Database Management Systems (DBMS) including its architecture (chapters 1 & 2). These chapters provide the foundation of DBMS.
Next, we'll explore how database files are structured and organized into data files and index files. Before concluding our discussion on indexes, we'll demonstrate how the database's SQL query planner and optimizer determine the appropriate index to be used. (Chapters 3 & 4)
Moving forward, we talk about important aspects of every DBMS: trees, tree balance, BSTs, b-trees (Chapter 5)
The final chapter is the most exciting part, where we will see how a SQL query operates by combining all the components discussed in the presentation.
Yassir Ez-znafry
Oracle

Hello everyone!

I'm Yassir Ez-znafry, ENSIAS graduate and a software engineer at Oracle with a passion for understanding the inner workings of databases. I hold several certifications, including:

Oracle Database SQL Certified Associate (OCA)

Oracle Certified Foundations Associate, Database

Oracle Certified Associate, Java SE 8 Programmer (OCA)

In my free time I write about Java, React, databases… on medium

I look forward to sharing insights and learning from the community.