Scratch the image to get a discount on your course. You'll be able to apply the coupon at checkout.

5.0 /5
(24)

86
Bienvenidos al curso de SQL
Cómo sacarle el máximo partido al curso
El repositorio Github del Curso
Toma notas de tu curso en tiempo real en Frogames Formación
Descarga el editor MySQL Workbench
Crea tu primera conexión SQL
Conexiones avanzadas a MySQL Workbench
Un tour por las funcionalidades de Workbench
La historia de la evolución de SQL, desde los años 60 hasta el siglo XXI
La sintaxis básica de SQL
SQL Interactivo vs SQL Hospedado
Introducción a las sentencias de definición
Crear esquemas
Eliminar esquemas
Esquemas
Solución al ejercicio de esquemas
Crear tablas
Tipos de Datos: Números
Tipos de datos: Cadenas de Caracteres
Tipos de Datos: Fechas
Restricciones de las columnas
Restricciones sobre la tabla
Tablas
Solución al ejercicio de tablas
Crear un Dominio
Ejemplo de Dominio: las provincias de Cataluña
Eliminar un Dominio
Modificar un Dominio
Definiciones de Valores por Defecto
Políticas de borrado y actualización de claves foráneas
Aserciones
Modificar y Eliminar Tablas
Modificar Tablas
Solución al ejercicio de las tablas
Crea la base de datos BDINFO
Solución a la creación de la base de datos BDINFO
Crear Vistas
Ejemplos de vistas
Eliminar una vista
¿Qué son las sentencias de Manipulación?
Insertar datos en una tabla
Insertar datos
Solución a la inserción de datos
Eliminar datos de una tabla
Insertar la información en la base de datos BDINFO
Solución a la inserción de datos en BDINFO
Consultas con SELECT
Filtrado con WHERE
Valores únicos con DISTINCT
Agregaciones de valores numéricos
Subconsultas
Filtrado de valores con BETWEEN
Filtrado de valores con IN
Filtrado de valores con LIKE
Filtrado de valores nulos
Filtrado de valores con SOME, ANY y ALL
Filtrado de valores con EXISTS
Ordenar valores de una consulta
Agrupación de valores
Combinación de tablas
Sintaxis completa del JOIN
Natural Join
Inner vs Outer Join
Joins de tres o más tablas
Unión de consultas
Intersección de consultas
Diferencia de consultas
Práctica de Consultas a SQL
Solución a los ejercicios de SQL
Las sentencias de control en SQL
Transacciones en SQL
Cómo crear un usuario para la base de datos
Otorgar permisos de acceso a los usuarios
Cambiar permisos de acceso manualmente en MySQL
Revocar permisos a los usuarios
Eliminar usuarios de la base de datos
Una introducción a los sublenguajes especializados
Qué es el SQL Hospedado
SQL/CLI (Call Level Interface)
Ejercicio 1: La base de datos de los vuelos
Ejercicio 2: Inserción de datos de vuelos
Ejercicio 3: Consultas a la base de datos de los vuelos
Ejercicio 4: Derivados de la base de datos de los vuelos
Ejercicio 5: Mis películas favoritas
¿Qué has aprendido en este curso?
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(24)

  • Avatar
    Nieves
    (5)
    SQL from A to Z: master queries, structures and optimization in relational databases

    This course teaches you SQL from scratch, including database creation, table design, data manipulation, complex queries, aggregate functions, operators, transactions and access control. You'll learn to work with management systems like MySQL, SQL Server or PostgreSQL, and you'll apply best practices to ensure integrity, performance and security. The approach is practical and progressive, ideal for those who want to apply SQL in backend development, data analysis or systems administration.

  • Avatar
    Jorge
    (5)
    The ultimate guide I needed!

    I don't have to be asking in forums how to do every query anymore, because here they explain everything from the most basic to the most complex. I love the clarity with which they teach and how you can apply everything right away. It's a tool I'm going to consult for life.

  • Avatar
    Yeison
    (5)
    Excellent for starting my Data Engineering career

    This course lets me understand the theoretical and practical concepts of SQL. In my personal and professional projects it's helped me grasp and optimize my queries and database creation. Thanks so much to you and the Frogames team

  • Avatar
    Santiago
    (5)
    I've loved everything I've learned about SQL

  • Avatar
    Nicolás
    (5)
    I loved how JOINs and subqueries were broken down

  • Avatar
    Javi
    (5)
    I speak the language of data

    Now I can make requests to databases without beating around the bush. It's saved me hours of manual work and I feel much more agile in my day-to-day.

  • Avatar
    Giovanni
    (5)
    Total Query Mastery

    This is definitely the ultimate SQL course if you want to go from the absolute basics to advanced data management. I loved the amount of practical exercises it includes, since they force you to think and master the language in a way that really sticks with you; now I feel like I can handle any database with total confidence!

  • Avatar
    Rocío
    (5)
    Recommended for both beginners and those looking to strengthen best practices and performance.

  • Avatar
    Jackeline
    (5)
    great explanation!

  • Avatar
    Rosa
    (5)
    Excellent!

    The course was exactly what I needed! It took me from knowing nothing about SQL to being able to query databases like a pro.

  • Avatar
    María
    (5)
    A Complete Guide to SQL

    This course lives up to its name: it covers SQL from A to Z. Perfect whether you're just starting out or already have some experience under your belt. I learned commands I didn't even know existed and I'm already using them in my projects.

  • Avatar
    Angel
    (5)
    SQL from A to Z: master database language with precision and fluency

    This Frogames course is a comprehensive guide to learning SQL from scratch, ideal for students, developers, and analysts who want to manipulate data efficiently and professionally. Through clear explanations and practical exercises, you'll learn to create, query, modify, and manage relational databases using standard SQL commands.

  • Avatar
    Gustavo
    (5)
    SQL from A to Z: master the language of data with clarity and confidence

    The SQL from A to Z course is a complete, practical and accessible guide for those who want to master the most widely used language in database management. From first steps to advanced queries, each module is designed with pedagogical precision, allowing students to progress with confidence and enthusiasm.

  • Avatar
    Samuel
    (5)
    I'd recommend it with my eyes closed

    I felt lost with so many SQL commands, but this course cleared things up for me. Now I make complex queries without breaking a sweat and my boss is impressed.

  • Avatar
    Carlos
    (5)
    SQL from Zero to Expert Level

    An essential course for any analyst or programmer!

  • Avatar
    Gabriela
    (5)
    A Complete Journey

    Due to the nature of the career I chose, mastering SQL is essential. I finished the course feeling ready for any database challenge.

  • Avatar
    Maria del Mar
    (5)
    Great course

    Perfect for starting to use SQL and applying it in my work. Juan Gabriel resolves all my doubts instantly!!

  • Avatar
    Miguel Ángel
    (5)
    New Knowledge Acquired

    I usually work in backend, so working with databases and using data manipulation statements is frequent in my day-to-day. The course allowed me to practice topics that I use less often in my daily work, like views or triggers. As always, another great Frogames course

  • Avatar
    Yvonne
    (5)
    I'm happy to have a course like this

    SQL is essential if you want to manage a relational database, good luck with this course

  • Avatar
    Joiser
    (5)
    Quite practical exercises

    It starts from the basics, but gradually goes deeper into more advanced topics in a clear and structured way. What I liked most was the amount of practical exercises, which really helped me consolidate what I learned

  • Avatar
    Miguel Angel
    (5)
    Excellent course.

    Very well explained content.

  • Avatar
    Alberto
    (5)
    Great course

    Excellent course to learn SQL

  • Avatar
    danison
    (5)
    SQL from A to Z recommendation.

    This course is an excellent option for anyone looking to learn about SQL, from creating tables and simple queries, to data manipulation and optimization. The course covers a wide range of relevant topics for those working in this field. Plus, it offers practical, interactive examples that let you apply what you've learned and improve your technical SQL skills. Overall, the course comes highly recommended for anyone wanting to deepen their knowledge and mastery.

  • Avatar
    Caty
    (5)
    Great course

    Great course. The exercises and practical projects are very useful for reinforcing the knowledge acquired and putting what you've learned into practice.

