GuideIntermediate
Workbook - SQL Mini-Bootcamp (DBeaver Edition)
_Pendiente de redactar._
- lessons
- 83
- modules
- 11
- available in
- English · Spanish
- access
- Included in the bootcamp

The syllabus, module by module
Open any of them to see its lessons.
- 01. Welcome to the SQL Mini-Bootcamp (DBeaver Edition)
- 02. Windows Installation: MySQL 8.4 and DBeaver
- 03. Mac Installation: MySQL 8.4 and DBeaver
- 01. Week 1 Objectives
- 02. What Is a Relational Database?
- 03. Verify MySQL and Connect DBeaver
- 04. DBeaver: Your Work Environment
- 05. Creating Your First Database and Tables
- 06. Data Types in MySQL
- 07. Your First SELECT: Basic Queries
- 08. Live session and delivery: the StreamFlix catalog
- 01. Objectives of Week 2
- 02. INSERT INTO: inserting data
- 03. UPDATE: modifying data
- 04. DELETE: removing data
- 05. NULL and DEFAULT values
- 06. Basic transactions
- 07. Data modification best practices
- 08. Live session and delivery: changing data without destroying the business
- 01. Week 3 Objectives: Relationships and Keys
- 02. PRIMARY KEY: The Primary Key
- 03. FOREIGN KEY: The Foreign Key
- 04. One-to-One and One-to-Many Relationships
- 05. Many-to-Many (N:M) Relationships
- 06. Referential Integrity: ON DELETE and ON UPDATE
- 07. Constraints and the ER Diagram in DBeaver
- 08. Live session and delivery: BiblioTech, tables connected with keys
- 01. Week 4 Objectives: JOINs and relationships
- 02. JOINs: combining data from several tables
- 03. INNER JOIN: only the matches
- 04. LEFT JOIN and RIGHT JOIN: keeping rows without a match
- 05. Several JOINs: three tables or more
- 06. SELF JOIN and CROSS JOIN: special cases
- 07. Aliases, clarity and best practices
- 08. Live session and delivery: combining tables with JOINs
- 01. Week 5 Objectives: Aggregations and Grouping
- 02. Aggregate Functions: COUNT, SUM, AVG, MIN and MAX
- 03. GROUP BY: Grouping Results
- 04. HAVING: Filtering Groups
- 05. Combining GROUP BY and ORDER BY
- 06. Scalar Functions versus Aggregate Functions
- 07. Reports and Summaries
- 08. Live session and delivery: TechMart's executive dashboard
- 01. Week 6 Objectives: Subqueries and Advanced Operators
- 02. What Subqueries Are
- 03. Subqueries in WHERE and SELECT
- 04. Correlated Subqueries
- 05. The IN, NOT IN and EXISTS Operators
- 06. The ANY, ALL and SOME Operators
- 07. UNION and UNION ALL
- 08. Live session and delivery: subqueries and advanced operators
- 01. Week 7 Objectives: Design and Normalization
- 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. The Full Normalization Process
- 08. Live session and delivery: TechStore, from a legacy table to 3NF
- 01. Week 8 Goals: Indexes and Performance
- 02. What Indexes Are and How They Work
- 03. MySQL Index Types
- 04. Creating and Dropping Indexes
- 05. EXPLAIN: Analyzing Execution Plans
- 06. Query Optimization
- 07. Detecting Slow Queries
- 08. Live session and delivery: MegaMart, from "never finishes" to milliseconds
- 01. Week 9 Goals: Views (VIEWS)
- 02. What Views Are and What They Are For
- 03. Creating Views with CREATE VIEW
- 04. Modifying and Dropping Views
- 05. Views with JOIN and Aggregations
- 06. Updatable and Read-Only Views
- 07. Best Practices and Use Cases
- 08. Live session and delivery: TechStore's view catalog
- 01. Week 10 Objectives: automation, security and final project
- 02. Variables and control flow
- 03. Stored procedures: creating and running
- 04. `OUT` and `INOUT` parameters and functions
- 05. Triggers: automation
- 06. Security: users and permissions
- 07. SQL injection and backup
- 08. Live session and final project: GlobalTech's HR system
Keep going with the full bootcamp.
This guide is the material for these bootcamps: it opens when you enroll.
What people usually ask
For as long as you have access to the bootcamp. This guide is its 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 the community forum. In a 1:1 program, also in your weekly session.
It's the bootcamp's material, not a replacement for it: this guide is what you study inside it.
Join the bootcamp
What students say
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.
No approved reviews yet.
Be the first to share your experience!