Curso MySQL - Curso Intensivo y Práctico

CONTENIDO:

00:00:28 Qué es MySQL
00:03:09 Terminología
00:04:11 Modelo Relacional
00:06:18 Tipos de dato
00:09:24 Software para Bases de datos
00:11:52 Conectar al Servidor SQL por terminal o Shell
00:12:29 SHOW DATABASES
00:12:59 CREATE DATABASE
00:13:54 USE DATABASE
00:14:36 SHOW TABLES
00:14:21 CREATE TABLE
00:19:38 DESCRIBE TABLE
00:20:50 CRUD
00:21:18 INSERT
00:24:16 SELECT
00:26:26 WHERE
00:28:02 LIMIT
00:28:32 UPDATE
00:31:39 DELETE
00:34:33 ALTER TABLE ADD
00:35:47 ALTER TABLE DROP COLUMN
00:36:46 MySQL Workbench
00:37:25 Conectar a Servidor MySQL
00:38:51 Importar Base de Datos existente
00:42:38 Table Inspector en Workbench
00:45:08 ORDER BY
00:47:21 GROUP BY y COUNT
00:51:10 INNER JOIN
00:53:41 INNER JOIN, COUNT y GROUP BY
00:56:01 DISTINCT
00:57:46 BETWEEN
00:58:58 LIKE
01:01:55 LIKE en 2 Columnas y CONCAT
01:05:16 IN

Enlace a restaurant.sql: https://www.dropbox.com/s/5j1t8umyynp...



Sígueme en mis Redes:
  / juandevwp  
  / juandevwp