{"id":592,"date":"2019-11-01T13:16:22","date_gmt":"2019-11-01T13:16:22","guid":{"rendered":"https:\/\/www.sequallity.co.uk\/?p=592"},"modified":"2020-01-16T15:55:34","modified_gmt":"2020-01-16T15:55:34","slug":"tsql-course-transact-sql-training","status":"publish","type":"post","link":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/","title":{"rendered":"TSQL Course | Transact SQL Training"},"content":{"rendered":"\n<p><h1> TSQL Course | Transact-SQL Training<\/h1><\/p>\n<p>Our TSQL Course can cover Beginners or Intermediate\/Advanced  training, depending on your needs. So, with this Transact SQL Training, you  will learn real-world skills gleaned by experienced SQL Developers.<\/p>\n\n\n\n<p>Learn how to write effective SQL statements from the ground up in this TSQL Course.  Understand the set paradigm, right from the start.  No experience is necessary to go to a good level with clear explanations and lots of examples. <\/p>\n\n\n\n<p>This course can be 1 day to 3 days depending on your level of expertise, you decide<\/p>\n\n\n\n<p>On the Beginners TSQL Course, we cover Set theory then lots of examples about selecting and filtering data.  Joining data and more difficult TSQL topics covered including examples of stored procedures and views.<\/p>\n\n\n\n<p>If you are require a more Intermediate\/Advanced Transact SQL Training Course we cover the more advanced constructs of TSQL and how to use them in the right way. We cover all of the new Transact-SQL features up to the version you choose to study in. Learning all about tables and indexes will let you know how to fix poorly performing SQL Server queries.<\/p>\n\n\n\n<p>Logical query processing, table b-trees, indexes, access methods are all covered.  How queries work and how to use the right construct at the right time is covered in depth.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T-SQL for\nBeginners or Data Analysts Training Course Agenda<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">T-SQL\nIntroduction<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; SQL Server Management Studio<\/li><li>&nbsp;&nbsp;&nbsp; Creating Tables<\/li><li>&nbsp;&nbsp;&nbsp; Naming Conventions<\/li><li>&nbsp;&nbsp;&nbsp; Data Types<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Transact-SQL<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; SELECT<\/li><li>&nbsp;&nbsp;&nbsp; FROM<\/li><li>&nbsp;&nbsp;&nbsp; WHERE<\/li><li>&nbsp;&nbsp;&nbsp; GROUP BY<\/li><li>&nbsp;&nbsp;&nbsp; ORDER BY<\/li><li>&nbsp;&nbsp;&nbsp; and lastly HAVING (not in the right order!) and why that&#8217;s important<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Expressions &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; CASE statements<\/li><li>&nbsp;&nbsp;&nbsp; LIKE<\/li><li>&nbsp;&nbsp;&nbsp; Functions (lots of them)<\/li><li>&nbsp;&nbsp;&nbsp; Date and Time<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Join Us<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Cross<\/li><li>&nbsp;&nbsp;&nbsp; Inner<\/li><li>&nbsp;&nbsp;&nbsp; Outer<\/li><li>&nbsp;&nbsp;&nbsp; 1-to-Many<\/li><li>&nbsp;&nbsp;&nbsp; Many-to-Many<\/li><li>&nbsp;&nbsp;&nbsp; Union<\/li><li>&nbsp;&nbsp;&nbsp; Union All<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Database\nObjects<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Stored Procedures<\/li><li>&nbsp;&nbsp;&nbsp; Views<\/li><li>&nbsp;&nbsp;&nbsp; Calling them and where to use them?<\/li><li>&nbsp;&nbsp;&nbsp; Why to use them?<\/li><li>&nbsp;&nbsp;&nbsp; Examples<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Adding More\nData<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; INSERT<\/li><li>&nbsp;&nbsp;&nbsp; DELETE<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Control of\nFlow<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; IF<\/li><li>&nbsp;&nbsp;&nbsp; WHILE<\/li><li>&nbsp;&nbsp;&nbsp; Cursors<\/li><li>&nbsp;&nbsp;&nbsp; Loops<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">It\u2019s all\nTemporary<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Derived Tables<\/li><li>&nbsp;&nbsp;&nbsp; Temporary Tables<\/li><li>&nbsp;&nbsp;&nbsp; Table Variables<\/li><li>&nbsp;&nbsp;&nbsp; Benefits and downsides<\/li><\/ul>\n\n\n\n<p> <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T-SQL for\nDevelopers Intermediate\/Advanced Training Course Agenda<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Query\nDeconstruction Introduction<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Logical Query Processing<\/li><li>&nbsp;&nbsp;&nbsp; SQL Server Database Internals<\/li><li>&nbsp;&nbsp;&nbsp; Storage &amp; B-Trees<\/li><li>&nbsp;&nbsp;&nbsp; Heaps, Indexes Clustered and Non-clustered<\/li><li>&nbsp;&nbsp;&nbsp; Covering Indexes<\/li><li>&nbsp;&nbsp;&nbsp; Index Access Methods<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Join Us<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Joins<\/li><li>&nbsp;&nbsp;&nbsp; Natural<\/li><li>&nbsp;&nbsp;&nbsp; Equi-joins and Non-equi joins<\/li><li>&nbsp;&nbsp;&nbsp; Nested, Merge and Hash Joins<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Data and\nTables &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Data Types<\/li><li>&nbsp;&nbsp;&nbsp; Normal Form<\/li><li>&nbsp;&nbsp;&nbsp; Temporary Tables<\/li><li>&nbsp;&nbsp;&nbsp; Table Variables<\/li><li>&nbsp;&nbsp;&nbsp; While vs Cursors<\/li><li>&nbsp;&nbsp;&nbsp; For Performance<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Table\nExpressions<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Derived Tables<\/li><li>&nbsp;&nbsp;&nbsp; CTEs and Views<\/li><li>&nbsp;&nbsp;&nbsp; In-line Table-Valued Functions<\/li><li>&nbsp;&nbsp;&nbsp; The APPLY Operator<\/li><li>&nbsp;&nbsp;&nbsp; Date and Time anomalies<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Execution<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Dynamic SQL vs Stored Procs<\/li><li>&nbsp;&nbsp;&nbsp; EXEC<\/li><li>&nbsp;&nbsp;&nbsp; sp_executesql<\/li><li>&nbsp;&nbsp;&nbsp; UDFs<\/li><li>&nbsp;&nbsp;&nbsp; Multistatement Table-Valued UDFs<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The Database\nObjects!<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Stored Procedures<\/li><li>&nbsp;&nbsp;&nbsp; Triggers<\/li><li>&nbsp;&nbsp;&nbsp; Error Handling<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Blockchain\nis old news &nbsp; <\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; Transactions<\/li><li>&nbsp;&nbsp;&nbsp; Isolation Levels<\/li><li>&nbsp;&nbsp;&nbsp; Locking and Blocking<\/li><li>&nbsp;&nbsp;&nbsp; Deadlocking<\/li><li>&nbsp;&nbsp;&nbsp; Handling deadlocks<\/li><li>&nbsp;&nbsp;&nbsp; Timeouts<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The Query\nOptimizer<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>&nbsp;&nbsp;&nbsp; The Query Optimizer<\/li><li>&nbsp;&nbsp;&nbsp; How the optimiser decides and indexes<\/li><li>&nbsp;&nbsp;&nbsp; Execution Plans<\/li><li>&nbsp;&nbsp;&nbsp; Graphical Execution Plans<\/li><li><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>TSQL Course Training Feedback<\/strong><\/h2>\n\n\n\n<p>What do our\ndelegates like most about the Transact SQL training course?<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TSQL\nTraining Comments<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>\u201cVery personable trainer who really engages the audience.&nbsp; Perfect way for me to learn\u201d \u2013 Jimmy<\/li><li>\u201cBeing able to go through examples throughout the day\u201d \u2013 Pritesh&nbsp; <\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><\/h3>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>TSQL Course | Transact-SQL Training Our TSQL Course can cover Beginners or Intermediate\/Advanced training, depending on your needs. So, with this Transact SQL Training, you will learn real-world skills gleaned by experienced SQL Developers. Learn how to write effective SQL statements from the ground up in this TSQL Course. Understand the set paradigm, right from the start. No experience is necessary to go to a good level with clear explanations<\/p>\n<div class=\"read-more\"><a class=\"btn read-more-btn\" href=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\">Read More<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[266,344,342,343],"tags":[],"class_list":["post-592","post","type-post","status-publish","format-standard","hentry","category-sql-server-training","category-transact-sql-course","category-tsql-course","category-tsql-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.8 (Yoast SEO v20.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to find T-SQL Courses | Transact SQL Training<\/title>\n<meta name=\"description\" content=\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\" \/>\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.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TSQL Course | Transact SQL Training\" \/>\n<meta property=\"og:description\" content=\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Server Consultancy and SQL Server Training\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-01T13:16:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-16T15:55:34+00:00\" \/>\n<meta name=\"author\" content=\"John Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sequallity\" \/>\n<meta name=\"twitter:site\" content=\"@sequallity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\"},\"author\":{\"name\":\"John Parker\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\"},\"headline\":\"TSQL Course | Transact SQL Training\",\"datePublished\":\"2019-11-01T13:16:22+00:00\",\"dateModified\":\"2020-01-16T15:55:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\"},\"wordCount\":746,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"articleSection\":[\"SQL Server Training\",\"Transact-SQL Course\",\"TSQL Course\",\"TSQL Training\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\",\"name\":\"How to find T-SQL Courses | Transact SQL Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\"},\"datePublished\":\"2019-11-01T13:16:22+00:00\",\"dateModified\":\"2020-01-16T15:55:34+00:00\",\"description\":\"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Training\",\"item\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/sql-server-training\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TSQL Course | Transact SQL Training\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"name\":\"SQL Server Consultancy and SQL Server Training\",\"description\":\"where SQL and Quality join...\",\"publisher\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization\",\"name\":\"Sequallity Limited\",\"url\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"contentUrl\":\"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg\",\"width\":800,\"height\":229,\"caption\":\"Sequallity Limited\"},\"image\":{\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/\",\"https:\/\/twitter.com\/sequallity\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f\",\"name\":\"John Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g\",\"caption\":\"John Parker\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to find T-SQL Courses | Transact SQL Training","description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","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.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/","og_locale":"en_GB","og_type":"article","og_title":"TSQL Course | Transact SQL Training","og_description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","og_url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/","og_site_name":"SQL Server Consultancy and SQL Server Training","article_publisher":"https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","article_published_time":"2019-11-01T13:16:22+00:00","article_modified_time":"2020-01-16T15:55:34+00:00","author":"John Parker","twitter_card":"summary_large_image","twitter_creator":"@sequallity","twitter_site":"@sequallity","twitter_misc":{"Written by":"John Parker","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#article","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/"},"author":{"name":"John Parker","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f"},"headline":"TSQL Course | Transact SQL Training","datePublished":"2019-11-01T13:16:22+00:00","dateModified":"2020-01-16T15:55:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/"},"wordCount":746,"commentCount":0,"publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"articleSection":["SQL Server Training","Transact-SQL Course","TSQL Course","TSQL Training"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/","name":"How to find T-SQL Courses | Transact SQL Training","isPartOf":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website"},"datePublished":"2019-11-01T13:16:22+00:00","dateModified":"2020-01-16T15:55:34+00:00","description":"Sequallity are a SQL Server Consultancy since 2005. Here is their SQL Server blog. All comments are opinions of the Authors.","breadcrumb":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/tsql-course-transact-sql-training\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/"},{"@type":"ListItem","position":2,"name":"SQL Server Training","item":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/sql-server-training\/"},{"@type":"ListItem","position":3,"name":"TSQL Course | Transact SQL Training"}]},{"@type":"WebSite","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#website","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","name":"SQL Server Consultancy and SQL Server Training","description":"where SQL and Quality join...","publisher":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#organization","name":"Sequallity Limited","url":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/","url":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","contentUrl":"https:\/\/www.sequallity.co.uk\/wp-content\/uploads\/2018\/09\/Sequality_Logo_Blue-Cyan-Blend_Large.jpg","width":800,"height":229,"caption":"Sequallity Limited"},"image":{"@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Sequallity-Ltd-437772140011198\/","https:\/\/twitter.com\/sequallity"]},{"@type":"Person","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/a607249919447f52446059e05c32ae4f","name":"John Parker","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a7f67ba401f89da69efc12c5309f35c08d867db69cddc738a4ab325da67106c3?s=96&d=monsterid&r=g","caption":"John Parker"}}]}},"_links":{"self":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/592","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/comments?post=592"}],"version-history":[{"count":9,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/592\/revisions"}],"predecessor-version":[{"id":662,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/posts\/592\/revisions\/662"}],"wp:attachment":[{"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/media?parent=592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/categories?post=592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sequallity.co.uk\/sql-server-consultancy\/wp-json\/wp\/v2\/tags?post=592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}