DEV Community

Cover image for Series: Learn Database Fundamental
Harry Bui
Harry Bui

Posted on

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:

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay