|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-the-basics-of-sql-server-query-optimization/
课程评论：没有评论
课程名称：掌握SQL Server查询优化基础 概述：本课程适合初学者，但节奏较快，可能需要学员进行额外的学习准备。课程包含四个不同的预览课程，帮助学员了解课程的速度。如果预览课程内容对你来说太快，建议在完成入门级课程后再参加本课程。 本课程将深入探讨查询优化器，这是编写的最复杂的软件之一。查询优化器是SQL Server的一个组件，旨在为查询提供最佳的执行计划。它会迅速寻找一个可行的执行计划，虽然不一定是最佳的，但会尽可能接近。 SQL Server查询优化器是一个基于成本的优化器，它会分析给定查询的多种执行计划，估算每个计划的成本，并选择成本最低的计划。优化器寻求优化时间与所选计划质量之间的平衡。 课程内容将结合实际操作的查询性能调优与优化器架构的基础知识，包括执行引擎、统计信息与成本估算、索引选择和优化过程。SQL Server数据库引擎的核心包括两个主要组件：存储引擎和查询处理器（也称为关系引擎），本课程将专注于查询处理器。 欢迎参加本课程！
Student Warning: Even though this is a beginners class it's fast paced and will require some outside study on your part. I've included 4 different preview lessons so you could better gauge the speed of the course. Please take a moment to preview all of them. If those lessons are too fast then please take this course after you've taken my entry level courses. Thanks..Mike Recent Unsolicited Testimonials "Learned lots from this well constructed and easy to follow course - thanks Mike!" - Caroline "Feel much more confident in MSSQL now. Thanks!" Jef Yo "This short course is excellent and will give you a good understanding of the basics in SQL server administration." Luke Dunn In this course we are going to delve into the Query Optimizer, easily one of the most complicated pieces of software ever written. The Query Optimizer is the SQL Server component that tries to give you an optimal execution plan for your queries. The Query Optimizer tries to find that execution plan as quickly as possible. Not the perfect plan but a good one. The SQL Server Query Optimizer is a cost-based optimizer. It analyzes a number of execution plans for a given query, estimates the cost of each of these plans, and chooses the plan with the lowest cost. The optimizer seeks to find balance between the optimization time and the quality of the selected plan. The course will be a balance of hands on query performance tuning and understanding the basics of the optimizer's architecture. We are going to learn about the execution engine, statistics and cost estimation, index selection and the optimization process. At the core of the SQL Server Database Engine are two major components: the storage engine and the query processor also called the relational engine. In this course our sole focus will be on the query processor. This part of the engine accepts all queries submitted to SQL Server and creates a plan for optimal execution. See you in the course!!!
