{"appState":{"pageLoadApiCallsStatus":true},"bookState":{"book":{"headers":{"timestamp":"2024-04-15T08:12:26+00:00"},"bookId":281870,"data":{"name":"SQL All-in-One For Dummies","title":"SQL All-in-One For Dummies","slug":"sql-all-in-one-for-dummies-3rd-edition","breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Programming & Web Design","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33592"},"slug":"programming-web-design","categoryId":33592},{"name":"SQL","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33608"},"slug":"sql","categoryId":33608}],"description":"<p><b>The most thorough SQL reference, now updated for SQL:2023</b> <p><i>SQL All-in-One For Dummies </i>has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there’s no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career. <ul> <li>Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts</li> <li>Read clear explanations of SQL code and learn to write complex queries</li> <li>Discover how to apply SQL in real-world situations to gain control over large datasets</li> <li>Enjoy a thorough reference to common tasks and issues in SQL development</li></ul><p>This Dummies All-in-One guide is for all SQL users—from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.","bookOutOfPrint":true,"testBankPinActivationLink":"","publishedDate":"2019-04-23T12:11:14+00:00","primaryISBN":"9781394242290","secondaryISBNs":"9781119569596,9781119569602,9781119569619","learningType":"Advance","primaryCategory":{"categoryId":33608,"title":"SQL","slug":"sql","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33608"}},"secondaryCategory":{"categoryId":0,"title":null,"slug":null,"_links":null},"amazon":{"default":"https://www.amazon.com/gp/product/1394242298/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1394242298/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1394242298-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1394242298/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1394242298/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/covers/9781119569619.jpg","width":250,"height":350},"authors":[{"authorId":9559,"name":"Allen G. Taylor","slug":"allen-g-taylor","description":" <p><b>Allen G. Taylor </b>is a 40-year veteran of the computer industry and the author of more than 40 books, including <i>SQL For Dummies </i>and <i>Database Development For Dummies.</i> For the latest news on Allen’s activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at [email protected].</p> ","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/9559"}},{"authorId":10600,"name":"Richard Blum","slug":"richard-blum","description":" <p><b>Allen G. Taylor </b>is a 40-year veteran of the computer industry and the author of more than 40 books, including <i>SQL For Dummies </i>and <i>Database Development For Dummies.</i> For the latest news on Allen’s activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at [email protected].</p> ","hasArticle":true,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/10600"}}],"relatedArticles":{"_links":{"self":"https://dummies-api.dummies.com/v2/articles?book=281870&offset=0&size=5"}},"relatedBooks":[{"bookId":292579,"name":"Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies","slug":"microsoft-sql-server-2008-all-in-one-desk-reference-for-dummies","primaryCategory":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"categoryList":["technology","software","microsoft-products","general-microsoft"],"image":{"src":null,"width":0,"height":0},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292579"}},{"bookId":281871,"name":"SQL For Dummies","slug":"sql-for-dummies-9th-edition","primaryCategory":{"categoryId":33608,"title":"SQL","slug":"sql","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33608"}},"categoryList":["technology","programming-web-design","sql"],"image":{"src":"https://www.dummies.com/covers/9781119527077.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281871"}},{"bookId":292959,"name":"Oracle PL / SQL For Dummies","slug":"oracle-pl-sql-for-dummies","primaryCategory":{"categoryId":33608,"title":"SQL","slug":"sql","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33608"}},"categoryList":["technology","programming-web-design","sql"],"image":{"src":"https://www.dummies.com/covers/9780764599576.jpg","width":250,"height":350},"_links":{"self":"https://dummies-api.dummies.com/v2/books/292959"}}],"cheatSheet":{"articleId":208690,"slug":"sql-all-in-one-for-dummies-cheat-sheet","title":"SQL All-in-One For Dummies Cheat Sheet","description":"SQL is a popular and useful programming language. You can make SQL even more useful if you know the phases of SQL development, the criteria for normal forms, the data types used by SQL, a little bit about set and value functions, as well as some tips on how to filter tables with WHERE clauses.","categoryList":["technology","programming-web-design","sql"]},"bookAuthorBio":"<p><b data-author-id=\"9559\">Allen G. Taylor </b>is a 40-year veteran of the computer industry and the author of more than 40 books, including <i>SQL For Dummies </i>and <i>Database Development For Dummies.</i> For the latest news on Allen’s activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at [email protected].</p>","additionalResourceLink":"","bookCompanionPage":{"pageId":0,"name":null,"slug":null,"_links":null},"seo":{"metaDescription":"","noIndex":0,"noFollow":0}},"_links":{"self":"https://dummies-api.dummies.com/v2/books/281870"}},"bookLoadedStatus":"success","bookExtras":{},"bookExtrasLoadedStatus":"initial"},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-04-15T10:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Book3","path":"/book/technology/programming-web-design/sql/sql-all-in-one-for-dummies-3rd-edition-281870/","hash":"","query":{},"params":{"category1":"technology","category2":"programming-web-design","category3":"sql","book":"sql-all-in-one-for-dummies-3rd-edition-281870"},"fullPath":"/book/technology/programming-web-design/sql/sql-all-in-one-for-dummies-3rd-edition-281870/","meta":{"routeType":"book","breadcrumbInfo":{"suffix":"Books","baseRoute":"/category/books"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

SQL All-in-One For Dummies book cover

SQL All-in-One For Dummies

Authors:

Allen G. Taylor ,

Overview

The most thorough SQL reference, now updated for SQL:2023

SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there’s no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming environment. Become a SQL guru and turn the page on the next chapter of your coding career.

Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts
Read clear explanations of SQL code and learn to write complex queries
Discover how to apply SQL in real-world situations to gain control over large datasets
Enjoy a thorough reference to common tasks and issues in SQL development

This Dummies All-in-One guide is for all SQL users—from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.

The most thorough SQL reference, now updated for SQL:2023

SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there’s no end in sight to the need for SQL know-how. You can take your career to the next level with this guide to creating databases, accessing and editing data, protecting data from corruption, and integrating SQL with other languages in a programming

environment. Become a SQL guru and turn the page on the next chapter of your coding career.

Get 7 mini-books in one, covering basic SQL, database development, and advanced SQL concepts
Read clear explanations of SQL code and learn to write complex queries
Discover how to apply SQL in real-world situations to gain control over large datasets
Enjoy a thorough reference to common tasks and issues in SQL development

This Dummies All-in-One guide is for all SQL users—from beginners to more experienced programmers. Find the info and the examples you need to reach the next stage in your SQL journey.

SQL All-in-One For Dummies Cheat Sheet

SQL is a popular and useful programming language. You can make SQL even more useful if you know the phases of SQL development, the criteria for normal forms, the data types used by SQL, a little bit about set and value functions, as well as some tips on how to filter tables with WHERE clauses.

About The Authors

Allen G. Taylor is a 40-year veteran of the computer industry and the author of more than 40 books, including SQL For Dummies and Database Development For Dummies. For the latest news on Allen’s activities, check out his online courses (at pioneer-academy1.teachable.com) and his blog (at www.allengtaylor.com). You can contact Allen at [email protected].