1<!doctype html> 2<html class="h-100" lang="en"> 3<head> 4 <meta charset="utf-8" /> 5 <title>SQLforDevs.com - Database Tips & Tricks</title> 6 <meta name="viewport" content="width=device-width, initial-scale=1" /> 7 <meta name="description" content="Subscribe to the newsletter to be notified on future content about lesser-known secrets in databases." /> 8 <!-- Livewire Styles --><style >[wire\:loading][wire\:loading], [wire\:loading\.delay][wire\:loading\.delay], [wire\:loading\.list-item][wire\:loading\.list-item], [wire\:loading\.inline-block][wire\:loading\.inline-block], [wire\:loading\.inline][wire\:loading\.inline], [wire\:loading\.block][wire\:loading\.block], [wire\:loading\.flex][wire\:loading\.flex], [wire\:loading\.table][wire\:loading\.table], [wire\:loading\.grid][wire\:loading\.grid], [wire\:loading\.inline-flex][wire\:loading\.inline-flex] {display: none;}[wire\:loading\.delay\.none][wire\:loading\.delay\.none], [wire\:loading\.delay\.shortest][wire\:loading\.delay\.shortest], [wire\:loading\.delay\.shorter][wire\:loading\.delay\.shorter], [wire\:loading\.delay\.short][wire\:loading\.delay\.short], [wire\:loading\.delay\.default][wire\:loading\.delay\.default], [wire\:loading\.delay\.long][wire\:loading\.delay\.long], [wire\:loading\.delay\.longer][wire\:loading\.delay\.longer], [wire\:loading\.delay\.longest][wire\:loading\.delay\.longest] {display: none;}[wire\:offline][wire\:offline] {display: none;}[wire\:dirty]:not(textarea):not(input):not(select) {display: none;}:root {--livewire-progress-bar-color: #2299dd;}[x-cloak="x-cloak"],[x-cloak=""] {display: none !important;}[wire\:cloak="wire:cloak"],[wire\:cloak=""] {display: none !important;}dialog#livewire-error::backdrop {background-color: rgba(0, 0, 0, .6);}</style> 9 <link rel="preload" as="style" href="https://sqlfordevs.com/build/assets/app-BWjJr8sc.css" /><link rel="modulepreload" as="script" href="https://sqlfordevs.com/build/assets/main-CaQpsnJj.js" /><link rel="modulepreload" as="script" href="https://sqlfordevs.com/build/assets/preload-helper-CwIXHf_L.js" /><link rel="stylesheet" href="https://sqlfordevs.com/build/assets/app-BWjJr8sc.css" data-navigate-track="reload" />
9<script type="module" src="https://sqlfordevs.com/build/assets/main-CaQpsnJj.js" data-navigate-track="reload"></script>
9 <link rel="icon" href="https://sqlfordevs.com/favicon.ico" sizes="any"> 10 <link rel="icon" type="image/png" sizes="16x16" href="https://sqlfordevs.com/build/assets/favicon-16x16-CNx8FWVz.png"> 11 <link rel="icon" type="image/png" sizes="32x32" href="https://sqlfordevs.com/build/assets/favicon-32x32-D8t-ER3X.png"> 12 <link rel="icon" type="image/png" sizes="96x96" href="https://sqlfordevs.com/build/assets/favicon-96x96-Cv4Gl5x6.png"> 13 <link rel="canonical" href="https://sqlfordevs.com/newsletter" /> 14 <meta name="csrf-token" content=""> 15 <meta property="og:type" content="website"> 16 <meta property="og:url" content="https://sqlfordevs.com/newsletter"> 17 <meta property="og:title" content="SQLforDevs.com - Database Tips & Tricks"> 18 <meta property="og:description" content="Subscribe to the newsletter to be notified on future content about lesser-known secrets in databases."> 19 <meta property="og:image" content="https://sqlfordevs.com/build/assets/twittercard-CedOatTH.png"> 20 <meta name="twitter:card" content="summary_large_image"> 21 <meta property="twitter:url" content="https://sqlfordevs.com/newsletter"> 22 <meta name="twitter:creator" content="@tobias_petry"> 23 <meta name="twitter:title" content="SQLforDevs.com - Database Tips & Tricks"> 24 <meta name="twitter:description" content="Subscribe to the newsletter to be notified on future content about lesser-known secrets in databases."> 25 <meta name="twitter:image" content="https://sqlfordevs.com/build/assets/twittercard-CedOatTH.png"> 26 </head> 27<body class="d-flex flex-column h-100"><a href="https://sqlfordevs.com/cdn-cgi/content?id=uXkMXlr9y_LMb6IW2j9I.6hD6YjMoXIkTDCsWEWWqBc-1791065413.5927703-1.2.1.1-grnQWSdAYjfkxv5X8mYznD4ea1kP3JzVKpLFmOkbsrASGd0I0_GkxQGBs19.ywmH" aria-hidden="true" rel="nofollow noopener" style="display: none !important; visibility: hidden !important"></a> 28 29 30 <div class="bg-dark text-white app-multicolor-border" style="background-image:url(https://sqlfordevs.com/build/assets/pattern-1-ZNqyR-1e.svg)"> 31 <div class="container-lg"> 32 <div class="row justify-content-center"> 33 <div class="col-md-10 col-lg-8"> 34 <nav x-data="{ open: false }" class="navbar navbar-expand-lg navbar-dark pb-6 pb-md-9"> 35 <div class="container-fluid mx-0 g-0"> 36 <a class="navbar-brand d-flex align-items-center d-lg-none" href="https://sqlfordevs.com"> 37 <img src="https://sqlfordevs.com/build/assets/logo-Dk2SdJWS.svg" width="28" height="28" class="me-3"> 38 SQL for Devs 39 </a> 40 <button class="navbar-toggler" type="button" @click="open = !open"> 41 <span class="navbar-toggler-icon"></span> 42 </button> 43 <div class="text-center d-none d-lg-flex flex-basis-100 flex-lg-basis-auto" :style="open && `display:block!important`"> 44 <a class="navbar-brand d-none d-lg-flex align-items-center pe-lg-6 me-0" href="https://sqlfordevs.com"> 45 <img src="https://sqlfordevs.com/build/assets/logo-Dk2SdJWS.svg" width="28" height="28" class="me-3"> 46 SQL for Devs 47 </a> 48 <ul class="navbar-nav justify-content-start w-100"> 49 <li class="nav-item "> 50 <a class="nav-link" href="https://sqlfordevs.com/tips"> 51 Tips 52 </a> 53 </li> 54 <li class="nav-item "> 55 <a class="nav-link" href="https://sqlfordevs.com/books+courses"> 56 Books + Courses 57 </a> 58 </li> 59 <li class="nav-item "> 60 <a class="nav-link" href="https://sqlfordevs.com/newsletter"> 61 Newsletter 62 </a> 63 </li> 64 </ul> 65 </div> 66 </div> 67</nav> 68 </div> 69 <div class="col-md-10 col-lg-8 pb-6 pb-md-9"> 70 <h6 class="text-uppercase text-warning mb-4"> 71 More Knowledge. Less Magic. 72</h6> 73<h1 class="font-serif display-3 mb-5"> 74 SQL is not Complex 75</h1> 76<p class="fs-lg mb-0"> 77 A better understanding of SQL changes the database black box perception to a time saver reducing development effort. 78</p> 79 </div> 80 </div> 81 </div> 82 </div> 83 84 <div class="container-lg justify-content-center mt-6 mt-md-9"> 85 <div class="row justify-content-center"> 86 <div class="col-md-10 col-lg-8"> 87 <h6 class="text-uppercase text-primary mb-5 text-center"> 88 Newsletter Subscription 89 </h6> 90 <h1 class="display-3 mb-4 text-center"> 91 More database tips 92 </h1> 93 <p class="fs-lg text-gray-600 mb-9 text-center"> 94 Subscribe to the newsletter to stay up to date. And learn more about databases weekly without any effort in minutes. 95 </p> 96 <hr class="hr-sm bg-warning mx-auto mb-9"> 97 <p class="fs-lg text-left"> 98 Every week, I am writing a thorough database tip for you, to make your application easier to build and faster.
99 These tips are designed to be consumed in less than a minute and provide more optional insightful knowledge if you want to understand a topic more complete. 100 </p> 101 <p class="fs-lg text-left mb-0"> 102 Staying up to date for any programming related stuff is really hard because everything is changing all the time. 103 But databases are exception: Knowledge you learn today is still valid in many years. 104 I can help you advance your career by learning more practical database knowledge without reading dozens of books. 105 Just subscribe to the newsletter any you will be informed whenever I finished writing another great tip you can use for your applications. 106 </p> 107 </div> 108 <div class="col-md-10 col-lg-8"> 109 <hr class="my-7"> 110 </div> 111 <div class="col-md-10 col-lg-8"> 112 <div wire:key="lw-3434802733-0" wire:snapshot="{"data":{"url":"https:\/\/sqlfordevs.com\/newsletter","ui":"footer","types":[["newsletter"],{"s":"arr"}],"email":null},"memo":{"id":"E0pLS0Zo9JZbKgJ9rBtt","name":"newsletter-subscribe","path":"newsletter","method":"GET","release":"a-a-a","children":[],"scripts":[],"assets":[],"errors":[],"locale":"en","islands":[]},"checksum":"9e536241fd94921cf275655d66462eef7c3c7188ace72d8a23960e8ddba408af"}" wire:effects="[]" wire:id="E0pLS0Zo9JZbKgJ9rBtt" wire:name="newsletter-subscribe"> 113 <!--[if BLOCK]><![endif]--><!--[if ENDBLOCK]><![endif]--> <!--[if BLOCK]><![endif]--><!--[if ENDBLOCK]><![endif]--> 114 <!--[if BLOCK]><![endif]--> <div class="row align-items-top justify-content-center"> 115 <div class="col"> 116 <h3 class="font-sans-serif mb-0"> 117 Are you interested to learn more? 118 </h3> 119 <p class="small text-muted mb-0"> 120 Be notified on future content. Never spam. 121 </p> 122 </div> 123 <div class="col-12 col-md-6 mt-3 mt-md-0"> 124 <div class="row g-0 align-items-center app-subscribe-form"> 125 <div class="col"> 126 <input class="form-control" type="email" placeholder="Email address" required="required" wire:model="email"> 127 </div> 128 <div class="col-auto"> 129 <button type="button" class="btn btn-primary" wire:click="subscribe">Subscribe</button> 130 <div wire:loading.flex.delay class="align-items-center justify-content-center position-absolute top-0 bottom-0 start-0 end-0 opacity-75 bg-primary" style="border-bottom-right-radius:0.5rem"> 131 <svg class="text-white" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" style="height:66%;animation: spin 1s linear infinite"> 132 <circle class="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" stroke-width="4"></circle> 133 <path class="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4zm2 5.291A7.962 7.962 0 014 12H0c0 3.042 1.135 5.824 3 7.938l3-2.647z"></path> 134 </svg> 135 </div> 136 </div> 137 </div> 138 <div class="row g-0 align-items-center app-subscribe-form"> 139 <!--[if BLOCK]><![endif]--><!--[if ENDBLOCK]><![endif]--> </div> 140 </div> 141 </div> 142 <!--[if ENDBLOCK]><![endif]--> 143 <!--[if BLOCK]><![endif]--><!--[if ENDBLOCK]><![endif]--> 144 <!--[if BLOCK]><![endif]--><!--[if ENDBLOCK]><![endif]--></div> 145 </div> 146 </div> 147 </div> 148 149 <footer class="footer py-6 mt-6 mt-md-9 bg-dark border-multicolor"> 150 <div class="container-lg"> 151 <div class="row align-items-center justify-content-center text-gray-600"> 152 <div class="col-md-10 col-lg-8"> 153 <div class="row g-0"> 154 <div class="col-12 col-sm-auto text-center text-sm-left"> 155 <ul class="list-inline list-unstyled small mb-0"> 156 <li class="list-inline-item"> 157 <a href="https://sqlfordevs.com/privacy" class="text-reset">Privacy</a> 158 </li> 159 <li class="list-inline-item"> 160 <a href="https://sqlfordevs.com/terms-and-conditions" class="text-reset">Terms & Conditions</a> 161 </li> 162 <li class="list-inline-item"> 163 <a href="https://sqlfordevs.com/imprint" class="text-reset">Contact (Imprint)</a> 164 </li> 165 </ul> 166 </div> 167 <div class="col-12 col-sm order-first order-sm-last text-center text-sm-end"> 168 <ul class="list-inline list-unstyled mb-2 mb-sm-0"> 169 <li class="list-inline-item"> 170 <a class="icon icon-sm text-reset" href="https://x.com/tobias_petry" target="_blank" rel="noopener"> 171 <svg class="size-6" xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-twitter-x" viewBox="0 0 16 16"> 172 <path d="M12.6.75h2.454l-5.36 6.142L16 15.25h-4.937l-3.867-5.07-4.425 5.07H.316l5.733-6.57L0 .75h5.063l3.495 4.633L12.601.75Zm-.86 13.028h1.36L4.323 2.145H2.865z"/> 173</svg> </a> 174 </li> 175 <li class="list-inline-item ms-1"> 176 <a class="icon icon-sm text-reset" href="https://www.linkedin.com/in/t-petry" target="_blank" rel="noopener"> 177 <svg class="size-6" xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-linkedin" viewB
177ox="0 0 16 16"> 178 <path d="M0 1.146C0 .513.526 0 1.175 0h13.65C15.474 0 16 .513 16 1.146v13.708c0 .633-.526 1.146-1.175 1.146H1.175C.526 16 0 15.487 0 14.854zm4.943 12.248V6.169H2.542v7.225zm-1.2-8.212c.837 0 1.358-.554 1.358-1.248-.015-.709-.52-1.248-1.342-1.248S2.4 3.226 2.4 3.934c0 .694.521 1.248 1.327 1.248zm4.908 8.212V9.359c0-.216.016-.432.08-.586.173-.431.568-.878 1.232-.878.869 0 1.216.662 1.216 1.634v3.865h2.401V9.25c0-2.22-1.184-3.252-2.764-3.252-1.274 0-1.845.7-2.165 1.193v.025h-.016l.016-.025V6.169h-2.4c.03.678 0 7.225 0 7.225z"/> 179</svg> </a> 180 </li> 181 </ul> 182 </div> 183 </div> 184 </div> 185 </div> 186 </div> 187</footer> 188
188<script src="https://sqlfordevs.com/js/script.js" data-domain="sqlfordevs.io" defer></script>
188 189
189<script src="https://sqlfordevs.com/a/script.js" defer></script>
189 190 191
191<script data-navigate-once="true">window.livewireScriptConfig = {"csrf":null,"uri":"https:\/\/sqlfordevs.com\/livewire-d21baec3\/update","moduleUrl":"https:\/\/sqlfordevs.com\/livewire-d21baec3","progressBar":"","nonce":""};</script>
vendor: 1 bytes, line 191
191
192<script type="module" src="https://static.cloudflareinsights.com/beacon.min.js/v31edd6df95cf4e85bb4c19e7a9bdbcba1788362987495" integrity="sha512-iIg7k2xntmwu6/uSb5tpc/hySgZc4eoL31yB29W6tJFo2akwjPWcEqnCEdJvGexCL0KEQwVYv5BlowfhVz26hg==" data-cf-beacon='{"version":"2024.11.0","token":"fdc9c61259f34cc6b1e69dcd5d90550e","r":1,"spa":2}' crossorigin="anonymous"></script>
vendor: 1 bytes, line 192
192
193<script>(function(){function c(){var b=a.contentDocument||(a.contentWindow&&a.contentWindow.document);if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'a44f4692fc51bae6',t:'MTc5MTA2NTQxMw=='};var a=document.createElement('script');a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script>
193</body> 194</html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.