Creando la Base de Datos

Clase 16 de 55 • Curso Profesional de Java EE 2017

Resumen

Nuestra base de datos será construída con el motor MySQL.

Operaremos MySQL a partir de PhpMyAdmin que lo tendremos disponible a partir de XAMPP.

Puedes descargar XAMPP en este enlace: https://www.apachefriends.org/es/index.html y lo tendrás disponible para Windows, Linux y MacOS.

No importa cual es tu sistema operativo asegurate de tener iniciados los siguientes como mínimo:

MySQL Database
Apache Web Server o Apache solamente

Si estas en Windows tendrás una vista como esta:

Si estas en Linux verás algo así:

Cuando los tengas iniciados entra a http://localhost/phpmyadmin para tener acceso a la administración de la base de datos.

Ve a la pestaña de Cuentas de Usuarios y crea uno platziprofesores
En nombre del host selecciona Local
La contraseña que manejaremos será la misma platziprofesores (solo con fines didácticos)
Selecciona el Check Crear una Base de Datos con el mismo nombre y otorgar todos los privilegios
Damos click en Continuar y del lado izquierdo veremos nuestra base de datos creada.

Mira en la sección archivos para obtener el query completo de la creación de las tablas.

Roger Davila

student•

Me salió un error al intentar crear el usuario, relacionado a esta instrucción:
SHOW PLUGINS SONAME LIKE ‘%_password_check%’

El error marcaba que no se podía encontrar el directorio “C:\xampp\lib\plugin” (en Windows). Para este caso solo tuve que crear manualmente el directorio y funcionó 😃 por si a alguien le sucede lo mismo!

Romà Pons Ridaura

student•

Así es, me sucedió lo mismo 😄

Ann Code

teacher•

Genial gracias por aportar 💪🏻

juan Moreno

student•

para aquellos que trabaje con workbench o directamente en la command line (tal como se ve en el curso de mySQL de platzi) les dejo el codigo SQL 😄

create database platzi;
use platzi;
create table profesor(
ID_profesor int primary key auto_increment,
nombre varchar(250),
avatar varchar(250)
);

create table curso(
ID_curso int primary key auto_increment,
ID_profesor int, 
nombre varchar (250), 
tema text , 
proyecto varchar(250),
foreign key (ID_profesor) references profesor(ID_profesor)
);