View More Reviews

PLANS TO MATCH YOUR GOALS AND NEEDS

Buy the individual course, get all the learning path or access to the entire platform

Choose the payment method that works best for your needs and budget with a one-time course payment, monthly or yearly access to the learning Path, or even to the entire platform.

One-Time Payment

Buy the course once and access it for life

59.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Popular

Bronze Frog

Access all Frogames courses, communities and extras

39 /month

  • Single payment of 39€ per month
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

Database Path

Access all courses in the Database Path

19.99 /month

  • Single payment of 19.99€ per month
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress

One-time payment

Buy the course once and access it for life

59.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Valorado

Gold Frog

Access all Frogames courses, communities and extras

349 /year

  • Single payment of €349 per year
  • 3 months of discount
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Resource Library
  • Monthly Q&A livestreams
  • Premium support

Database Path

Access all courses in the Database Path

199 /year

  • Single annual payment of €199
  • 4 months of discount
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Premium support

* All prices include taxes.

For your security, all orders will be processed on a secure server.

Database Path

The ultimate bundle with all our Database courses so you can learn everything you need to know about SQL and databases. Includes upcoming courses and updates and improvements to current ones.

Git y GitHub de la A a la Z: Todo sobre el control de versiones

Learn the fundamental concepts and essential workflow for version control using Git and GitHub from scratch!

106 classes

Introduction to Databases

Learn the fundamentals of how digital representations work and how they connect with the real world and abstract concepts. Master database terminology from A to Z.

76 classes

Fundamentos del Modelo Relacional de Datos y Álgebra Relacional

Dive into the world of relational algebra and advance with steady steps in the world of databases

70 classes

SQL from A to Z

From creating databases to having total control of your queries, this course will take you from beginner to expert in handling data efficiently

86 classes

Diseño de bases de datos de la A a la Z

Learn about database design, from initial concepts to SQL implementation

76 classes

Databases: Learn SQL from scratch

Learn SQL, the language of databases, from scratch with practical exercises to master loading, querying, modifying and managing your data while learning all the key SQL commands.

82 classes

Business Data Science con Python y SQL Server

Data Analysis for Business Decision Making based on Descriptive, Diagnostic, Predictive and Prescriptive Analytics

51 classes

Power BI, SQL y Desarrollo Web integrados para Seguimiento de Tareas

The BI analyst must have the ability to identify data potentially important for the business and that, when processed, can become a solid foundation for decision-making.

38 classes

Ciencia de datos con MySQL, RStudio y Power BI: Casos Reales

Put yourself in the shoes of a data scientist looking at different real-world scenarios

54 classes