Coursera 笔记

Module 01 · Getting Started with SQL

Module Summary: Getting Started with SQL总结:基础 SQL

Coursera ↗

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

  • The Data Manipulation Language (DML) statements read and modify data. 
    数据操作语言(DML)语句用于读取和修改数据。
  • The search condition of the WHERE clause uses a predicate to refine the search.
    WHERE 子句的搜索条件使用谓词来细化搜索。
  • The SQL retrieves specific data from databases.
    SQL 从数据库中检索特定数据。
  • The COUNT, DISTINCT, and LIMIT are expressions used with SELECT statements. 
    COUNT、DISTINCT 和 LIMIT 是与 SELECT 语句一起使用的表达式。
  • The real-world applications of SELECT statements.
    SELECT 语句的实际应用。
  •  The INSERT, UPDATE, and DELETE are DML statements for populating and changing tables. 
    INSERT、UPDATE 和 DELETE 是用于填充和更改表的数据操作语言(DML)语句。