{"product_id":"performance-tuning-and-optimizing-sql-server-2016-databases-10989","title":"Performance Tuning and Optimizing SQL Databases Training (10987)","description":"\u003cdiv\u003e\n\u003cp\u003eThis official Microsoft four-day instructor-led SQL Database Performance Tuning \u0026amp; Optimization training course provides students who manage and maintain SQL Server databases with the knowledge and skills to know how to optimize and tune SQL database performance.\u003c\/p\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eYou Will Learn How To:\u003c\/h3\u003e\n\u003cul\u003e\r\n\t\u003cli\u003eDescribe the high level architectural overview of SQL Server and its various components\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe the SQL Server execution model, waits and queues\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe core I\/O concepts, Storage Area Networks and performance testing\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe architectural concepts and best practices related to data files for user databases and TempDB\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe architectural concepts of the Optimizer and how to identify and fix query plan issues\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache\u003c\/li\u003e\r\n\t\u003cli\u003eDescribe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events\u003c\/li\u003e\r\n\t\u003cli\u003eExplain data collection strategy and techniques to analyze collected data\u003c\/li\u003e\r\n\t\u003cli\u003eUnderstand techniques to identify and diagnose bottlenecks to improve overall performance\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\r\n\u003cp\u003e \u003c\/p\u003e\r\n\u003c\/div\u003e\u003cdiv\u003e\n\u003cul class=\"accordion\"\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eOn-Demand Training Description\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cp\u003eWith a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.\u003c\/p\u003e\r\n\r\n\t\u003cp\u003ePLUS, we include access to a Microsoft Certified Trainer (MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!\u003c\/p\u003e\r\n\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eFlexibility to take the course on your own time, at your own pace\u003c\/li\u003e\r\n\t\t\u003cli\u003eForever access to the digital course materials – for any refreshers\u003c\/li\u003e\r\n\t\t\u003cli\u003eYou will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months\u003c\/li\u003e\r\n\t\t\u003cli\u003eUpon course activation, the MOC On Demand videos and labs are available for three months\u003c\/li\u003e\r\n\t\t\u003cli\u003e2 FREE hours of individual coaching from an MCT Learning Tree Instructor\u003c\/li\u003e\r\n\t\t\u003cli\u003eThis delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)\u003c\/li\u003e\r\n\t\t\u003cli\u003e\n\u003cb\u003eNOTE:\u003c\/b\u003e Only live, in-class training is eligible for NASBA CPEs; on-demand training is not eligible for CPE credit\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRequirements\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eIn addition to their professional experience, students who attend this training should already have the following technical knowledge:\r\n\t\t\u003cul\u003e\r\n\t\t\t\u003cli\u003eBasic knowledge of the Microsoft Windows operating system and its core functionality\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eWorking knowledge of database administration and maintenance\u003c\/li\u003e\r\n\t\t\t\u003cli\u003eWorking knowledge of Transact-SQL\u003c\/li\u003e\r\n\t\t\u003c\/ul\u003e\r\n\t\t\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\t\u003cli\u003e\r\n\t\u003ch3\u003eRedeem Your Microsoft Training Vouchers (SATV):\u003c\/h3\u003e\r\n\r\n\t\u003cdiv\u003e\r\n\t\u003cul\u003e\r\n\t\t\u003cli\u003eThis course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.\u003c\/li\u003e\r\n\t\t\u003cli\u003eWant to learn more about Microsoft SATVs? \u003ca href=\"https:\/\/www.learningtree.com\/tuition\/microsoft-training-vouchers\" target=\"”_blank”\"\u003e\u003cstrong\u003eClick to view our SATVs infographic.\u003c\/strong\u003e\u003c\/a\u003e\n\u003c\/li\u003e\r\n\t\u003c\/ul\u003e\r\n\t\u003c\/div\u003e\r\n\t\u003c\/li\u003e\r\n\u003c\/ul\u003e\r\n\u003c\/div\u003e","brand":"Microsoft","offers":[{"title":"206B24US \/ 2020-06-02T09:00:00 \/ Online","offer_id":30319215607926,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"208A83CN \/ 2020-08-25T09:00:00 \/ Ottawa","offer_id":30686937940086,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"209B40US \/ 2020-09-08T09:00:00 \/ Herndon","offer_id":30686938005622,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"20CC14US \/ 2020-12-01T09:00:00 \/ New York","offer_id":31395170549878,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"207J06US \/ 2020-07-07T09:00:00 \/ San Francisco","offer_id":31612683649142,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"20AH19US \/ 2020-10-13T09:00:00 \/ Seattle","offer_id":31612683681910,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"211D52US \/ 2021-01-05T09:00:00 \/ San Francisco","offer_id":31612683714678,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"212A30CN \/ 2021-02-02T09:00:00 \/ Ottawa","offer_id":31612683747446,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true},{"title":"213A85US \/ 2021-03-09T09:00:00 \/ Herndon","offer_id":31612683780214,"sku":"US-8428-GOVT-IL","price":2659.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/ltreetheta.myshopify.com\/products\/performance-tuning-and-optimizing-sql-server-2016-databases-10989","provider":"Learning Tree International","version":"1.0","type":"link"}