Category: Tutorials
You are in the right place if you want a lesson you can follow, not a glossary and not a product homepage. This shelf holds most of the articles on Analytics Made Simple. Two paths sit inside it on purpose. SQL is the database path: you have rows, and you need to ask a question without exporting another spreadsheet. AI is the tool path: chat products, open-weight models, and the jobs those tools are actually good at. Other tutorials land here when they teach a skill that does not belong on a narrower shelf.
A category page is the pile. A series page is the path, with a place to start and an order. If you open a tag or page 2 of this list, you are in a filing cabinet. The lesson is the article, or the series hub that lines the articles up.
Where to start: if the pain is a table, open the SQL series and use the first part on that page. If the pain is a model name or a chat tool, open the AI category and pick the product you already have on screen. If you are not sure which job you have, open Learn and choose the track that matches the work, not the logo.
SQL Tutorial 8: Modifying Data with SQL
Change data safely with INSERT, UPDATE, and DELETE on the customers and orders toy schema. Practice row adds, targeted edits, and careful deletes, plus a light take on…
SQL Tutorial 7: Subqueries in SQL
Subqueries nest one query inside another so you can filter and shape results with answers from other answers. Learn scalar, IN, EXISTS, and derived tables on the customers…
SQL Tutorial 6: Joins in SQL
Connect customers to orders with INNER and LEFT joins, using keys on purpose. Learn how join grain can explode row counts, when not to join, and how to…
SQL Tutorial 5: Aggregate Functions and Grouping Data
Turn rows into summaries with COUNT, SUM, AVG, MIN, and MAX. Group with GROUP BY, and learn when HAVING filters groups while WHERE filters rows, so your totals…
SQL Tutorial 4: Filtering and Sorting Data in SQL
Filter rows with WHERE, combine conditions with AND and OR, and use IN, BETWEEN, and careful LIKE patterns. Sort with ORDER BY and learn NULL basics so your…
