{"id":4892,"date":"2018-06-11T09:19:22","date_gmt":"2018-06-11T16:19:22","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4892"},"modified":"2018-06-11T09:19:22","modified_gmt":"2018-06-11T16:19:22","slug":"new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/","title":{"rendered":"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning"},"content":{"rendered":"<p style=\"text-align: justify;\">Continuing our series of live, online classes,\u00a0<strong>Kimberly\u00a0will be delivering\u00a0her new <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/ietlb\/\" target=\"_blank\" rel=\"noopener noreferrer\"><em>IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning<\/em><\/a>\u00a0in October!<\/strong>\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October 9-11 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to the recordings\u00a0following the end of the class.<\/p>\n<p style=\"text-align: justify;\">Rather than have people try to watch a full day of training at their computer for one of more days, the class will run from 10am to 3pm PST each day, with two 90-minute teaching sessions, each followed by Q&amp;A, and a lunch break. We chose to do this, and to spread the class over a few days, so the times work pretty well for those in the Americas, Africa, and Europe. We also realize that this is complex content, so want to give attendees time to digest each day\u2019s material, plus extensive Q&amp;A.<\/p>\n<p style=\"text-align: justify;\">Here are some select quotes from prior attendees of Kimberly&#8217;s live, online\u00a0classes:<\/p>\n<ul>\n<li style=\"text-align: justify;\"><em>\u201cKimberly is incredibly knowledgeable and was able to adapt the techniques to all the different scenarios presented to her.\u201d<\/em><\/li>\n<li style=\"text-align: justify;\"><em>\u201cThe best educator I\u2019ve ever seen. She makes complex concepts \u201cmagically\u201d easy to grasp. Incred-amazing.\u201d<\/em><\/li>\n<li style=\"text-align: justify;\"><em>\u201cGreat course. I could hear clearly, the content was relevant to current day problems, and provided clear instruction.\u201d<\/em><\/li>\n<li style=\"text-align: justify;\"><em>\u201cThis was REALLY good. Getting to an IE is tough there are only a few a year and more importantly because there are only a few they cover a pretty broad range of information. Since I do mainly database design and query tuning, I can\u2019t justify much beyond IE1 as I don\u2019t do day to day DBA work. Seeing you were offering the online event focused on a specific topic \u2013 very large tables \u2013 was PERFECT. I know I really need to improve my knowledge of the options in that area. I recalled the PV\/PT architecture from IE1 and knew a refresher, coupled with the new information would be perfect. The cost was BEYOND reasonable. The time frame, at only about 1\/2 a day, was easy to justify and easy to manage keeping up with regular work while I did it. So this worked out to be a perfect event.\u201d<\/em>\u00a0\u2013 Todd Everett, USA<\/li>\n<li style=\"text-align: justify;\"><em>\u201cLoved the online aspect. It felt like I was there with the question ability and having the questions just answered right there. I felt I had a voice and could ask anything and the ability to watch it later made it totally worth the registration.\u201d<\/em><\/li>\n<li style=\"text-align: justify;\"><em>\u201cI really enjoyed the ability to ask questions as the course went along so that I didn\u2019t forget what I wanted to ask while you were teaching. This allowed for questions to come through and class to continue until a good stopping point to answer the questions. Plus having the questions written from other attendees was nice for future reference instead of trying to remember from an in-person class discussion.\u201d<\/em><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">The modules covered will be:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Batches, Transactions, and Error Handling<\/li>\n<li>The Anatomy of a Data Modification<\/li>\n<li>Locking \/ Isolation<\/li>\n<li>Table Maintenance and Schema Locks<\/li>\n<li>Locking, Blocking, and an Intro to Deadlocks<\/li>\n<li>Versioning<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>The price of the class is US$699 (or US$599 for prior live, online attendees) and there&#8217;s also a combo price for all three new classes announced today.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>You can get all the details\u00a0<a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/live-online-ietlb-20181009\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/strong><\/p>\n<p style=\"text-align: justify;\">The class was also announced in our\u00a0<a href=\"https:\/\/www.sqlskills.com\/join-the-sqlskills-insider-community\/\" target=\"_blank\" rel=\"noopener noreferrer\">newsletter<\/a>\u00a0today, with a US$100 discount for those people who received that newsletter, valid\u00a0through the end of June. All future live, online classes will always feature a\u00a0discount for newsletter subscribers.<\/p>\n<p style=\"text-align: justify;\">We decided to start teaching some live, online classes as we recognize that not everyone can travel to our in-person classes, or take that time away from work or family, or simply have travel budget as well as training budget. People also have different ways they learn, some preferring in-person training, some preferring recorded, online training, and some preferring live, online training.<\/p>\n<p style=\"text-align: justify;\">We\u2019ll be doing more of these\u00a0so stay tuned for updates (and discounts through the newsletter).<\/p>\n<p style=\"text-align: justify;\">We hope\u00a0you can join us!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Continuing our series of live, online classes,\u00a0Kimberly\u00a0will be delivering\u00a0her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October 9-11 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to the recordings\u00a0following the end [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,57,66,82,97],"tags":[],"class_list":["post-4892","post","type-post","status-publish","format-standard","hentry","category-classes","category-locking","category-performance-tuning","category-snapshot-isolation","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Continuing our series of live, online classes,\u00a0Kimberly\u00a0will be delivering\u00a0her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October 9-11 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to the recordings\u00a0following the end [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-11T16:19:22+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/\",\"name\":\"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2018-06-11T16:19:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/","og_locale":"en_US","og_type":"article","og_title":"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal","og_description":"Continuing our series of live, online classes,\u00a0Kimberly\u00a0will be delivering\u00a0her new IETLB: Immersion Event on Transactions, Locking, Blocking, Isolation, and Versioning\u00a0in October!\u00a0The class will be delivered live via WebEx\u00a0on\u00a0October 9-11 (roughly 12-13 hours of content including Q&amp;As; about the same as two full workshop days!) and the attendees\u00a0will have lifetime access to the recordings\u00a0following the end [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/","og_site_name":"Paul S. Randal","article_published_time":"2018-06-11T16:19:22+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/","name":"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2018-06-11T16:19:22+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-live-online-training-class-in-october-transactions-locking-blocking-isolation-and-versioning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New live online training class in October: Transactions, Locking, Blocking, Isolation, and Versioning"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4892"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4892\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}