¡El poder de los datos!
¡El poder de los datos!
Introducción a las bases de datos relacionales
Buenas prácticas de bases de datos con SQL
Tipos de datos en SQL
¿Cómo crear una base de datos en SQL?
Práctica: Tu primera consulta en bases de datos
Historia y Evolución de SQL
Práctica: Creación de Tablas en SQL (CREATE TABLE)
Manipulación de Datos
Insertando Datos con SQL (INSERT)
Consultas y Selecciones en SQL (SELECT)
Práctica: SELECT en SQL
Actualización de Datos con SQL (UPDATE)
Eliminación de Datos con SQL (DELETE)
Práctica: CRUD con SQL
Manipulación Avanzada de Datos
Instalación de MySQL Server y MySQL Workbench
¿Qué es la cláusula WHERE de SQL?
Filtrar y Ordenar Datos en SQL (LIKE)
Práctica: Filtrar Datos con WHERE en SQL
Cláusulas de Comparación Textual en SQL (AND, NULL, IN, NOT)
Funciones de Aritmética Básica en SQL (COUNT, SUM, AVG)
Funciones de Aritmética Básica en SQL (MIN, MAX)
Agrupación de Datos
Agrupación de Datos en SQL: GROUP BY, HAVING y CASE para Análisis Avanzado
Práctica: Agrupamiento y Ordenamiento de Datos
Tipos de JOIN en SQL
¿Cómo funciona INNER JOIN, LEFT JOIN, RIGHT JOIN y FULL JOIN?
Práctica: LEFT JOIN en SQL
Transformación de Datos
Vistas Materializadas en SQL: Como optimizar tus consultas y reportes.
Práctica: Crear Vistas Materializadas en SQL
Optimización de Bases de Datos con SQL: CREATE INDEX y TRIGGER
Vistas Materializadas y Temporales en SQL
Expresiones de Tablas Comunes (CTE) en SQL
Procedimientos Almacenados
Procedimientos Almacenados en SQL
Procedimientos Almacenados en SQL: Gestión de Variables y Manejo de Excepciones
Administración de Base de Datos
Respaldos y Restauración de Bases de Datos
Seguridad en Bases de Datos SQL
Análisis de Datos Avanzados
Potenciando los Datos en la Nube: Data Science, Big Data, ML e AI
SQL para Análisis de Datos: Primeros pasos con Power BI
No tienes acceso a esta clase
¡Continúa aprendiendo! Únete y comienza a potenciar tu carrera
Si ya tienes una cuenta,
No se trata de lo que quieres comprar, sino de quién quieres ser. Invierte en tu educación con el precio especial
Antes: $249
$209
Paga en 4 cuotas sin intereses
Termina en:
12 Días
3 Hrs
15 Min
32 Seg
Práctica: Filtrar Datos con WHERE en SQL
17/36Aportes 70
Preguntas 0
Ordenar por:
Que increible prueba, la he realizado asi:
`SELECT *`
`FROM COURSES`
`WHERE n_reviews > 0;`
`SELECT *`
`FROM COURSES`
`WHERE n_reviews BETWEEN 1 AND 100;`
`SELECT name`
`FROM COURSES`
`WHERE name LIKE "%SQL%";`
```js
SELECT * FROM COURSES
WHERE n_reviews >= 1;
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSES
WHERE name like '%sql%'
```
No me carga la practica 09/11/2024
500 Internal Server Error
SELECT \*FROM COURSES
where n\_reviews >0;
SELECT \*FROM COURSES
where n\_reviews between 1 and 100;
SELECT NAME FROM COURSES
WHERE NAME LIKE '%SQL%';
Comparto la respuesta:
SELECT \*FROM COURSESWHERE n\_reviews >=1;
SELECT \*FROM COURSESWHERE n\_reviews between 1 and 100;
SELECT \*FROM COURSESWHERE name like '%SQL%';
SELECT \* FROM COURSES WHERE n\_reviews > 1;SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \* FROM COURSES WHERE name LIKE '%SQL%';
\-- Escribe tu código aquí 👇SELECT \*FROM COURSESwhere n\_reviews>0;
SELECT \*FROM COURSESwhere n\_reviewsbetween 1 and 100;
SELECT \*FROM COURSESwhere name like '%SQL%';
mi aporte:
SELECT \*FROM COURSESWHERE N\_REVIEWS >=1;
SELECT \*FROM COURSESWHERE N\_REVIEWS BETWEEN 1 AND 100;
SELECT \*FROM COURSESWHERE NAME LIKE '%SQL%';
Acá dejo mi aporte:
```js
SELECT *
FROM COURSES
WHERE N_REVIEWS >=1;
SELECT *
FROM COURSES
WHERE N_REVIEWS BETWEEN 1 AND 100;
SELECT *
FROM COURSES
WHERE NAME LIKE '%SQL%';
```SELECT \*FROM COURSESWHERE N\_REVIEWS >=1;
SELECT \*FROM COURSESWHERE N\_REVIEWS BETWEEN 1 AND 100;
SELECT \*FROM COURSESWHERE NAME LIKE '%SQL%';
Mi solución, aunque no fue tan sencillo llegar a ella:
```python
SELECT * FROM COURSES WHERE n_reviews > 0;
SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;
SELECT * FROM COURSES WHERE name LIKE '%SQL%';
```SELECT \* FROM COURSES WHERE n\_reviews > 0;SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \* FROM COURSES WHERE name LIKE '%SQL%';
\-- Escribe tu código aquí 👇SELECT \* FROM COURSESWHERE N\_REVIEWS > 0;
SELECT \* FROM COURSESWHERE N\_REVIEWS BETWEEN 1 AND 100;
SELECT name FROM COURSESWHERE name LIKE "%SQL%";
\-- Seleccionar todos los cursos con al menos 1 reviewSELECT \* FROM courses WHERE n\_reviews >= 1;-- Seleccionar todos los cursos con entre 1 y 100 reviewsSELECT \* FROM courses WHERE n\_reviews BETWEEN 1 AND 100;-- Seleccionar los nombres de los cursos que contienen "SQL"SELECT name FROM courses WHERE name LIKE '%SQL%';
```txt
-- Escribe tu código aquí 👇
SELECT * FROM COURSES
WHERE n_reviews >= 1;
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSES
WHERE name LIKE '%SQL%';
```
SELECT \* FROM COURSES where n\_reviews >= 1;
SELECT \* FROM COURSES where n\_reviews between 1 and 100;
SELECT name from COURSESwhere name like '%sql%';
`SELECT *`
`FROM COURSES`
`WHERE n_reviews != 0;`
`SELECT * FROM COURSES`
`WHERE n_reviews BETWEEN 1 and 100;`
`SELECT name FROM COURSES`
`WHERE name LIKE '%SQL%';`
Me gusto este ejercicio. Aqui les muestro mi respuesta:
-- Escribe tu código aquí 👇SELECT \*FROM COURSESWHERE n\_reviews > 0;
SELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSESWHERE name LIKE '%SQL%';```js
-- Escribe tu código aquí 👇
SELECT *
FROM COURSES
WHERE n_reviews > 0;
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSES
WHERE name LIKE '%SQL%';
```
`-- Escribe tu código aquí 👇SELECT * FROM COURSESWHERE n_reviews >=1;`
`SELECT * FROM COURSESWHERE n_reviews BETWEEN 1 AND 100;`
`SELECT name FROM COURSES WHERE name LIKE "%SQL%";`
Y yo FELIZ:
\-- Escribe tu código aquí 👇SELECT \*FROM COURSESWHERE n\_reviews >= 1;
SELECT \*FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT nameFROM COURSESWHERE name LIKE "%SQL%";
Este es mi respuesta frente al reto en la primera parte no use mayor o igual a 1 o a 0 lo que hice fue usar el de diferente "!="
\-- PARTE 1
SELECT \*
FROM COURSES
WHERE n\_reviews != 0;
\-- PARTE 2
SELECT \*
FROM COURSES
WHERE n\_reviews BETWEEN 1 AND 100;
\-- PARTE 3
SELECT \*
FROM COURSES
WHERE name LIKE '%SQL%'
Recuerden borrar la sentencia que propone el ejercicio al inicio. Y solo dejar lo que piden.
SELECT \* FROM COURSESWHERE n\_reviews > 1;
SELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT \* FROM COURSESWHERE name LIKE '%SQL%';
`SELECT * FROM COURSESWHERE n_reviews >= 1;`
`SELECT * FROM COURSESWHERE n_reviews BETWEEN 1 AND 100;`
`SELECT nameFROM COURSESWHERE name like "%SQL%";`
`SELECT * FROM COURSES WHERE n_reviews > 0;SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;SELECT NAME FROM COURSES WHERE NAME LIKE "%SQL%";`
SELECT \* FROM COURSES WHERE n\_reviews >=1;
SELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSESWHERE name LIKE "%SQL%";
interesante,
![]()
SELECT \*FROM COURSESWHERE N\_REVIEWS BETWEEN 1 AND 100;
SELECT \* FROM COURSES WHERE name LIKE "%SQL%";
SELECT \*FROM COURSESWHERE n\_reviews >0;
SELECT \* FROM COURSESWHERE n\_reviews between 1 AND 100;
SELECT \* FROM COURSESWHERE name LIKE '%SQL%';
Mi respuesta
\-- Escribe tu código aquí 👇
SELECT \*FROM courses
WHERE n\_reviews > 1;
\--Reto2-->
SELECT \*FROM courses
WHERE n\_reviews BETWEEN 1 AND 100;
\--Reto3-->
SELECT name
FROM courses
WHERE name LIKE "%SQL%";
SELECT \*FROM COURSES WHERE n\_reviews>0 ;
SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;
SELECT \* FROM COURSES WHERE name LIKE '%SQL%'
SELECT id, name, n\_reviews
FROM courses
WHERE (n\_reviews > 0)
OR (n\_reviews BETWEEN 1 AND 100)
OR (name LIKE '%SQL%');
MI SOLUCION:
```js
SELECT *
FROM COURSES WHERE n_reviews > 0;
SELECT *
FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;
SELECT name
FROM COURSES WHERE name LIKE "%SQL%";
```
A continuación mis queries:
```js
-- Escribe tu código aquí 👇
SELECT *
FROM COURSES
WHERE n_reviews >= 1;
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT name FROM COURSES
WHERE name LIKE '%SQL%';
```
```txt
-- Escribe tu código aquí 👇
SELECT * FROM COURSES
WHERE n_reviews > 1;
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT NAME FROM COURSES
WHERE NAME LIKE '%SQL%';
```-- Escribe tu código aquí 👇SELECT \* FROM COURSESWHERE n\_reviews > 1;
SELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT NAME FROM COURSESWHERE NAME LIKE '%SQL%';
SELECT \*FROM COURSESWHERE 1 =1 AND n\_reviews >= 1;
SELECT \* FROM COURSESWHERE 1 = 1 AND n\_reviews BETWEEN 1 AND 100;
SELECT NAME FROM COURSESWHERE 1 = 1 AND NAME LIKE '%SQL%';
LIKE es un operador utilizado principalmente en cláusulas WHERE para buscar patrones en datos de texto
SELECT name
FROM COURSES
WHERE name LIKE "%SQL%";
Así fue como yo lo hice
SELECT \* FROM COURSESWHERE n\_reviews > 1;
SELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT \* FROM COURSESWHERE NAME LIKE '%SQL%'
```js
-- 1 consulta
SELECT * FROM COURSES
WHERE n_reviews > 1;
-- 2da consulta
SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
-- 3ra Consulta
SELECT name FROM COURSES
WHERE name LIKE "%SQL%";
```-- 1 consultaSELECT \* FROM COURSESWHERE n\_reviews > 1;
\-- 2da consultaSELECT \* FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
\-- 3ra ConsultaSELECT name FROM COURSESWHERE name LIKE "%SQL%";
`SELECT * FROM COURSES where n_reviews > 1;`
`select * from courses where n_reviews between 1 and 100;`
`select name from courses where name like '%SQL%';`
Mi ejercicio
```html
-- Escribe tu código aquí 👇
SELECT * FROM COURSES
WHERE N_REVIEWS > 0;
SELECT * FROM COURSES
WHERE N_REVIEWS BETWEEN 1 AND 100;
SELECT * FROM COURSES
WHERE NAME LIKE "%SQL%";
```
SELECT \*
FROM COURSES
WHERE n\_reviews > 0;
SELECT \*
FROM COURSES
WHERE n\_reviews > 1 AND n\_reviews <= 100;
SELECT \*
FROM COURSES
WHERE name LIKE "%SQL%";
```js
SELECT * FROM COURSES
WHERE n_reviews > 0;
SELECT * FROM COURSES
WHERE n_reviews >= 1 AND n_reviews <= 100;
SELECT name FROM COURSES
WHERE name LIKE '%SQL%';
```SELECT \* FROM COURSESWHERE n\_reviews > 0;
SELECT \* FROM COURSESWHERE n\_reviews >= 1 AND n\_reviews <= 100;
SELECT name FROM COURSESWHERE name LIKE '%SQL%';
```js
SELECT * FROM COURSES
WHERE n_reviews > 0;
SELECT * FROM COURSES
WHERE n_reviews >= 1 AND n_reviews <= 100;
SELECT name FROM COURSES
WHERE name LIKE '%SQL%';
```
\-- Escribe tu código aquí 👇SELECT \* FROM COURSES C WHERE C.n\_reviews > 0;
SELECT \* FROM COURSES C WHERE C.n\_reviews BETWEEN 1 AND 100;
SELECT \* FROM COURSES C WHERE C.name LIKE '%SQL%';
Me encanta este pedo del confeti
🥳🎊
SELECT \* FROM COURSES WHERE n\_reviews > 0;SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \* FROM COURSES WHERE name LIKE "%SQL%";
SELECT \*FROM COURSES WHERE n\_reviews > 0;
SELECT \* FROM COURSES WHERE n\_reviews BETWEEN 1 AND 100;
SELECT \* FROM COURSES WHERE name LIKE '%SQL%';
Lo realicé de esta manera:
`SELECT * FROM COURSES C WHERE C.n_reviews > 0;`
`SELECT * FROM COURSES C WHERE C.n_reviews BETWEEN 1 AND 100;`
`SELECT * FROM COURSES C WHERE C.name LIKE '%SQL%';`
Lo tengo bien escrito y me ejecuta porque rayos me dice que no, que rabia
Si usan 'SQL' da error al utilizar comillas simples, "%SQL%" Con comillas funciona perfectamente.
```js
SELECT *
FROM COURSES
WHERE n_reviews > 0;
SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;
SELECT name
FROM COURSES
WHERE name LIKE "%SQL%";
```SELECT \*FROM COURSESWHERE n\_reviews > 0;
SELECT \*FROM COURSESWHERE n\_reviews BETWEEN 1 AND 100;
SELECT nameFROM COURSESWHERE name LIKE "%SQL%";
¿Quieres ver más aportes, preguntas y respuestas de la comunidad?