explaingit

mouredev/hello-sql

9,424PythonAudience · generalComplexity · 2/5Setup · easy

TLDR

A free beginner SQL course in Spanish with 80+ video lessons and matching code files covering everything from basic queries to stored procedures, transactions, and connecting databases to Python.

Mindmap

mindmap
  root((hello-sql))
    Course structure
      Reading data
      Writing data
      Managing tables
      Table relationships
    Core SQL commands
      SELECT and WHERE
      INSERT UPDATE DELETE
      JOIN types
    Advanced topics
      Indexes
      Triggers
      Stored procedures
      Transactions
    Final section
      Python integration
      Database connection
      YouTube timestamps
Click or tap to explore — scroll the page freely

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

Things people build with this

USE CASE 1

Learn SQL from scratch following a structured 7-hour Spanish-language video course with matching code files for each lesson

USE CASE 2

Practice writing SELECT, INSERT, UPDATE, and DELETE statements with real examples tied to YouTube timestamps you can jump to directly

USE CASE 3

Study advanced SQL topics like indexes, triggers, stored procedures, and transactions with a step-by-step curriculum

USE CASE 4

Learn how to connect a SQL database to a Python application using the code examples in the final course section

Tech stack

SQLPython

Getting it running

Difficulty · easy Time to first run · 30min

Course video is in Spanish, a YouTube account helps to follow along with the 7-hour recording.

In plain English

Hello SQL is a free, beginner-level course that teaches the fundamentals of SQL and relational databases from scratch. SQL is the language used to store, retrieve, and manage data in most databases. The course is in Spanish and accompanies a 7-hour video on YouTube, originally recorded live on Twitch. The repository contains the SQL code files that go along with over 80 video lessons covering more than 50 SQL commands. The lessons are organized into sections that follow a logical learning path: reading data, writing data, managing databases and tables, relationships between tables, joining related tables, and advanced topics. The early lessons cover the basics of querying a database with SELECT and filtering results using commands like WHERE, ORDER BY, LIKE, and LIMIT. Later lessons move into writing data with INSERT, UPDATE, and DELETE, then into creating and modifying table structures. The section on table relationships explains the three main types of how database tables can relate to each other: one-to-one, one-to-many, and many-to-many. The advanced section covers topics like indexes, which speed up data lookups, triggers, which run automatically when data changes, views, which save queries as reusable named objects, stored procedures, which store complex logic inside the database, and transactions, which group multiple operations so they either all succeed or all fail together. The final section of the course shows how to connect to a database from application code, with examples in Python. Each lesson in the README links directly to the corresponding timestamp in the YouTube video and to the matching SQL file in the repository, so you can follow along in whichever order you prefer.

Copy-paste prompts

Prompt 1
I just learned basic SQL SELECT and WHERE, give me 10 practice exercises to filter, sort, and limit results from a products database table
Prompt 2
Show me how to write SQL stored procedures and triggers for a simple e-commerce database with orders, customers, and inventory tables
Prompt 3
I'm following the hello-sql course section on transactions, write a practice example that demonstrates BEGIN, COMMIT, and ROLLBACK with a bank transfer scenario
Prompt 4
How do I connect a Python script to a PostgreSQL database and run parameterized SQL queries to read and insert rows?
Prompt 5
Design a relational database schema that demonstrates one-to-one, one-to-many, and many-to-many relationships for a school management system, with SQL to create all the tables
Open on GitHub → Explain another repo

← mouredev on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.