OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Course image
Coursera logo

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

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
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.

Good to know

Know what's good
, what to watch for
, 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

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
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 haven't picked any books for this reading list yet.

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to Data-Driven Systems: DBMS, SQL & Data Modeling.
Data Science: Capstone
Data Warehouse Concepts, Design, and Data Integration
Foundations: Data, Data, Everywhere
Foundations of Data Science
Warehousing Data with Oracle Autonomous Data Warehouse...
Data Lake Mastery: The Key to Big Data & Data Engineering
Data Security Champion: Secure Data Storage
Big Data Capstone Project
Building Your First Data Pipeline in Azure Data Factory
Course image
Effort
4 weeks of study, 2-3 hours/week
Via
Coursera
Institution
Northeastern University
Instructor
Simon W. Wang
Session
August 5, 2024 - September 9, 2024
Language
English
Good to know
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
Share and help others discover this course
Facebook LinkedIn X Reddit Link Email
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 - 2024 OpenCourser