Module 02 · Introduction to Relational Databases and Tables
Summary: Relational Database Concepts and Tables总结:关系数据库概念与数据表
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)语句。