We may earn an affiliate commission when you visit our partners.
Course image
Simon W. Wang

In the Data-Driven Systems: DBMS, SQL & Data Modeling course, you will gain an essential foundation in database theory and skills, exploring key concepts and architecture within a data-centric system context. You will acquire valuable knowledge and skills in managing, manipulating, and analyzing large datasets, with an emphasis on both relational and NoSQL databases.

Enroll now

What's inside

Syllabus

General Database Purpose
In Module 1, you will embark on a journey through the history and evolution of database systems, gaining valuable insights into the milestones that have shaped modern data management. Through critical analysis of historical contexts and past design strategies, you will develop a nuanced understanding of how database designs have progressed and occasionally faltered. We will evaluate the impact of these developments on current database practices and learn to apply this knowledge to assess and enhance database effectiveness.
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Explores advanced database techniques applying to advanced technologies
Teaches data management and analysis, which is essential for various industries
Suitable for learners interested in database theory and skills
Emphasizes both relational and NoSQL databases, which reflects industry trends
May require basic understanding of database concepts
Covers advanced database techniques, which may be overwhelming for beginners

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Solid database foundations for data professionals

According to students, this course provides a strong foundational understanding of database systems, making it highly relevant for aspiring data professionals. Learners frequently commend the clear and concise lectures and the instructor's ability to explain complex topics simply. The hands-on exercises, particularly in SQL, are often highlighted as a significant strength. While the course is lauded for its structured approach and real-world examples, some learners with prior experience suggest there could be more challenging practical problems. The MongoDB module is a timely addition, though a few older reviews indicate it might feel somewhat rushed or less integrated than the relational database content.
A timely introduction, yet some found it less comprehensive.
"The MongoDB section was a great bonus."
"The MongoDB section felt a bit rushed and could use more practical applications."
"The MongoDB module felt somewhat tacked on compared to the relational database content, which was much stronger."
Ideal for beginners, but advanced learners may seek more depth.
"A solid introduction. My only minor critique is that some parts could benefit from more challenging practical problems, especially for those with some prior experience."
"The theoretical parts are quite dense, and sometimes I felt the course moved a bit too fast. I had to supplement with external resources."
"It's a decent overview, but I wouldn't recommend it for advanced learners looking for deep dives."
Useful hands-on exercises, especially for SQL.
"I particularly enjoyed the hands-on exercises in SQL and MongoDB; they really solidified my learning."
"The hands-on coding and projects are the strongest part of the course for me."
"The SQL exercises were okay, but I would have liked more variety in the problem sets."
Lectures are concise and explain complex concepts effectively.
"The lectures were clear and concise, making complex topics like normalization easy to grasp."
"The instructor explained concepts very well."
"I appreciate the effort put into explaining complex topics simply."
Content is up-to-date and practical for career development.
"The course is highly relevant for anyone looking to start a career in data."
"The content is up-to-date and highly practical."
"The introduction to MongoDB was a timely addition, showing the course keeps pace with industry trends."
An excellent base in database theory and practical skills.
"This course provided an excellent foundational understanding of database systems, from theory to practical application."
"Highly recommend this course for anyone looking to build a strong foundation in data systems."
"As someone new to databases, this course was a lifesaver. I now feel confident in discussing DBMS concepts and writing basic SQL queries."
A few past reports of minor lab or forum response issues.
"The labs were sometimes buggy, and I spent more time troubleshooting than learning."
"I didn't feel very hands-on for a 'data-driven' course, expected more coding practice."
"The instructor's responses in the forum were slow, which was frustrating when stuck on assignments."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Data-Driven Systems: DBMS, SQL & Data Modeling with these activities:
Review Relational Database Concepts
Refresh your memory on relational database fundamentals to set a strong foundation for the course.
Browse courses on Relational Database
Show steps
  • Review concepts of tables, attributes, and relationships
  • Explore examples of relational database structures
Revisit Database Query Languages
Solidify your SQL skills to make it easier to follow SQL exercises.
Browse courses on SQL
Show steps
  • Review SQL syntax and commands
  • Practice writing queries using sample datasets
