Bienvenida conceptos b谩sicos y contexto hist贸rico de las Bases de Datos

1

Bienvenida conceptos b谩sicos y contexto hist贸rico de las Bases de Datos

2

Playground: tu primera consulta en bases de datos

Introducci贸n a las bases de datos relacionales

3

Historia de las bases de datos relacionales

4

Qu茅 son entidades y atributos

5

Entidades de Platzi Blog

6

Relaciones

7

M煤ltiples muchos

8

Diagrama ER

9

Diagrama F铆sico: tipos de datos y constraints

10

Diagrama F铆sico: normalizaci贸n

11

Formas normales en Bases de Datos relacionales

12

Diagrama F铆sico: normalizando Platziblog

RDBMS (MySQL) o c贸mo hacer lo anterior de manera pr谩ctica

13

Instalaci贸n local de un RDBMS (Windows)

14

驴Qu茅 es RDB y RDBMS?

15

Instalaci贸n local de un RDBMS (Mac)

16

Instalaci贸n local de un RDBMS (Ubuntu)

17

Clientes gr谩ficos

18

Servicios administrados

SQL hasta en la sopa

19

Historia de SQL

20

DDL create

21

Playground: CREATE TABLE

22

CREATE VIEW y DDL ALTER

23

DDL drop

24

Playground: VIEW, ALTER y DROP en SQL

25

DML

26

Playground: CRUD con SQL

27

驴Qu茅 tan standard es SQL?

28

Creando Platziblog: tablas independientes

29

Creando Platziblog: tablas dependientes

30

Creando Platziblog: tablas transitivas

Consultas a una base de datos

31

驴Por qu茅 las consultas son tan importantes?

32

Estructura b谩sica de un Query

33

SELECT

34

Playground: SELECT en SQL

35

FROM y SQL JOINs

36

Utilizando la sentencia FROM

37

Playground: FROM y LEFT JOIN en SQL

38

WHERE

39

Utilizando la sentencia WHERE nulo y no nulo

40

Playground: Filtrando Datos con WHERE

41

GROUP BY

42

ORDER BY y HAVING

43

Playground: Agrupamiento y Ordenamiento de Datos

44

El interminable agujero de conejo (Nested queries)

45

驴C贸mo convertir una pregunta en un query SQL?

46

Pregunt谩ndole a la base de datos

47

Consultando PlatziBlog

48

Playground: Prueba Final con PlatziBlog

Introducci贸n a la bases de datos NO relacionales

49

驴Qu茅 son y cu谩les son los tipos de bases de datos no relacionales?

50

Servicios administrados y jerarqu铆a de datos

Manejo de modelos de datos en bases de datos no relacionales

51

Top level collection con Firebase

52

Creando y borrando documentos en Firestore

53

Colecciones vs subcolecciones

54

Recreando Platziblog

55

Construyendo Platziblog en Firestore

56

Proyecto final: transformando tu proyecto en una db no relacional

Bases de datos en la vida real

57

Bases de datos en la vida real

58

Big Data

59

Data warehouse

60

Data mining

61

ETL

62

Business intelligence

63

Machine Learning

64

Data Science

65

驴Por qu茅 aprender bases de datos hoy?

Bonus

66

Bases de datos relacionales vs no relacionales

67

Elegir una base de datos

No tienes acceso a esta clase

隆Contin煤a aprendiendo! 脷nete y comienza a potenciar tu carrera

Playground: Filtrando Datos con WHERE

40/67

Aportes 63

Preguntas 0

Ordenar por:

驴Quieres ver m谩s aportes, preguntas y respuestas de la comunidad?

o inicia sesi贸n.

Soluci贸n鈥 馃槃
.

.
.
.
.
.
.

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%";

My solution:

SELECT *
FROM COURSES
WHERE n_reviews >= 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE '%SQL%' 

Este Playground est谩 descrito excelentemente bien. 馃槏 Si todos fueran como este, ahorr谩ramos much铆simo tiempo. 馃檭

Mi soluci贸n


SELECT *
FROM COURSES WHERE n_reviews > 0;

SELECT *
FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES WHERE name LIKE '%SQL%';

Increible! lo estoy entendiendo 馃檭!

