• No products in the cart.

5

10

ratings 

Data Modelling and Database Design for business analysts. About the course. Making a conceptual representation of data objects facilitates easy …

UDesign Membership
Course Access

Unlimited Duration

Students Enrolled

1725

Total Video Time

1 hour, 20 minutes

Posted by
Data Modelling and Database Design for business analysts. About the course. Making a conceptual representation of data objects facilitates easy storage in a database by organizing data elements in a standard way to show how they relate to one another and real-world entities. Mastering the act of manipulating data is a skill that every business analyst must hone, and that is what this course is all about. Prerequisite. Basic knowledge of data analysis is advisable. What does this course provide? This course goes through:
  •   An introduction to database, relational database, data modeling, and databasedesign.
  •   Primary key and Foreign key, and their application.
  •   Tracking changes made to data and objects using metadata.
  •   The relationship that exists between different entities using an entity-relationshipdiagram.
  •   Resolving conflicts that arise in a different relationship.
  •   Table normalization and dependency.
  •   Steps involved in designing a database.
Who is this course for? This course is meant for a business analyst or anyone with a basic knowledge of data analysis.
Profile Photo
Hoz map
5 5
29085

Students

About Instructor

Course Currilcum

  • Introduction 00:02:00
  • Course outline 00:05:00
  • What is Database 00:05:00
  • Relational database 00:08:00
  • Primary Key and Foreign Key 00:14:00
  • Meta Data 00:02:00
  • Entity Relationship Diagram 00:13:00
  • Resolving Many to Many Relationship 00:07:00
  • Design Database from ERD 00:05:00
  • Normalization and Dependency 00:17:00
  • Database Design Steps 00:02:00

Course Reviews

5

5
10 ratings
  • 5 stars10
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 5

    Amazing course!

  2. Vikrant MontroseMarch 22, 2021 at 5:45 pm

    5

    The lectures explain everything really clearly and in a logical order, and the visual presentation is fantastic. Super professional production!

  3. Shubh ReddihoughMarch 22, 2021 at 5:45 pm

    5

    Thank you.Enjoyed the course as always

  4. Addelyn FairbourneMarch 22, 2021 at 5:45 pm

    5

    This was a good course because prior to this course I did not fully have experience. I’ve learned a-lot. Thank you.

  5. Nathalie SherbornMarch 22, 2021 at 5:45 pm

    5

    Thanks,for the great course.

  6. Hadria RubertisMarch 22, 2021 at 5:44 pm

    5

    So far this has been very helpful! Very step by step discussions.

  7. 5

    Excellent Course!!! Step by step explanations and to round it off – amazing practice sets to reinforce learning.

  8. Loraine McVickerMarch 22, 2021 at 5:44 pm

    5

    Absolutely, been interested in this topic for the last 3 – 4 months

  9. 5

    So far Im enjoying the course

  10. Floriana AldersonJune 16, 2020 at 5:44 pm

    5

    The topics were delivered well and quite interesting but remember that this is only the first step in the endless journey

X