Data Modelling and Database Design for Business Analysts

Description

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

What You Will Learn!

• A stduent will achieve two important skills required for a Business Analyst - Data Modelling and Database Design. After completing this course, a student will be able to analyse business cases, develop Entity Relationship Diagram (ERD) and design Relational Database. However, this course is NOT about database development on any specific DBMS. A database design can be implemented using any available tool or DBMS (e.g. Oracle, SQL). Data Modelling and Database Design are independent of any specific tool.

Who Should Attend!

• Someone who wants to become a Business Analyst, or want to learn Data Modelling and Database Design.

TAKE THIS COURSE