|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-programming-and-stored-procedures-fundamentals/
课程评论：没有评论
## SQL Server 编程与存储过程基础 这门课程将带您从零开始学习SQL Server编程和存储过程。无论您是否具备编程背景，都将能够通过循序渐进的学习，掌握创建强大、实用的存储过程的技能。 **课程亮点:** * **零基础入门:** 无需任何编程经验，课程从基础概念讲起，逐步深入。 * **实操导向:** "边做边学" 的教学方式，让您在实践中巩固知识。 * **实用技能:** 学习如何高效地编写和管理存储过程，提升数据处理能力。 * **广泛适用:** 即使您不是开发者，学习SQL也能让您在工作中更高效地处理数据。 **导师介绍:** Enrique Valencia，一位在新加坡的数据库专业人士，拥有7年SQL Server DBA经验，并活跃于MySQL, MariaDB, PostgreSQL, Redis, Elasticsearch, MongoDB等多种开源数据库领域，专注于SQL性能优化、高可用性和自动化。 **课程内容:** * **存储过程基础:** 理解并使用可重用的SQL代码片段。 * **参数化存储过程:** 实现数据在存储过程与外部应用间的交互。 * **变量:** 学习如何使用变量存储和操作数据。 * **输出参数与返回值:** 掌握从存储过程向调用程序返回数据的方法。 * **IF 语句:** 实现条件化执行SQL语句。 * **WHILE 循环:** 实现SQL脚本的重复执行。 * **用户定义函数 (UDF):** 创建可接受参数、执行计算并返回结果的自定义函数。 * **临时表与表变量:** 学习临时存储数据的方法。 * **表值函数:** 创建返回表类型数据的函数。 * **公共表表达式 (CTE):** 创建可引用的临时命名结果集。 * **动态 SQL:** 学习在运行时动态构建SQL语句的技术。 * **事务:** 理解数据库操作的原子性、一致性、隔离性和持久性。 * **DML 触发器:** 自动响应数据修改事件的触发器。 * **DDL 触发器:** 响应数据定义语言 (DDL) 事件的触发器。 加入本课程，解锁SQL Server编程的强大能力，提升您的数据处理和业务分析技能！
Learn SQL Server Programming by doing!This course will assist you in achieving the objective of creating useful and powerful stored procedures. This is a step-by-step course. We will build on what we had learned in every new session. This course teaches you SQL Programming and Stored Procedure from scratch. No prior programming experience is required.Why should you learn SQL even if you are not a Developer?These days, almost everyone has to work with data in some form or another. Usually, it's through spreadsheets or databases, but if you can learn a little SQL you can become so much more powerful in your job.Who is teaching you?My name is Enrique Valencia. I'm a database professional based in Singapore. I've been a SQL Server DBA for 7 years. Now, I'm working on various open-source databases such as MySQL, MariaDB, PostgreSQL, Redis, Elasticsearch, and MongoDB. My focus is on SQL performance optimization, high availability, and automation.I hope that you'll enjoy this course as much as I did creating it!Below is the list of topics that will be covered in this course.Stored Procedure Fundamentals - A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.Using Parameters in Stored Procedures - used to exchange data between stored procedures and functions and the application or tool that is called the stored procedure or function.Variables - an object that can hold a single data value of a specific type.Output Parameters & Return Values - two ways of returning result sets or data from a Stored Procedure to a calling program.IF Statements - Imposes conditions on the execution of a Transact-SQL statement.WHILE Loops - used to repeatedly execute a certain piece of SQL script.User Defined Functions - routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value.Temporary Tables - database table that exists temporarily on the database server.Table Variables - a special type of the local variable that helps to store data temporarily, similar to the temp table in SQL Server.Table Valued Functions - user-defined function that returns a table data type and also it can accept parameters.Common Table Expressions (CTEs) - a temporary named result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement.Dynamic SQL Scripts - a programming technique that enables you to build SQL statements dynamically at runtime.Transactions - a sequential group of statements or queries to perform single or multiple tasks in a database.DML Triggers - a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger.DDL Triggers - fire in response to a variety of Data Definition Language (DDL) events.
