|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-sql-server-t-sql-concepts-raise-above-beginner-level/
课程评论：没有评论
**课程名称：SQL SERVER 存储过程与概念 - 提升至进阶水平** **课程概述：** 本课程旨在通过构建8个存储过程，帮助您深入理解SQL Server的高级概念和技术，帮助您从初学者进阶。您将学习如何创建存储过程，并逐步加入逻辑和功能，以应对真实场景中的SQL Server开发任务。课程以实用为导向，详细解释每一行代码，并深入讲解Transact-SQL（T-SQL）的各项构造。 **核心内容：** * **存储过程的创建与应用：** 学习如何构建存储过程，并逐步为其添加逻辑和功能，以满足实际开发需求。 * **T-SQL 进阶概念：** 深入理解并应用以下T-SQL概念： * 创建动态查询的三种方式 * 执行动态查询 * 游标（Cursors）的概念与实用性 * SQL Server 的 PIVOT 操作符 * ROW\_NUMBER() 函数及创建多重分区 * 在同一查询中进行 UPDATE WITH JOIN 操作 * OUTPUT 子句 * OUTER APPLY 和 CROSS APPLY * **数据库设计与实现：** 通过一个存储过程，学习如何创建**多对多关系数据库**，并掌握主键 (PK)、外键 (FK) 和标识列自增等概念。 * **XML 处理：** 学习 XML 解析和数据选择。 **课程价值：** 本课程涵盖的T-SQL概念和存储过程等关键技术，将是您未来无论是作为SQL开发人员、Web开发人员还是App开发人员职业生涯中的核心技能。 * **实践性强：** 所有内容均通过实际的存储过程构建来讲解，确保学习的有效性。 * **全面覆盖：** 涵盖了从基础的应用到高级的概念和工具。 * **职业导向：** 帮助您掌握在SQL Server开发中至关重要的技能。 **其他信息：** * 课程提供30天免费试用，您可以根据需求决定是否继续学习。
Join this course and learn the concepts below by building 8 Stored Procedures.First of all, learn how to build Stored Procedures, then, slowly add logic and functionality according to real-life scenarios that you are asked to complete as an SQL Server Developer. The entire course is designed so that it explains every line of code that is written and also get a good knowledge of all the added Transact constructs, in a practical approach. More or less, the T-SQL concepts that we will be working with and the constructs (like Stored Procedures) are probably the main features that you'll be using in your planned career either you choose to become a SQL developer or a Web Developer/App Developer.Not the last, the 8th Stored Procedure will create with a click of a button a fully Many-to-Many relational database, so that means will also be dealing with concepts like PK, FK and Identity Incrementation.As a summary, please read below some of the main subjects that this course deals with, and remember, you can freely browse the course for 30 days, because, if it is not what you searched for, you can ask a refund.UNDERSTAND and APPLY inside Stored Procedures T-SQL concepts like:3 Ways of Creating Dynamic QueriesExecute Dynamic QueriesThe concept and utility of CursorsSQL Server Pivot OperatorROW_NUMBER() and create multiple PartitionsUPDATE with JOIN inside the same query OUTPUT clause, OUTER and CROSS APPLYCreate with a Procedure Many-to-Many relational database XML Parsing and master XML selection of Data
