Stage 5 of 9 · 8 lessons · ~3 weeks
Schema design
Turn requirements into tables: model entities and relationships, choose keys and data types for your database, normalise to third normal form, add constraints and know when to denormalise.
7 more stages, 51 more topics, free with an account.
You have seen the open stages of the SQL and databases roadmap. Every topic it covers is listed above, and an account opens the rest: what each topic means, a question to check yourself, the courses, the practice and Tauseef's advice for every stage. Early access is open: sign up and your account is active shortly after.
Everything here is free to learn from. A few things, like adding a roadmap, keeping a cheat sheet or asking Tauseef a question, use credits. You get 15 when you join, your first roadmap is free, and if you are learning seriously and run out, you can ask for more. Credits only make sure the platform goes to people who are actually learning.