Mastering Data Modeling Fundamentals (Udemy.com)
Entity-Relationship Techniques and Best Practices
Created by: Alan Simon
Produced in 2021
What you will learn
- Master the techniques needed to build data models for your organization.
- Apply key data modeling design principles through both classic entity-relationship notation and the crows foot notation.
- Build semantically accurate data models consisting of entities, attributes, relationships, hierarchies, and other modeling constructs.
- Convert conceptual data models to logical and physical data models through forward engineering.
Quality Score
Overall Score : 90 / 100
Course Description
During the course, youll put what you learn to work and define sample data model segments in both classic entity-relationship notation and also the crows foot notation to help emphasize the best practices and techniques covered in this course. Each section has either scenario based quiz questions or hands on assignments that emphasizes key learning objectives for that sections material. This way, you can be confident as you move through the course that youre picking up the key points about data modeling.
To build this course, I drew from more than 30 years of my own work involving data modeling and related disciplines. Long ago, in the late 1980s, I was a software engineer at what was then the worlds second largest computer systems vendor, Digital Equipment Corporation. I wrote software for a conceptual and logical database design tool - in other words, a data modeling tool. My own consulting firm, Thinking Helmet, Inc., specializes in data management and analytics-focused disciplines for which data modeling is essential. Ive rolled up my sleeves and personally tackled every aspect of what youll learn in this course. Ive even learned a few painful lessons, and have built a healthy share of lessons learned into the course material.
In this course, I take you from the fundamentals and concepts of data modeling all the way through a number of best practices and techniques that youll need to build data models in your organization. Youll find many examples that clearly demonstrate the key concepts and techniques covered throughout the course. By the end of the course, youll be all set to not only put these principles to work, but also to make the key data modeling and design decisions required by the art of data modeling that transcend the nuts-and-bolts techniques and design patterns.
Specifically, this course will cover:
Foundational data modeling concepts and fundamentalsThe symbiotic relationship between data modeling and database design (Hint: the two are not exactly the same!)Different modeling approaches, techniques, and notations that you can put to workThe fundamentals of entities, attributes, and relationships, as well as how to express these concepts in multiple modeling notationsHow we incorporate real-world complexities into our entities, attributes, and relationshipsThe data modeling lifecycle that includes forward engineering a conceptual data model to a logical and then a physical model, as well as how we reverse-engineer a physical data model back to the conceptual levelDifferent software-based approaches for data modeling toolsData modeling is both an art and a science. While we have developed a large body of best practices over the years, we still have to make this-or-that types of decisions throughout our data modeling work, often based on deep experience rather than specific rules. Thats what Ive instilled into this course: the fusion of data modeling art and science that you can bring to your organization and your own work. So come join me on this journey through the world of data modeling!
Who this course is for:
A business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data modeling, who desires to build a personal toolbox of data modeling best practices and techniques.
After completing this course, you will be ready to begin working on real-world data modeling projects, either with expanded responsibilities as part of an existing role or to find a new position involving data modeling. Example positions include database designer, conceptual data modeler, database engineer, and business analyst with an emphasis on data requirements.
Instructor Details
- 4.5 Rating
129 Reviews
Alan Simon
Alan Simon is a long-time authority on aligning transformational business process improvement initiatives with emerging data and analytics technology. He is the Managing Principal of Thinking Helmet, Inc., a boutique consultancy. In the past, Alan has led global and national consulting practices specializing in business intelligence and data warehousing. He is known for his engaging, innovative, and thought-provoking perspectives about the disciplines in which he specializes.
Alan is the author of 31 business and technology books, including the original edition of Data Warehousing For Dummies, 90 Days to the Data Mart, How to be a Successful Computer Consultant, and Data Warehousing and Business Intelligence for E-Commerce. His upcoming book The Business Hypothesis Imperative: Solving the Missing Link in Big Data, Analytics, and Data-Driven Insights is the culmination of more than 40 years as a technology professional working on the leading edge of data and analytics technologies.
Alan is a native of Pittsburgh and holds a Masters Degree in Management Information Systems from the University of Arizona and a Bachelors Degree in Computer Information Systems from Arizona State University. He also pursued post-graduate, non-degree study in artificial intelligence and medical information systems at the University of Denver. Alan has been at the forefront of applying emerging technologies and practices to a variety of busi
More courses by Alan Simon
More other courses
Unofficial Udemy Student Guide: Courses Free or Dirt Cheap (2019)
4.9 (312 Reviews)
Provider: Udemy
Time: 3.5h
$11.99
Professional Advanced Angelic Healing Practitioner Course (2021)
4.9 (310 Reviews)
- Provider: Udemy
- Time: 3h
$11.99
Professional Accredited Earth Angel Course (2021)
4.9 (301 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
Cours signe bb tout le vocabulaire autour du bb (2021)
4.9 (198 Reviews)
- Provider: Udemy
- Time: 1 hour on-demand videoh
$11.99
Reviews
- Video Duration:
3h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
