GuideIntermediate
Workbook - SQL Mini-Bootcamp
- 83
- lessons
- 11
- modules
- English · Spanish
- available in
- Free
- access
Content
The syllabus, module by module
Open any of them to see its lessons.
- welcome
- windows-installation
- 03. Installing MySQL on Mac
- 01. Week 1 Objectives
- 02. What is a Relational Database?
- 03. Verify and Configure Your MySQL Environment
- 04. MySQL Workbench - Your Work Environment
- 05. Create Your First Database and Tables
- 06. Data Types in MySQL
- 07. Your First SELECT - Basic Queries
- Week 1 — Review and Deliverables Session: Your first database, live
- 01. Week 2 Objectives
- 02. INSERT INTO - Insert Data
- 03. UPDATE - Modify Data
- 04. DELETE - Remove Data
- 05. NULL and DEFAULT Values
- 06. Basic Transactions
- 07. Best Practices for Data Modification
- Week 2 — Live Review & Submission: Modifying data without destroying the business
- 01. Week 3 Objectives - Relationships and Keys
- 02. PRIMARY KEY
- 03. FOREIGN KEY
- 04. 1:1 and 1:N Relationships
- 05. N:M Relationships (Many to Many)
- 06. Referential Integrity - ON DELETE and ON UPDATE
- 07. Additional Constraints and ERD Diagrams
- Week 3 — Review and Deliverables Session: Connecting tables with FOREIGN KEY
- 01. Week 4 Objectives — JOINs and Relationships
- 02. JOINs — Combining Data from Multiple Tables
- 03. INNER JOIN — Only the matches
- 04. LEFT JOIN and RIGHT JOIN — Preserving rows without a match
- 05. Multiple JOINs — 3 or more tables
- 06. SELF JOIN and CROSS JOIN — Special cases
- 07. Aliases, clarity, and best practices
- Week 4 — Review & Submission Session: Combining tables with JOINs
- 01. Week 5 Objectives — Aggregations and Grouping
- 02. Aggregate Functions - COUNT, SUM, AVG, MIN, MAX
- 03. GROUP BY - Group Results
- 04. HAVING - Filter Groups
- 05. Combining GROUP BY and ORDER BY
- 06. Scalar Functions vs Aggregate Functions
- 07. Advanced Reports and Summaries
- Week 5 — Review & Submission Session: Analytical dashboard with JOINs and aggregations
- 01. Week 6 Objectives - Subqueries and Advanced Operators
- 02. What Subqueries Are
- 03. Subqueries in WHERE and SELECT
- 04. Correlated Subqueries
- 05. IN, NOT IN, and EXISTS Operators
- 06. ANY, ALL, and SOME Operators
- 07. UNION and UNION ALL
- Week 6 — Review and Submission Session: Subqueries and Advanced Operators
- 01. Week 7 Objectives - Normalization and Advanced Design
- 02. Introduction to Relational Design
- 03. Data Redundancy and Anomalies
- 04. First Normal Form (1NF)
- 05. Second Normal Form (2NF)
- 06. Third Normal Form (3NF)
- 07. Complete Normalization Process
- Week 7 — Review and Submission Session: Normalize a legacy system from 0NF to 3NF
- 01. Week 8 Objectives - Indexes and Performance
- 02. What Indexes Are and How They Work
- 03. Types of Indexes in MySQL
- 04. Creating and Dropping Indexes
- 05. EXPLAIN - Analyzing Execution Plans
- 06. Query Optimization
- 07. Detecting Slow Queries
- Week 8 — Review and Submission Session: Optimize a slow system (from 5s to 50ms)
- 01. Week 9 Objectives - Views (VIEWS)
- 02. What Views Are and What They're For
- 03. Creating Views (CREATE VIEW)
- 04. Modifying and Dropping Views
- 05. Views with JOIN and Aggregations
- 06. Updatable vs Read-Only Views
- 07. Best Practices and Use Cases
- Week 9 — Review and Submission Session: Views to reuse queries and protect data
- 01. Week 10 Objectives - Automation, Security, and Final Project
- 02. Variables and Control Flow
- 03. Stored Procedures - Create and Run
- 04. OUT, INOUT Parameters and Functions
- 05. Triggers - Automation
- 06. Security - Users and Permissions
- 07. SQL Injection and Backup
- Week 10 — Review and Final Project Session: Production-ready HR System (100-pt capstone)
Where it fits
This guide is part of something bigger
It's studied inside these programs, with support and dates.
Common questions
What people usually ask
No limit. It's a free guide: come in whenever you like, as often as you like.
No. Modules run from easier to harder, but you can jump to the one you need. Progress is saved per lesson.
Whatever is needed is listed under “What you need to bring”, above. If nothing is listed there, you can start from zero.
In the Club's WhatsApp group, and every two weeks there's a live with an instructor where questions get worked through.
No. This guide is self-paced with no dates. The bootcamp is live, by cohort, with work someone reviews.
Start whenever you like
What students say
Based on 1 verified review
These reviews are from enrolled students who completed at least 50% of the course. We moderate reviews only on content grounds (spam, offensive language, personal data), never for being critical or negative.
5.0
1 review
me gusta el ritmo del curso, te enseña las partes teoricas con partes practicas para reforzar conceptos. Las unidades estan bien planteadas al crecimiento curso.