Organize Course Notes and Materials
Maximize your retention by keeping your notes and materials well-organized.
Show steps
  • Review lecture notes, slides, and readings
  • Summarize key concepts and add personal insights
  • Organize your notes into a logical structure
Four other activities
Expand to see all activities and additional details
Show all seven activities
Join a Database Study Group
Connect with peers to enhance your learning through discussions and collaborations.
Show steps
  • Find or create a study group with other students taking the course
  • Meet regularly to discuss course materials, share knowledge, and work on assignments together
Follow Tutorials on NoSQL Databases
Supplement course content with tutorials to deepen your understanding of NoSQL databases.
Browse courses on NoSQL
Show steps
  • Find video tutorials on MongoDB or other NoSQL databases
  • Follow along with the tutorials and take notes
  • Try out the examples and exercises provided in the tutorials
Solve Database Design Problems
Test your understanding of database design concepts through practice problems.
Browse courses on Database Design
Show steps
  • Find online resources or textbooks with database design problems
  • Attempt to solve the problems on your own
  • Check your solutions against provided answers or consult with peers
Design and Implement a Database Schema
Reinforce your learning by applying your knowledge to a practical database design project.
Browse courses on Database Design
Show steps
  • Identify a project or use case that requires a database
  • Use the concepts covered in the course to design a database schema
  • Implement the schema using a database management system
  • Test and refine your implementation

Career center

Learners who complete Data-Driven Systems: DBMS, SQL & Data Modeling will develop knowledge and skills that may be useful to these careers:

Reading list

