{"id":2818,"date":"2017-01-11T16:11:48","date_gmt":"2017-01-11T14:11:48","guid":{"rendered":"https:\/\/voxxeddays.com\/bucharest\/?p=2818"},"modified":"2017-01-11T16:11:48","modified_gmt":"2017-01-11T14:11:48","slug":"modern-sql","status":"publish","type":"post","link":"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/","title":{"rendered":"Modern SQL"},"content":{"rendered":"<h2>Modern SQL<\/h2>\n<p><img loading=\"lazy\" class=\"image-medalion-post alignright wp-image-1971\" src=\"https:\/\/incremental.community\/wp-content\/uploads\/2017\/01\/markus-winand.png\" alt=\"Markus Winard\" width=\"130\" height=\"130\" \/><\/p>\n<blockquote>\n<p class=\"p1\"><span class=\"s1\"><a href=\"https:\/\/twitter.com\/@MarkusWinand\">Markus Winand<\/a> teaches efficient SQL. He covers both aspects: the development time to accomplish a task using SQL as well as the runtime of the final solution. He also published the book \u201cSQL Performance Explained\u201c and is currently working on his next book, which is being published on an ongoing basis at <a href=\"http:\/\/modern-sql.com\/\">http:\/\/modern-sql.com\/<\/a><\/span><\/p>\n<\/blockquote>\n<p class=\"p1\"><span class=\"s1\">A lot has changed since SQL-92. This session goes through some SQL features introduced by later standards, shows which databases support them and demos how these features solve every day problems more easily. Topics covered include: processing graphs, more powerful aggregations, ranking and more.<\/span><span class=\"s1\"><br \/>\nAs a matter of fact, most textbooks, websites, and even universities teach SQL as it was 25 years ago (SQL-92). In the meantime, SQL evolved into a more modern data processing language that is not limited to relational algebra anymore. Although many databases support more modern SQL for years, hardly any developer knows how the new features can be used to solve common problems. This session is, therefore, not limited to explaining SQL features but also compares the SQL-92 solution to common problems to the more modern solution to make the benefit directly visible. Finally, the session also shows how long these features are supported by various databases so that you immediately know whether the shown solution works in your environment or not.<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modern SQL Markus Winand teaches efficient SQL. He covers both aspects: the development time to accomplish a task using SQL as well as the runtime of the final solution. He also published the book \u201cSQL Performance Explained\u201c and is currently working on his next book, which is being published on an ongoing basis at http:\/\/modern-sql.com\/ [&hellip;]<\/p>\n","protected":false},"author":7816,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Modern SQL - Voxxed Days Greece<\/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:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Modern SQL - Voxxed Days Greece\" \/>\n<meta property=\"og:description\" content=\"Modern SQL Markus Winand teaches efficient SQL. He covers both aspects: the development time to accomplish a task using SQL as well as the runtime of the final solution. He also published the book \u201cSQL Performance Explained\u201c and is currently working on his next book, which is being published on an ongoing basis at http:\/\/modern-sql.com\/ [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Voxxed Days Greece\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/voxxedbucharest\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-11T14:11:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/incremental.community\/wp-content\/uploads\/2017\/01\/markus-winand.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@VoxxedBucharest\" \/>\n<meta name=\"twitter:site\" content=\"@VoxxedBucharest\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"alexproca\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/voxxeddays.com\/greece\/#website\",\"url\":\"https:\/\/voxxeddays.com\/greece\/\",\"name\":\"Voxxed Days Greece\",\"description\":\"Another Voxxed event\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/voxxeddays.com\/greece\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/incremental.community\/wp-content\/uploads\/2017\/01\/markus-winand.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/#webpage\",\"url\":\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/\",\"name\":\"Modern SQL - Voxxed Days Greece\",\"isPartOf\":{\"@id\":\"https:\/\/voxxeddays.com\/greece\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/#primaryimage\"},\"datePublished\":\"2017-01-11T14:11:48+00:00\",\"dateModified\":\"2017-01-11T14:11:48+00:00\",\"author\":{\"@id\":\"https:\/\/voxxeddays.com\/greece\/#\/schema\/person\/3610fff738a03b155237ab4707e803eb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/voxxeddays.com\/greece\/2017\/01\/11\/modern-sql\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/voxxeddays.com\/greece\/#\/schema\/person\/3610fff738a03b155237ab4707e803eb\",\"name\":\"alexproca\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/voxxeddays.com\/greece\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb9bbcf4c88be28b95644b3697985fcb?s=96&d=mm&r=g\",\"caption\":\"alexproca\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/posts\/2818"}],"collection":[{"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/users\/7816"}],"replies":[{"embeddable":true,"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/comments?post=2818"}],"version-history":[{"count":0,"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/posts\/2818\/revisions"}],"wp:attachment":[{"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/media?parent=2818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/categories?post=2818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/voxxeddays.com\/greece\/wp-json\/wp\/v2\/tags?post=2818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}