|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-advanced-transact-sql-t-sql-using-sql-server-2017/
课程评论：没有评论
**Coursera 课程总结：高级 Transact-SQL (T-SQL)：存储过程与函数** 本课程适合已有 SQL 或 T-SQL 基础知识的学习者，旨在深入讲解 Transact-SQL (T-SQL) 的高级用法。课程将使用最新免费的 Microsoft SQL Server 2017 Express 版本和 AdventureWorks 2014 示例数据库，并指导学员安装和使用 SQL Server Management Studio。 课程重点在于编写和应用 T-SQL 的高级查询，这些技巧兼容 SQL Server 2012、2014、2016 和 2017 版本。学员将详细学习各种函数的具体功能和用法，包括： * **内置函数：** `Convert`、`Substring`、`Cast`、`Round` * **控制流函数：** `Case` 表达式 * **聚合函数 (Aggregate Functions)** * **分析函数 (Analytic functions)** * **排名函数 (Ranking functions)** * **集合运算符 (SET operators)** 此外，课程还将教授**存储过程 (Stored Procedures)** 的创建、修改和删除方法。 **本课程的主要学习内容包括：** * 安装 Microsoft SQL Server Express 2017 * 下载并附加示例数据库 * 掌握 `Convert`、`Substring`、`Cast`、`Round` 等函数的应用 * 理解并运用 `Case` 表达式 * 深入学习聚合函数、分析函数和排名函数 * 熟练运用集合运算符 * 学习存储过程的完整生命周期管理
Transact-SQL is also popularly refereed to as T-Sequel.This is Microsoft's own implementation of the international Structural Query Language (SQL).This course assumes you have some basic knowledge of SQL or T-SQL and will provide you with more advanced knowledge of Transact-SQL (T-SQL). I will be using the latest free version of Microsoft SQL Server 2017 Express edition and a sample adventureworks 2014 database. We will be installing and using SQL Server Management Studio as part of the SQL Server Express edition 2017 The course focuses on writing and advanced queries that can be used with T-SQLin SQL Server 2012, 2014 and 2016 and 2017. In this course you will learn the details and capabilities of using various types of functions like aggregate,analytic and ranking. You will also learn about stored procdures and how to create ,modify and delete them. I will also be showing you how to use SET operators. What You Will Learn in this course includes: Installing Microsoft SQL Server Express 2017Downloading and attaching sample databaseUsing Convert functionUsing Substring functionUsing Cast functionUsing Round FunctionUsing Case expressionAggregate FunctionsAnalytic functionsSET operatorsStored ProcedureRanking functions
