|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/database-design-postgresql
课程评论：没有评论
本课程名称为《数据库设计与PostgreSQL中的基础SQL》。在本课程中，您将学习数据库的历史设计以及在PostgreSQL环境中使用SQL的技巧。通过常见SQL命令（如INSERT INTO、WHERE、ORDER BY、ON DELETE CASCADE等），您将能够创建表、定义列类型和数据模式。 课程内容包括数据建模以及如何在PostgreSQL中表示一对多和多对多关系。学生将进行实践作业，创建表、插入数据、设计数据模型、构建关系结构以及在表中插入和查询关系数据。 课程大纲如下： 1. **SQL简介**：在第一周，您将了解本课程的目标，学习关于构建SQL标准的重要人物和组织，区分关系数据库与扁平文件，并利用psql和SQL命令在PostgreSQL数据库中创建、读取、更新和删除表。 2. **单表SQL**：本周，您将回顾并使用常见的psql命令，通过命令行创建数据库，并运用包括INSERT INTO、WHERE和ORDER BY在内的常见SQL命令。 3. **一对多数据模型**：本周重点在于关系数据库设计和一对多数据模型。您还将学习主键、逻辑键和外键在数据库中的功能，以及如何重新连接表中具有对应数据的行。 4. **多对多数据模型**：课程的最后一周专注于多对多数据模型。您将能够区分一对多和多对多关系，并学习规范化数据以及在多对多关联表中插入数据项。 通过本课程，您将系统掌握数据库设计的基础知识及其在PostgreSQL中的应用。
Name:Introduction to SQL
Description:In this first week, you will hear more about the goals of this course. You'll learn about the people and organizations instrumental to building the SQL standard, learn to differentiate between relational databases and flat files, and utilize psql and SQL commands to create, read, update, and delete tables in a PostgreSQL database.
Name:Single Table SQL
Description:This week, you'll learn to recall and utilize common psql commands, create a database using command line prompts, and utilize common SQL commands, including INSERT INTO, WHERE, and ORDER BY.
Name:One-To-Many Data Models
Description:This week focuses on relational database design and one-to-many data models. You'll also learn the functions of primary, logical, and foreign keys within a database, and how to reconnect rows with corresponding data in a table.
Name:Many-To-Many Data Models
Description:The final week in this course focuses on many-to-many data models. You'll soon be able to differentiate between one-to-many and many-to-many relationships, and as well as normalize and insert data items into a connected set of many-to-many tables.
In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Students will do hands-on assignments creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.
