Course Overview课程概述

Welcome to the introductory course on Relational Databases. This course is part of the IBM Data Engineering Professional Certificate designed to prepare you for a career as a Junior Data Engineer.
欢迎来到关系数据库入门课程。本课程是 IBM 数据工程专业证书的一部分，旨在帮助您为成为一名初级数据工程师做好准备。

Every good relational database solution begins with a solid design and implementation strategy. A well-designed relational database ensures that the users and applications that depend on the data will know that it is:
每一个好的关系数据库解决方案都始于扎实的设计和实施策略。一个设计良好的关系数据库可确保依赖数据的用户和应用程序知道数据是：

• Accurate. Can you rely on the accuracy of the data as new information is added or it is modified?
  准确的。当添加新信息或修改信息时，您能依赖数据的准确性吗？
• Easy to access. Is the data organized to make it fast, easy, and predictable to query and maintain?
  易于访问。数据是否组织得当，以便快速、轻松、可预测地查询和维护？
• Reliable. Can your database design ensure data integrity and maintain consistent and reliable data?
  可靠性。您的数据库设计能否确保数据完整性并保持数据的一致性和可靠性？
• Flexible. Can you update or expand on the design to meet future data requirements?
  灵活性。您能否更新或扩展设计以满足未来的数据需求？

In this course, you will learn some basic relational database concepts and learn to think about data in terms of relationships and how information can be best organized to produce the results you want to achieve. You will also learn about different deployment topologies options and the tradeoffs that impact your design decisions. You will then move onto relational database design, creating an Entity Relationship Diagram for a specific use case that serves as the blueprint for the implementation of your database. You will also learn about the role of relational model constraints in ensuring that your data maintains its integrity and achieves a level of performance that meets the needs of the users of the data.
在本课程中，您将学习一些基本的关联式数据库概念，并学习如何从关系的角度思考数据，以及如何最好地组织信息以产生您想要实现的结果。您还将了解不同的部署拓扑选项以及影响您设计决策的权衡。然后，您将进入关联式数据库设计，为特定用例创建实体关系图，作为数据库实现的蓝图。您还将了解关联模型约束在确保数据完整性和达到满足数据用户需求的性能水平方面的作用。

With a solid plan, you will then learn how to use SQL statements and several Relational Database Management Systems (RDBMS) tools to transform a relational database design into a physical database and its objects, such as tables, keys, indexes, and constraints.
有了坚实的计划，您将学习如何使用 SQL 语句和几种关联式数据库管理系统 (RDBMS) 工具将关联式数据库设计转换为物理数据库及其对象，例如表、键、索引和约束。

You will build hands-on experience by developing an Entity Relationship Diagram to map out the data model of a relational database, applying techniques that help improve the integrity of your data and the performance of your queries.
您将通过开发实体关系图来绘制关系数据库的数据模型，从而获得实践经验，并应用有助于提高数据完整性和查询性能的技术。

You will also learn the fundamentals of Db2, explore how to manipulate data within tables and implement the design in IBM Db2 on Cloud through a series of optional hands-on labs.
您还将学习 Db2 的基础知识，探索如何在表中操作数据，并通过一系列可选的动手实验在 IBM Db2 on Cloud 中实现设计。

Course Content  课程内容

This course is divided into four modules. It is recommended that you complete one module per week or at a pace that suits you - whether it's a few hours every day or completing the entire course over a weekend or even in one day.
本课程分为四个模块。建议您每周完成一个模块，或者按照适合您的进度进行——无论是每天学习几个小时，还是在一个周末甚至一天内完成整个课程。

Introduction to Relational Databases (RDBMS) 关系型数据库（RDBMS）简介

Module 1: Relational Database Concepts
模块 1：关系数据库概念

• Lesson: Fundamental Relational Database Concepts
  课程：关系数据库基本概念
• Lesson: Introducing Relational Database Products
  课程：关系数据库产品介绍
• Lesson: Module 1 Summary and Assessment
  课程：模块 1 总结与评估

Module 2: Using Relational Databases
模块 2：使用关系型数据库

• Lesson: Creating Tables and Loading Data
  课程：创建表和加载数据
• Lesson: Designing Keys, Indexes, and Constraints
  课程：设计键、索引和约束
• Lesson: Module 2 Summary and Assessment
  课程：模块 2 总结与评估
• Lesson: (Optional) Db2 Labs
  课程：(可选) Db2 实验

Module 3: MySQL and PostgreSQL
模块 3：MySQL 和 PostgreSQL

• Lesson: MySQL  课程：MySQL
• Lesson: PostgreSQL  课程：PostgreSQL
• Lesson: Module 3 Summary and Assessment
  课程：模块 3 总结与评估

Module 4: Final Project and Assessment
模块 4：最终项目与评估

• Lesson: ERDs and Final Project
  课程：ERD 与最终项目
• Lesson: Glossary and Final Assessment
  课程：词汇表与最终评估
• Lesson: Course Wrap-up  课程：课程总结

Watch the videos, work through the labs, and add to your portfolio. Good luck!
观看视频，完成实验，并将其添加到您的作品集中。祝您好运！