René's URL Explorer Experiment

{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt","url":"https://sqlint.com","logo":"https://sqlint.com/og-image.jpg","email":"support.sqlint@gmail.com","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","disambiguatingDescription":"SqlInt (sqlint.com) is a browser-based SQL practice and interview-preparation website with free client-side SQL tools - a web platform, not a command-line utility.","contactPoint":{"@type":"ContactPoint","contactType":"customer support","email":"support.sqlint@gmail.com","availableLanguage":["en"]},"subjectOf":[{"@type":"WebPage","url":"https://sqlint.com/about","name":"About SqlInt"}],"sameAs":[]},{"@type":"WebSite","@id":"https://sqlint.com/#website","url":"https://sqlint.com","name":"SqlInt","description":"SqlInt is a browser-based SQL practice and interview-preparation platform that also provides free client-side SQL tools for developers.","publisher":{"@id":"https://sqlint.com/#organization"}}]}

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"How long does it take to learn SQL?","acceptedAnswer":{"@type":"Answer","text":"Most beginners reach working fluency in 2–4 weeks at 30–60 minutes a day: week one for SELECT, WHERE, and JOINs, then aggregations, subqueries, and window functions. This 27-topic roadmap is ordered exactly in that progression, so follow it top to bottom."}},{"@type":"Question","name":"Is SQL hard to learn for beginners?","acceptedAnswer":{"@type":"Answer","text":"No — SQL is one of the easiest programming languages to learn because queries read almost like English sentences. Start with SELECT and filtering, practice each topic's examples, and use the hints when you get stuck. No prior coding experience is needed."}},{"@type":"Question","name":"Is this SQL course really free?","acceptedAnswer":{"@type":"Answer","text":"Yes. The complete 27-topic roadmap — every explanation, syntax reference, example, and interview tip — is free with no signup. Printable cheat sheets and the SQL practice playground are free too."}},{"@type":"Question","name":"Where should a complete beginner start?","acceptedAnswer":{"@type":"Answer","text":"Start with topic 1 and move down the roadmap in order: SELECT first, then WHERE filtering, ORDER BY, and JOINs before touching aggregations or subqueries. Each topic lists its level and duration — Beginner topics take 10–15 minutes each."}},{"@type":"Question","name":"Should I learn SQL through puzzles or this roadmap?","acceptedAnswer":{"@type":"Answer","text":"Do both: follow this roadmap for structured learning, then reinforce each topic by playing the story-driven SQL puzzle games, where chapters apply the same skills (JOINs, CTEs, window functions) inside a story. Play first if you learn best by doing."}},{"@type":"Question","name":"How do I prepare for SQL interviews after learning?","acceptedAnswer":{"@type":"Answer","text":"Once you finish the Advanced topics, drill the SQL interview question bank: 90+ real interview problems with schemas, hints, and instant feedback in the browser. Finish each roadmap topic's interview tips first — they flag exactly what interviewers probe."}}]}

