Data-Driven Systems

DBMS, SQL & Data Modeling

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

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Three deals to help you save

We found three deals and offers that may be relevant to this course.

Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid until December 12

Annual Subscription Savings

Unlock programs from Google, Microsoft, and IBM and join 77% of learners who reported positive career outcomes.

Only $239!

Valid for a limited time only

Future-proof your career

Access O'Reilly books, live events, courses, and more. Save with an annual subscription.

Take

15%

off

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.

Entity-Relationship Modeling

In Module 2, you will explore the intricacies of database modeling, learning to articulate and refine models using established and emerging methodologies. This module aims to equip you with a solid understanding of fundamental modeling concepts, the skills to use UML and Crow’s Foot notations effectively, and the ability to perform and critically analyze Entity Relationship Models. By exploring the principles and components of various data models, you will enhance your ability to develop robust database structures tailored to specific requirements.

Foundations of Database Design

In Module 3 you will explore the crucial phases of the database development life cycle, delving deep into the theory and practice of database normalization. This section is designed to enhance your proficiency in developing streamlined and efficient database structures, aligning with industry best practices. Through a comprehensive survey and analysis, you will gain insights into how databases fit within software architectures and the importance of each development stage.

Advanced Database Techniques

In Module 4 you will focus on advanced database techniques, with a special emphasis on MongoDB. You will learn about the critical role of normalization in optimizing database design for performance and scalability. Additionally, this part will cover advanced concepts such as document-oriented databases, indexing strategies, and performance tuning, providing you with the skills to implement and manage robust database solutions using MongoDB.

Save this course

Save Data-Driven Systems: DBMS, SQL & Data Modeling to your list so you can find it easily later:

Save

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

Show steps

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

Show steps

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

Show steps

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

Show steps

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

Show steps

Supplement course content with tutorials to deepen your understanding of NoSQL databases.

Browse courses on NoSQL

Show steps