|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-performance-tuning-101/
课程评论：没有评论
这门 Coursera 课程“如何成为世界级 SQL Server 性能调优师”旨在帮助学员掌握 SQL Server 的性能调优技能。通过课程，学员将能够： * **建立坚实的性能调优基础：** 学习并掌握一套行之有效的数据库调优策略和方法论，告别凭感觉的“艺术”，而是运用严谨的流程。 * **量化性能改进：** 理解建立基线的重要性，从而能够清晰地衡量调优前后的系统表现，为成功调优提供“前后对比”的快照。 * **优化查询与事务：** 深入理解如何通过减少响应时间（提高数据检索效率）和降低资源消耗（如减少 INSERT 和 SELECT 操作的负担）来实现性能提升，并通过实例（如在线订购系统）说明其重要性。 * **应对实际问题，提升自信：** 课程通过实用的演示和脚本，帮助学员解决实际数据库性能问题，增强作为性能调优师的信心。 * **提升 DBA 职业能力：** 无论学员是初级还是资深 DBA，都能从课程中获得宝贵知识，将性能调优技能提升到新的水平。 课程强调，SQL Server 就像一辆高性能跑车，而调优师则是能将其性能发挥到极致的关键。本课程将赋予学员成为优秀性能调优师的知识和能力，确保数据库交易拥有顺畅的流程。
Some Course Reviews. "I've also looked at the database with multiple system monitoring products. But really where do I go from here? and when I find the problem what do I really need to do? Mike really shows you the nitty gritty." "This was just the course I have been waiting for. Mike's demos and scripts have helped me become a confident tuner. The best thing about this course was that I was able to improve our server performance straightaway." "I already have a great deal of DBA related experienced in the real world. What this course did for me was help me establish a model, and strategy for database tuning and performance monitoring.""After taking this course not only will you have a sound performance tuning strategy and be well equipped to establish baselines and apply performance tweaks on your servers, but more importantly, you'll have a strong performance tuning foundation and be poised to take your new skills and understanding to the next level. At such a low price, this course is a no-brainer whether you're a junior or senior DBA. I'm so impressed with the course" - Jamar Thank you reviewers for your kind feedback. This course focuses on making SQL Server more performant. SQL Server is like a high performance sports car. Anyone can drive it but put it in the hands of a skilled performance tuner and you've just gone from average to incredible. No one wants an average performing system and with the KNOWLEDGE acquired from THIS COURSE your performance tuning acumen won't be average either. This course will give YOU the foundation to become a skilled PERFORMANCE TUNER. WE will start by building a baseline. How can you measure YOUR success without knowing how poorly the system was before you arrived? Baselines give us a before and after snapshot of the system we are going to tune. Once thought of as an art, performance tuning is nothing more than a series of processes that seek to accomplish TWO basic goals. The FIRST one is to increase the response time for a given transaction or set of transactions. The SECOND one is reduce resource consumption. On the surface this sounds simple but nothing could be further from the truth. A database is a collection of objects. The most fundamental and most important is the table object. Users interact with tables via transactions. Most online transaction processing databases are read and write heavy. We put data into to our tables or INSERT it and we read that data or SELECT it. Let's use an online ordering system as an example. I need a product and I've found it on x(dot)com. Before I can order it I need to give x(dot)com a few things. My name, address, product I'm ordering and money of course. All this information is INSERTED into various tables. Once I've provided all the necessary information someone at x(dot)has to SELECT or read that data so my order can be filled. Imagine for a minute that I make several attempts to provide x(dot)com with my name, address… etc. However, after three attempts the information can't be saved to the database and I receive multiple errors. Most people won't try three times unless the product can't be purchased somewhere else. Most users will look elsewhere after that second failure. This course WILL provide YOU with the foundation necessary to ensure data can be saved and retrieved so the database will have an organic flow of transactions. ENROLL now. Let's get started!!!
