Data Modelling and Database Design for Business Analysts

Learn Data Modelling and Database Design to become a successful Business Analyst

4.10 (127 reviews)
Udemy
platform
English
language
Other
category
instructor
Data Modelling and Database Design for Business Analysts
728
students
2 hours
content
Dec 2019
last update
$44.99
regular price

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.

Why take this course?

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

Screenshots

Data Modelling and Database Design for Business Analysts - Screenshot_01Data Modelling and Database Design for Business Analysts - Screenshot_02Data Modelling and Database Design for Business Analysts - Screenshot_03Data Modelling and Database Design for Business Analysts - Screenshot_04

Reviews

Matunin
December 18, 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.
Minh
August 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.
Vilnis
June 17, 2020
Extremely basic. Kinda data modeling and DB design for complete idiots. Expected much more. No way you "achieve two important skills required for a Business Analyst - Data Modelling and Database Design" as promised. Far less than required to develop a data model for real business with many fact tables. The 'real-life' example is childish and thus impractical unless you have Cornershop, but then again you hardly need all this stuff.
Steve
May 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.
Brian
May 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.
Shreya
March 31, 2020
The lectures were good but could have been more clear. Otherwise, it is a course worth the time and money.
Saurav
February 14, 2020
Bieng new to RDBM and Data modelling, this course really helped me in building my foundation in this domain.
Justin
November 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.
Jeff
September 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.
Kanishk
August 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.
Wendy
September 11, 2018
I was excited to take this course but was really bored. When I get bored, I stop paying attention. I've taken a lot of courses on Udemy and the one thing which keeps me coming back is...most of the instructors are excited about their topic. Their enthusiasm translates into presentation. It is what was missing from this course.

Charts

Price

Data Modelling and Database Design for Business Analysts - Price chart

Rating

Data Modelling and Database Design for Business Analysts - Ratings chart

Enrollment distribution

Data Modelling and Database Design for Business Analysts - Distribution chart

Related Topics

1641148
udemy ID
4/11/2018
course created date
11/20/2019
course indexed date
Bot
course submited by