Monthly Subscription Starting at AED 99 + VAT

Advanced Data Modeling
  • Level Professional
  • Duration 18 hours
  • Course by Meta
  • Offered by

About

Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration. To take this course, you must have completed the previous Database courses. You must also be eager to continue your journey with coding. The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career—no degree or experience required to get started. By the end of this course, you’ll be able to: - Deploy basic data modeling skills and navigate modern storage options for a data warehouse - Apply planning and execution of ETL style database engineering by building upon existing MySQL skills - Develop a working knowledge of the different aspects of managing a database including administration of database operations and concerns, alongside processes and solutions for monitoring, reporting and debugging - Demonstrate data modeling skills within a real-world project environment You’ll gain experience with the following tools and software: - Workbench data modeling software - Syntaxes used to interact with a data warehouse - Extract, transform and loading (ETL) techniques and methods - MySQL data warehouse administration - Data warehouse monitoring and reporting tools - Database debugging and testing tools - Data modeling tools

Modules

Course Introduction

    • 2 Videos
    • 4 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • What do you hope to learn?

2 Videos

  • Introduction to Advanced Data Modeling
  • How is data modeling used at Meta?

4 Readings

  • Course syllabus for Advanced Data Modeling
  • How to be successful in this course
  • Course requirements
  • Additional resources

Database modeling

    • 3 Videos
    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge Check: Database modeling
  • Self review: Design a database model for this scenario

3 Videos

  • Overview of data modeling
  • Types of data models
  • Recap: Normalization of relational database models

4 Readings

  • Data model example
  • Exercise: Design a database model for this scenario
  • Solution: Design a database model for this scenario
  • Additional resources

MySQL Workbench (WB)

    • 4 Videos
    • 5 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge Check: MySQL Workbench (WB)
  • Self review: Design a database model in MySQL Workbench
  • Module Quiz: Data Modeling and Management

4 Videos

  • Introduction to MySQL Workbench
  • Data management in MySQL Workbench
  • Database modeling in MySQL Workbench
  • Module summary: Data modeling and management

5 Readings

  • 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

What is a data warehouse?

    • 3 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check: Data warehousing

3 Videos

  • Overview of data warehousing
  • Data warehouse architecture
  • Case Study: Real world data project

3 Readings

  • The data warehouse Extract, Transform and Load (ETL) process
  • ETL testing
  • Additional resources

Dimensional data modeling

    • 3 Videos
    • 4 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: Dimensional data modeling fundamentals
  • Self review: Create a dimensional data model
  • Module Quiz: Data Warehousing

3 Videos

  • Fundamentals of dimensional data modeling
  • Dimensional data modeling in practice
  • Module summary: Data warehousing

4 Readings

  • OLAP cubes
  • Exercise: Create a dimensional data model
  • Solution: Create a dimensional data model
  • Additional resources

Introduction to data analytics

    • 3 Videos
    • 2 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check: Data analytics

1 Discussions

  • Which data analytics reports do you engage with weekly, and why?

3 Videos

  • Overview of data analytics
  • Data mining versus machine learning
  • Overview of data visualization

2 Readings

  • The value of data insights in business
  • Additional resources

Advanced data analytics in practice

    • 5 Videos
    • 4 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: Advanced data anlytics in practice
  • Self review: Data analysis in Tableau
  • Module Quiz: Advanced Data Analytics

5 Videos

  • 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

4 Readings

  • Getting started with Tableau
  • Exercise: Data analysis in Tableau
  • Solution: Data analysis in Tableau
  • Additional resources

Final project assessment

    • 1 Videos
    • 3 Readings
    • 1 Discussion
    • 1 PeerReview
    • 1 Assignment
Show info about module content

1 Assignment

  • Final Graded Quiz: Advanced Data Modeling

1 Peer Review

  • Data modeling project

1 Discussions

  • What challenges did you encounter when modeling and analyzing your data?

1 Videos

  • Course recap for Advanced Data Modeling

3 Readings

  • About the final project assessment
  • Exercise: Data modeling project
  • Solution: Data modeling project

Course wrap-up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Congratulations, you have completed Advanced Data Modeling

1 Readings

  • Next steps after completing Advanced Data Modeling

Auto Summary

"Advanced Data Modeling" focuses on advanced database concepts including modeling, automation, and optimization. Ideal for IT & Computer Science enthusiasts, the course is led by expert instructors on Coursera. Over 1080 hours, learners will master MySQL, ETL techniques, and database administration. Subscription options include Starter and Professional, making it accessible to all aspiring professionals seeking high-growth careers.

Taught by Meta Staff
Instructor

Taught by Meta Staff