Database Management Systems

位教师：Connie Taylor

访问权限由 New York State Department of Labor 提供

4,004 人已注册

6个模块

深入了解一个主题并学习基础知识。

44 条评论

中级等级

需要一些相关经验

3 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

6个模块

深入了解一个主题并学习基础知识。

44 条评论

中级等级

需要一些相关经验

3 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

要了解的详细信息

作业

35 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有6个模块

This course introduces database concepts as related to the design of online data systems. This course will focus on the design and use of the MySQL relational database and Structured Query Language (SQL). Problems involving structuring, creating, maintaining, and accessing multi-user databases are presented and solutions developed. Comparisons of several commercially available database management systems are made including NoSQL systems.

Module 1 includes lectures on database design, database evolution, and the power of database management systems. After reading Chapter 1 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 1 Application and Module 1 Quiz (only 1 attempt each).

涵盖的内容

4个视频5篇阅读材料4个作业1个讨论话题

4个视频总计40分钟

Introduction to the Class 6分钟
Types of Databases and Database Design 12分钟
Database Evolution: An Origin Story 8分钟
The Power of Database Management Systems 14分钟

5篇阅读材料总计95分钟

Course Outline 10分钟
Overview of Course Learning Objectives 10分钟
Learner Support Resources 10分钟
Connecting Course Learning Objectives 5分钟
Read Chapter 1: Database Systems Textbook 60分钟

4个作业总计70分钟

Module 1 Application 30分钟
Module 1 Quiz: Introduction to Database Systems 10分钟
Module 1 Practice Exercises (Part 1) 15分钟
Module 1 Practice Exercises (Part 2) 15分钟

1个讨论话题总计10分钟

Introduction Discussion 10分钟

Module 2 includes lectures on data modeling, the evolution of data models, and data model abstraction. After setting up LucidChart, reading Chapters 2 and 9, and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 2 Application and Module 2 Quiz (only 1 attempt each).

涵盖的内容

3个视频4篇阅读材料5个作业

3个视频总计38分钟

Data Modeling Overview 11分钟
Evolution of Data Models 14分钟
Data Model Abstraction 13分钟

4篇阅读材料总计140分钟

Connecting Course Learning Objectives 5分钟
Read Chapter 2: Database Systems Textbook 60分钟
Read Chapter 9: Database Systems Textbook 60分钟
LucidChart Setup 15分钟

5个作业总计100分钟

Module 2 Application (Part 1) 30分钟
Module 2 Application (Part 2) 30分钟
Module 2 Quiz: Data Models and Database Design 10分钟
Module 2 Practice Exercises (Part 1) 15分钟
Module 2 Practice Exercises (Part 2) 15分钟

Module 3 includes lectures on relational database models, operators, data dictionary and system catalog, entities and relationships, and data redundancy. After reading Chapter 3 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 3 Application and Module 3 Quiz (only 1 attempt each).

涵盖的内容

6个视频2篇阅读材料5个作业

6个视频总计56分钟

Relational Database Model Overview 16分钟
Relational Database Model Operators 8分钟
Relational Database Join Operators 10分钟
Data Dictionary & System Catalog 4分钟
Entities & Relationships 8分钟
Data Redundancy 10分钟

2篇阅读材料总计65分钟

Connecting Course Learning Objectives 5分钟
Read Chapter 3: Database Systems Textbook 60分钟

5个作业总计85分钟

Module 3 Application 30分钟
Module 3 Quiz: The Relational Database Model 10分钟
Module 3 Practice Exercises (Part 1) 15分钟
Module 3 Practice Exercises (Part 2) 15分钟
Module 3 Practice Exercises (Part 3) 15分钟

Module 4 includes lectures on entity relationships, entity participation and degrees in relationships, developing an Entity Relationship (ER) diagram, and a Module Review. After reading Chapter 4 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 4 Applications (2 attempts each) and Module 4 Quiz (only 1 attempt).

涵盖的内容

5个视频2篇阅读材料9个作业

5个视频总计64分钟

Entity Relationship Overview 11分钟
Relationships Between Entities 10分钟
Entity Participation and Degrees in Relationships 10分钟
Developing an ER Diagram 19分钟
Module Review 14分钟

2篇阅读材料总计65分钟

Connecting Course Learning Objectives 5分钟
Read Chapter 4: Database Systems Textbook 60分钟

9个作业总计205分钟

Module 4 Application (Part 1) 30分钟
Module 4 Application (Part 2) 30分钟
Module 4 Application (Part 3) 30分钟
Module 4 Application (Part 4) 30分钟
Module 4 Application (Part 5) 30分钟
Module 4 Quiz: Entity Relationship Modeling 10分钟
Module 4 Practice Exercises (Part 1) 15分钟
Module 4 Practice Exercises (Part 2) 15分钟
Module 4 Practice Exercises (Part 3) 15分钟

Module 5 includes lectures on Extended Entity Relationship (EER) model constructions, good primary keys, flexible solutions, and a Module Review. After reading Chapter 5 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 5 Application and Module 5 Quiz (only 1 attempt each).

涵盖的内容

4个视频2篇阅读材料8个作业

4个视频总计37分钟

Extended Entity Relationship (EER) Model Constructs 14分钟
Good Primary Keys 9分钟
Flexible Solutions 9分钟
Module Review 5分钟

2篇阅读材料总计65分钟

Connecting Course Learning Objectives 5分钟
Chapter 5: Database Systems Textbook 60分钟

8个作业总计190分钟

Module 5 Application (Part 1) 30分钟
Module 5 Application (Part 2) 30分钟
Module 5 Application (Part 3) 30分钟
Module 5 Application (Part 4) 30分钟
Module 5 Application (Part 5) 30分钟
Module 5 Quiz: Advanced Modeling 10分钟
Module 5 Practice Exercises (Part 1) 15分钟
Module 5 Practice Exercises (Part 2) 15分钟

Module 6 includes lectures on normalization, normal forms and transformations, applying normalization roles to tables, denormalization, and ERD data-modeling checklists. After reading Chapter 6 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 6 Application and Module 6 Quiz (only 1 attempt each).