Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Modelling and Database Design for Business Analysts
Rating: 4.1 out of 5(135 ratings)
767 students

Data Modelling and Database Design for Business Analysts

Learn Data Modelling and Database Design to become a successful Business Analyst
Created byDr Monjur Ahmed
Last updated 12/2019
English

What you'll 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.

Course content

1 section • 15 lectures • 2h 6m total length

  • Why take This Course?2:37
  • Course Outline5:25
  • What is Database?5:26
  • Test Your Knowledge: What is Database?
  • What is Relational Database?8:40
  • Test Your Knowledge: What is Relational Database?
  • Primary Key and Foreign Key14:21
  • Test Your Knowledge: Primary Key and Foreign Key
  • What is Meta Data?2:36
  • Test Your Knowledge: What is Meta Data?
  • Data Modelling using Entity Relationship Diagram (ERD): A Mini-Case Analysis13:22
  • Resolving Many-to-Many Relationship in ERD7:56
  • Test Your Knowledge: Resolving Many-to-Many Relationships in ERD
  • Designing a Database from ERD5:51
  • Test Your Knowledge: Designing a Database from ERD
  • Normalization, Dependency and Anomaly17:11
  • Test Your Knowledge: Normalization, Dependency and Anomaly
  • Database Design Steps2:18
  • Test Your Knowledge: Database Design Steps
  • Conclusions3:36
  • Analyze a Mini Case Study to Develop ERD & Database Design
  • Bonus Topic: Drawing ERD using a tool (Dia)14:11
  • Bonus Topic: Use Case Diagram10:28
  • Test Your Knowledge
  • Bonus Topic: Sharding in NoSQL12:06

    This lecture video explores the concept of sharding in database and in different types of NoSQL databases.

Requirements

  • Basic computer literacy

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

Who this course is for:

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

Report abuse