Data Modelling and Database Design for Business Analysts (Udemy.com)
Learn Data Modelling and Database Design to become a successful Business Analyst
Created by: Dr Monjur Ahmed
Last updated December 2019
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.
How it compares
Against the other 371 rated Udemy courses in Data Analysis on CourseDuck:
- Rating4.1 out of 5higher than 8% of them
- Reviews135#317 of 372 by number of reviews
- Length2.1 hoursshorter than 79% of them
- Last updatedDecember 2019earlier than 90% of them
Course 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
Instructor Details
- 4.1 Rating
135 Reviews
Dr Monjur Ahmed
Monjur is an educator. He is a Lecturer with about 10 years of teaching experience. He has taught at Universities and other tertiary education institutes in the UK and APAC region. His PhD research was on Cloud Computing security. At postgraduate level, Monjur studied Communications Engineering and Telecommunications. His major at undergraduate level was Computing & Information Systems.
Monjur's area of expertise are Business Systems Analysis, Big Data and Business Intelligence, Cloud Computing, Computer and Information Security, Database Design and Development, and IT Project Management.
Monjur's approach to teaching is to keep it simple and straightforward. Using real life simple examples in teaching, he aims to establish the fact that nothing is complex; one super-complex entity is just an amalgamation of some super-simple things.
More Data Analysis courses
Complete neural signal processing and analysis: Zero to hero (2026)
4.8 (2,013 Reviews)
Provider: Udemy
Time: 46.9h
$12.99
Excel for Business Analysts Online Course (2023)
4.8 (636 Reviews)
Provider: Udemy
Time: 9.3h
$74.99
Alteryx Designer Advanced Certification Mega Bundle (2023)
4.8 (468 Reviews)
Provider: Udemy
Time: 16.9h
$69.99
Reviews
By Jinakumar on 2/18/2024
Yes I am data analyst and I need to look at the data model
By Matunin Miaffo Latala on 12/17/2022
it is just very easily assimmiliable. how can i have the handout so that i can follow you better while you are doing the explanation.
By Minh Quang Tran on 8/24/2021
To be fair, I believe that some of the information is delivered well and easy to understand. However, there are crucial points which cause distractions: 1. Voice and Volume: There are many sessions where I can barely hear what the instructor say. I even use a speaker but still, can't really hear anything. 2. Subtitles: As we are learning new technical knowledge and new terminologies, I wonder why the subtitle does not exist. This is extremely hard for students to grab new concepts, especially international students where English is not their first language. 3. Wasted Loop: During the lecture, there are long silences which can be reduced to reduce the length of the videos. For instance, such a 10-minute video can be reduced to 6 or 7 minutes. But this is mostly related to individual personality of each instructor, so it's hard to say.
By Steve Studley on 5/30/2020
Very good information. Reasonable presentation, good testing to reaffirm knowledge gained. Instructors version of language and delivery was off from mine, not anyone's fault but made it harder for me to follow.
By Brian K Durr on 5/15/2020
I like to have either the slides or transcript to build my personal learning tool. Don't see an option to make transcript available or to download the slides.
By Chiounan Chen on 3/12/2020
Thanks for the explanation of ER Diagram, it's a great help.
By Saurav Jain on 2/14/2020
Bieng new to RDBM and Data modelling, this course really helped me in building my foundation in this domain.
By Justin Pulley on 11/25/2019
There were a lot of pauses with silence and it was at times very distracting. The bonus topic also had quite a few click errors while trying to show how to use the dia tool.
By Jeff Stevens on 9/25/2019
Material is relevant. Instructor speaks too slow which takes too long to cover the material. Sessions one and two consumed 10 minutes, but could have taken 2 to 3 at the most.
By Kanishk Aditya on 8/17/2019
This is a good course. It took things right from the foundation and built up to more complex scenarios. Some aspects of the course could have been fleshed out more but that is more a function of a one sided conversation/lecture rather than a comment on the course itself. I am satisfied with this course structure and execution.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 82 / 100