```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 COURSES WHERE n\_reviews BETWEEN 1 AND 100;SELECT \*FROM COURSESWHERE 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%%鈥;

Here we go 馃槂

SELECT *
FROM COURSES
where n_reviews > 80;

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 respuesta:

Super mejor redactado el ejercicio

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 >=1;
SELECT *
FROM COURSES
WHERE n_reviews >=1
AND n_reviews <=100;
SELECT *
FROM COURSES
WHERE name like 鈥%SQL%鈥;

鈥 Escribe tu c贸digo aqu铆 馃憞
鈥 Escribe tu c贸digo aqu铆 馃憞
SELECT *
FROM COURSES where n_reviews>=1;

SELECT *
FROM COURSES WHERE n_reviews>=1 and n_reviews<=100

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES where name LIKE 鈥%SQL%鈥

Hola muchachos ac谩 esta mi soluci贸n

< SELECT *
FROM COURSES
WHERE n_reviews > 0;

SELECT *
FROM COURSES
WHERE n_reviews between 1 and 101;

SELECT *
FROM COURSES
WHERE name like "%SQL%";> 

yeeei

SELECT *
FROM COURSES
WHERE n_reviews > 0;

SELECT *
FROM COURSES
where n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE '%SQL%';

Est谩 bueno como este curso va de a poco, paso a paso, sin atropellar con lo que se aprende!

.
.
.
.
.
.
.
.
.
.
.
.
.
.

-- Selecci贸n de los cursos con al menos 1 review (n_reviews > 0)
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews > 0;

-- Selecci贸n de los cursos con entre 1 y 100 reviews (n_reviews entre 1 y 100)
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

-- Selecci贸n de los cursos con "SQL" en alguna parte de su nombre (usando LIKE)
SELECT id, name, n_reviews
FROM courses
WHERE 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%鈥

O
2)
鈥 Escribe tu c贸digo aqu铆 馃憞
SELECT *
FROM COURSES
WHERE n_reviews >= 1
and n_reviews between 1 and 100
and name like 鈥%SQL%鈥
;

deberian agregar mas de estos cada vez que se ve un tema, es una dinamica muy genial.

Mi solucion:

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE 鈥%SQL%鈥;

me gustan estos peque帽os desafios, gracias platzi

-- Escribe tu c贸digo aqu铆 馃憞
-- SELECT * FROM COURSES;

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 COURSES
WHERE n_reviews >= 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT name
FROM COURSES
WHERE name LIKE 鈥%SQL%鈥;

Prueba superada

Reto realizado!

SELECT * FROM courses
WHERE n_reviews >= 1;

SELECT * FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM courses
WHERE name LIKE "%SQL%";

鈥 Mi soluci贸n 馃憞

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 COURSES WHERE n_reviews >=1;
SELECT * FROM COURSES WHERE n_reviews BETWEEN 1 AND 100;

SELECT name FROM COURSES WHERE name LIKE "%SQL%";

40. Playground: Filtrando Datos con WHERE

-- Escribe tu c贸digo aqu铆 馃憞
SELECT id, name, n_reviews
FROM courses
WHERE n_reviews >= 1;

SELECT id, name, n_reviews
FROM courses
WHERE n_reviews BETWEEN 1 AND 100;

SELECT id, name, n_reviews
FROM courses
WHERE name LIKE '%SQL%';

al fin pude realizar un reto 馃槂 la guia fue excelente en los anteriores me perdia en que objetivos se cumplirian

Otro reto m谩s para la colecci贸n 馃槈馃挌

Aqu铆 pueden probar el c贸digo:

-- Primer reto 
SELECT *
FROM COURSES
WHERE n_reviews >= 1;

-- Segundo reto
SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

-- Tercer reto
SELECT *
FROM COURSES
WHERE name LIKE '%sql%';

Solucion
.
Ejecutando el c贸digo:
.

.
Corriendo las pruebas:
.

Feedback (April 1st, 23): Las soluciones que escribimos no se guardan y los playground se consideran completos por el simple hecho de dar clic en avanzar y no cuando se escribe la soluci贸n.

Comparto mi Soluci贸n 馃憞

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%";

A quien le sirva, aqui mi solucion:

-- Escribe tu c贸digo aqu铆 馃憞
SELECT *
FROM COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM COURSES
WHERE name LIKE '%SQL%'

Buenas Clases, he disfrutado los playground.
No pongo mis respuestas porque es seguir la corriente del mundo.

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE 鈥%SQL%鈥;

Mi soluci贸n:

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%';

Mi soluci贸n est谩 aqu铆:

SELECT *
FROM COURSES
WHERE n_reviews >= 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE '%SQL%';

Adjunto resultado de actividad

SELECT * 
FROM COURSES
WHERE n_reviews > 0;

SELECT * 
FROM COURSES
WHERE n_reviews > 0 AND n_reviews <= 100;

SELECT * 
FROM COURSES
WHERE name LIKE '%SQL%';

Mi solucion:
.
.
.
.
.
.
.
.

![](

Mi solucion :DD

-- Primera sentencia where 

SELECT * from COURSES 
where n_reviews >= 1; 

-- Segunda sentencia where 

SELECT * from COURSES 
where n_reviews > 1 and n_reviews < 100;

-- Tercera sentencia where 

SELECT * from COURSES 
where name like '%SQL%' 

Solucion

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 COURSES
WHERE n_reviews >= 1;

SELECT * FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT * FROM COURSES
WHERE name LIKE '%SQL%';

Comparto mi Query

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 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铆 馃憞
.
.
.
.
.
.
.
.
.
鈥 MI CODIGO

SELECT *
FROM COURSES
WHERE n_reviews > 1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE '%SQL%';

Esta fue mi soluci贸n

Este fue el c贸digo que us茅

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 * FROM COURSES
WHERE name LIKE "%SQL%";

Es la primera vez que me sale de una . que buena herramienta para practicar lo aprendido .

SELECT *
FROM COURSES
WHERE n_reviews >=1;

SELECT *
FROM COURSES
WHERE n_reviews BETWEEN 1 AND 100;

SELECT *
FROM COURSES
WHERE name LIKE 鈥%SQL%鈥;

Soluci贸n:

SELECT *
FROM courses
WHERE n_reviews>=1;

SELECT *
FROM courses 
WHERE n_reviews>=1  AND n_reviews<=100;

SELECT *
FROM courses
WHERE name LIKE "%SQL%";

Mi humilde soluci贸n.

``
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 >=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 COURSES where n_reviews >=1;

SELECT *
FROM COURSES where n_reviews BETWEEN 1 and 100;

SELECT * 
FROM COURSES where name like '%SQL%'

undefined