|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/an-abridged-introduction-to-dynamic-sql/
课程评论：没有评论
**课程名称：** 动态 SQL 简明入门 **课程概述：** 本课程旨在介绍动态 SQL 的概念、应用及实践。动态 SQL 是一种在程序运行时动态构建 SQL 语句的编程技术，能够帮助开发者创建更通用、更灵活的应用程序，因为它允许 SQL 语句的完整文本在编译时未知。 **课程亮点：** * **解决未知细节场景：** 动态 SQL 尤其适用于需要操作一个或多个对象，但在编写代码时并不清楚所有细节的场景。 * **提高性能：** 通过动态 SQL，可以根据性能需求定制 SQL 语句，例如移除多余的对象、连接和子查询，以及减小 SQL 语句的大小，从而提高执行速度并降低资源消耗。 * **适合不同水平的学习者：** 无论您是动态 SQL 的初学者，还是已有一定经验，本课程都将帮助您学习、实践并立即应用动态 SQL，或探索新的应用场景并温习旧知。 * **实践导向：** 课程将包含大量练习，从基础概念入手，逐步过渡到更详细的示例，并展示多个实际应用案例。 * **实战引入：** 讲师还将分享自己编写的、严重依赖动态 SQL 的自动化软件引擎 `sqlblackbox` 的部分代码。 **适合人群：** 对数据库管理或开发抱有浓厚兴趣的任何人。 **课程特色：** * 由实践中的教育者教授，课程交付流畅且切中要点。 * 提供即时应用的机会。 * 内容实用，贴近实际需求。
"First impressions are "Finally, a practicing educator" Course delivery is smooth and spot on. Right before you lose hope a gem like this pops up - thanks." - Don Councill Welcome to An Abridged Introduction to Dynamic SQL. Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at runtime. You can create more general purpose, flexible applications by using dynamic SQL because the full text of a SQL statement may be unknown at compilation. Dynamic SQL is often underused, misused, or overused. If you are completely unfamiliar with Dynamic SQL, this will be an opportunity to learn, practice, and immediately apply it. If you already have experience in writing and using Dynamic SQL, this will be a chance to learn new applications while getting a refresher on those you have worked with in the past. Anyone with a healthy interest in database administration or development can benefit from the topics covered in this course. Dynamic SQL seeks to solve scenarios where you want to operate on one or many objects, but do not know all the details but don't know all the details as your write the code. Dynamic SQL gives us an opportunity to customize statements to match performance needs. Removing excess objects, removing joins and subqueries, and reducing the size of a SQL statement can result in faster executions times and reduce resource consumption. The course will be exercise laden. Because Dynamic SQL is unfamiliar to many we will start of basic and transition into more detailed examples. There are many reasons why you would want to incorporate Dynamic SQL into your everyday arsenal of SQL Server tools and in the course we will demonstrate several real world example. I'd also like to add that an automated software engine I've authored called sqlblackbox relies heavily on Dynamic SQl and in the course I'll show you a few simple lines I use in the application. Thank you for your interest in An Abridged Introduction to Dynamic SQL and we will see you in the course.
