Database design is the process of producing a detailed data model of a database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design. Through this tutorial we will try to teach the basis components of database design and explains how to make a good database design.
Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!
Contents of this courseÂ
- Introduction and Database OverviewÂ
- Understanding SQL Types of commandsÂ
- Tables, Views and Stored ProceduresÂ
- Database constraintsÂ
- Database NormalizationÂ
- ER DiagramÂ
- Relational Database Management SystemÂ
- NoSQLÂ
- RDBMS vs. NoSQLÂ
