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

4.9 /5
(40)

82
Bienvenido al curso de SQL para Data Science
Cómo sacarle el máximo partido al curso
La comunidad de Discord para Aprender con Amigos
Toma notas de tu curso en tiempo real en Frogames Formación
Unos apuntes magníficos de SQL que te van a venir geniales
¿Qué es una base de datos relacional?
SQL: Structured Query Language
Por qué utilizar SQL en Ciencia de Datos?
Instalando MS SQL Server
Integridad de los datos
Organizando un Archivo en Tablas
Archivos csv que vamos a utilizar
Cargando un archivo csv en SQL Server
Los datos en forma de texto en SQL
Los datos numéricos en SQL
Los datos en formato de fechas en SQL
Otros tipos de datos en SQL
Creación de una Base de Datos y sus Tablas desde cero con SQL
Importando registros dentro de una tabla
Ejercicios de final de sección
Respuestas a la Tarea Conceptos Básicos acerca de Bases de Datos
SELECT y FROM
Extrayendo componentes de la fecha
Filtrando la información con SQL: Where, like, igual a, diferente a
Not Like y mas ejemplos de uso de Like
El mundo de las expresiones regulares
Filtrando información numérica
Guardando los resultados en un archivo csv
Select dentro de Select
ORDER BY
SELECT TOP
La paginación con Order, Offset y Fetch
Extrayendo valores unicos con Distinct
SUM, MIN, MAX, COUNT y AVG
GROUP BY y HAVING
UNION
CONCAT
CONCAT_WS
TRIM, LTRIM y RTRIM
CAST y CONVERT
Ejercicios de final de sección
Respuestas Sección de Sentencias Básicas de SQL
Operadores Lógicos
Operadores de Comparacion
Subconsultas Escalonadas
Subconsultas de Lista
Ejercicios de final de sección
Respuestas a los Ejercicios acerca de Operadores
Los inner joins
Los outer joins
El problema de claves repetidas
Uniendo diferentes tablas
Inner Join
Left Join, Right Join y Full Join
Join entre Bases de Datos
Self Join
Consultas complejas utilizando Vistas
Creando una Tabla a partir de otra Tabla o de una Vista
Utilizando Variables en nuestras consultas
CASE
Ejercicios de final de sección
Respuestas a la tarea de la sección uniendo diferentes tablas
INSERT
ALTER TABLE Parte I
ALTER TABLE Parte II
UPDATE
DELETE
Eliminando registros duplicados
DROP y TRUNCATE
Ejercicios de final de sección
Respuestas a la Tarea Modificando las Tablas
Cursores y procedimientos almacenados
Cursores
Utilizando la información almacenada en el cursor
Procedimientos Almacenados
Combinando Cursores y Procedimientos Almacenados
Ejercicios de final de sección
Respuestas a la Tarea Aspectos avanzados acerca de Bases de Datos
Creando una Base de Datos desde RStudio
Creación de una Tabla desde RStudio
Asignando la Llave Primaria de una Tabla desde RStudio
Enhorabuena por completar el curso de SQL

instructor

