Coursera 笔记

Module 06 · Bonus Module: Advanced SQL for Data Engineers

Summary: Views, Stored Procedures, and Transactions总结:视图、存储过程和事务

Coursera ↗

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

  • Views are a dynamic mechanism for presenting data from one or more tables.
    视图是一种动态机制,用于从一个或多个表中呈现数据。
  • A transaction represents a complete unit of work, which can be one or more SQL statements.
    事务代表一个完整的工作单元,可以是一个或多个 SQL 语句。
  • An ACID transaction is one where all the SQL statements must complete successfully, or none at all.
    一个 ACID 事务是指所有 SQL 语句必须全部成功完成,或者全部不完成的事务。
  • A stored procedure is a set of SQL statements that are stored and executed on the database server, allowing you to send one statement as an alternative to sending multiple statements.
    存储过程是一组存储在数据库服务器上并执行的 SQL 语句,允许您发送一个语句作为发送多个语句的替代方案。
  • You can write stored procedures in many different languages like SQL PL, PL/SQL, Java, and C.
    您可以使用 SQL PL、PL/SQL、Java 和 C 等多种语言编写存储过程。