Skip to content
UdemyData AnalysisPaid courseBeginner levelCertificate

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

icon
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

icon
Course 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

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.
   

icon
More Data Analysis courses

Free

$79.99

$12.99

$74.99

$69.99

Free

icon
Reviews

4.1

135 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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.

Showing all 10 reviews on CourseDuck

Read all 135 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 82 / 100