Category: SQL
You are here if you have a table and a question, and another export into a sheet is how the answer gets worse. These articles are the SQL series in category form. The numbered tutorials start with a playground and the core commands, then reading rows, filtering, sorting, grouping, and joins. Later tutorials cover subqueries, changing rows, views and indexes, and making a query faster and easier to keep. One extra primer, outside that numbered run, asks what SQL is and why you would learn it.
Do not start in the middle because a title mentions joins. Joins make sense after you can read and filter a single table. The series hub states the order. The category page is only the shelf.
Where to start: open the SQL series. Use the first part on that page. If you only needed the word, the primer is enough. If you need to write the query on Monday, use the playground and go in order.
SQL Tutorial 3: Retrieving Data with SELECT
Learn to retrieve exactly the columns you need with SELECT, rename them with aliases, remove duplicate rows with DISTINCT, and cap result size with LIMIT. Stop shipping SELECT…
SQL Tutorial 2: Master the Core Commands (SELECT, INSERT, UPDATE, DELETE)
Master the four core SQL commands: SELECT to read, INSERT to add, UPDATE to change, and DELETE to remove. Learn the safety habits that keep practice useful and…
SQL Tutorial 1: Setting Up Your SQL Playground
Set up a low-drama SQL playground with SQLite first, then compare common engines for later work. Create the toy customers and orders tables in your head and on…
SQL for Beginners: What is SQL and Why You Should Learn It
SQL is how you ask a database for answers instead of scrolling forever. This intro explains tables, the toy customers and orders schema, why SQL still matters at…
