Name

SQL (Structured Query Language) is the standard language used for managing relational databases. Relational databases store data in tables and allow for complex relationships between data, making them a powerful tool for organizing and retrieving data.

The Power of SQL: A Comprehensive Guide to Relational Databases

Coding Blog

Features

Templates

Showcase

Resources

Pricing

Login

SQL (Structured Query Language) is the standard language used for…

<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WTZ8GQJR" height="0" width="0"
    style="display:none;visibility:hidden"></iframe></noscript>



<script>
  window.onload = () => {

    // ==== Update current query parameters to include `source` ====
    // Rewardful uses `via`, this isn't tracked in Plausible

    let params = new URL(document.location).searchParams;

    // ==== Update current query parameters to include `source` ====
    // Rewardful uses `via`, this isn't tracked in Plausible
    
    let newParams = new URL(document.location);
        let viaFound = false;
        let sourceFound = false;
        params.forEach((value, key) => {
          if (key === "via") {
            viaFound = true;
            newParams.searchParams.set("source", `via-${value}`);
          }
          if (key === "source") {
            sourceFound = true;
          }
        });
        if (viaFound && !sourceFound) {
          window.location = newParams.href;
        }

        // ==== Update utm_source for links that contains build TYPEDREAM_HREF ====
    // Get all links that contains build TYPEDREAM_HREF
    const TYPEDREAM_HREF = "typedream.com";
    const BUILD_TYPEDREAM_HREF = "build.typedream.com";
    Array.from(
      document.querySelectorAll(`[href*='${TYPEDREAM_HREF}']`)
    ).forEach((e) => {
      var href = e.getAttribute("href");
      var url = new URL(href);
      var urlParams = new URL(href).searchParams;
      params.forEach((value, key) => {
        // for PH, if there is ref=xxx change it to utm_source=xxx
        urlParams.set(key === 'ref' ? 'utm_source' : key, value);
      });
      url.search = urlParams;
      e.href = url.toString();

      // track conversion
      // if (e.href.includes(BUILD_TYPEDREAM_HREF)) {
      //  e.addEventListener('click', function() {gtag_report_conversion(e.href)})
      // }
    });

   Array.from(document.querySelectorAll(`[href^='/']`)).forEach((e) => {
      var href = e.getAttribute("href");
      href = `${window.location.protocol}//${window.location.host}${href}`;
      var url = new URL(href);
      var urlParams = new URL(href).searchParams;
      params.forEach((value, key) => {
        // for PH, if there is ref=xxx change it to utm_source=xxx
        urlParams.set(key === 'ref' ? 'utm_source' : key, value);
      });
      url.search = urlParams;
      e.href = url.toString();
    });


    // Make sticky table of contents
    var sibling = document.getElementById("sticky-sibling")
    if (sibling && sibling.nextSibling) {
      var toc = sibling.nextSibling
      toc.style.backgroundColor = 'red';
    }
  };

</script>





<script id="ze-snippet" src="https://static.zdassets.com/ekr/snippet.js?key=f871bdf7-2c33-4fbd-bb5d-7e7ab05bea84">
</script>




<script>
  const searchClient = algoliasearch(
        "SMJ4AJCZFI",
        "bdf124d4eb5f98cc467769a011fba85a"
      );

      const search = instantsearch({
        indexName: "help_typedream",
        searchClient
      });

      setTimeout(() => {
        search.addWidgets([
          instantsearch.widgets.searchBox({
            container: "#searchbox",
            searchAsYouType: false,
            placeholder: "Search for articles"
          }),
          instantsearch.widgets.hits({
            container: "#hits",
            templates: {
              item(hit, { html, components }) {
                return html`
                  <a
                    class="search-hit-row-link"
                    href=${hit.link}
                    target="_blank"
                  >
                    <div class="search-hit-row">
                      <h2>
                        ${components.Highlight({ attribute: "name", hit })}
                      </h2>
                      <p>${hit.description}</p>
                    </div>
                  </a>
                `;
              },
              empty(results, { html }) {
                return html`<div class="search-empty ais-InfiniteHits-item">
                  No results for <q>${results.query}</q>
                </div>`;
              },
              showMoreText(data, { html }) {
                return html`<span class="search-showmore">Show more</span>`;
              }
            }
          })
        ]);

        // Conditionally display the hits widget only when a search query is entered
        search.on("render", () => {
          const hitsContainer = document.querySelector("#hits");
          if (search.helper.state.query === "") {
            hitsContainer.style.display = "none";
          } else {
            hitsContainer.style.display = "block";
          }
        });

        search.start();
      }, 500);
</script>

The Power of SQL: A Comprehensive Guide to Relational Databases

See More Posts