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.
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.
涵盖的内容
4个视频19篇阅读材料4个作业1个讨论话题
显示有关单元内容的信息
4个视频•总计12分钟
Course Introduction•1分钟
Meet Your Faculty•2分钟
Database System History•5分钟
Relational Database vs. NoSQL Database•5分钟
19篇阅读材料•总计177分钟
Course Overview•1分钟
Syllabus - Data-Driven Systems: DBMS, SQL & Data Modeling•10分钟
Academic Integrity•1分钟
Introduction for Video: "Database System History"•2分钟
The Evolution of Databases•10分钟
Data Catergories•4分钟
Data Types and Uses•4分钟
Data Models and Their Use Cases•5分钟
Today's Database Landscape•23分钟
Lucidchart•45分钟
Sharding vs. Replication •3分钟
Introduction for Video: “Relational Database vs. NoSQL Database”•2分钟
Relational Databases•28分钟
Key Takeaways: Relational Data Model•2分钟
What is NoSQL?•18分钟
Comparing Relational Model and NoSQL•4分钟
Data Universal Framework Comparison•6分钟
Case Study: Designing a Scalable Payment Processing System•8分钟
Module 1 Summary•1分钟
4个作业•总计21分钟
Databases •5分钟
Check Your Knowledge: Database History•6分钟
Check Your Knowledge: Relational Databases•5分钟
Check Your Knowledge: Relational Database vs. NoSQL Database•5分钟
1个讨论话题•总计10分钟
Meet Your Fellow Learners•10分钟
Entity-Relationship Modeling
第 2 单元•小时 后完成
单元详情
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.
涵盖的内容
2个视频15篇阅读材料6个作业
显示有关单元内容的信息
2个视频•总计4分钟
Data Modeling•2分钟
Entity Relationship Diagram (ERD)•2分钟
15篇阅读材料•总计124分钟
Entity-Relationship Modeling•17分钟
Types of Keys and Data Integrity•10分钟
Crow’s Foot Notation•10分钟
Strong Entity vs. Weak Entity•5分钟
Identifying vs. Non-Identifying Relationships•10分钟
ERD Example•10分钟
Unified Modeling Language (UML) Notation•7分钟
Multiplicity•3分钟
Mission Statement and Objectives•6分钟
Modeling Comparison Between Relational and Document Databases•10分钟
Create ERD for Document Database•5分钟
Popular NoSQL Databases•20分钟
Enhanced Entity-Relationship Modeling•5分钟
Video: Enhanced Entity-Relationship Modeling•5分钟
Module 2 Summary•1分钟
6个作业•总计33分钟
Entity-Relationship Modeling•6分钟
ERD Quiz•5分钟
Check Your Knowledge: Data Modeling•6分钟
Check Your Knowledge: Entity Relationship Diagrams (ERD)•6分钟
Check Your Knowledge: Crow’s Foot Notation•4分钟
Check Your Knowledge: Enhanced Entity-Relationship Modeling•6分钟
Foundations of Database Design
第 3 单元•小时 后完成
单元详情
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.
涵盖的内容
1个视频11篇阅读材料2个作业1个讨论话题
显示有关单元内容的信息
1个视频•总计2分钟
“Database Development Lifecycle”•2分钟
11篇阅读材料•总计95分钟
Introduction to Video: “Database Development Lifecycle”•2分钟
Database and Software Development Life Cycles•16分钟
Stages of Database Design•5分钟
Two Major Approaches to Database Design•3分钟
CASE Tools•5分钟
Best Practices for Database Design•5分钟
Document Databases Design–Embedding vs. Referencing•5分钟
Design Comparison: Relational vs. NoSQL Databases•5分钟
Methodology: Conceptual Database Design•33分钟
Methodology: Logical Database Design for Relational Model•15分钟
Module 3 Summary•1分钟
2个作业•总计11分钟
Database and Software Development Life Cycles•5分钟
Check Your Knowledge: Database Development Life Cycle•6分钟
1个讨论话题•总计30分钟
Exploring Database Relevance in Applications•30分钟
Advanced Database Techniques
第 4 单元•小时 后完成
单元详情
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.
涵盖的内容
1个视频12篇阅读材料2个作业
显示有关单元内容的信息
1个视频•总计2分钟
How Does a Database Fit in the Overall Software Development Project?•2分钟
12篇阅读材料•总计108分钟
Normalization•10分钟
Understanding Database Normalization•32分钟
Attributes•5分钟
Getting Started with MongoDB Atlas Database •10分钟
MongoDB Normalization•4分钟
MongoDB Design–Denormalization•5分钟
Common Ways to Query MongoDB Data•7分钟
Syntax Rules for MongoDB•18分钟
MongoDB Calculating Averages and Totals•10分钟
Object Database Normalization•5分钟
Module 4 Summary•1分钟
Congratulations•1分钟
2个作业•总计11分钟
MongoDB•5分钟
Check Your Knowledge: Database and Software Development Project•6分钟
Founded in 1898, Northeastern is a global research university with a distinctive, experience-driven approach to education and discovery. The university is a leader in experiential learning, powered by the world’s most far-reaching cooperative education program. The spirit of collaboration guides a use-inspired research enterprise focused on solving global challenges in health, security, and sustainability.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.