Advanced Data Modeling (Coursera)

Offered by Meta,
Advanced Data Modeling (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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

Course 7 of 9 in the Meta Database Engineer Professional Certificate.

What You Will Learn

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

Syllabus

WEEK 1
Data modeling and management
Get to grips with fundamental data modeling concepts, with a particular focus on a systematic database modeling process. Then learn to use MySQL Workbench to visually design, model, generate, and manage databases.

WEEK 2
Data warehousing
Learn about the role of data warehouses in database analytics, the characteristics of a data warehouse and data warehouse architecture. Develop familiarity with the dimensional data modeling approach for data warehousing.

WEEK 3
Advanced data analytics
Explore the role of advanced data analytics tools and evaluate how they're used to evaluate business performance.

WEEK 4
Model and analyze data
Apply data modeling to a real world project.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Data Engineering Capstone Project (Coursera) Coursera
IBM

Data Engineering Capstone Project (Coursera)

In this course you will apply a variety of data engineering skills and techniques you have learned as part of the previous courses in the IBM Data Engineering Professional Certificate. You will assume the role of a Junior Data Engineer who has recently joined the organization and be presented with a real-world use case that requires a data engineering solution.

Nov 16th 2026
5-12 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Nov 30th 2026
5-12 Weeks
MySQL for Data Analytics and Business Intelligence (Coursera) Coursera
Edureka

MySQL for Data Analytics and Business Intelligence (Coursera)

Embark on a thorough educational expedition through the "Fundamentals of Database Management with MySQL" module. This foundational program aims to impart a robust comprehension of MySQL, a prominent Relational Database Management System (RDBMS). Participants will delve into crucial concepts, ranging from the fundamentals of SQL to more advanced topics like data retrieval, relationships, business intelligence, and data visualization.

Nov 30th 2026
1 Week
Excel Skills for Business: Intermediate II (Coursera) Coursera
Macquarie University

Excel Skills for Business: Intermediate II (Coursera)

Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In this third course of our Excel specialization Excel Skills for Business you will delve deeper into some of the most powerful features Excel has to offer.

Nov 16th 2026
5-12 Weeks
Ethics of Technology (Coursera) Coursera
University of Notre Dame

Ethics of Technology (Coursera)

This course explores the ethical implications of data analytics. It connects old ideas – privacy, surveillance, power, justice, accountability, corporate responsibility, stakeholder theory – with new technologies and cases, such as the use of machine learning to predict crime. The course will prepare you to evaluate strategic arguments about the ethics of data analytics and to relate data analytics to ethical concepts so that you approach newer, ambiguous capabilities of technology and artificial intelligence with a critical eye.

Nov 16th 2026
4 Weeks
Social Media Data Analytics (Coursera) Coursera
University of Washington

Social Media Data Analytics (Coursera)

Learner Outcomes: After taking this course, you will be able to: utilize various Application Programming Interface (API) services to collect data from different social media sources such as YouTube, Twitter, and Flickr; process the collected data - primarily structured - using methods involving correlation, regression, and classification to derive insights about the sources and people who generated that data; analyze unstructured data - primarily textual comments - for sentiments expressed in them; use different tools for collecting, analyzing, and exploring social media data for research and development purposes.

Nov 16th 2026
4 Weeks
Spatial Data Science and Applications (Coursera) Coursera
Yonsei University

Spatial Data Science and Applications (Coursera)

Spatial (map) is considered as a core infrastructure of modern IT world, which is substantiated by business transactions of major IT companies such as Apple, Google, Microsoft, Amazon, Intel, and Uber, and even motor companies such as Audi, BMW, and Mercedes. Consequently, they are bound to hire more and more spatial data scientists. Based on such business trend, this course is designed to present a firm understanding of spatial data science to the learners, who would have a basic knowledge of data science and data analysis, and eventually to make their expertise differentiated from other nominal data scientists and data analysts.

Nov 30th 2026
5-12 Weeks
Database Engineer Capstone (Coursera) Coursera
Meta

Database Engineer Capstone (Coursera)

In this course you’ll complete a capstone project in which you’ll create a database and client for Little Lemon restaurant. To complete this course, you will need database engineering experience. The Capstone project enables you to demonstrate multiple skills from the Certificate by solving an authentic real-world problem. Each module includes a brief recap of, and links to, content that you have covered in previous courses in this program.

Nov 16th 2026
4 Weeks
Foundations of mining non-structured medical data (Coursera) Coursera
EIT Digital

Foundations of mining non-structured medical data (Coursera)

The goal of this course is to understand the foundations of Big Data and the data that is being generated in the health domain and how the use of technology would help to integrate and exploit all those data to extract meaningful information that can be later used in different sectors of the health domain from physicians to management, from patients to care givers, etc.

Nov 16th 2026
5-12 Weeks
Analíticas de Datos con Pandas (Coursera) Coursera
Tecnológico de Monterrey

Analíticas de Datos con Pandas (Coursera)

La analítica de datos ha avanzado considerablemente en los últimos años y ahora existen diversas herramientas que nos permiten realizar tareas o procesos que antes eran complicados de realizar. Gracias a su versatilidad, el lenguaje de programación Python posee una serie de librerías que permiten realizar proyectos de analítica de datos de una forma muy sencilla y una de las librerías más populares es Pandas.

Nov 16th 2026
4 Weeks
Calculus through Data & Modeling: Applying Differentiation (Coursera) Coursera
Johns Hopkins University

Calculus through Data & Modeling: Applying Differentiation (Coursera)

As rates of change, derivatives give us information about the shape of a graph. In this course, we will apply the derivative to find linear approximations for single-variable and multi-variable functions. This gives us a straightforward way to estimate functions that may be complicated or difficult to evaluate. We will also use the derivative to locate the maximum and minimum values of a function. These optimization techniques are important for all fields, including the natural sciences and data analysis. The topics in this course lend themselves to many real-world applications, such as machine learning, minimizing costs or maximizing profits.

Nov 16th 2026
5-12 Weeks