4.9 /5
(40)

  • Avatar
    Gustavo
    (5)
    SQL from scratch: the course that turns data into smart decisions

    The course Databases: Learn SQL from scratch is an exceptional educational offering for those who want to dive into the world of data management with a solid and practical foundation. Designed for absolute beginners, this course successfully demystifies SQL and presents it as an accessible, logical, and powerful tool.

  • Avatar
    Nieves
    (5)
    Databases: Learn SQL from scratch – query, structure and master your data like a pro

    This course teaches you to work with SQL (Structured Query Language) from the ground up, including database creation, table design, data insertion and modification, simple and advanced queries, aggregate functions, table relationships, and query optimization.

  • Avatar
    Samuel
    (5)
    Worth every minute

    I always thought SQL was complicated, but the teachers made it look easy. Now I can handle databases.

  • Avatar
    Jackeline
    (5)
    Now I can create tables, relationships, and extract useful information for my projects

  • Avatar
    Antonio Jesús
    (5)
    Really good, concise.

    I loved it, Rocío explains really well, with support from Juan Gabriel in some of the more complex sections. Honestly, it felt short to me, I wouldn't mind diving deeper into SQL with a course like the one Juan Gabriel suggests. Thanks to the whole team.

  • Avatar
    Hector
    (5)
    SQL Course

    Great course.

  • Avatar
    Jesus
    (5)
    An extraordinary course to get started in the world of SQL

    When I started the course I had no knowledge of SQL. Now I'm able to create my own databases, run queries and link tables together. It seems to me like a must-take course if you want to work in data analysis. Congrats to Juan Gabriel and Rocío for this excellent course.

  • Avatar
    Miguel Ángel
    (5)
    Essential course to improve your knowledge

    I have experience handling databases in both MySQL and Postgresql but barely any in SQL Server. This course helped me fill that gap. Despite not being very long, it is comprehensive. My only complaint (so to speak) is that, being one of the few courses I've seen that covers cursors and stored procedures, that section is quite short. The instructor explains really well and is also very attentive to solving any problems that might come up. Without a doubt, this course is a great choice

  • Avatar
    Misael A.
    (5)
    Excellent for reinforcing SQL knowledge!

    During my time as a university student, I'd already studied the basics of databases (including the SQL statements covered in the course). However, given the flood of information you're bombarded with during your degree, I have to admit I forgot a lot of that database knowledge. So this course has been excellent for me to re-learn and re-understand the SQL queries that are necessary in the programming world. I highly recommend it to anyone going through the situation I was in, and also to those who don't know much about this field, since the course is well explained 👌🏼.

  • Avatar
    Jorge
    (5)
    I finally get tables!

    It took me years to understand how to organize information properly, but this course explains everything so clearly that the complex queries that used to give me a headache I now knock out in seconds.

  • Avatar
    Javi
    (5)
    I thought coding was just for geniuses

    Now I finally get how to store information and ask for it back without getting confused. It gave me a lot of independence at work because now I can pull my own reports without asking anyone for help.

  • Avatar
    Giovanni
    (5)
    Understanding SQL with clarity

    Now I feel capable of managing any table and understanding how information is structured behind any application, something I consider fundamental nowadays.

  • Avatar
    Santiago
    (5)
    It's true you learn from scratch. Great course

  • Avatar
    Rocío
    (5)
    great course to learn SQL

  • Avatar
    Nicolás
    (5)
    SQL from Scratch

    I highly recommend the course. It's well explained and you learn a lot of things

  • Avatar
    María
    (5)
    Finally, I understand SQL

    This course was exactly what I needed to get started with databases. The explanations are clear, step by step, with plenty of practical examples. Now I feel confident querying and modifying data. Highly recommended!

  • Avatar
    Rosa
    (5)
    it's true, from scratch

    I learned a lot with this course

  • Avatar
    Angel
    (5)
    SQL from scratch: master the language that brings databases to life

    This Frogames course is a complete introduction to SQL, designed for those who want to learn how to query, modify, and manage relational databases with no prior experience.

  • Avatar
    Gabriela
    (5)
    A turning point in my learning

    This course cleared up so many doubts for me. Understanding comes quickly when each concept is explained with practical examples. Now I can run queries and handle data with way more confidence

  • Avatar
    Caty
    (5)
    Essential, valuable and important

    Fundamental for managing and manipulating databases efficiently, something really good and effective

  • Avatar
    Carlos
    (5)
    Database Fundamentals

    Knowing how to manage databases is extremely important, which is why I think it's excellent that Frogames teaches this topic with the professionalism that characterizes its courses.

  • Avatar
    Ever
    (5)
    Excellent course

    Excellent material and very well-explained classes

  • Avatar
    Alexander
    (5)
    Excellent

    I really enjoyed the course, since it's comprehensive and straightforward with the necessary topics to start understanding SQL.

  • Avatar
    Gabriela
    (5)
    very useful

  • Avatar
    Juan Luis
    (5)
    start

    great start, explaining the training's added features very effectively and solid opening notes that make it more enjoyable. Congratulations.

  • Avatar
    ivan sergio
    (5)
    Great Course...!!!

    I think mastering SQL is fundamental for a good data analyst...So I'm looking forward to the next Master in SQL course (Super Saiyan Level 3 Phase)...!!!

  • Avatar
    Alberto
    (5)
    SQL server

    I had zero SQL knowledge when I started, and now I've got a solid foundation—obviously I still need to practice and build on it, but at least programmers can't pull the wool over my eyes anymore. Highly recommended if you're starting from scratch or need a refresher after not using it for a while.

  • Avatar
    Joiser
    (5)
    Ideal for beginners

    The SQL course is perfect for beginners, clearly explaining the fundamentals and basic queries.

  • Avatar
    Marc
    (5)
    Great course

    It helped me a lot to learn this type of language

  • Avatar
    Laura
    (5)
    I'm really enjoying it

    I have the last section left and I have to say I've really liked it.

  • Avatar
    Alexander Maicol
    (1)
    I've done the first 3 sections and I'm not...

    I don't think the teacher explains the course in the right way. I'm 3 modules in and in several cases I've had to guess what she was doing in Management Studio... On the other hand, the explanations are too short and too long for the learner at the same time. I think I'll do the SQL phase on Udemy with another teacher to see if I can understand the concepts better and move forward with the Path. That said, I'm motivated to learn and complete the Path.

  • Avatar
    DAVID VICTOR
    (4)
    SQL

    A good starting point, though you could go much deeper.

  • Avatar
    Josep
    (5)
    Josep Elias

    A course that combines theory and practice really well.

  • Avatar
    Selvie Carolin
    (5)
    Really Well Explained

    The course is really well explained. I have all the information I need to learn SQL in a short time. It would be great if the syntax were written alongside the videos (like in the Python course), so we could find them quickly without having to go through the videos one by one.

  • Avatar
    Brandon
    (4)
    Complete Course for Everyday Use

    I thought it was a good course that correctly introduces you to the world of SQL. They answer questions pretty quickly and grade assignments fast with comments. There are some things I'm not sure might be outdated, but I had trouble running some things that didn't work due to version issues, but apart from that everything went well. I'm looking forward to the BigQuery course.

  • Avatar
    Jesus
    (5)
    SQL COURSE REVIEW

    I enjoyed the course because they explain everything in great detail

  • Avatar
    danison
    (5)
    SQL

    I keep thinking something that makes me happy every morning: as soon as I finish learning on this platform I'll have as many tools in my favor as there are stars in the sky. Another interesting course to explore, SQL is definitely something I'll apply in my career.

  • Avatar
    Matías
    (5)
    Essential this SQL course for my Data Science Path

    Always straight to the point, they explain clearly and concisely, another excellent Frogames course, I'm getting closer every time to having all the tools I need for my STACK!

  • Avatar
    Yvonne
    (5)
    Great course

    Complete, it's ideal for those of us who are just getting started with SQL

  • Avatar
    BORJA
    (5)
    Excellent course!

    Great course to learn SQL.

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

39.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

39.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