Series: Learn Database Fundamental

Introduction

In this series, I will note and share all things I learn about Database Fundamentals. This series will not focus on the SQL language syntax. Instead, we will focus on topics that you can apply in database engineering, which are common across all databases (e.g., MySQL, SQL Server, PostgreSQL, etc.).

For this series, we will primarily discuss PostgreSQL and cover the following topics:

• Transactions
• ACID Properties
• Database Internals
• Index in Database
• Explain B-Tree and B+Tree
• Partition, Sharding, Replica in Database
• Locking
• Normalization and Denormalization
• How to Design a Database: Step-by-Step

---

Ask for Help or Give Feedback

If you need any assistance or have feedback to share, you can reach out to me through the following channels:

• Email: [e-mail]
• GitHub: harrybui03
• LinkedIn: Harry Bui