Module 06 · Bonus Module: Advanced SQL for Data Engineers
Summary: Views, Stored Procedures, and Transactions总结:视图、存储过程和事务
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 等多种语言编写存储过程。