Course Highlights
  • Deploy basic data modeling skills and navigate modern storage options for a data warehouse.
  • Demonstrate data modeling skills within a real-world project environment.
Curriculum

28 Topics
Introduction to Advanced Data Modeling
How is data modeling used at Meta?
Overview of data modeling
Types of data models
Recap: Normalization of relational database models
Introduction to MySQL Workbench
Data management in MySQL Workbench
Database modeling in MySQL Workbench
Module summary: Data modeling and management
Course syllabus for Advanced Data Modeling
How to be successful in this course
Course requirements
Additional resources
Data model example
Exercise: Design a database model for this scenario
Solution: Design a database model for this scenario
Additional resources
Installing MySQL Workbench
MySQL Workbench for data modeling and data management
Exercise: Design a database model in MySQL Workbench
Solution: Design a database model in MySQL Workbench
Additional resources
Module Quiz: Data Modeling and Management
Knowledge Check: Database modeling
Self review: Design a database model for this scenario
Knowledge Check: MySQL Workbench (WB)
Self review: Design a database model in MySQL Workbench
What do you hope to learn?

17 Topics
Overview of data warehousing
Data warehouse architecture
Case Study: Real world data project
Fundamentals of dimensional data modeling
Dimensional data modeling in practice
Module summary: Data warehousing
The data warehouse Extract Transform and Load (ETL) process
ETL testing
Additional resources
OLAP cubes
Exercise: Create a dimensional data model
Solution: Create a dimensional data model
Additional resources
Module Quiz: Data Warehousing
Knowledge check: Data warehousing
Knowledge check: Dimensional data modeling fundamentals
Self review: Create a dimensional data model

19 Topics
Overview of data analytics
Data mining versus machine learning
Overview of data visualization
Using advanced analytic tools for data analysis
Data import and data preparation in Tableau
Data filtering and visualization in Tableau
Create an interactive dashboard
Module summary: Advanced data analytics
The value of data insights in business
Additional resources
Getting started with Tableau
Exercise: Data analysis in Tableau
Solution: Data analysis in Tableau
Additional resources
Module Quiz: Advanced Data Analytics
Knowledge check: Data analytics
Knowledge check: Advanced data anlytics in practice
Self review: Data analysis in Tableau
Which data analytics reports do you engage with weekly and why?

10 Topics
Course recap for Advanced Data Modeling
Congratulations you have completed Advanced Data Modeling
About the final project assessment
Exercise: Data modeling project
Solution: Data modeling project
Next steps after completing Advanced Data Modeling
Final Graded Quiz: Advanced Data Modeling
Data modeling project
What challenges did you encounter when modeling and analyzing your data?
Reflect on learning

  Write a Review

Advanced Data Modeling

Go to Free Course