Data Modelling and Database Design for Business Analysts

Data Modelling and Database Design for Business Analysts udemy course free download

Learn Data Modelling and Database Design to become a successful Business Analyst

Overall Course Objective:

• Gain two essential skills to become a Business Analyst
  1. Data modelling
  2. Relational Database Design

Learning Outcomes (LOs):

1. Understand Database and Relational Database
2. Understand Data Modelling
3. Learn to Develop Entity Relationship Diagram (ERD)
4. Design Database
5. Analyze real life business/organizations to model data requirement

Course Outline:

1. Database and Relational Database
2. Tables (database tables and its elements)
3. Case Study Analysis (real life scenario analysis)
4. Entity Relationship Diagram (ERD)
5. Anomalies (Insert, Update, Delete)
6. Dependency (Functional, Partial and Transitive)
7. Normalization (UNF, 1NF, 2NF and 3NF)
8. Database Development Steps