Data Modeling Course Online & Certification

Learn all the skills needed to design and manage database architecture through this database modeling course. Targeted at data architects, database developers, data engineers, business intelligence and systems analysts, this practical data modeling training teaches you how to create database designs based on business requirements directly in your hands. With this structured program, you will get familiar with three main levels of database modeling: conceptual level (business entity modeling), logical level (modeling attributes, keys, and normalization), and physical level (modeling database-specific data types, indexing, partitioning, etc.). You will learn OLTP database design following 3NF rules to eliminate redundancy and ensure data integrity. Also, OLAP database design will be covered by means of Ralph Kimball dimensional modeling (fact tables, dimension tables, slowly changing dimensions, and conformed dimensions). In addition, the modern data architecture models will be explored, including Data Vault 2.0 (hubs, links, and satellites), document database modeling in NoSQL databases (MongoDB), semi-structured modeling for JSON and JSONB, and graph database design.