|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/stored-procedures-unpacked-learn-to-code-t-sql-stored-procs/
课程评论：没有评论
课程名称：EssentialSQL: 存储过程解析 - 使用TSQL编码 课程概述：本课程旨在教授如何使用TSQL编写存储过程和脚本，以自动化数据工程和数据分析任务。对于希望在数据库管理员中脱颖而出的DBA而言，这是一个非常出色的SQL课程。学习使用SQL Server存储过程的数据库编程概念。无论你是：一个希望用存储过程确保应用安全的开发者；一个希望扩大工具集的顾问；一个希望理解数据库代码的IT专业人士；一个希望为SQL数据分析参数化PowerBI查询的分析师；还是一个希望提升SQL Server数据库管理员技能的SQL Server DBA，本课程都将为你提供所需的工具、灵感和无与伦比的支持，助你提升SQL技能。 在本课程中，你将学习到： - 使用存储过程实现业务逻辑。 - 从零开始开发存储过程！ - 一些基本的故障排除技能。 - 了解游标的正确使用方法。 - 应用数据库事务技术，以提交或回滚数据库更改。 - 捕获和处理错误。 没有比以下情况更糟糕的事情：对学习新知识充满期待却不知道从何入手；浪费时间学习不必要的内容；被众多选项压得喘不过气而不知道选择哪一个。想象一下，拥有快速编写存储过程的知识，能够将你的SQL技能提升到一个新高度的自信感。获得成就感，掌握大多数人无法学会的技能。 通过完成本课程，你将对开发存储过程有更深的理解，克服你的恐惧，能够编写能够传递参数、处理错误并回滚意外数据库更改的存储过程。这真是太酷了！
Use TSQL to write stored procedures and scripts to automate data engineering and data analysis task. This is a great SQL course for a DBA to take if they want to stand out from other database administrators. Learn Database Programming concepts using SQL Server stored procedures.Whether You're:A developer looking to secure your app with stored procedures.A consultant looking to expand your tool setAn IT professional looking to read and understand database codeAn analyst looking to parametrize PowerBI queries for SQL data analysisA sql server DBA looking to build their SQL server database administrator skillsYou're in the right place and I'm going to tell you exactly how Stored Procedure Unpacked gives you the tools, inspiration, and unparalleled support on your journey to level up your SQL skills.In this Course you will Learn to:Use stored procedures to implement business logic.Develop stored procedures from scratch!Learn some basic troubleshooting skills.Know the right way to use cursors.Apply database transaction techniques to commit or rollback your database changes.Trap and handle errors.Nothing is worse than:Being excited to learn something new but not knowing where to start.Wasting time learning the wrong features.Being overwhelmed with options and not know which to use.Imagine having the knowledge to know how to quickly write stored procedures to take your SQL to the next level. The confidence confidence that you're on the right track. A sense of accomplishment, you have learned something most cannot.By the time you've complete this course you'll have an appreciation of developing stored procedures, overcome your fear, and able to write stored procedures that pass parameters, handle errors, and rollback unintended database changes.Now that's cool!
