|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-real-world-troubleshooting-skills/
课程评论：没有评论
**课程名称：** 我如何解决 95% 的 SQL Server 宕机问题 **课程概述：** 本课程由 Mike West 主讲，专注于教授一项至关重要的技能：如何着手解决生产环境中 SQL Server 出现的问题。课程以“实战”为导向，通过多个真实世界案例，深入剖析 SQL Server 宕机场景，并演示如何将其恢复。学员将学习到性能调优的“语言”，了解行业术语和独有的脚本工具。 **课程亮点：** * **核心技能：** 教授如何判断“发生什么”、“它意味着什么”以及“如何修复”。 * **实战案例：** 强调真实世界场景，学员将模拟 OLTP 应用，学习识别和处理问题。 * **独家脚本：** 介绍一个由 SQL Server 领域顶尖专家开发并广泛使用的关键脚本，该脚本被认为是解决性能问题的“万能钥匙”。学员将学会如何设置自己的脚本库，并获得最初的几个脚本。 * **易于上手：** 课程设置简单，只需将 Transact-SQL 代码复制粘贴到 SQL Server Management Studio 即可。 * **内容充实：** 大部分课程时间将用于演示和分析，学员将深入理解故障排除过程和恢复步骤。 * **高性价比：** 课程中的脚本和应用方法本身就物超所值。 * **实用性强：** 课程内容被评价为“非常实用”、“细节丰富”、“应用到实际工作中”等。 **目标学员：** 希望提升 SQL Server DBA 技能，尤其是向高级 DBA 迈进的专业人士。 **学习成果：** 学员将获得一套强大的生产环境故障排除工具和方法论，能够自信地应对和解决绝大多数 SQL Server 宕机问题。
COURSE REVIEWS: "This was one of the most useful classes I have taken in a long time. Very specific, real-world examples. It covered several instances of 'what is happening', 'what it means' and 'how you fix it'. I was impressed." Steve"Mike West ROCKS and is a FANTASTIC TEACHER for newbie DBAs! If you offer more videos on the subject i will be one of the first to sign up!!" - Rob R"I've been a DBA for a few years now and have used sp_who is active for years (and love it!) and even I learned a few new tricks. Great class!" Nancy"Well the credit also goes back to the mentor of this online course.yes it is worth for small amount of price." HCDS Academy"Very practical course" - Guillermo "I love the detail and the real world applications" - Darryl "Knowledge is always about applied information towards getting results in a particular context. This is pristine knowledge supported by the experience of Mike. Solid gold" - Roman"Awesome course, it showed me some useful tips and some neat things which I will be using from now on" Thomas "Does an excellent job of (a) explaining course intent, (b) concepts, and most importantly, (c) explains the tools, gives a detailed (and easy) description of how to install them, and how to use them, and for what purpose. Great course!" Douglas T."This will give you a head start when it comes to trouble shooting your SQL server. Thanks Mike!" Luke D"Instructor was engaging and the course material was just the right about to get to the core of the issues." Texas Squirrel "Difficult concepts expressed in simple terms." Dare DavidCOURSE DESCTIPTION What do I mean when I use the words "real world?"This course is about learning a very specific skill that's one of the most important ones to becoming a senior level SQL Server DBA and that is - Where do you begin troubleshooting production issues?I'm going to give you the starting point and we are going to work through several examples of real world scenarios where a SQL Server was down and how I brought back online. You'll learn the language of performance tuning. All industries have their own vernacular and the SQL world is no exception.I'll be introducing some new terms and scripts that are very specific to performance tuning and optimization. These scripts and how I apply them are worth the cost of the course. Performance tuners are like mechanics. Our goal is to keep the SQL engine as tuned as it possibly can be. One stored procedure to rule them all! In the real world, the elite SQL Server DBAs don't use canned tools. Many of the greats have a library of scripts and they use ONE of these every single day. If you don't have a script library started then I'll show you how to set one up and GIVE you your first few scripts. When I'm called into troubleshoot a struggling SQL Server I always use ONE script first. This script was developed by one of the world's leading experts on SQL Server and used by many of the world's leading experts on SQL Server. This is a hands on course. You will simulate a OLTP application and learn what to look for when issues arise. All of the demos are written in transact. Everything is included in the price of the course. Set up for the course is easy. Installing the tools will take several minutes. The most important part of our course will be working through the real world examples. All my lessons will have very specific instructions. The set up for all of the lessons is simply to cut and paste the transact code into SQL Server Management Studio. The vast majority of the course will be working through the demos and analyzing how to troubleshot production down issues and what steps can be taken to bring the server back online. The course will also include lectures but the lectures will be short and pragmatic. SQL Server is one of the most complicated pieces of software in Microsoft's suite. This course will provide you with the single most important facet to analyzing real world outages. Where do you start? If you want to be one of the most skilled SQL Server DBAs then you MUST learn how to use this script effectively! Start now! Enroll today.
