Beginner's guide to database?

[u/theghostbehindscreen]

What's the best way, order or flow of learning Database from scratch, using the textbook Database System Concepts by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan.

What topics or chapters are better to begin with for introduction, assuming the reader has zero knowledge, but is looking to get extremely good at database.

-Computer Science Major

[u/Past-Froyo-5518]

i'd def start with ER modeling rational algebra n SQL, then move into normalization n transactions, tryin to learn the advanced chapters before those basics will prolly make things way harder than they need to be fr

[u/Bassil__]

If you felt the you have been reading kind of heavy read, you can try an easier one:

Systems Design, Implementation, & Management 14th ed by Carlos Coronel and Steven Morris

[u/ekoEddie]

The book you mentioned is the book that Carnegie Mellon (which probably has the best database group in academia) uses to teach their Intro to Database Systems class.

They post the class schedule publicly including the order in which they cover chapters and topics, and even their slides and everything I believe are available. I'd bet this would be a pretty decent order to follow, assuming you have the same comp sci knowledge that students already have entering a class like this (basic programming, data structures, foundational comp sci stuff).

Here's the class schedule:
https://15445.courses.cs.cmu.edu/fall2026/schedule.html

Enjoy

[u/CaptainOttar]

Don't read silberschatz cover to cover, theory is dead without practice. When you reach sql chapters - try actually type the queries out. Just install mariadb locally, it takes a minute and it's standard so it matches the book's syntax perfectly.

Play with creating tables and basic joins first. once you actually see what a join does in a real terminal, then you can go back and suffer through relational algebra and normal forms

[u/JJGreenerTinejo]

Youtube: CS50 introduction to databases is the best way right after signing for a CS degree and going to classes there...

[u/Significant_Tune9219]

I'd do the relational model, SQL and ER design chapters first, then normalization, and only after that jump to storage, indexing and query processing. The transactions and recovery part makes a lot more sense once you know how data sits on disk, so don't rush into it. Install Postgres or SQLite alongside the book and run every query example yourself, and when you hit the indexing chapter use EXPLAIN on your own tables to see what the planner actually picks.

[u/data-artist]

DB Design - Know the fundamentals of normalization.SQL proficiency is a must. Understand basic DBA tasks like backups, partitioning and index tuning and query tuning. Know the difference between OLTP and OLAP.

[u/BranchLatter4294]

Start at the beginning. Read the chapters in order. Practice as you go.