Creando la Base de Datos

Clase 16 de 55 • Curso Profesional de Java EE 2017

Contenido del curso

Bienvenida al curso

1
¿Qué vamos a construir?
01:22 min

Aplicaciones Java EE

MVC en Java EE

Maven y Gradle

Las bases del Proyecto

Modelado y creando la base de datos

Hibernate

Spring Framework

API Rest en Java EE

Deployando un API REST en Java EE

Spring Security

54
Spring Security y JSON Web Tokens
00:05 min

Fin del Curso

55
Conclusión
01:02 min

Tomar examen

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.

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

Roger Davila

Romà Pons Ridaura

Ann Code

teacher•

juan Moreno

Nicolás Beltrami

Carlos Alberto Vergara Ortiz

Marilyn Stanwood

Cesar David Ramírez Dimaté

Nicolas Santillan

Raul Castillo

José Padrón

Luis Alberto Velez Tascon

Rodolfo Pablo Silva

Juan Lagos

Luis Lira

Julian Parra

Hosward Alfredo Villoria Camacho

Javier Pava

Diego Forero

Team Platzi•

Jonatan Josue Murcia Acuña

Carlos Uriel de Jesus Sánchez González

Elizabeth López Sanchez

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