Coursera 笔记

IBM

Introduction to Relational Databases (RDBMS)

关系数据库（RDBMS）入门

63 notes · 11 images · 45/55 条官方条目有笔记 · certified

Coursera ↗

Module 01

Relational Database Concepts

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

Using Relational Databases

12 / 20 篇
  1. 01Types of SQL Statements (DDL vs. DML)
  2. 02Creating Tables创建数据库表
  3. 03CREATE TABLE Statement
  4. 04ALTER, DROP, and Truncate Tables
  5. 05Data Movement Utilities数据迁移工具
  6. 06Loading Data数据加载
  7. 07Hands-on Lab: Create Tables and Load Data in Datasette动手实验：在 Datasette 中建表与加载数据
  8. 08Summary and Highlights: Creating Tables and Loading Data总结与要点：建表与加载数据
  9. 09Database Objects and Hierarchy (Including Schemas)数据库对象与层级结构（含模式）
  10. 10Primary Keys and Foreign Keys主键与外键
  11. 11Overview of Indexes索引概述
  12. 12Normalization数据库规范化
  13. 13Relational Model Constraints - Advanced高级关系模型约束
  14. 14Hands-on Lab: Normalization, Keys, and Constraints in Relational Database动手实验：关系数据库的规范化、键与约束
  15. 15Summary and Highlights: Designing Keys, Indexes, and Constraints总结与要点：键、索引与约束设计
  16. 16Reading: Overview of Optional Lesson
  17. 17Optional Lesson Overview
  18. 18Create Db2 Service Instance
  19. 19Create Tables and Load Data in Db2
  20. 20(Optional) Hands-on Lab: Normalization, Keys, and Constraints in Relational Databases (with Db2)
Module 03

MySQL and PostgreSQL

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

Final Project and Assessment

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