{"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 – Learn SQL with simple, interactive exercises"},"content":{"rendered":"\n

\"\"<\/a><\/p>\n

SQLBolt<\/a> is by far the best SQL tutorial that I’ve ever seen!\u00a0 Yes, I know, it’s a very bold statement.\u00a0 But I promise that it’s true.<\/p>\n

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.\u00a0 But SQLBolt provides a giant leap forward in this area.<\/p>\n

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’t have to install a database or get access to a real one, and you don’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

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

There is really no reason now for anybody at all to learn SQL.\u00a0 SQLBolt is brilliant!<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

SQLBolt is by far the best SQL tutorial that I’ve ever seen!\u00a0 Yes, I know, it’s a very bold statement.\u00a0 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.\u00a0 But … Continue reading SQLBolt – Learn SQL with simple, interactive exercises<\/span><\/a><\/p>\n\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_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},"_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":[],"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 "All"","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 – 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 "All"","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 "All"","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 "All"","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 – 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 "All"","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 – 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 "All"","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}]}}