{"id":4166,"date":"2022-12-03T14:00:36","date_gmt":"2022-12-03T14:00:36","guid":{"rendered":"https:\/\/koeky.nl\/boeken\/product\/sql-pocket-guide-4th-edition\/"},"modified":"2022-12-03T14:00:40","modified_gmt":"2022-12-03T14:00:40","slug":"sql-pocket-guide-4th-edition","status":"publish","type":"product","link":"https:\/\/koeky.nl\/boeken\/product\/sql-pocket-guide-4th-edition\/","title":{"rendered":"SQL Pocket Guide, 4th Edition"},"content":{"rendered":"<p>A Guide to SQL Usage<\/p>\n<p>If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference.<\/p>\n<p>&nbsp;<\/p>\n<p>Auteur: Alice  Zhao<\/p>\n<p>Taal: Engels<\/p>\n<p>Bindwijze: paperback<\/p>\n<p>Rubriek: IT-management \/ ICT<\/p>\n<p>Leverbaarheid: Direct leverbaar<\/p>\n<p>Uitgever: O&#8217;Reilly<\/p>\n<p>Verschijningsdatum: 2021-09-30T00:00:00+02:00<\/p>\n<p>Trefwoord:<br \/>\nProgrammeren<br \/>\ndatabasebeheer<br \/>\nSQL<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You&#8217;ll find many examples that address the language&#8217;s complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.&#13;<br \/>\n&#13;<br \/>\nIn this updated edition, author Alice Zhao describes how these database management systems implement SQL syntax for both querying and making changes to a database. You&#8217;ll find details on data types and conversions, regular expression syntax, window functions, pivoting and unpivoting, and more.&#13;<br \/>\n&#13;<br \/>\n&#8211; Quickly look up how to perform specific tasks using SQL&#13;<br \/>\n&#8211; Apply the book&#8217;s syntax examples to your own queries&#13;<br \/>\n&#8211; Update SQL queries to work in five different database management systems&#13;<br \/>\n&#8211; NEW: Connect Python and R to a relational database&#13;<br \/>\n&#8211; NEW: Look up frequently asked SQL questions in the &#8220;How Do I?&#8221; chapter<\/p>\n","protected":false},"featured_media":4167,"comment_status":"closed","ping_status":"open","template":"","meta":[],"product_brand":[],"product_cat":[24],"product_tag":[],"class_list":{"0":"post-4166","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-it-management-ict","8":"first","9":"instock","10":"product-type-external"},"_links":{"self":[{"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/product\/4166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/comments?post=4166"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/media\/4167"}],"wp:attachment":[{"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/media?parent=4166"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/product_brand?post=4166"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/product_cat?post=4166"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/koeky.nl\/boeken\/wp-json\/wp\/v2\/product_tag?post=4166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}