Learn to design structured, efficient databases with real-world data modeling techniques.
Data modeling defines and applies structure to the information systems in an enterprise. Data stored in various relational databases needs data modeling to depict the relationship between entities in the databases. The models provide pictorial views of how the data flows across the enterprise, departments, or business areas. Before creating a database for any application, you need well-constructed data models to maintain the integrity of data and improve query performance. This course provides in-depth knowledge and hands-on practice in data modeling and design.
After introducing the basic concepts and principles, the course addresses data modeling techniques and practices in four modeling areas: conceptual, logical, physical and dimensional. The course first addresses the collection of user requirements, followed by design approaches for logical and physical models. You will study real-world examples of data models for transactional systems, data marts and enterprise data warehouses. Expert instructors will share their practical experiences.
This is a hands-on course using an industry-leading data modeling tool in class. By the end of the course, you will be able to create data models for enterprise applications.
This class is offered in an online synchronous format. Students are expected to log into this course via Canvas at the start time of scheduled meetings and participate via Zoom, for the duration of each scheduled class meeting.
To see all meeting dates, click "Full Schedule" below.
You will be granted access in Canvas to your course site and course materials approximately 24 hours prior to the published start date of the course.
Students will need access to a computer and the ability to install software. Open source data modeling software can be found at:
Recommended Text: Data Modeling Essentials, 3rd edition, Graeme Simsion and Gaham Witt, Morgan Kaufmann, ISBN-10: 0126445516, ISBN-13: 978-0126445510.
