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

Accounting Data Analytics with Python (Coursera) Coursera
University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Sep 14th 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.

Sep 7th 2026
5-12 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.

Sep 7th 2026
5-12 Weeks
Getting Started with Data Analytics on AWS (Coursera) Coursera
AWS

Getting Started with Data Analytics on AWS (Coursera)

With the explosion of data collection enabled by the internet, mobile applications and transformation into the cloud, effective data analytics is turning into a critical tool in practically every domain – from academia to enterprise. In this course, learners will get an introduction to the different types of data analytics (descriptive, diagnostic, predictive and prescriptive) and dive into the basics of descriptive data analysis using data and tools in the AWS Cloud.

Sep 21st 2026
1 Week
Snowflake - SnowPro Core Certification Preparation (Coursera) Coursera
Board Infinity

Snowflake - SnowPro Core Certification Preparation (Coursera)

"Snowflake - SnowPro Core Certification Preparation" is a comprehensive course meticulously crafted to guide learners through the essentials of Snowflake, preparing them for the SnowPro Core Certification. Spanning three modules, the course begins with the fundamentals of Snowflake, exploring its architecture, data loading, and modeling. The second module delves into operational and management aspects, including account management, performance optimization, and security.

Sep 14th 2026
3 Weeks
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.

Sep 7th 2026
5-12 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.

Sep 7th 2026
5-12 Weeks
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.

Sep 7th 2026
5-12 Weeks
Hands-on with AWS for IT Professionals (Coursera) Coursera
AWS

Hands-on with AWS for IT Professionals (Coursera)

This course gets hands-on by teaching how to create a new AWS Account, create an Administrative User, and explore the AWS Free Tier. Students can then follow demonstration and explainer videos containing on how AWS Services can combine to create solutions that can be useful in real-life scenarios. The scenarios are grouped into three major categories: Data, Operations, and Architecture.

Sep 7th 2026
2 Weeks
Foundations of Data Science (Coursera) Coursera
Google

Foundations of Data Science (Coursera)

This is the first of seven courses in the Google Advanced Data Analytics Certificate, which will help develop the skills needed to apply for more advanced data professional roles, such as an entry-level data scientist or advanced-level data analyst. Data professionals analyze data to help businesses make better decisions. To do this, they use powerful techniques like data storytelling, statistics, and machine learning. In this course, you’ll begin your learning journey by exploring the role of data professionals in the workplace. You’ll also learn about the project workflow PACE (Plan, Analyze, Construct, Execute) and how it can help you organize data projects.

Sep 7th 2026
5-12 Weeks
Data Ingestion, Exploration & Visualization in Qlik Sense (Coursera) Coursera
Coursera Instructor Network

Data Ingestion, Exploration & Visualization in Qlik Sense (Coursera)

This course is an intermediate-level course designed for learners who want to continue their data visualization journey with Qlik Sense, a powerful sophisticated Business Intelligence tool. Data preparation and ingestion is a key prerequisite for data visualization, and this course not only dives deep into that concept, but other important intermediate topics such as filters, expressions, and personalization.

Sep 14th 2026
1 Week