{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://sqlint.com"},{"@type":"ListItem","position":2,"name":"Learn SQL","item":"https://sqlint.com/learn-sql"}]}

{"@context":"https://schema.org","@type":"ItemList","name":"Complete SQL Roadmap","description":"Learn SQL from zero to expert with our complete 27-topic roadmap. Includes syntax examples, common mistakes, interview tips, and a printable SQL cheat sheet.","numberOfItems":27,"url":"https://sqlint.com/learn-sql","itemListElement":[{"@type":"ListItem","position":1,"name":"Introduction to Databases — Beginner","url":"https://sqlint.com/learn-sql/introduction-to-databases","description":"A database is an organized collection of structured data stored electronically. Relational databases (RDBMS) store data in tables — grids of rows (records) and columns (fields). Tables are linked via "},{"@type":"ListItem","position":2,"name":"SELECT Statement — Beginner","url":"https://sqlint.com/learn-sql/select-statement","description":"SELECT retrieves data from one or more tables. You can select all columns with * or specify individual columns. Aliases (AS) rename a column or table for the duration of the query. SQL execution order"},{"@type":"ListItem","position":3,"name":"WHERE Clause — Beginner","url":"https://sqlint.com/learn-sql/where-clause","description":"WHERE filters rows before aggregation. It supports operators: =, !=, \u003c, >, \u003c=, >=, LIKE, IN, BETWEEN, IS NULL, IS NOT NULL. Combine conditions with AND (both must be true), OR (either must be true), N"},{"@type":"ListItem","position":4,"name":"ORDER BY — Beginner","url":"https://sqlint.com/learn-sql/order-by","description":"ORDER BY sorts the result set. Default is ASC (ascending, A→Z, 0→9). Use DESC for descending. You can sort by multiple columns — the second sort applies within ties of the first. Without ORDER BY, SQL"},{"@type":"ListItem","position":5,"name":"LIMIT & OFFSET — Beginner","url":"https://sqlint.com/learn-sql/limit-offset","description":"LIMIT restricts the number of rows returned. OFFSET skips rows — essential for pagination. Always combine with ORDER BY when paginating to ensure consistent results. SQL Server uses TOP instead of LIM"},{"@type":"ListItem","position":6,"name":"DISTINCT — Beginner","url":"https://sqlint.com/learn-sql/distinct","description":"DISTINCT removes duplicate rows from a result set. When applied to multiple columns, it returns unique COMBINATIONS of those columns — not unique values per column independently. COUNT(DISTINCT col) c"},{"@type":"ListItem","position":7,"name":"NULL Handling — Beginner","url":"https://sqlint.com/learn-sql/null-handling","description":"NULL represents missing or unknown data — not zero, not empty string. NULL propagates: any arithmetic with NULL returns NULL. Comparisons with NULL always return UNKNOWN. Use COALESCE to replace NULL "},{"@type":"ListItem","position":8,"name":"Aggregate Functions — Intermediate","url":"https://sqlint.com/learn-sql/aggregate-functions","description":"Aggregate functions compute a single result from multiple rows. Core functions: COUNT (rows), SUM (total), AVG (mean), MIN (smallest), MAX (largest). All aggregates except COUNT(*) ignore NULL values."},{"@type":"ListItem","position":9,"name":"GROUP BY — Intermediate","url":"https://sqlint.com/learn-sql/group-by","description":"GROUP BY groups rows with identical values into summary rows. Every column in SELECT must either appear in GROUP BY or be wrapped in an aggregate function. You can group by multiple columns to get uni"},{"@type":"ListItem","position":10,"name":"HAVING Clause — Intermediate","url":"https://sqlint.com/learn-sql/having-clause","description":"HAVING filters groups produced by GROUP BY. It's WHERE for aggregated results — applied after aggregation, unlike WHERE which runs before. You can use aggregate functions in HAVING that aren't in SELE"},{"@type":"ListItem","position":11,"name":"CASE WHEN — Intermediate","url":"https://sqlint.com/learn-sql/case-when","description":"CASE WHEN adds conditional logic inside SQL — like if/else statements. It can be used in SELECT, WHERE, ORDER BY, and GROUP BY. Two forms: simple CASE (compares one value) and searched CASE (evaluates"},{"@type":"ListItem","position":12,"name":"String Functions — Intermediate","url":"https://sqlint.com/learn-sql/string-functions","description":"SQL has built-in string functions for data cleaning and transformation. Common ones: CONCAT (join strings), UPPER/LOWER (change case), LENGTH (character count), SUBSTRING/SUBSTR (extract part of strin"},{"@type":"ListItem","position":13,"name":"Pattern Matching (LIKE & REGEXP) — Intermediate","url":"https://sqlint.com/learn-sql/pattern-matching-like-regexp","description":"Pattern matching allows you to search for data that follows a specific format rather than an exact value. The LIKE operator uses wildcards: '%' (matches zero or more characters) and '_' (matches exact"},{"@type":"ListItem","position":14,"name":"Date Functions — Intermediate","url":"https://sqlint.com/learn-sql/date-functions","description":"Date functions are critical in analytics — most business queries involve time periods, age calculations, or date formatting. Key functions: NOW()/CURRENT_DATE (current time), YEAR/MONTH/DAY (extract p"},{"@type":"ListItem","position":15,"name":"JOINs (Inner, Left, Right, Full, Self) — Intermediate","url":"https://sqlint.com/learn-sql/joins-inner-left-right-full-self","description":"JOINs combine rows from two or more tables based on a related column. INNER JOIN: only matching rows from both tables. LEFT JOIN: all left rows + matching right rows (NULL if no match). RIGHT JOIN: al"},{"@type":"ListItem","position":16,"name":"Subqueries — Advanced","url":"https://sqlint.com/learn-sql/subqueries","description":"A subquery is a query nested inside another. Non-correlated subqueries run once independently. Correlated subqueries reference the outer query and run once per outer row — they can be slow on large ta"},{"@type":"ListItem","position":17,"name":"Common Table Expressions (CTEs) — Advanced","url":"https://sqlint.com/learn-sql/common-table-expressions-ctes","description":"A CTE is a named temporary result set defined with the WITH clause before the main query. CTEs improve readability by breaking complex queries into named steps. Multiple CTEs can be chained. Recursive"},{"@type":"ListItem","position":18,"name":"Window Functions — Advanced","url":"https://sqlint.com/learn-sql/window-functions","description":"Window functions perform calculations across rows related to the current row WITHOUT collapsing them like GROUP BY. They use the OVER() clause with optional PARTITION BY (grouping) and ORDER BY (order"},{"@type":"ListItem","position":19,"name":"Views — Advanced","url":"https://sqlint.com/learn-sql/views","description":"A VIEW is a saved SQL query stored in the database that acts as a virtual table. It doesn't store data itself — it re-runs the underlying query each time it's accessed. Use views for: security (hide s"},{"@type":"ListItem","position":20,"name":"Stored Procedures — Advanced","url":"https://sqlint.com/learn-sql/stored-procedures","description":"A stored procedure is a reusable block of SQL code stored in the database. It accepts IN (input), OUT (output), and INOUT parameters, can contain conditional logic, loops, and transactions. Benefits: "},{"@type":"ListItem","position":21,"name":"Indexes — Advanced","url":"https://sqlint.com/learn-sql/indexes","description":"An index is a data structure that speeds up reads by letting the DB find rows without scanning the full table — like a book index. Clustered Index: physically reorders the table data (one per table, u"},{"@type":"ListItem","position":22,"name":"Query Optimization — Advanced","url":"https://sqlint.com/learn-sql/query-optimization","description":"Query optimization ensures SQL runs efficiently at scale. Use EXPLAIN/EXPLAIN ANALYZE to see the execution plan. Look for: full table scans (type=ALL), missing indexes, large estimated row counts, and"},{"@type":"ListItem","position":23,"name":"Transactions & COMMIT / ROLLBACK — Advanced","url":"https://sqlint.com/learn-sql/transactions-commit-rollback","description":"A transaction is a unit of work that either completes fully or not at all. Use BEGIN/START TRANSACTION to start, COMMIT to save permanently, ROLLBACK to undo all changes. SAVEPOINT creates a checkpoin"},{"@type":"ListItem","position":24,"name":"ACID Properties — Advanced","url":"https://sqlint.com/learn-sql/acid-properties","description":"ACID guarantees reliable processing of database transactions. Atomicity: all operations succeed or all are rolled back — no partial state. Consistency: data moves from one valid state to another, all "},{"@type":"ListItem","position":25,"name":"Advanced Analytics SQL — Expert","url":"https://sqlint.com/learn-sql/advanced-analytics-sql","description":"Expert analytics SQL involves cohort analysis (grouping users by when they joined), retention analysis (% of users who return), and funnel analysis (conversion rates through a sequence of steps). Thes"},{"@type":"ListItem","position":26,"name":"Real Business SQL Scenarios — Expert","url":"https://sqlint.com/learn-sql/real-business-sql-scenarios","description":"Expert SQL in industry means writing queries for business problems across payments, banking, fraud detection, e-commerce, and marketing. These require combining multiple concepts: window functions, CT"},{"@type":"ListItem","position":27,"name":"SQL Interview Preparation — Expert","url":"https://sqlint.com/learn-sql/sql-interview-preparation","description":"SQL interviews at top companies test: window functions (RANK, LAG, ROW_NUMBER), CTEs, self-joins, date math, deduplication, and business logic translation. The interview process: clarify requirements "}]}

{"@context":"https://schema.org","@type":"Course","@id":"https://sqlint.com/learn-sql#course","name":"Learn SQL — Complete 27-Topic Roadmap","description":"A free 27-topic SQL course from first SELECT to window functions, indexes, and analytics SQL — each topic with syntax, examples, common mistakes, and interview tips.","url":"https://sqlint.com/learn-sql","inLanguage":"en","isAccessibleForFree":true,"provider":{"@type":"Organization","@id":"https://sqlint.com/#organization","name":"SqlInt","url":"https://sqlint.com"},"hasPart":[{"@type":"LearningResource","name":"Introduction to Databases — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/introduction-to-databases","educationalLevel":"Beginner","timeRequired":"10 mins"},{"@type":"LearningResource","name":"SELECT Statement — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/select-statement","educationalLevel":"Beginner","timeRequired":"12 mins"},{"@type":"LearningResource","name":"WHERE Clause — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/where-clause","educationalLevel":"Beginner","timeRequired":"10 mins"},{"@type":"LearningResource","name":"ORDER BY — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/order-by","educationalLevel":"Beginner","timeRequired":"10 mins"},{"@type":"LearningResource","name":"LIMIT & OFFSET — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/limit-offset","educationalLevel":"Beginner","timeRequired":"10 mins"},{"@type":"LearningResource","name":"DISTINCT — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/distinct","educationalLevel":"Beginner","timeRequired":"11 mins"},{"@type":"LearningResource","name":"NULL Handling — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/null-handling","educationalLevel":"Beginner","timeRequired":"10 mins"},{"@type":"LearningResource","name":"Aggregate Functions — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/aggregate-functions","educationalLevel":"Intermediate","timeRequired":"12 mins"},{"@type":"LearningResource","name":"GROUP BY — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/group-by","educationalLevel":"Intermediate","timeRequired":"12 mins"},{"@type":"LearningResource","name":"HAVING Clause — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/having-clause","educationalLevel":"Intermediate","timeRequired":"10 mins"},{"@type":"LearningResource","name":"CASE WHEN — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/case-when","educationalLevel":"Intermediate","timeRequired":"12 mins"},{"@type":"LearningResource","name":"String Functions — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/string-functions","educationalLevel":"Intermediate","timeRequired":"10 mins"},{"@type":"LearningResource","name":"Pattern Matching (LIKE & REGEXP) — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/pattern-matching-like-regexp","educationalLevel":"Intermediate","timeRequired":"10 mins"},{"@type":"LearningResource","name":"Date Functions — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/date-functions","educationalLevel":"Intermediate","timeRequired":"12 mins"},{"@type":"LearningResource","name":"JOINs (Inner, Left, Right, Full, Self) — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/joins-inner-left-right-full-self","educationalLevel":"Intermediate","timeRequired":"25 mins"},{"@type":"LearningResource","name":"Subqueries — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/subqueries","educationalLevel":"Advanced","timeRequired":"17 mins"},{"@type":"LearningResource","name":"Common Table Expressions (CTEs) — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/common-table-expressions-ctes","educationalLevel":"Advanced","timeRequired":"15 mins"},{"@type":"LearningResource","name":"Window Functions — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/window-functions","educationalLevel":"Advanced","timeRequired":"25 mins"},{"@type":"LearningResource","name":"Views — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/views","educationalLevel":"Advanced","timeRequired":"10 mins"},{"@type":"LearningResource","name":"Stored Procedures — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/stored-procedures","educationalLevel":"Advanced","timeRequired":"15 mins"},{"@type":"LearningResource","name":"Indexes — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/indexes","educationalLevel":"Advanced","timeRequired":"17 mins"},{"@type":"LearningResource","name":"Query Optimization — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/query-optimization","educationalLevel":"Advanced","timeRequired":"22 mins"},{"@type":"LearningResource","name":"Transactions & COMMIT / ROLLBACK — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/transactions-commit-rollback","educationalLevel":"Advanced","timeRequired":"12 mins"},{"@type":"LearningResource","name":"ACID Properties — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/acid-properties","educationalLevel":"Advanced","timeRequired":"12 mins"},{"@type":"LearningResource","name":"Advanced Analytics SQL — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/advanced-analytics-sql","educationalLevel":"Expert","timeRequired":"30 mins"},{"@type":"LearningResource","name":"Real Business SQL Scenarios — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/real-business-sql-scenarios","educationalLevel":"Expert","timeRequired":"30 mins"},{"@type":"LearningResource","name":"SQL Interview Preparation — SQL Tutorial with Examples","url":"https://sqlint.com/learn-sql/sql-interview-preparation","educationalLevel":"Expert","timeRequired":"30 mins"}]}