GuideIntermediate
Workbook - SQL Mini-Bootcamp
- 83
- lessons
- 11
- modules
- English · Spanish
- available in
- Included in the bootcamp
- 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
This guide is the material for these cohorts: it opens when you enroll, with support and dates.
Common questions
What people usually ask
For as long as your bootcamp enrollment is active. This guide is the cohort's material: it opens when you enroll and isn't sold separately.
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 your cohort's channel, with your instructor and the rest of the group. The bootcamp's live sessions are the other place to ask.
It's the bootcamp's material, not a replacement for it. The bootcamp adds dates, a cohort, reviewed work and support; this guide is what you study inside it.
Come in with your cohort
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.