We've selected 50 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Data-Driven Systems: DBMS, SQL & Data Modeling.
Classic work on database design theory. It covers topics such as relational algebra, normalization, and data integrity.
Created by the original architect of pandas, this masterwork teaches the canonical data structures and vectorized operations essential for slicing, cleaning, merging, and reshaping complex tabular datasets in Python.
Co-authored by Pramod Sadalage and Martin Fowler, this seminal taxonomy defines the four core NoSQL families—key-value, document, column-family, and graph—while introducing aggregate-oriented modeling, consistent hashing, and polyglot persistence.
Presents the modern tidyverse grammar for transforming messy data into structured insights. Covers tibbles, dplyr pipelines, tidyr pivoting, and purrr iterations for rapid exploratory data manipulation.
Unmatched in architectural rigor, Kleppmann compares LSM-trees against B-trees, leaderless Dynamo-style replication against consensus protocols, and document versus graph models so engineers understand the exact trade-offs behind NoSQL engines.
Demystifies relational data transformation through practical PostgreSQL projects. Teaches window functions, subqueries, regular expressions, and cross-tabulations required to manipulate data directly inside the database.
Collection of articles from SQL Server experts on the topic of performance tuning. It covers a wide range of topics, from query optimization to hardware tuning.
This foundational textbook widely used in university computer science programs. It provides a comprehensive overview of database systems, covering models, languages, and system design. It's excellent for gaining a broad understanding and is often used as a primary reference.
Delving into the storage engines and distributed protocols powering Apache Cassandra, RocksDB, and CouchDB, Petrov explains SSTables, Bloom filters, read repair, hinted handoff, and gossip dissemination.
Delivers a comprehensive, project-driven guide to wrangling messy timeseries, handling missing values, and restructuring dataframes with pandas. Emphasizes defensive coding and performance profiling for large analytical workloads.
Explores the mathematical and algorithmic techniques for transforming raw tabular data into predictive signals. Details numeric scaling, log transforms, categorical encoding, text vectorization, and automated feature extraction.
Essential for anyone looking to deepen their understanding of SQL performance and optimization. explains how databases execute queries and provides insights into writing efficient SQL code. It's highly recommended for developers and database administrators aiming to improve application performance.
Guides engineers through extracting, cleaning, and transforming irregular data from diverse formats including JSON, XML, PDF, and messy CSVs. Focuses on automation, error detection, and parsing web feeds reliably.
Designed specifically for developers transitioning from relational SQL schemas, this pragmatic guide walks through query-driven schema denormalization, key design, document embedding versus referencing, and graph traversal modeling.
Provides a beginner-friendly introduction to data modeling, covering fundamental concepts, techniques, and diagramming. It includes hands-on exercises and self-tests to reinforce learning, making it suitable for high school and undergraduate students, as well as those new to the field.
Provides a deep, foundational look into R core data objects, subscripting mechanics, factor conversions, string manipulation, and reshaping vectors. Offers timeless clarity on base R data processing paradigms.
Definitive work on the principles and techniques of transaction processing, a core concept in database systems and distributed computing. It is essential for understanding how to build reliable and consistent data systems.
Updated for MongoDB 7.0 in 2024, Aleksendrić and Borucki's guide explores time-series collections, compound shard keys, aggregation pipeline optimization, and vector search indexing for modern document workloads.
The first volume in a series, this book offers a collection of universal data models applicable across various industries. It's a practical guide providing pre-built patterns for common business concepts like parties, products, and orders. This is an excellent reference for data modelers at all levels, particularly useful for jump-starting modeling projects.
Provides a step-by-step guide to data modeling and database design. It covers all the essential concepts, such as entity-relationship modeling, normalization, and database design patterns.
Lays out a systematic workflow for profiling, assessing, and structuring untidy business data. Connects data preparation directly to downstream analytics, preventing upstream bias and data transformation bottlenecks.
This contemporary book focuses on the practical aspects of operating database systems in production, emphasizing reliability and resilience. It's highly relevant for working professionals and those interested in the operational side of databases.
Provides a comprehensive introduction to MongoDB, covering foundational concepts, querying, indexing, and administration. It's suitable for beginners and serves as a strong reference for developers and administrators. The 3rd edition is updated for MongoDB 4.2, making it relatively current and a valuable resource for gaining a broad understanding.
Delivers fast, battle-tested techniques for cleaning and pivoting irregular spreadsheet exports. Shows how to master Power Query, dynamic arrays, and nested lookups to clean corporate datasets with surgical speed.
Provides a detailed look inside the implementation of database systems, covering topics like storage engines, indexing, and concurrency control. It is excellent for deepening understanding of how databases function at a low level and is valuable for database professionals.
Covers the end-to-end process of designing, building, and managing data pipelines and analytical systems. It is highly relevant for aspiring and practicing data engineers, covering a wide range of contemporary data management tools and techniques.
Dives into common mistakes and suboptimal solutions in database design and SQL coding, explaining how to identify and correct them. It's crucial for deepening understanding and writing more robust and maintainable SQL. It's a valuable resource for developers and database professionals seeking to improve their practices.
Presents a proactive architectural framework for monitoring data pipelines and catching silent transformation bugs. Teaches automated anomaly detection, schema drift prevention, and lineage tracking for robust data operations.
Is dedicated to the MongoDB aggregation framework, a powerful tool for data analysis and transformation. It's highly relevant for users who need to perform complex data processing within MongoDB. The focus on optimization makes it particularly useful for developers and data analysts.
Focuses on using SQL specifically for data analysis, covering techniques beyond basic querying to transform and gain insights from data. It's suitable for those who have a foundational understanding of SQL and want to apply it in a data analysis context. It's relevant for data scientists and analysts.
Provides a practical guide to establishing and implementing data governance programs. It is crucial for understanding the organizational and process aspects of managing data effectively and valuable resource for data leaders and practitioners.
Offers a practical, step-by-step guide to relational database design, including data modeling principles. It's aimed at beginners and those without extensive technical backgrounds, making it suitable for high school or early undergraduate students and business professionals who need to understand database fundamentals.
Covering the world's most popular document database, this third edition details BSON schema design, compound indexing, the aggregation pipeline framework, multi-document ACID transactions, replica sets, and sharded clusters.
Exposes the most widespread and damaging traps in relational data manipulation and query construction. Illustrates how to avoid Cartesian explosion, improper NULL comparisons, and flawed table structures with cleaner SQL alternatives.
While focused on MySQL, this book provides in-depth coverage of database and SQL performance tuning that is applicable to other systems. It's essential for those working with large datasets and high-traffic applications. It's a comprehensive guide for optimizing SQL queries and database infrastructure.
Collects cautionary case studies from seasoned data practitioners detailing how hidden encoding bugs, missing fields, schema mismatches, and parsing failures occur, with concrete recipes for defensive data hygiene.
Tailored for aspiring data scientists, this book focuses on the SQL skills needed for data analysis, including dataset construction and manipulation. It bridges the gap between basic SQL and its application in data science workflows. Relevant for those entering or working in the data science field.
While focused on T-SQL (for Microsoft SQL Server), this book provides a deep and rigorous understanding of SQL fundamentals that are applicable to many dialects. It's highly regarded for its clear explanations and challenging examples, making it excellent for solidifying core concepts. It's often used by professionals working with SQL Server.
Explores reusable data model patterns for common business structures. It helps in applying data modeling rules in an enterprise context and provides high-level models for various business areas. This valuable resource for experienced modelers and professionals looking for proven solutions to recurring modeling challenges.
This is the Chinese version of the Data Modeling book, providing valuable content on designing MongoDB schemas for Chinese-speaking audiences. It covers the same essential concepts and patterns for effective data modeling in MongoDB.
Focuses on practical data engineering using modern technologies like Apache Spark and Delta Lake. It is highly relevant for professionals building data pipelines and managing data in cloud-based data lakes, addressing contemporary challenges in big data.
Introduces high-performance dataframe processing using Polars and Apache Arrow memory layout. Demonstrates lazy evaluation, query optimization, and multicore parallel execution for multiterabyte data manipulation in Python.
Explores advanced in-process analytical querying and columnar data manipulation using DuckDB. Teaches students how to construct complex analytical pipelines, process multiterabyte Parquet tables locally, and embed SQL transformations into Python.
Covers distributed data transformation patterns across large compute clusters using Apache Spark. Explains DataFrame and Dataset operations, resilient distributed transformations, and partitioning optimization.
Wide-column distributed stores excel at high-velocity write workloads across multiple data centers. Carpenter and Hewitt cover CQL data modeling, tunable consistency levels, compaction strategies, and cluster operations.
This guide provides practical advice and techniques for improving data quality, a fundamental aspect of effective data management. It valuable resource for anyone responsible for ensuring the accuracy and reliability of data.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Data-Driven Systems: DBMS, SQL & Data Modeling.
Data Wrangling with MongoDB
Most relevant
MongoDB: The Complete Guide to NoSQL Database Development
Most relevant
Implement Polyglot Persistence Using SQL and NoSQL...
Most relevant
MySQL, PostgreSQL and MongoDB Database Design Masterclass
Most relevant
The Ultimate MySQL Bootcamp: Go from SQL Beginner to...
Most relevant
Databases and SQL for Data Science with Python
Most relevant
MongoDB - The Complete Developer's Guide 2024
Most relevant
The Complete Developers Guide to MongoDB
Most relevant
【世界で70万人が受講】Web Developer Bootcamp 2023(日本語版)
Most relevant

Coursera Buyer Protection & Guarantee

Verified partner policies & purchase protections

Accredited University Partner
Free Trial & Audit

7-Day Free Trial & Free Audit

7-day free trial on monthly Coursera Plus subscriptions; free audit option available on most individual courses to explore video lectures and readings at no charge.

Return & Refund Policy

14-Day Refund Guarantee

14-day refund window on annual Coursera Plus subscriptions and single-course purchases prior to certificate issuance. Monthly subscriptions do not offer refunds once billed.

Buyer Protections

Verified Academic & Industry Partner

Accredited university and industry certifications (e.g. Stanford, Google, IBM, Yale), secure SSL payment processing, and verifiable digital certificate links.

Key Purchase Protections
14-day refund window on annual Coursera Plus and single courses
7-day free trial on monthly Coursera Plus subscriptions
Free course audit option for lectures and readings
Verified certificates from top universities & companies
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser