{"id":15844,"date":"2026-08-10T11:59:19","date_gmt":"2026-08-10T11:59:19","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/julia-evans-become-a-select-star-wizard-zines-2020\/"},"modified":"2026-08-10T11:59:19","modified_gmt":"2026-08-10T11:59:19","slug":"julia-evans-become-a-select-star-wizard-zines-2020","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/julia-evans-become-a-select-star-wizard-zines-2020\/","title":{"rendered":"Julia Evans \u2013 Become a SELECT Star (Wizard Zines) 2020"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2><span dir=\"auto\" style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">Become a SELECT Star (Wizard Zines) takes a different approach to the SQL query language, focusing on the internal logic of databases rather than repeating dry statements. Julia Evans explains why the structure of SQL statements can sometimes seem strange and how understanding the order in which operations are executed in a database can help you write more efficient queries. This book is designed for those who are familiar with the basic commands but are confused by complex queries or unexpected database behavior (such as how to handle NULL values).<\/span><\/p>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">In the second part of the book, the author moves on to more advanced concepts that are often overlooked in introductory tutorials. Using illustrative examples, he illustrates the power of \u201cwindow functions,\u201d which are crucial for temporal and comparative analysis of large data sets. The book emphasizes that SQL is not simply a language for extracting data, but a tool for structured thinking. By reading this work, the reader will learn how to force the database to perform heavy calculations to avoid transferring huge amounts of data to the application.<\/span><\/p>\n<h3 data-path-to-node=\"3\"><span dir=\"auto\" style=\"vertical-align: inherit\">Book Features<\/span><\/h3>\n<ul>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">A detailed explanation of the order in which commands are executed in SQL (which is different from the order in which they are written).<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Learn how JOIN types work and their impact on combining different tables.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Examine the specific behaviors of the NULL value and the common errors it causes in data comparisons.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Learn Window Functions to perform advanced calculations on related rows.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">A guide to using indexes to dramatically improve query speed.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Provide practical methods for simplifying complex, nested queries into understandable parts.<\/span><\/li>\n<\/ul>\n<h3 data-path-to-node=\"15\"><span dir=\"auto\" style=\"vertical-align: inherit\">Book specifications<\/span><\/h3>\n<ul>\n<li data-path-to-node=\"16,0,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?jvns.ca\/blog\/2020\/02\/03\/new-zine--become-a-select-star\/\" target=\"_blank\" rel=\"nofollow noopener\"><span dir=\"auto\" style=\"vertical-align: inherit\">Julia Evans<\/span><\/a><\/li>\n<li data-path-to-node=\"16,1,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/julia-evans\/\"><span dir=\"auto\" style=\"vertical-align: inherit\">Julia Evans<\/span><\/a><\/li>\n<li data-path-to-node=\"16,3,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Number of pages: 28<\/span><\/li>\n<li data-path-to-node=\"16,4,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Format: PDF<\/span><\/li>\n<\/ul>\n<h3><strong><span dir=\"auto\" style=\"vertical-align: inherit\">Headlines<\/span><\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1026458 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/12\/Become-a-SELECT-Star-Wizard-Zines131.png\" alt=\"Become a SELECT Star (Wizard Zines)\" width=\"595\" height=\"867\"><\/p>\n<h3><span dir=\"auto\" style=\"vertical-align: inherit\">Pictures<\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1026457 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/12\/Become-a-SELECT-Star-Wizard-Zines1.png\" alt=\"Become a SELECT Star (Wizard Zines)\" width=\"740\" height=\"93\"><\/p>\n<h3><span dir=\"auto\" style=\"vertical-align: inherit\">User Guide<\/span><\/h3>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">Extract the file and run it with the appropriate software.<\/span><\/p>\n<h3><span dir=\"auto\" style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl3.downloadly.ir\/Files\/Elearning\/Julia_Evans_Become_a_SELECT_Star_Wizard_Zines_2020_Downloadly.ir.rar?nocache=1785940735\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download file \u2013 18.9 MB<\/span><\/a><\/p>\n<h5><span dir=\"auto\" style=\"vertical-align: inherit\">File(s) password: <\/span><a><span dir=\"auto\" style=\"vertical-align: inherit\">www.downloadly.ir<\/span><\/a><\/h5>\n<h3><span dir=\"auto\" style=\"vertical-align: inherit\">File size<\/span><\/h3>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">18.9 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Become a SELECT Star (Wizard Zines) takes a different approach to the SQL query language, focusing on the internal logic of databases rather than re<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[127485],"dgi_tag":[127797,127798,127799,127800,127801,127802,127803,127759],"class_list":["post-15844","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-ebook","dgi_tag-become-a-select-star-wizard-zines","dgi_tag-become-a-select-star-wizard-zines-book","dgi_tag-become-a-select-star-wizard-zines-download","dgi_tag-download-become-a-select-star-wizard-zines","dgi_tag-download-become-a-select-star-wizard-zines-book","dgi_tag-free-become-a-select-star-wizard-zines","dgi_tag-free-download-become-a-select-star-wizard-zines","dgi_tag-julia-evans"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/15844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/15844\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=15844"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=15844"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=15844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}