15 Days of SQL: The Complete SQL Masterclass 2026
Master SQL in just 15 days from Basics to Pro by working daily on real-life projects
Lo que serás capaz de hacer
Learn SQL with the world’s best SQL course in just 15 days! 1 hour per day, for just 15 days and you will be fluent in SQL! That’s the only course you need to completely master SQL. You will be guided step-by-step from beginner to absolute expert in SQL. Why is this the best course you can take? The most comprehensive course that teaches you everthing from beginner to expert Much more challenges & hands-on coding exercises than other courses Much more real-life advanced topics that other courses don’t cover By the end of this guided experience you will be so fluent in SQL to get a job and work professionally and with a lot of confidence with SQL! This is the most comprehensive & most modern course you can find on SQL. Here is why: Most comprehenisve course with 14 hours video lectures and most topics Master SQL by working on real-life challenges Learn PostgreSQL – the most modern SQL system & easy to transfer to all other SQL dialects We will set up two modern databases and learn everything with realistic data, so you can do everything hands-on! Learn from a real expert - crystal clear & straight-forward Understand everything step by step from the absolute basics to the advanced topics Learn the practical to upskill your career or find a job with SQL We cover every single important topic you will need including the advanced topics other courses do not cover! Including... GROUP BY JOINs Functions UNIONs Data manipulation & Data Definition Views Window functions Grouping sets Rollups Transactions Subqueries Query optimization Indexes and much more! Plus, tons of practical challenges and 2 complete course projects and much more challenges than you can find anywhere else! This course will take you all the way from beginner to being able to upskill your career and make you ready to get a job with SQL! Check out the free video previews and enroll now! See you inside the course!
- Become an SQL Expert in Just 15 Days with a structured, hands-on approach!
- Solve professional-level SQL challenges with hands-on projects
- Write efficient & advanced SQL queries to analyze and manipulate data from complex datasets
- Gain expertise in advanced techniques like joins, subqueries, window functions, and stored procedures
- Learn best practices for query optimization, indexing, and handling large-scale datasets with ease
- Build, manage, and optimize relational databases to support decision-making and business operations.
Temario
UNIDAD 1 - Day 1 - Getting started with SQL! · 33 leccionesUNIDAD 1 - Day 1 - Getting started with SQL!
UNIDAD 1 - Day 1 - Getting started with SQL!
- Welcome!
- How to get the most out of the course
- How this course works
- Why learning SQL?
- Let the Joruney Begin!
- Let's get started!
- What is a database?
- Databases
- Different dialects of SQL
- Dialects of SQL
- Installing PostgreSQL & pgAdmin (Windows)
- Common problems: Set binary paths
- Installing PostgreSQL & pgAdmin (MacOS)
- Setting up the database
- Common problems: Slow performance
- The Project
- SELECT
- SELECT
- Challenge: SELECT
- Solution: SELECT
- ORDER BY
- SELECT & ORDER BY
- Challenge: ORDER BY
- Solution: ORDER BY
- SELECT DISTINCT
- Challenge: SELECT DISTINCT
- Solution: SELECT DISTINCT
- LIMIT
- SELECT DISTINCT & LIMIT
- COUNT()
- COUNT()
- Today's challenges
- Today's summary
UNIDAD 2 - Day 2 - Basics: Filtering · 30 leccionesUNIDAD 2 - Day 2 - Basics: Filtering
UNIDAD 2 - Day 2 - Basics: Filtering
- WHERE
- WHERE
- Challenge: WHERE
- Solution: WHERE
- WHERE operators
- WHERE operators
- Challenge: WHERE operators
- Solution: WHERE operators
- WHERE with AND/OR
- WHERE with AND/OR
- Challenge: WHERE with AND/OR
- Solution: WHERE with AND/OR
- Quick note on time zones
- BETWEEN
- BETWEEN
- Challenge: BETWEEN
- Solution: BETWEEN
- IN
- IN operator
- Challenge: IN
- Solution: IN
- LIKE
- LIKE
- Challenge: LIKE
- Solution: LIKE
- Comments & Aliases
- Today's summary
- Today's challenges
- Introducing Role Plays
- SQL Job Interview – Filtering Logic & Query Thinking
UNIDAD 3 - Day 3 - Basics: Grouping · 20 leccionesUNIDAD 3 - Day 3 - Basics: Grouping
UNIDAD 3 - Day 3 - Basics: Grouping
- Today's plan
- Aggregate functions
- Aggregate functions
- Challenge: Aggregate function
- GROUP BY
- GROUP BY
- Challenge: GROUP BY
- Solution: GROUP BY
- GROUP BY multiple columns
- GROUP BY multiple columns
- Challenge: GROUP BY multiple columns
- Solution: GROUP BY multiple columns
- HAVING
- HAVING
- Challenge: HAVING
- Solution: HAVING
- Introducing the second project
- Note for Mac users
- Important: Problems & solutions of setting up the database
- Today's summary
UNIDAD 4 - Day 4 - Intermediate: Functions · 28 leccionesUNIDAD 4 - Day 4 - Intermediate: Functions
UNIDAD 4 - Day 4 - Intermediate: Functions
- Today's plan
- LENGTH, LOWER & UPPER
- LENGTH, LOWER & UPPER
- Challenge: LENGTH, LOWER & UPPER
- Solution: LENGTH, LOWER & UPPER
- LEFT & RIGHT
- Challenge: LEFT & RIGHT
- Solution: LEFT & RIGHT
- Concatenate
- Concatenate
- Challenge: Concatenate
- Solution: Concatenate
- POSITION
- Challenge: POSITION
- Solution: POSITION
- SUBSTRING
- Challenge: SUBSTRING
- Solution: SUBSTRING
- EXTRACT
- Challenge: EXTRACT
- Solution: EXTRACT
- TO_CHAR
- Challenge: TO_CHAR
- Solution: TO_CHAR
- Intervals & Timestamps
- Challenge: Intervals & Timestamps
- Solution: Intervals & Timestamps
- Today's slides
UNIDAD 5 - Day 5 - Intermediate: Conditional Expressions · 19 leccionesUNIDAD 5 - Day 5 - Intermediate: Conditional Expressions
UNIDAD 5 - Day 5 - Intermediate: Conditional Expressions
- Mathematical functions and operators
- Mathematical functions and operators
- Challenge: Mathematical functions and operators
- Solution: Mathematical functions and operators
- CASE WHEN - Theory
- CASE WHEN - Hands-on
- CASE WHEN
- 3 Challenge: CASE WHEN
- Solutions
- Solution: CASE WHEN
- CASE WHEN & SUM
- CASE WHEN & SUM
- COALESCE
- COALESCE
- CAST
- Challenge: CAST & COALESCE
- Solution: CAST & COALESCE
- REPLACE
- Today's slides
UNIDAD 6 - Day 6 - Intermediate: Joins · 22 leccionesUNIDAD 6 - Day 6 - Intermediate: Joins
UNIDAD 6 - Day 6 - Intermediate: Joins
- What are joins?
- INNER JOIN - Theory
- INNER JOIN - Practice
- FULL OUTER JOIN
- JOIN & WHERE
- LEFT OUTER JOIN
- Challenge: LEFT OUTER JOIN
- Solution: LEFT OUTER JOIN
- RIGHT OUTER JOIN
- Challenge: Joins
- Solution: Joins
- Joins on multiple conditions
- Solution: Joins on multiple conditions
- Joining multiple tables
- Challenge: INNER JOIN
- Solution: INNER JOIN
- Joining multiple tables - Practice
- Challenge: Joining multiple tables
- Solution: Joining multiple tables
- More challenges
- Solutions
- Today's slides
UNIDAD 7 - Day 7 - Advanced: UNION & Subqueries · 20 leccionesUNIDAD 7 - Day 7 - Advanced: UNION & Subqueries
UNIDAD 7 - Day 7 - Advanced: UNION & Subqueries
- UNION
- UNION - Practice
- Subqueries in WHERE
- Challenge: Subqueries in WHERE
- Solution: Subqueries in WHERE
- More challenges: Subqueries in WHERE
- Solution: More challenges
- Subqueries in FROM
- Challenge: Subqueries in FROM
- Solution: Subqueries in FROM
- Subqueries in SELECT
- Challenge: Subqueries in SELECT
- Solution: Subqueries in SELECT
- Correlated Subqueries in WHERE
- Challenge: Correlated subqueries in WHERE
- Solution: Correlated subqueries in WHERE
- Correlated Subquery in SELECT
- More challenges: Correlated subqueres
- Solution: More challenges
- Today's slides
UNIDAD 8 - Day 8 - Advanced: Course project · 17 leccionesUNIDAD 8 - Day 8 - Advanced: Course project
UNIDAD 8 - Day 8 - Advanced: Course project
- Project Introduction
- Challenges
- Solutions
- Solution 1
- Solution 2
- Solution 3
- Solution 4
- Solution 5
- Solution 6
- Solution 7
- Solution 8
- Solution 9
- Solution 10
- Solution 11
- Solution 12
- Solution 13
- Solution 14
UNIDAD 9 - Day 9 - Advanced: Managing tables & databases · 21 leccionesUNIDAD 9 - Day 9 - Advanced: Managing tables & databases
UNIDAD 9 - Day 9 - Advanced: Managing tables & databases
- Managing databases & tables
- CREATE DATABASE
- CREATE & DROP DATABASE
- Data Types
- Data Types
- Constraints
- Constraints
- Primary Key & Foreign Key
- Primary & Foreign Key
- CREATE TABLE
- CREATE TABLE
- INSERT
- INSERT
- ALTER TABLE
- Challenge: ALTER TABLE
- Solution: ALTER TABLE
- TRUNCATE & DROP TABLE
- CHECK
- Challenge: CHECK
- Solution: CHECK
- Today's slides
UNIDAD 10 - Day 10 - Advanced: Views & Data Manipulation · 18 leccionesUNIDAD 10 - Day 10 - Advanced: Views & Data Manipulation
UNIDAD 10 - Day 10 - Advanced: Views & Data Manipulation
- UPDATE
- Challenge: UPDATE
- Solution: UPDATE
- DELETE
- Challenge: DELETE
- Solution: DELETE
- CREATE TABLE AS
- Challenge: CREATE TABLE AS
- Solution: CREATE TABLE AS
- CREATE VIEW
- Challenge: CREATE VIEW
- Solution: CREATE VIEW
- CREATE MATERIALIZED VIEW
- Managing views
- Challenge: Managing views
- Solution: Managing views
- Import & Export
- Today's slides
UNIDAD 11 - Day 11 - Pro: Window Functions · 14 leccionesUNIDAD 11 - Day 11 - Pro: Window Functions
UNIDAD 11 - Day 11 - Pro: Window Functions
- OVER() with PARTITION BY
- Challenge: OVER() with PARTITION BY
- Solution: OVER() with PARTITION BY
- OVER() with ORDER BY
- Challenge: OVER() with ORDER BY
- Solution: OVER() with ORDER BY
- RANK()
- Challenge: RANK()
- Solution: RANK()
- FIRST_VALUE()
- LEAD & LAG
- Challenge: LEAD & LAG
- Solution: LEAD & LAG
- Today's slides
UNIDAD 12 - Day 12 - Pro: Grouping sets, rollups, self-joins · 17 leccionesUNIDAD 12 - Day 12 - Pro: Grouping sets, rollups, self-joins
UNIDAD 12 - Day 12 - Pro: Grouping sets, rollups, self-joins
- GROUPING SETS
- Challenge: GROUPING SETS
- Solution: GROUPING SETS
- Additional challenge
- Solution: Additional Challenge
- ROLLUP
- Challenge: ROLLUP
- Solution: ROLLUP
- CUBE
- Challenge: CUBE
- Solution: CUBE
- Self joins
- Challenge: Self joins
- Solution: Self joins
- CROSS JOIN
- NATURAL JOIN
- Today's slides
UNIDAD 13 - Day 13 - Pro: Course project · 3 leccionesUNIDAD 13 - Day 13 - Pro: Course project
UNIDAD 13 - Day 13 - Pro: Course project
- Project introduction
- The challenges
- Solutions
UNIDAD 14 - Day 14 - Pro: Stored procedures, transactions & user-defined functions · 12 leccionesUNIDAD 14 - Day 14 - Pro: Stored procedures, transactions & user-defined functions
UNIDAD 14 - Day 14 - Pro: Stored procedures, transactions & user-defined functions
- User-defined functions
- User-defined functions - Example
- Challenge: User-defined functions
- Solution
- Transactions
- Challenge: Transactions
- Solution: Transactions
- Rollbacks
- Stored procedures
- Challenge: Stored procedures
- Solution: Stored procedure
- Today's slides
UNIDAD 15 - Day 15 - Pro: Indexes, Partitining & Query Optimization · 14 leccionesUNIDAD 15 - Day 15 - Pro: Indexes, Partitining & Query Optimization
UNIDAD 15 - Day 15 - Pro: Indexes, Partitining & Query Optimization
- User management
- CREATE USER | ROLE
- GRANT & REVOKE privileges
- Privileges - Hands-on
- Challenge: Privileges
- Solution: Privileges
- What are indexes?
- B-Tree index
- Bitmap index
- Indexes - Guidelines
- Creating indexes
- Creating indexes
- Execution plan & query performance
- Today's slides
UNIDAD 16 - Extra Day: CTEs (Common Table Expressions) · 13 leccionesUNIDAD 16 - Extra Day: CTEs (Common Table Expressions)
UNIDAD 16 - Extra Day: CTEs (Common Table Expressions)
- Why an extra day?
- Common Table Expressions (CTEs) - First Example
- Common Table Expressions - More Complex Example
- Challenge 1: Create a simple CTE
- Solution 1: Create a simple CTE
- Common Table Expressions - Using Multiple CTEs
- Challenge 2: Using Multiple CTEs
- Solution 2: Using Multiple CTEs
- Recursive CTEs - Concept
- Recursive CTEs - Hierarchical Data
- Recursive CTEs - Termination Condition
- Challenge 3: Recursive CTE
- Solution 3: Recursive CTE
UNIDAD 17 - Bonus · 1 leccionesUNIDAD 17 - Bonus
UNIDAD 17 - Bonus
- Bonus
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
17 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
8 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Nikolai Schuler.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 17 unidades · 302 lecciones · 60 h
- 12 meses de acceso
- 8 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Nikolai Schuler; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
