{"id":3557,"date":"2023-10-23T10:15:08","date_gmt":"2023-10-23T09:15:08","guid":{"rendered":"https:\/\/kudzia.eu\/b\/?p=3557"},"modified":"2024-05-05T20:02:33","modified_gmt":"2024-05-05T19:02:33","slug":"resources-for-learning-sql","status":"publish","type":"post","link":"https:\/\/kudzia.eu\/b\/2023\/10\/resources-for-learning-sql\/","title":{"rendered":"resources for learning SQL"},"content":{"rendered":"\n<p>SQL basics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/sqlbolt.com\/\">https:\/\/sqlbolt.com\/<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/cs50.harvard.edu\/sql\/2023\/\">https:\/\/cs50.harvard.edu\/sql\/2023\/<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selectstarsql.com\/\">https:\/\/selectstarsql.com\/<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/mystery.knightlab.com\/\">https:\/\/mystery.knightlab.com\/<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/news.ycombinator.com\/item?id=35665142\">https:\/\/news.ycombinator.com\/item?id=35665142<\/a> + <a href=\"https:\/\/news.ycombinator.com\/item?id=31355809\">https:\/\/news.ycombinator.com\/item?id=31355809<\/a> + <a href=\"https:\/\/lost-at-sql.therobinlord.com\/\">https:\/\/lost-at-sql.therobinlord.com\/<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/news.ycombinator.com\/item?id=35247242\">https:\/\/news.ycombinator.com\/item?id=35247242<\/a> &#8211; mysql for developers e-learning<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/gvwilson.github.io\/sql-tutorial\">https:\/\/gvwilson.github.io\/sql-tutorial<\/a><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.databasestar.com\/sql-roadmap\">https:\/\/www.databasestar.com\/sql-roadmap<\/a> + <a href=\"https:\/\/www.databasestar.com\/vip\">https:\/\/www.databasestar.com\/vip<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>indexes: <a href=\"https:\/\/use-the-index-luke.com\/\">https:\/\/use-the-index-luke.com\/<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>&#8216;modern&#8217; SQL:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/modern-sql.com\/\">https:\/\/modern-sql.com\/<\/a> <\/li>\n\n\n\n<li><a href=\"https:\/\/15445.courses.cs.cmu.edu\/fall2023\/slides\/02-modernsql.pdf\">https:\/\/15445.courses.cs.cmu.edu\/fall2023\/slides\/02-modernsql.pdf<\/a> from great lectures by <a href=\"https:\/\/www.cs.cmu.edu\/~pavlo\/\">Andy Pavlo<\/a><\/li>\n<\/ul>\n\n\n\n<p> fiddles &#8211; web-based sandboxes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/sqlfiddle.com\/\">https:\/\/sqlfiddle.com\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.db-fiddle.com\/\">https:\/\/www.db-fiddle.com\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/play.clickhouse.com\/\">https:\/\/play.clickhouse.com\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>SQL basics: indexes: https:\/\/use-the-index-luke.com\/ &#8216;modern&#8217; SQL: fiddles &#8211; web-based sandboxes:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[],"class_list":["post-3557","post","type-post","status-publish","format-standard","hentry","category-unimportant"],"_links":{"self":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/comments?post=3557"}],"version-history":[{"count":4,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3557\/revisions"}],"predecessor-version":[{"id":3622,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/posts\/3557\/revisions\/3622"}],"wp:attachment":[{"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/media?parent=3557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/categories?post=3557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kudzia.eu\/b\/wp-json\/wp\/v2\/tags?post=3557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}