index.html

<!doctype html>
<html lang="en" data-theme="dark">
  <head>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <title>Learn SQL in the browser · SQL Learn</title>
    <meta
      name="description"
      content="Learn SQL by writing queries in the browser. Free SQL practice for SELECT, WHERE, JOIN, GROUP BY, and more. No account, no install, and no personal data."
    />
    <meta name="keywords" content="learn SQL, learning SQL, how to SQL, how to learn SQL, SQL tutorial, SQL practice, SQL exercises, write a SQL query" />
    <meta name="author" content="SQL Learn" />
    <meta name="robots" content="index, follow, max-image-preview:large, max-snippet:-1" />
    <meta name="theme-color" content="#141218" />
    <link rel="canonical" href="https://sqllearn.bitilia.com/" />
    <link rel="icon" href="/favicon.ico" sizes="any" />
    <link rel="icon" type="image/webp" href="/favicon.webp" />
    <meta property="og:type" content="website" />
    <meta property="og:site_name" content="SQL Learn" />
    <meta property="og:title" content="Learn SQL in the browser · SQL Learn" />
    <meta
      property="og:description"
      content="Learn SQL by writing queries in the browser. Free SQL practice for SELECT, WHERE, JOIN, GROUP BY, and more. No account, no install, and no personal data."
    />
    <meta property="og:url" content="https://sqllearn.bitilia.com/" />
    <meta property="og:image" content="https://sqllearn.bitilia.com/favicon.webp" />
    <meta property="og:locale" content="en" />
    <meta name="twitter:card" content="summary" />
    <meta name="twitter:title" content="Learn SQL in the browser · SQL Learn" />
    <meta
      name="twitter:description"
      content="Learn SQL by writing queries in the browser. Free SQL practice for SELECT, WHERE, JOIN, GROUP BY, and more. No account, no install, and no personal data."
    />
    <meta name="twitter:image" content="https://sqllearn.bitilia.com/favicon.webp" />
    <script type="application/ld+json">
      {
        "@context": "https://schema.org",
        "@graph": [
          {
            "@type": "WebSite",
            "@id": "https://sqllearn.bitilia.com/#website",
            "url": "https://sqllearn.bitilia.com/",
            "name": "SQL Learn",
            "description": "Learn SQL by writing queries in the browser. Free SQL practice for SELECT, WHERE, JOIN, GROUP BY, and more. No account, no install, and no personal data.",
            "inLanguage": "en",
            "publisher": { "@id": "https://sqllearn.bitilia.com/#app" }
          },
          {
            "@type": "WebApplication",
            "@id": "https://sqllearn.bitilia.com/#app",
            "name": "SQL Learn",
            "url": "https://sqllearn.bitilia.com/",
            "applicationCategory": "EducationalApplication",
            "operatingSystem": "Web",
            "browserRequirements": "Requires a modern browser. Queries run locally.",
            "isAccessibleForFree": true,
            "offers": { "@type": "Offer", "price": "0", "priceCurrency": "USD" },
            "description": "SQL Learn is a free way to learn SQL by writing it. Each exercise gives you tables and a task. You write a query, run it in the browser, and see whether the result matches.",
            "featureList": [
              "SELECT statements",
              "WHERE filtering",
              "JOINs",
              "GROUP BY and aggregations",
              "ORDER BY",
              "LIMIT and OFFSET",
              "Subqueries",
              "Window functions",
              "In-browser SQLite"
            ]
          },
          {
            "@type": "FAQPage",
            "@id": "https://sqllearn.bitilia.com/#faq",
            "url": "https://sqllearn.bitilia.com/#about",
            "mainEntity": [
              {
                "@type": "Question",
                "name": "How do I learn SQL?",
                "acceptedAnswer": {
                  "@type": "Answer",
                  "text": "Write a short query, run it, and check the result. Begin with Select Statements, then WHERE, then joins. SQL Learn is a set of exercises for that practice."
                }
              },
              {
                "@type": "Question",
                "name": "How do I write SQL if I have never written a query?",
                "acceptedAnswer": {
                  "@type": "Answer",
                  "text": "Name the columns and the table, then run it: SELECT last_name, salary FROM employees. Change the columns and add a WHERE filter until the result matches the task."
                }
              },
              {
                "@type": "Question",
                "name": "Is this SQL tutorial free?",
                "acceptedAnswer": {
                  "@type": "Answer",
                  "text": "Yes. SQL Learn runs fully in the browser and makes no external requests. We do not process any personal data."
                }
              },
              {
                "@type": "Question",
                "name": "Do I need to install a database to practice SQL?",
                "acceptedAnswer": {
                  "@type": "Answer",
                  "text": "No. The exercises run on SQLite in the browser."
                }
              },
              {
                "@type": "Question",
                "name": "What SQL should a beginner learn first?",
                "acceptedAnswer": {
                  "@type": "Answer",
                  "text": "SELECT, WHERE, JOIN, GROUP BY, and ORDER BY. Those cover most questions people ask of a table."
                }
              }
            ]
          },
          {
            "@type": "ItemList",
            "@id": "https://sqllearn.bitilia.com/#topics",
            "name": "SQL topics to practice",
            "itemListElement": [
              { "@type": "ListItem", "position": 1, "name": "Select Statements", "url": "https://sqllearn.bitilia.com/?source=topics&topic=select&q=1" },
              { "@type": "ListItem", "position": 2, "name": "WHERE Clause and Filtering", "url": "https://sqllearn.bitilia.com/?source=topics&topic=where&q=1" },
              { "@type": "ListItem", "position": 3, "name": "Aggregations", "url": "https://sqllearn.bitilia.com/?source=topics&topic=aggregations&q=1" },
              { "@type": "ListItem", "position": 4, "name": "ORDER BY and Sorting", "url": "https://sqllearn.bitilia.com/?source=topics&topic=order-by&q=1" },
              { "@type": "ListItem", "position": 5, "name": "LIMIT and OFFSET", "url": "https://sqllearn.bitilia.com/?source=topics&topic=limit-offset&q=1" },
              { "@type": "ListItem", "position": 6, "name": "Joins", "url": "https://sqllearn.bitilia.com/?source=topics&topic=joins&q=1" },
              { "@type": "ListItem", "position": 7, "name": "Subqueries", "url": "https://sqllearn.bitilia.com/?source=topics&topic=subqueries&q=1" },
              { "@type": "ListItem", "position": 8, "name": "Window Functions", "url": "https://sqllearn.bitilia.com/?source=topics&topic=windows&q=1" }
            ]
          }
        ]
      }
    </script>
    <script>
      document.documentElement.classList.add("js");
    </script>
    <style>
      html.js .crawl { display: none; }
      .crawl {
        max-width: 42rem;
        margin: 0 auto;
        padding: 32px 20px 64px;
        font-family: Roboto, "Segoe UI", sans-serif;
        color: #e6e0e9;
        background: #141218;
        line-height: 1.5;
      }
      .crawl h1, .crawl h2, .crawl h3 { font-weight: 500; line-height: 1.3; }
      .crawl a { color: #d0bcff; }
      .crawl ul, .crawl ol { padding-left: 1.25rem; }
    </style>
  </head>
  <body>
    <article class="crawl">
      <h1>Learn SQL in the browser</h1>
      <p>
        SQL Learn is a free way to learn SQL by writing it. Each exercise gives you tables and a task. You write a query, run it in the browser, and see whether the result matches. There is no account, no install, and nothing is sent to a server.
      </p>
      <h2>How to learn SQL</h2>
      <p>
        Learning SQL sticks when you write a query and check the result, not when you only read one. Start with a select statement, then filtering, joins, and grouping.
      </p>
      <ol>
        <li>Choose a topic. Select Statements is the right start if you are new to SQL.</li>
        <li>Read the tables and the task.</li>
        <li>Write the query and run it. A matching result means it is right.</li>
        <li>Open a hint if you stall, then go on to the next exercise.</li>
      </ol>
      <h2>How to write a SQL query</h2>
      <p>
        A SQL query asks a table for rows. Start with SELECT and the columns you want, then FROM and the table name. Add WHERE to keep certain rows, JOIN to bring in a related table, GROUP BY to summarise, and ORDER BY to sort. LIMIT pages through the result.
      </p>
      <p>A first query looks like this: SELECT last_name, salary FROM employees WHERE salary >= 100000 ORDER BY salary DESC.</p>
      <h2>What you can practice</h2>
      <p>
        Work through SELECT, WHERE, aggregations, ORDER BY, LIMIT and OFFSET, functions, duplicates, ranking, CASE, joins, self joins, subqueries, common table expressions, window functions, dates, and changes with INSERT, UPDATE, and DELETE.
      </p>
      <p>Other sets use a clinic, a shop, a streaming catalog, a community, and a search log, so you can practice SQL on more than one database.</p>
      <h2>SQL topics</h2>
      <ul>
        <li><a href="/?source=topics&amp;topic=select&amp;q=1">Select Statements</a></li>
        <li><a href="/?source=topics&amp;topic=where&amp;q=1">WHERE Clause &amp; Filtering</a></li>
        <li><a href="/?source=topics&amp;topic=aggregations&amp;q=1">Aggregations</a></li>
        <li><a href="/?source=topics&amp;topic=order-by&amp;q=1">ORDER BY &amp; Sorting</a></li>
        <li><a href="/?source=topics&amp;topic=limit-offset&amp;q=1">LIMIT &amp; OFFSET</a></li>
        <li><a href="/?source=topics&amp;topic=functions&amp;q=1">Basic Functions</a></li>
        <li><a href="/?source=topics&amp;topic=joins&amp;q=1">Joins</a></li>
        <li><a href="/?source=topics&amp;topic=subqueries&amp;q=1">Subqueries</a></li>
        <li><a href="/?source=topics&amp;topic=windows&amp;q=1">CTEs and window functions</a></li>
        <li><a href="/?source=topics&amp;topic=dates&amp;q=1">Date operations</a></li>
        <li><a href="/?source=company&amp;collection=ecommerce&amp;q=1">Company SQL practice</a></li>
      </ul>
      <h2>Questions about learning SQL</h2>
      <h3>How do I learn SQL?</h3>
      <p>Write a short query, run it, and check the result. Begin with Select Statements, then WHERE, then joins. SQL Learn is a set of exercises for that practice.</p>
      <h3>How do I write SQL if I have never written a query?</h3>
      <p>Name the columns and the table, then run it: SELECT last_name, salary FROM employees. Change the columns and add a WHERE filter until the result matches the task.</p>
      <h3>Is this SQL tutorial free?</h3>
      <p>Yes. SQL Learn runs fully in the browser and makes no external requests. We do not process any personal data.</p>
      <h3>Do I need to install a database to practice SQL?</h3>
      <p>No. The exercises run on SQLite in the browser.</p>
      <h3>What SQL should a beginner learn first?</h3>
      <p>SELECT, WHERE, JOIN, GROUP BY, and ORDER BY. Those cover most questions people ask of a table.</p>
    </article>
    <div id="root"></div>
    <script type="module" src="/src/main.tsx"></script>
  </body>
</html>