Coursera 笔记

Module 02 · Introduction to Relational Databases and Tables

Summary: Relational Database Concepts and Tables总结:关系数据库概念与数据表

Coursera ↗

Congratulations! You have completed this lesson. At this point in the course, you know:  
恭喜!您已完成本课程。此时,您已经知道:

  • A database is a repository of data that provides functionality for adding, modifying, and querying the data.  
    数据库是存储数据并提供添加、修改和查询数据功能的仓库。
  • SQL is a language used to query or retrieve data from a relational database.  
    SQL 是一种用于查询或从关系数据库中检索数据的语言。
  • The Relational Model is the most used data model for databases because it allows for data independence.  
    关系模型是数据库最常用的数据模型,因为它允许数据独立性。
  • The primary key of a relational table uniquely identifies each tuple or row, preventing duplication of data and providing a way of defining relationships between tables.  
    关系表的主键唯一标识每个元组或行,防止数据重复,并提供定义表之间关系的方法。
  • SQL statements fall into two different categories: Data Definition Language (DDL) statements and Data Manipulation Language (DML) statements. 
    SQL 语句分为两类:数据定义语言(DDL)语句和数据操作语言(DML)语句。