{"id":28425,"date":"2018-03-09T04:08:38","date_gmt":"2018-03-09T02:08:38","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28425"},"modified":"2018-03-09T04:08:38","modified_gmt":"2018-03-09T02:08:38","slug":"sqlbolt-learn-sql-with-simple-interactive-exercises","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/","title":{"rendered":"SQLBolt &#8211; Learn SQL with simple, interactive exercises"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p><a href=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"28426\" data-permalink=\"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/sqlbolt\/\" data-orig-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?fit=1186%2C868&amp;ssl=1\" data-orig-size=\"1186,868\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"sqlbolt\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?fit=660%2C483&amp;ssl=1\" class=\"aligncenter size-medium wp-image-28426\" src=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt-500x366.png?resize=500%2C366&#038;ssl=1\" alt=\"\" width=\"500\" height=\"366\" srcset=\"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?resize=500%2C366&amp;ssl=1 500w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?resize=768%2C562&amp;ssl=1 768w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?resize=1024%2C749&amp;ssl=1 1024w, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt.png?w=1186&amp;ssl=1 1186w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/sqlbolt.com\/\">SQLBolt<\/a> is by far the best SQL tutorial that I&#8217;ve ever seen!\u00a0 Yes, I know, it&#8217;s a very bold statement.\u00a0 But I promise that it&#8217;s true.<\/p>\n<p>With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn&#8217;t been sold.\u00a0 But SQLBolt provides a giant leap forward in this area.<\/p>\n<p>The tutorial starts from the very basics and gets progressively more and more advanced.\u00a0 But this progression is divided into small, very focused chapters.\u00a0 Each chapter provides a brief description of the concept, an example query for the concept, and a set of exercises.\u00a0 The exercises are all interactive, so that you don&#8217;t have to install a database or get access to a real one, and you don&#8217;t have to trust yourself on correctly solving the tasks.\u00a0 The interactive exercises system marks the problem as solved the moment you type in the correct query.<\/p>\n<p>If you get stuck at any point with any particular exercises, just click on the Solution link nearby, and the tutorial will show you the correct answer.\u00a0 I found this to be a perfect balance between forcing the reader to try things out, but without the annoying delays for those of us who like to skip ahead.<\/p>\n<p>There is really no reason now for anybody at all to learn SQL.\u00a0 SQLBolt is brilliant!<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>SQLBolt is by far the best SQL tutorial that I&#8217;ve ever seen!\u00a0 Yes, I know, it&#8217;s a very bold statement.\u00a0 But I promise that it&#8217;s true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn&#8217;t been sold.\u00a0 But &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQLBolt &#8211; Learn SQL with simple, interactive exercises<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"SQLBolt - Learn SQL with simple, interactive exercises #databases #SQL #tutorials #courses","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,18,62,1334],"tags":[1192,1559,773,80],"keyring_services":[],"class_list":["post-28425","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-technology","category-web-work","tag-computer-science","tag-databases","tag-sql","tag-tutorials"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"SQLBolt is by far the best SQL tutorial that I&#039;ve ever seen! Yes, I know, it&#039;s a very bold statement. But I promise that it&#039;s true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn&#039;t been sold. But\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Leonid Mamchenkov\"\/>\n\t<meta name=\"google-site-verification\" content=\"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Leonid Mamchenkov - Life, universe, and everything else\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov\" \/>\n\t\t<meta property=\"og:description\" content=\"SQLBolt is by far the best SQL tutorial that I&#039;ve ever seen! Yes, I know, it&#039;s a very bold statement. But I promise that it&#039;s true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn&#039;t been sold. But\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2018-03-09T02:08:38+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2018-03-09T02:08:38+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MamchenkovBlog\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov\" \/>\n\t\t<meta name=\"twitter:description\" content=\"SQLBolt is by far the best SQL tutorial that I&#039;ve ever seen! Yes, I know, it&#039;s a very bold statement. But I promise that it&#039;s true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn&#039;t been sold. But\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@mamchenkov\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#blogposting\",\"name\":\"SQLBolt \\u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov\",\"headline\":\"SQLBolt &#8211; Learn SQL with simple, interactive exercises\",\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2018\\\/03\\\/sqlbolt-500x366.png\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#articleImage\"},\"datePublished\":\"2018-03-09T04:08:38+02:00\",\"dateModified\":\"2018-03-09T04:08:38+02:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#webpage\"},\"articleSection\":\"All, Programming, Technology, Web work, Computer Science, databases, sql, tutorials\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"position\":2,\"name\":\"Technology\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"name\":\"Programming\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"position\":3,\"name\":\"Programming\",\"item\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#listItem\",\"name\":\"SQLBolt &#8211; Learn SQL with simple, interactive exercises\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/#listItem\",\"name\":\"Technology\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#listItem\",\"position\":4,\"name\":\"SQLBolt &#8211; Learn SQL with simple, interactive exercises\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/category\\\/technology\\\/programming\\\/#listItem\",\"name\":\"Programming\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/\",\"name\":\"Leonid Mamchenkov\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g\",\"width\":96,\"height\":96,\"caption\":\"Leonid Mamchenkov\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#webpage\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/\",\"name\":\"SQLBolt \\u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov\",\"description\":\"SQLBolt is by far the best SQL tutorial that I've ever seen! Yes, I know, it's a very bold statement. But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn't been sold. But\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/2018\\\/03\\\/09\\\/sqlbolt-learn-sql-with-simple-interactive-exercises\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/author\\\/leonid\\\/#author\"},\"datePublished\":\"2018-03-09T04:08:38+02:00\",\"dateModified\":\"2018-03-09T04:08:38+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/\",\"name\":\"Blog of Leonid Mamchenkov\",\"description\":\"Life, universe, and everything else\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/mamchenkov.net\\\/wordpress\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov","description":"SQLBolt is by far the best SQL tutorial that I've ever seen! Yes, I know, it's a very bold statement. But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn't been sold. But","canonical_url":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"VHvdD0_usx1_4DzKy_QCVcICVgX2EgA2ybELT-wl7kQ","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#blogposting","name":"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov","headline":"SQLBolt &#8211; Learn SQL with simple, interactive exercises","author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/03\/sqlbolt-500x366.png","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#articleImage"},"datePublished":"2018-03-09T04:08:38+02:00","dateModified":"2018-03-09T04:08:38+02:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#webpage"},"isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#webpage"},"articleSection":"All, Programming, Technology, Web work, Computer Science, databases, sql, tutorials"},{"@type":"BreadcrumbList","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","position":1,"name":"Home","item":"https:\/\/mamchenkov.net\/wordpress","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","position":2,"name":"Technology","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","name":"Programming"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","position":3,"name":"Programming","item":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/","nextItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#listItem","name":"SQLBolt &#8211; Learn SQL with simple, interactive exercises"},"previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/#listItem","name":"Technology"}},{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#listItem","position":4,"name":"SQLBolt &#8211; Learn SQL with simple, interactive exercises","previousItem":{"@type":"ListItem","@id":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/#listItem","name":"Programming"}}]},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/#person","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"Person","@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author","url":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/","name":"Leonid Mamchenkov","image":{"@type":"ImageObject","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cf6df002a284d78fb6e9d8222ca4d102e0832035ed6bc8447008bd234e131a4?s=96&d=identicon&r=g","width":96,"height":96,"caption":"Leonid Mamchenkov"}},{"@type":"WebPage","@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#webpage","url":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/","name":"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov","description":"SQLBolt is by far the best SQL tutorial that I've ever seen! Yes, I know, it's a very bold statement. But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn't been sold. But","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#website"},"breadcrumb":{"@id":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/#breadcrumblist"},"author":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"creator":{"@id":"https:\/\/mamchenkov.net\/wordpress\/author\/leonid\/#author"},"datePublished":"2018-03-09T04:08:38+02:00","dateModified":"2018-03-09T04:08:38+02:00"},{"@type":"WebSite","@id":"https:\/\/mamchenkov.net\/wordpress\/#website","url":"https:\/\/mamchenkov.net\/wordpress\/","name":"Blog of Leonid Mamchenkov","description":"Life, universe, and everything else","inLanguage":"en-US","publisher":{"@id":"https:\/\/mamchenkov.net\/wordpress\/#person"}}]},"og:locale":"en_US","og:site_name":"Leonid Mamchenkov - Life, universe, and everything else","og:type":"article","og:title":"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov","og:description":"SQLBolt is by far the best SQL tutorial that I've ever seen! Yes, I know, it's a very bold statement. But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn't been sold. But","og:url":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/","og:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:secure_url":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg","og:image:width":1024,"og:image:height":1024,"article:published_time":"2018-03-09T02:08:38+00:00","article:modified_time":"2018-03-09T02:08:38+00:00","article:publisher":"https:\/\/www.facebook.com\/MamchenkovBlog","twitter:card":"summary_large_image","twitter:site":"@mamchenkov","twitter:title":"SQLBolt \u2013 Learn SQL with simple, interactive exercises - Leonid Mamchenkov","twitter:description":"SQLBolt is by far the best SQL tutorial that I've ever seen! Yes, I know, it's a very bold statement. But I promise that it's true. With hundreds of books, videos, and other tutorials around, the problem of delivering the understanding of data management, databases, and SQL to regular people still hasn't been sold. But","twitter:creator":"@mamchenkov","twitter:image":"https:\/\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2026\/03\/leonid-sailing-beer.jpg"},"aioseo_meta_data":{"post_id":"28425","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-07-19 19:27:10","updated":"2026-01-15 13:32:09","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/\" title=\"Technology\">Technology<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/\" title=\"Programming\">Programming<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQLBolt \u2013 Learn SQL with simple, interactive exercises\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/mamchenkov.net\/wordpress"},{"label":"Technology","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/"},{"label":"Programming","link":"https:\/\/mamchenkov.net\/wordpress\/category\/technology\/programming\/"},{"label":"SQLBolt &#8211; Learn SQL with simple, interactive exercises","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/03\/09\/sqlbolt-learn-sql-with-simple-interactive-exercises\/"}],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":24803,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/10\/03\/sql-vs-nosql-how-to-choose\/","url_meta":{"origin":28425,"position":0},"title":"SQL vs NoSQL: How to Choose","author":"Leonid Mamchenkov","date":"October 3, 2015","format":false,"excerpt":"\"SQL vs NoSQL: How to Choose\" article continues the discussion of SQL vs. NoSQL from the \"SQL vs NoSQL: The Differences\" article. \u00a0Both should be read in full. \u00a0But I'll keep the summary here for future use. SQL databases: store related data in tables require a schema which defines tables\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28562,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/05\/08\/database-flow-modern-self-hosted-web-interface-for-sql-and-graphql\/","url_meta":{"origin":28425,"position":1},"title":"Database Flow &#8211; modern, self-hosted web interface for SQL and GraphQL","author":"Leonid Mamchenkov","date":"May 8, 2018","format":false,"excerpt":"Database Flow is a modern, Open Source, self-hosted, web-based tool for working with SQL databases and GraphQL APIs.\u00a0 It supports a variety of the database engines: IBM DB2, Oracle, H2, PostgreSQL, MySQL, SQLite, Informix, and Microsoft SQL Server.\u00a0 It features an advanced SQL editor, query plan analyzer, GraphQL client, schema\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/05\/database-flow-500x281.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":24512,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/07\/28\/sql-style-guide\/","url_meta":{"origin":28425,"position":2},"title":"SQL Style Guide","author":"Leonid Mamchenkov","date":"July 28, 2015","format":"link","excerpt":"SQL Style Guide - much needed!","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17993,"url":"https:\/\/mamchenkov.net\/wordpress\/2013\/04\/12\/sql-joins\/","url_meta":{"origin":28425,"position":3},"title":"SQL joins","author":"Leonid Mamchenkov","date":"April 12, 2013","format":"image","excerpt":"Found this one somewhere on Google+. \u00a0Handy!","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2013\/04\/SQL-joins-500x393.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":20288,"url":"https:\/\/mamchenkov.net\/wordpress\/2014\/02\/05\/textql-execute-sql-against-structured-text-like-csv-or-tsv\/","url_meta":{"origin":28425,"position":4},"title":"TextQL &#8211; execute SQL against structured text like CSV or TSV","author":"Leonid Mamchenkov","date":"February 5, 2014","format":"link","excerpt":"TextQL - execute SQL against structured text like CSV or TSV","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"textql usage","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2014\/02\/textql_usage-500x375.gif?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28898,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/10\/29\/soar-sql-optimizer-and-rewriter\/","url_meta":{"origin":28425,"position":5},"title":"SOAR &#8211; SQL Optimizer And Rewriter","author":"Leonid Mamchenkov","date":"October 29, 2018","format":false,"excerpt":"\u00a0 SOAR is an SQL Optimizer and Rewriter.\u00a0 It can help analyse, optimize, and rewrite SQL queries.\u00a0 Don't get offset by the Chinese documentation as default - there is an English translation. Here are some of the features: Cross-platform support, such as Linux, Mac, and Windows Support Heuristic Rules Suggestion\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/10\/soar-1-500x208.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=28425"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28425\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=28425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=28425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=28425"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=28425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}