Data Modelling and Database Design for Business Analysts

Name: Data Modelling and Database Design for Business Analysts
Rating: 4.1 (135 reviews)

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
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
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
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):

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 this course is for:

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