When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Data Modelling and Database Design for Business Analysts
Learn Data Modelling and Database Design to become a successful Business Analyst
This Course Includes
udemy
4.4 (134 reviews )
2h 6m 
english
Online - Self Paced
professional certificate
Udemy
About Data Modelling and Database Design for Business Analysts
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..