Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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)
768 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

    Explore how data modeling captures business data requirements and guides database design, highlighting why this course emphasizes good design to ensure accurate, integrated systems and reduce costs.

  • Course Outline5:25

    Explore the learning outcomes and course outline for data modelling and relational database design. Learn to model data, develop entity relationship diagrams, and apply normalization to design databases for organizations.

  • What is Database?5:26
  • Test Your Knowledge: What is Database?
  • What is Relational Database?8:40

    Learn what a relational database is, how tables relate to form a single database, and how linking tables eliminates duplication while enabling cross-table queries.

  • Test Your Knowledge: What is Relational Database?
  • Primary Key and Foreign Key14:21

    Explore how primary keys uniquely identify records and how foreign keys connect related tables in a relational database, using student and transaction IDs.

  • 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

    Explore data modeling with entity relationship diagrams (ERD) to identify entities like customer, employee, and order, and model one-to-one, one-to-many, and many-to-many relationships with optionality.

  • Resolving Many-to-Many Relationship in ERD7:56

    Learn how to resolve many-to-many relationships in an ERD by introducing an extra entity, such as food order, and using a composite primary key of the two parent keys.

  • Test Your Knowledge: Resolving Many-to-Many Relationships in ERD
  • Designing a Database from ERD5:51

    Design a database from an entity relationship diagram by identifying primary keys, foreign keys, and composite keys; convert entities to tables and resolve many-to-many relationships with a food order table.

  • Test Your Knowledge: Designing a Database from ERD
  • Normalization, Dependency and Anomaly17:11

    Explore normalization, functional, partial, and transitive dependencies, and learn to eliminate anomalies using 1st to 3rd normal forms, foreign keys, and join tables.

  • Test Your Knowledge: Normalization, Dependency and Anomaly
  • Database Design Steps2:18
  • Test Your Knowledge: Database Design Steps
  • Conclusions3:36

    Learn data modeling with entity relationship diagrams and derive a relational database design from real-life cases, while distinguishing database design from development and recognizing DBMS-agnostic implementation.

  • Analyze a Mini Case Study to Develop ERD & Database Design
  • Bonus Topic: Drawing ERD using a tool (Dia)14:11

    Learn to draw an entity-relationship diagram using the Dia tool, create entities, define primary keys, add attributes, and establish relationships with appropriate notation.

  • Bonus Topic: Use Case Diagram10:28

    Illustrate the big picture of a system with use case diagrams, highlighting actors such as customer and mechanic and the sequence from appointment booking to inspection, report, and payment.

  • 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