Coursera 笔记

IBM/Introduction to Relational Databases (RDBMS)/PostgreSQL

Introduction to Relational Databases (RDBMS)

关系数据库（RDBMS）入门 · IBM · 63 篇

01Relational Database Concepts28

01Course Introduction课程介绍
02Course Overview课程概述
03Review of Data Fundamentals数据基础回顾
04Information and Data Models信息模型与数据模型
05ERDs and Types of Relationships实体关系图与关系类型
06Mapping Entities to Tables实体到表的映射
07Data Types数据类型
08Relational Model Concepts关系模型概念
09Hands-on Lab: Relational Model Concepts动手实验：关系模型概念
10Summary and Highlights总结与要点
11Summary and Highlights: Fundamental Relational Database Concepts总结与要点：基本关系数据库概念
12Practice Quiz: Fundamental Relational Database Concepts练习测验：基本关系数据库概念
13Graded Quiz: Fundamental Relational Database Concepts评分测验：基本关系数据库概念
14Database Architecture数据库架构
15Distributed Architecture and Clustered Databases分布式架构与集群数据库
16Database Usage Patterns数据库使用模式
17Introduction to Relational Database Offerings关系型数据库产品概览
18Db2IBM Db2 概览
19Db2IBM Db2 概览
20MySQLMySQL 数据库概览
21MySQLMySQL 数据库概览
22PostgreSQLPostgreSQL 数据库概览
23PostgreSQLPostgreSQL 数据库概览
24Reading: Deep Dive into Advanced Relational Model Concepts阅读：深入理解高级关系模型概念
25Reading: Advanced Relational Model Concepts阅读：高级关系模型概念
26Summary and Highlights: Introducing Relational Database Products总结与要点：关系型数据库产品介绍
27Practice Quiz: Introducing Relational Database Products练习测验：关系型数据库产品介绍
28Graded Quiz: Introducing Relational Database Products评分测验：关系型数据库产品介绍

02Using Relational Databases12

01Creating Tables创建数据库表
02Data Movement Utilities数据迁移工具
03Loading Data数据加载
04Hands-on Lab: Create Tables and Load Data in Datasette动手实验：在 Datasette 中建表与加载数据
05Summary and Highlights: Creating Tables and Loading Data总结与要点：建表与加载数据
06Database Objects and Hierarchy (Including Schemas)数据库对象与层级结构（含模式）
07Primary Keys and Foreign Keys主键与外键
08Overview of Indexes索引概述
09Normalization数据库规范化
10Relational Model Constraints - Advanced高级关系模型约束
11Hands-on Lab: Normalization, Keys, and Constraints in Relational Database动手实验：关系数据库的规范化、键与约束
12Summary and Highlights: Designing Keys, Indexes, and Constraints总结与要点：键、索引与约束设计

03MySQL and PostgreSQL15

01Getting Started with MySQLMySQL 入门
02Creating Databases and Tables in MySQL在 MySQL 中创建数据库与表
03Populating MySQL Databases and Tables填充 MySQL 数据库与表
04Hands-on Lab: Getting Started with MySQL Command Line动手实验：MySQL 命令行入门
05Hands-on Lab: Create Tables and Load Data in MySQL using phpMyAdmin动手实验：使用 phpMyAdmin 在 MySQL 中建表与加载数据
06Using Keys and Constraints in MySQL在 MySQL 中使用键与约束
07Hands-on Lab: Keys and Constraints in MySQL using phpMyAdmin动手实验：使用 phpMyAdmin 设置 MySQL 键与约束
08Summary and Highlights: MySQL总结与要点：MySQL
09Getting Started with PostgreSQLPostgreSQL 入门
10Creating Databases and Loading Data in PostgreSQLPostgreSQL 建库与数据加载
11Hands-on Lab: Getting Started with PostgreSQL Command Line动手实验：PostgreSQL 命令行入门
12Hands-on Lab: Create Tables and Load Data in PostgreSQL using pgAdmin动手实验：使用 pgAdmin 在 PostgreSQL 中建表与加载数据
13Views数据库视图
14Hands-on Lab: Views in PostgreSQL动手实验：PostgreSQL 视图
15Summary and Highlights: PostgreSQL总结与要点：PostgreSQL

04Final Project and Assessment8

01Approach to Database Design (Including ERD)数据库设计方法（含 ERD）
02Best Practices of RDBMS Design关系型数据库设计最佳实践
03Hands-on Lab: Database Design Using ERDs动手实验：使用 ER 图设计数据库
04Reading: Project Overview阅读：项目概述
05Project Submission and Peer Review项目提交与同行评审
06Final Project: Database Design and Implementation期末项目：数据库设计与实现
07Course Glossary: Introduction to Relational Databases (RDBMS)课程术语表：关系型数据库入门
08Congratulations and Next Steps结课祝贺与后续学习

Module 01 · Relational Database Concepts

PostgreSQLPostgreSQL 数据库概览

本篇为同一课时的重复导出，完整正文与表格见PostgreSQL 数据库概览。

← 上一篇PostgreSQLPostgreSQL 数据库概览下一篇 →Reading: Deep Dive into Advanced Relational Model Concepts阅读：深入理解高级关系模型概念

Coursera 笔记 · Noted by 千啾略 · As of 2026-09-14