create table redSocial(
ID_red int primary key auto_increment,
nombre varchar(250),
icono varchar(250)
);
create table profesor_red(
ID_profesor_red int primary key,
ID_profesor int,
ID_red int,
nickname varchar(250),
foreign key (ID_profesor) references profesor(ID_profesor),
foreign key (ID_red) references redSocial(ID_red)
);```

Nicolás Beltrami

student•

Te falta separar las palabras en CREATE TABLE Y CREATE DATABASE

Carlos Alberto Vergara Ortiz

student•

error 1022 al crear una tabla en MySQL: Can’t write; duplicate key in table MySQL Error.

Marilyn Stanwood

student•

las tablas las pueden crear via comandos mysql (en la consola). aqui los comandos que yo utilize 😃

https://platzi.com/jee/tutoriales/java-ee-platzi-profesores-socialmedia-database-creation/

Cesar David Ramírez Dimaté

student•

Realmente recomiendo muchísimo utilizar directamente MySQL Workbench, no tiene sentido utilizar XAMPP para esto ya que stack es para MySQL-Apache-Php.

Acá dejo como instalar MySQL y MySQL Workbench en un ambiente de Linux.

https://platzi.com/java-basico-2015/tutoriales/instalar-mysql-y-workbench-en-linux-ubuntu-1404/

Nicolas Santillan

student•

Yo utilizo MySQL Workbench es mucho mejor en apariencia y es lo óptimo para Java,Eclipse,Spring.

Aquí el link de descarga.

Instala el Workbench y Server casí todo la instalación es por defecto(Siguiente).

Si vas a utilizar Workbench es porque ya estás familiarizado con bases de datos y también te toca investigar un poco como hacer que todo corra sin ningún incoveniente no es nada dificil.

Espero que consideren en introducir una rama en este curso utilizando Workbench.

Saludos.

Raul Castillo

student•

de acuerdo contigo.

José Padrón

student•

buen curso

Luis Alberto Velez Tascon

student•

Para hacer los diseños de base de datos y tener un gestor de base de datos me parece mucho mejor manejar mysql workbench

Rodolfo Pablo Silva

student•

Es necesario que todas las llaves foráneas se deban indexar o bajo que criterios debo saber que atributos indexar y cuales no?

Juan Lagos

student•

¿El motor de almacenamiento? ¿innoDB a que hace referencia?

Luis Lira

student•

Hace referencia al tipo de moto de almacenamiento que estarás usando. Aquí puedes encontrar más información sobre estos motores y una compartiva :D

Julian Parra

student•

Por gusto, prefiero usar SQLYog

Ann Code

teacher•

Excelente!! Recuerda que nuestra sección de tutoriales siempre está disponible en el curso por si quieres compartirnos.

https://platzi.com/clases/jee/tutoriales/

Hosward Alfredo Villoria Camacho

student•

actualmente estoy trabajando con linux, habia instalado mysql2 a traves de gemas (ya que programo en ruby on rails), luego instale mysql worbench y al instalar xampp y hacer start el xampp se quedaba starting y luego se detenia… al revisar el log decia que ya habia un mysql corriendo, a quienes ocurra eso solo cambien el puerto ya que tiene conflicto de puertos. Tan sencillo como eso

Cesar David Ramírez Dimaté

student•

Lo mejor es manejar mysql en consola directamente.

Cesar David Ramírez Dimaté

student•

Cómo crear las tablas en la base de datos según lo visto en el vídeo lo más detallado posible.

CREATE SCHEMA `platzi_java_ee` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
-- ALTER SCHEMA `platzi_java_ee` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

CREATE TABLE `platzi_java_ee`.`teacher` (
  `id_teacher` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(250) CHARACTER SET 'utf8' NOT NULL,
  `avatar` VARCHAR(250) CHARACTER SET 'utf8' NULL,
  PRIMARY KEY (`id_teacher`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `platzi_java_ee`.`course` (
  `id_course` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(250) CHARACTER SET 'utf8' NOT NULL,
  `themes` TEXT CHARACTER SET 'utf8' NULL,
  `project` VARCHAR(250) CHARACTER SET 'utf8' NULL,
  `id_teacher` INT,
  PRIMARY KEY (`id_course`),
  INDEX `fk_course_teacher_idx` (`id_teacher`),
  CONSTRAINT `fk_course_teacher`
    FOREIGN KEY (`id_teacher`)
    REFERENCES `platzi_java_ee`.`teacher` (`id_teacher`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Cesar David Ramírez Dimaté

student•

Cómo crear la base de datos, usuario y definir privilegios desde la terminal…

mysql -u root -p  # Solicita la contraseña de usuario root.
mysql>
	CREATE DATABASE platzi_java_ee;  -- Crear nueva BD.
	CREATE USER platziprofesores@localhost IDENTIFIED BY 'PlatziProfesores';  -- Crear el usuario user_wp con contraseña PlatziProfesores.
	GRANT ALL PRIVILEGES ON platzi_java_ee.* TO platziprofesores@localhost;  -- Dar acceso al usuario de la nueva BD creada.
	FLUSH PRIVILEGES;  -- Informar de los nuevos privilegios establecidos.
	exit

Javier Pava

student•

Tambien lo puedo crear por MAMP?

Diego Forero

Team Platzi•

Sip, no hay problema, se usa XAMPP porque es multiplataforma y esta para los tres sistemas operativos (Linux, Mac y Windows), pero incluso si sabes sql puedes crearla por consola 😛.

Javier Pava

student•

Muchas gracias @GOLLUM23!

Romà Pons Ridaura

student•

He solucionado un error y quiero ponerlo por si a alguien le pasa. Al abrir XAMPP me salia el error Port 80 in use by “Unable to open process” with PID 4!

para arreglarlo:

Deshabilitar todos los módulos de XAMPP (con el botón Stop) y cerrar el panel de control.
-Ir a Inicio->Ejecutar y teclear services.msc
-Buscar en la lista el “Servicio de Publicación World Wide Web”.
-Hacer click con el botón derecho encima y seleccionar Detener.
-Hacer click con el botón derecho de nuevo y en Propiedades seleccionar Tipo de Inicio: Manual.
-Ya podemos arrancar de nuevo todos los servicios deseados en XAMPP.

FUENTE:

Ann Code

teacher•

Excelente qué bueno que compartes la solución 💪🏻

Ann Code

teacher•

Oye sería genial que compartieras esta información aquí: https://platzi.com/clases/jee/tutoriales/

😄

Jonatan Josue Murcia Acuña

student•

para los usuarios de linux pueden activar Mysql + apache + proFTPD desde la terminal mediante el comando

sudo /opt/lampp/lampp start

Carlos Uriel de Jesus Sánchez González

student•

el manejo de xampp es solo de modo de ejemplo se puede utilizar cualquier manejador de bd, lo bueno es el server apache

pedro albenis parrado vargas

student•

como seria en oracle 12

Wilson Alejandro Gonzalez Gaitan

student•

Compañero en este caso adjunto script de oracle 11g en este caso seria lo mismo que la 12g

Adjunto código

<--------------------------------------------------------
--  DDL for Table TEACHER
--------------------------------------------------------



CREATE TABLE "PLATZI"."TEACHER" 
   (
    "ID_TEACHER" NUMBER(*, 0), 
	"NAME" VARCHAR2(250 CHAR),
	"AVATAR" VARCHAR2(250 CHAR)
	
   ) SEGMENT CREATION IMMEDIATE 
   
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
  
--------------------------------------------------------
--  DDL for Table COURSE
--------------------------------------------------------
  
CREATE TABLE "PLATZI"."COURSE" 
   (
    "ID_COURSE" NUMBER(*, 0), 
	"ID_TEACHER" NUMBER(*, 0), 
	"NAME" VARCHAR2(250 CHAR),
	"THEMES" VARCHAR2(250 CHAR),
	"PROJECT" VARCHAR2(250 CHAR)
	
   ) SEGMENT CREATION IMMEDIATE 
   
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
 
--------------------------------------------------------
--  DDL for Table SOCIAL_MEDIA
--------------------------------------------------------
  
  CREATE TABLE "PLATZI"."SOCIAL_MEDIA" 
   (
    "ID_SOCIAL_MEDIA" NUMBER(*, 0), 
	"NAME" VARCHAR2(250 CHAR),
	"ICON" VARCHAR2(250 CHAR)
	
   ) SEGMENT CREATION IMMEDIATE 
   
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  

--------------------------------------------------------
--  DDL for Table TEACHER_SOCIAL_MEDIA
--------------------------------------------------------
  
  CREATE TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" 
   (
    "ID_TEACHER_SOCIAL_MEDIA" NUMBER(*, 0), 
	"ID_TEACHER" NUMBER(*, 0), 
	"ID_SOCIAL_MEDIA" NUMBER(*, 0), 
	"NICKNAME" VARCHAR2(250 CHAR)
	
   ) SEGMENT CREATION IMMEDIATE 
   
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
--------------------------------------------------------
--  DDL for Index TEACHER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PLATZI"."TEACHER_PK" ON "PLATZI"."TEACHER" ("ID_TEACHER") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
--------------------------------------------------------
--  DDL for Index COURSE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PLATZI"."COURSE_PK" ON "PLATZI"."COURSE" ("ID_COURSE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
  
--------------------------------------------------------
--  DDL for Index SOCIAL_MEDIA_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PLATZI"."SOCIAL_MEDIA_PK" ON "PLATZI"."SOCIAL_MEDIA" ("ID_SOCIAL_MEDIA") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;
  
--------------------------------------------------------
--  secuencias
--------------------------------------------------------

CREATE SEQUENCE TEACHER_SEQ INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20;


CREATE SEQUENCE COURSE_SEQ INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20;


CREATE SEQUENCE SOCIAL_MEDIA_SEQ INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 CACHE 20;

--------------------------------------------------------
--  DDL for Trigger TEACHER
--------------------------------------------------------



CREATE OR REPLACE TRIGGER "PLATZI"."TEACHER" 
   before insert on "PLATZI"."TEACHER" 
   for each row 
begin  
   if inserting then 
      if :NEW."ID_TEACHER" is null then 
         select TEACHER_SEQ.nextval into :NEW."ID_TEACHER" from dual; 
      end if; 
   end if; 
end;

/
ALTER TRIGGER "PLATZI"."TEACHER" ENABLE;


--------------------------------------------------------
--  DDL for Trigger COURSE
--------------------------------------------------------



CREATE OR REPLACE TRIGGER "PLATZI"."COURSE" 
   before insert on "PLATZI"."COURSE" 
   for each row 
begin  
   if inserting then 
      if :NEW."ID_COURSE" is null then 
         select COURSE_SEQ.nextval into :NEW."ID_COURSE" from dual; 
      end if; 
   end if; 
end;

/
ALTER TRIGGER "PLATZI"."COURSE" ENABLE;

--------------------------------------------------------
--  DDL for Trigger SOCIAL_MEDIA
--------------------------------------------------------



CREATE OR REPLACE TRIGGER "PLATZI"."SOCIAL_MEDIA" 
   before insert on "PLATZI"."SOCIAL_MEDIA" 
   for each row 
begin  
   if inserting then 
      if :NEW."ID_SOCIAL_MEDIA" is null then 
         select SOCIAL_MEDIA_SEQ.nextval into :NEW."ID_SOCIAL_MEDIA" from dual; 
      end if; 
   end if; 
end;

/
ALTER TRIGGER "PLATZI"."SOCIAL_MEDIA" ENABLE;


--------------------------------------------------------
--  Constraints for Table TEACHER
--------------------------------------------------------

  ALTER TABLE "PLATZI"."TEACHER" MODIFY ("ID_TEACHER" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER" MODIFY ("AVATAR" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER" ADD CONSTRAINT "TEACHER_PK" PRIMARY KEY ("ID_TEACHER")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE;
  
--------------------------------------------------------
--  Constraints for Table COURSE
--------------------------------------------------------

  ALTER TABLE "PLATZI"."COURSE" MODIFY ("ID_COURSE" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."COURSE" MODIFY ("ID_TEACHER" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."COURSE" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."COURSE" MODIFY ("THEMES" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."COURSE" MODIFY ("PROJECT" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."COURSE" ADD 
  (
     CONSTRAINT "COURSE_TEACHER_FK"  FOREIGN KEY (ID_TEACHER)  REFERENCES TEACHER (ID_TEACHER),
     CONSTRAINT "COURSE_PK" PRIMARY KEY ("ID_COURSE")

  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE
  );
  
  --------------------------------------------------------
--  Constraints for Table SOCIAL_MEDIA
--------------------------------------------------------

  ALTER TABLE "PLATZI"."SOCIAL_MEDIA" MODIFY ("ID_SOCIAL_MEDIA" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."SOCIAL_MEDIA" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."SOCIAL_MEDIA" MODIFY ("ICON" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."SOCIAL_MEDIA" ADD 
  (
     CONSTRAINT "SOCIAL_MEDIA_PK" PRIMARY KEY ("ID_SOCIAL_MEDIA")

  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE
  );
  
--------------------------------------------------------
--  Constraints for Table TEACHER_SOCIAL_MEDIA
--------------------------------------------------------

  ALTER TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" MODIFY ("ID_TEACHER_SOCIAL_MEDIA" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" MODIFY ("ID_TEACHER" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" MODIFY ("ID_SOCIAL_MEDIA" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" MODIFY ("NICKNAME" NOT NULL ENABLE);
  ALTER TABLE "PLATZI"."TEACHER_SOCIAL_MEDIA" ADD 
  (
     CONSTRAINT "TEACHER_SOCIAL_TEACHER_FK"  FOREIGN KEY (ID_TEACHER)  REFERENCES TEACHER (ID_TEACHER),
	 CONSTRAINT "TEACHER_SOCIAL_MEDIA_FK"  FOREIGN KEY (ID_SOCIAL_MEDIA)  REFERENCES SOCIAL_MEDIA (ID_SOCIAL_MEDIA),
     CONSTRAINT "TEACHER_SOCIAL_MEDIA_PK" PRIMARY KEY ("ID_TEACHER_SOCIAL_MEDIA")

  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM"  ENABLE
  );
  
 
>

Adjunto script del user

<-- USER SQL
CREATE USER PLATZI IDENTIFIED BY "PLattzi12"  
DEFAULT TABLESPACE "SYSTEM"
TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES
GRANT "DATAPUMP_EXP_FULL_DATABASE" TO PLATZI WITH ADMIN OPTION;
GRANT "DBA" TO PLATZI WITH ADMIN OPTION;
GRANT "HS_ADMIN_EXECUTE_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "ADM_PARALLEL_EXECUTE_TASK" TO PLATZI WITH ADMIN OPTION;
GRANT "CTXAPP" TO PLATZI WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "CONNECT" TO PLATZI WITH ADMIN OPTION;
GRANT "DATAPUMP_IMP_FULL_DATABASE" TO PLATZI WITH ADMIN OPTION;
GRANT "OEM_MONITOR" TO PLATZI WITH ADMIN OPTION;
GRANT "APEX_ADMINISTRATOR_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "AQ_USER_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "SCHEDULER_ADMIN" TO PLATZI WITH ADMIN OPTION;
GRANT "XDB_SET_INVOKER" TO PLATZI WITH ADMIN OPTION;
GRANT "RECOVERY_CATALOG_OWNER" TO PLATZI WITH ADMIN OPTION;
GRANT "DBFS_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES_OVER_HTTP" TO PLATZI WITH ADMIN OPTION;
GRANT "HS_ADMIN_SELECT_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "PLUSTRACE" TO PLATZI WITH ADMIN OPTION;
GRANT "RESOURCE" TO PLATZI WITH ADMIN OPTION;
GRANT "AQ_ADMINISTRATOR_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "DELETE_CATALOG_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES_WITH_PUBLIC" TO PLATZI WITH ADMIN OPTION;
GRANT "XDB_WEBSERVICES" TO PLATZI WITH ADMIN OPTION;
GRANT "EXECUTE_CATALOG_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "EXP_FULL_DATABASE" TO PLATZI WITH ADMIN OPTION;
GRANT "GATHER_SYSTEM_STATISTICS" TO PLATZI WITH ADMIN OPTION;
GRANT "LOGSTDBY_ADMINISTRATOR" TO PLATZI WITH ADMIN OPTION;
GRANT "AUTHENTICATEDUSER" TO PLATZI WITH ADMIN OPTION;
GRANT "OEM_ADVISOR" TO PLATZI WITH ADMIN OPTION;
GRANT "HS_ADMIN_ROLE" TO PLATZI WITH ADMIN OPTION;
GRANT "XDBADMIN" TO PLATZI WITH ADMIN OPTION;
GRANT "IMP_FULL_DATABASE" TO PLATZI WITH ADMIN OPTION;
ALTER USER PLATZI DEFAULT ROLE "DATAPUMP_EXP_FULL_DATABASE","DBA","HS_ADMIN_EXECUTE_ROLE","ADM_PARALLEL_EXECUTE_TASK","CTXAPP","SELECT_CATALOG_ROLE","CONNECT","DATAPUMP_IMP_FULL_DATABASE","OEM_MONITOR","APEX_ADMINISTRATOR_ROLE","AQ_USER_ROLE","SCHEDULER_ADMIN","XDB_SET_INVOKER","RECOVERY_CATALOG_OWNER","DBFS_ROLE","XDB_WEBSERVICES_OVER_HTTP","HS_ADMIN_SELECT_ROLE","PLUSTRACE","RESOURCE","AQ_ADMINISTRATOR_ROLE","DELETE_CATALOG_ROLE","XDB_WEBSERVICES_WITH_PUBLIC","XDB_WEBSERVICES","EXECUTE_CATALOG_ROLE","EXP_FULL_DATABASE","GATHER_SYSTEM_STATISTICS","LOGSTDBY_ADMINISTRATOR","AUTHENTICATEDUSER","OEM_ADVISOR","HS_ADMIN_ROLE","XDBADMIN","IMP_FULL_DATABASE";

-- SYSTEM PRIVILEGES
GRANT CREATE JOB TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT UPDATE ANY CUBE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY TRIGGER TO PLATZI WITH ADMIN OPTION;
GRANT MANAGE ANY FILE GROUP TO PLATZI WITH ADMIN OPTION;
GRANT ALTER PUBLIC DATABASE LINK TO PLATZI WITH ADMIN OPTION;
GRANT MANAGE FILE GROUP TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY INDEX TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY SEQUENCE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT UNDER ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY LIBRARY TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY EDITION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ROLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE LIBRARY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ROLLBACK SEGMENT TO PLATZI WITH ADMIN OPTION;
GRANT CREATE TRIGGER TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT ADMINISTER DATABASE TRIGGER TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY MEASURE FOLDER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY OUTLINE TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY INDEXTYPE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY DIRECTORY TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY RULE SET TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT DEBUG CONNECT SESSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT ALTER SESSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE MATERIALIZED VIEW TO PLATZI WITH ADMIN OPTION;
GRANT MERGE ANY VIEW TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY INDEX TO PLATZI WITH ADMIN OPTION;
GRANT CREATE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY RULE SET TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY MATERIALIZED VIEW TO PLATZI WITH ADMIN OPTION;
GRANT AUDIT SYSTEM TO PLATZI WITH ADMIN OPTION;
GRANT CREATE OPERATOR TO PLATZI WITH ADMIN OPTION;
GRANT MANAGE ANY QUEUE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY SQL PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT GRANT ANY OBJECT PRIVILEGE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE INDEXTYPE TO PLATZI WITH ADMIN OPTION;
GRANT AUDIT ANY TO PLATZI WITH ADMIN OPTION;
GRANT DEBUG ANY PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY MEASURE FOLDER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE MEASURE FOLDER TO PLATZI WITH ADMIN OPTION;
GRANT UPDATE ANY CUBE BUILD PROCESS TO PLATZI WITH ADMIN OPTION;
GRANT CREATE VIEW TO PLATZI WITH ADMIN OPTION;
GRANT ALTER DATABASE LINK TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY EVALUATION CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT DELETE ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE SESSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE RULE TO PLATZI WITH ADMIN OPTION;
GRANT BECOME USER TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT INSERT ANY MEASURE FOLDER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY SQL PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT FORCE ANY TRANSACTION TO PLATZI WITH ADMIN OPTION;
GRANT DELETE ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY SEQUENCE TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY EDITION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE EXTERNAL JOB TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY MATERIALIZED VIEW TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY CUBE BUILD PROCESS TO PLATZI WITH ADMIN OPTION;
GRANT FLASHBACK ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY RULE SET TO PLATZI WITH ADMIN OPTION;
GRANT BACKUP ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY CUBE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE TABLE TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY LIBRARY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY OUTLINE TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY CLUSTER TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY CLASS TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY RULE SET TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY SEQUENCE TO PLATZI WITH ADMIN OPTION;
GRANT UNDER ANY TYPE TO PLATZI WITH ADMIN OPTION;
GRANT MANAGE TABLESPACE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY OPERATOR TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY OPERATOR TO PLATZI WITH ADMIN OPTION;
GRANT EXEMPT IDENTITY POLICY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE TYPE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE TABLESPACE TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY TRANSACTION TO PLATZI WITH ADMIN OPTION;
GRANT DELETE ANY MEASURE FOLDER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY CUBE TO PLATZI WITH ADMIN OPTION;
GRANT LOCK ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE EVALUATION CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY TYPE TO PLATZI WITH ADMIN OPTION;
GRANT ADVISOR TO PLATZI WITH ADMIN OPTION;
GRANT CREATE PUBLIC DATABASE LINK TO PLATZI WITH ADMIN OPTION;
GRANT ANALYZE ANY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY RULE TO PLATZI WITH ADMIN OPTION;
GRANT INSERT ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ROLLBACK SEGMENT TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY JOB TO PLATZI WITH ADMIN OPTION;
GRANT ALTER USER TO PLATZI WITH ADMIN OPTION;
GRANT QUERY REWRITE TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY DICTIONARY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE PUBLIC SYNONYM TO PLATZI WITH ADMIN OPTION;
GRANT GLOBAL QUERY REWRITE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY CLUSTER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY RULE TO PLATZI WITH ADMIN OPTION;
GRANT UPDATE ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT SYSDBA TO PLATZI WITH ADMIN OPTION;
GRANT ADMINISTER RESOURCE MANAGER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY SYNONYM TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY SYNONYM TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE SYNONYM TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY PROGRAM TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY TYPE TO PLATZI WITH ADMIN OPTION;
GRANT ON COMMIT REFRESH TO PLATZI WITH ADMIN OPTION;
GRANT CREATE SEQUENCE TO PLATZI WITH ADMIN OPTION;
GRANT COMMENT ANY MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT ADMINISTER SQL TUNING SET TO PLATZI WITH ADMIN OPTION;
GRANT SYSOPER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY INDEXTYPE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO PLATZI WITH ADMIN OPTION;
GRANT RESTRICTED SESSION TO PLATZI WITH ADMIN OPTION;
GRANT DEQUEUE ANY QUEUE TO PLATZI WITH ADMIN OPTION;
GRANT ANALYZE ANY DICTIONARY TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY INDEXTYPE TO PLATZI WITH ADMIN OPTION;
GRANT ADMINISTER ANY SQL TUNING SET TO PLATZI WITH ADMIN OPTION;
GRANT CREATE USER TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY OPERATOR TO PLATZI WITH ADMIN OPTION;
GRANT CREATE CUBE BUILD PROCESS TO PLATZI WITH ADMIN OPTION;
GRANT CREATE PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY ROLE TO PLATZI WITH ADMIN OPTION;
GRANT UPDATE ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY LIBRARY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY VIEW TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY CLUSTER TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY RULE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER TABLESPACE TO PLATZI WITH ADMIN OPTION;
GRANT UNDER ANY VIEW TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT GRANT ANY PRIVILEGE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY TRIGGER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY VIEW TO PLATZI WITH ADMIN OPTION;
GRANT EXPORT FULL DATABASE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY EVALUATION CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT FLASHBACK ARCHIVE ADMINISTER TO PLATZI WITH ADMIN OPTION;
GRANT IMPORT FULL DATABASE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY OUTLINE TO PLATZI WITH ADMIN OPTION;
GRANT COMMENT ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE DATABASE LINK TO PLATZI WITH ADMIN OPTION;
GRANT DROP PUBLIC SYNONYM TO PLATZI WITH ADMIN OPTION;
GRANT DROP USER TO PLATZI WITH ADMIN OPTION;
GRANT CHANGE NOTIFICATION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE MINING MODEL TO PLATZI WITH ADMIN OPTION;
GRANT INSERT ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT DROP PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY MATERIALIZED VIEW TO PLATZI WITH ADMIN OPTION;
GRANT CREATE RULE SET TO PLATZI WITH ADMIN OPTION;
GRANT EXEMPT ACCESS POLICY TO PLATZI WITH ADMIN OPTION;
GRANT MANAGE SCHEDULER TO PLATZI WITH ADMIN OPTION;
GRANT READ ANY FILE GROUP TO PLATZI WITH ADMIN OPTION;
GRANT FORCE TRANSACTION TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY CUBE BUILD PROCESS TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY TYPE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT DROP PUBLIC DATABASE LINK TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY INDEXTYPE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY SQL PROFILE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER SYSTEM TO PLATZI WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY ROLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY CUBE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY TRIGGER TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY TABLE TO PLATZI WITH ADMIN OPTION;
GRANT ADMINISTER SQL MANAGEMENT OBJECT TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY DIRECTORY TO PLATZI WITH ADMIN OPTION;
GRANT ENQUEUE ANY QUEUE TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY EVALUATION CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY ASSEMBLY TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY TYPE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE CLUSTER TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT EXECUTE ANY EVALUATION CONTEXT TO PLATZI WITH ADMIN OPTION;
GRANT RESUMABLE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE ANY LIBRARY TO PLATZI WITH ADMIN OPTION;
GRANT DROP ANY EDITION TO PLATZI WITH ADMIN OPTION;
GRANT CREATE PROCEDURE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER DATABASE TO PLATZI WITH ADMIN OPTION;
GRANT SELECT ANY CUBE TO PLATZI WITH ADMIN OPTION;
GRANT GRANT ANY ROLE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY RULE TO PLATZI WITH ADMIN OPTION;
GRANT CREATE CUBE DIMENSION TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ANY OPERATOR TO PLATZI WITH ADMIN OPTION;
GRANT CREATE CUBE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER RESOURCE COST TO PLATZI WITH ADMIN OPTION;
GRANT DROP TABLESPACE TO PLATZI WITH ADMIN OPTION;
GRANT ALTER ROLLBACK SEGMENT TO PLATZI WITH ADMIN OPTION;

>

Resultado del modelo entidad

Cesar David Ramírez Dimaté

student•

Relación actual generada por MySQL Workbench

Wilson Alejandro Gonzalez Gaitan

student•

Comparto modelo entidad relación generado en oracle

Elizabeth López Sanchez

student•

Gracias, no me sabía esos features del phpmyadmin!

Creando la Base de Datos

Bienvenida al curso

¿Qué vamos a construir?

Aplicaciones Java EE

Java EE vs Java SE

¿Cómo funcionan las aplicaciones Java EE?

MVC en Java EE

Hola Mundo con JSP

Corriendo nuestra aplicación en Apache Tomcat

Java Servlets

Java Beans

MVC en nuestra aplicación

Archivos War empaquetados y su estructura

Maven y Gradle

Asistentes Inteligentes Maven

Gradle

Las bases del Proyecto

Aplicaciones Orientadas a Presentación vs. Servicios

IDE Spring Tool Suite

Modelado y creando la base de datos

Análisis del Problema [Nuestro Proyecto]

Diagramas Entidad Relación y UML

Creando la Base de Datos

Poniendo Relaciones en nuestra Base de Datos

Creando un proyecto de Java que se conecta a la base de datos

Hibernate

¿Qué es Hibernate?

Configurando Hibernate en Spring Tool Suite

Integrando Hibernate al proyecto y conectando a la base de datos

Mapeo y Anotaciones con Hibernate JPA

Mapeando nuestro proyecto con Hibernate JPA

Anotaciones básicas en nuestro proyecto

Relaciones o Asociaciones en Hibernate [One To One, One To Many y Many to Many]

Mapeando Relaciones a nuestro proyecto

Queries a la base de datos usando Hibernate

¿Qué es un DAO?

Manejo de Session en Hibernate

Spring Framework

¿Qué es un Framework?

¿Qué es Spring Framework?

Spring Bean Factory

Composición de Spring, Spring MVC y Spring Boot

Integrando Spring al proyecto

Componentes de un proyecto en Spring Boot

Configurando Hibernate con Spring

Configurando DAO's con Spring y Filtros con HQL Hibernate

Resolviendo el reto de CRUD y más de HQL

Hibernate HQL Joins

API Rest en Java EE

¿Qué es y cómo funciona API Rest?

Configurando Service

Creando Controller API Rest por Entidad

Definiendo métodos, Get y Post

Métodos Patch y Delete

Manejando Mensajes de Error Personalizados

Manejando Filtros en REST

Subir imágenes en un API REST

Mostrar imágenes en un API REST

Eliminar imágenes en un API REST

Relaciones entre Recursos part. 1

Relaciones entre Recursos part. 2

Deployando un API REST en Java EE

Deploy de tu proyecto Java en Heroku

Sube tu proyecto a Heroku con Git

Spring Security

Spring Security y JSON Web Tokens

Fin del Curso

Conclusión

Cuando los tengas iniciados entra a http://localhost/phpmyadmin para tener acceso a la administración de la base de datos.