|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-fast-track-temp-tables-and-table-variables/
课程评论：没有评论
Coursera 课程总结：SQL Server FAST TRACK - 临时表和表变量 本课程深入讲解了 SQL Server 中临时表（Temp Tables）和表变量（Table Variables）的编程应用。课程假定学习者具备基本的数据库概念和架构知识，并直接切入核心主题。临时表和表变量能够解决开发中许多棘手的挑战，因此掌握它们至关重要。 课程内容涵盖： **临时表 (TEMP TABLES)** * 临时表及其与 TempDB 数据库的关系 * 临时表的持久性（Persistence） * 存储过程中的持久性 * Transact-SQL (TSQL) 与存储过程的持久性比较 * 命令行 TSQL 示例 * IDENTITY 列的用法 * 存储过程的用法 * 命令行 TSQL 与存储过程的比较 * 临时表与真实表（Real Tables）的对比 **表变量 (TABLE VARIABLES)** * 表变量的非持久性（No Persistence） * 命令行 TSQL 示例 * IDENTITY 列的用法 * 存储过程的用法 * 用户定义函数（User Defined Function, UDF）的用法 **临时表与表变量的比较** * 相似之处与不同之处 * 各自的优缺点
This is an in depth course about programming with TEMP TABLES and TABLE VARIABLES in SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject. Temp tables and table variables can solve a lot of the trickier challenges faced by developers so you need to become expert with them. This course will get cover all of the following: TEMP TABLES Temp Tables and the Temp Database (tempdb) Persistence Persistence in STORED PROCEDURES Persistence - TSQL vs STORED PROCEDURES Command Line TSQL examples IDENTITY column usage STORED PROCEDURE usage Command Line TSQL vs STORED PROCEDURE TEMP TABLES vs REAL TABLES TABLE VARIABLES No Persistence Command Line TSQL examples IDENTITY column usage STORED PROCEDURE usage USER DEFINED FUNCTION usage Table Variables vs Temp Tables: How they are similar and how they differ Benefits and drawbacks to each type
