Data Modelling and Database Design for Business Analysts
Learn Data Modelling and Database Design to become a successful Business Analyst
Ratings 4.17 / 5.00
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.
Description
Overall Course Objective:
- Gain two essential skills to become a Business Analyst
- Data modelling
- Relational Database Design
Learning Outcomes (LOs):
- Understand Database and Relational Database
- Understand Data Modelling
- Learn to Develop Entity Relationship Diagram (ERD)
- Design Database
- Analyze real life business/organizations to model data requirement
Course Outline:
- Database and Relational Database
- Tables (database tables and its elements)
- Case Study Analysis (real life scenario analysis)
- Entity Relationship Diagram (ERD)
- Anomalies (Insert, Update, Delete)
- Dependency (Functional, Partial and Transitive)
- Normalization (UNF, 1NF, 2NF and 3NF)
- Database Development Steps
Who Should Attend!
- Someone who wants to become a Business Analyst, or want to learn Data Modelling and Database Design.
