If you are a current or aspiring IT professional in search of sound, practical techniques to analyze and model data as part of the overall data management lifecycle, this is the course for you.
Let the in-depth focus on modeling in this course help you succeed in any organization that relies on data to drive decision making. You’ll learn the modeling process in data management, discover how to refine your existing skills for better performance, and gain confidence in leveraging skills across projects.This course covers the skills an IT professional needs to be proficient in data modeling for data management. Review the steps needed to carry out good database design including good database normalization. Understand the use of entity-relationship diagrams, subtype normalization, domain definition through conceptual schema, plus relational database modeling through UML modeling. Apply these concepts to real world scenarios using Microsoft SQL Server as your back end database.
During the course, you’ll put what you learn to work and define sample data model segments in both “classic” entity-relationship notation and also the “crow’s 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 emphasize key learning objectives for that section’s material. This way, you can be confident as you move through the course that you’re picking up the key points about data modelling.
-
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 “crow’s 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.