Download Mexico First

Propuesta de
Capacitación
MEXICO FEDERAL
INSTITUTE FOR
REMOTE SERVICES &
TECHNOLOGY A.C
(Mexico First)
19 de noviembre de 2010
1
México D.F. 19 de Noviembre de 2010
Raúl González
Director General
MEXICO FEDERAL INSTITUTE FOR REMOTE SERVICES & TECHNOLOGY A.C
(Mexico First)
Presente.
Tengo el agrado de dirigirme a Ud. a los efectos de hacerle llegar una
propuesta de capacitación, esperando que sea de su completo agrado.
Quedo a su entera disposición ante cualquier consulta o inquietud que
pudiera surgir.
Muy cordialmente,
Nora Herrera
WDP Manager
Oracle University
2
CONTENIDO
•
Propuesta de Capacitación
•
Certificaciones Propuestas
•
Propuesta Comercial
•
Términos y Condiciones de Oracle
University
•
Descriptivos de los cursos
3
Propuesta de Capacitación
La industria de tecnologías de la información se ha convertido en un importante motor de la
economía del país, debido a su impacto transversal en los diferentes sectores económicos y el
valor agregado implícito en esta actividad.
El cambio demográfico en nuestro país y la competencia internacional exigen que las
Universidades públicas y privadas actualicen sus estrategias para atender la creciente
demanda de educación de calidad, que le permita competir a más mexicanos por buenos
empleos y contar con las capacidades necesarias para emprender un mayor número de
negocios o proyectos personales propios.
Existe una conciencia cada vez más amplia del peso que tiene el conocimiento y la innovación
en una economía global y esta provocando que las Instituciones Académicas y los estudiantes,
busquen superarse para aprovechar las innumerables oportunidades que ofrece el entorno de
las tecnologías de la información.
Recibir el conocimiento de expertos de cada área en diversos temas ha generado a la
posibilidad de que los alumnos tengan sus puntos de vista, que los asimilen y los hagan
propios. De acuerdo a recientes investigaciones educativas aplicadas, hay 3 estrategias que
siguen las empresas en el desarrollo de aprendizaje, una es entre empresas con equipos
colaborando, otra es pidiendo información y analizándola y otra manera es llevando a un
especialista al lugar para que aprenda en el sitio de trabajo.
AMITI, ANIEI y CANIETI, con el apoyo de la Secretaría de Economía han creado la iniciativa
MexicoFirst, esta es una Asociación civil operada por CANIETI cuya misión es aumentar la
cantidad de personas certificadas en nuestro país, de forma que nuestro recurso humano sea
reconocido globalmente como una excelente opción para satisfacer las necesidades de la
industria de TI. El objetivo de MexicoFirst es captar las necesidades de certificación en TI de
los diferentes estados, y unificar el poder de compra para mejorar la calidad y el costo. Esto
acelerará los proyectos que solicitan Fondos
“La calidad es el eje central y MexicoFirst tiene como objetivo masificar la capacitación de los
profesionales de TI en el país.”
Objetivo del Programa
Establecer un mecanismo de trabajo efectivo que optimice los recursos disponibles en el fondo,
con el objeto de lograr los máximos resultados, mediante una participación integral de las
partes involucradas en la estrategia de capacitación y certificación.
En la actualidad, es indispensable que las personas que se agregan al campo laboral en
nuestro país, cuenten con conocimientos sólidos en ingeniería de software, lenguajes de
programación y una enseñanza certificada, para ello, las universidades constantemente llevan
a cabo la actualización de sus planes de estudio, sin embargo, el ritmo de cambio tecnológico
es tan vertiginoso que es necesario apoyar a la academia con programas que permitan
fortalecer y actualizar sustentablemente el nivel de conocimientos de los diferentes
participantes en la comunidad: profesores, alumnos, investigadores y
áreas internas de desarrollo de software.
4
Modelo propuesto
Mexico First
 Estrategia de las áreas de cobertura
 Normaliza contenidos y procesos de certificación
 Analiza y aprueba propuestas estatales
Oracle University
 Proporciona Contenidos Certificados a través de un kit que contiene el manual del
curso presencial certificado, Curso Web, Simulador del examen de la prueba
(epractice) y voucher de certificación (2 oportunidades).
Nota: El kit de certificación My SQL no incluye curso web no simulador de examen.
Beneficios del Programa



Metodología Consultiva aplicada en los clientes del sector empresarial.
Material Web: permite a los estudiantes repasar y revisar contenidos en español, en
cualquier lugar y hora, logrando avanzar en el estudio y preparación de acuerdo a su
disponibilidad de tiempos.
Simulador de práctica permitiendo a los estudiantes conocer previamente el contexto y
entorno del examen de certificación.
5
Certificaciones propuestas
1) KIT SUN CERTIFIED JAVA ASSOCIATE
Esta certificación ofrece al candidato un excelente punto de partida para forjarse un futuro
profesional encaminado al desarrollo de aplicaciones o la gestión de proyectos de software
basados en tecnologías Java. Avala los conocimientos del alumno sobre conceptos básicos de
programación OO y programación Java, así como sus conocimientos generales sobre las
plataformas y tecnologías Java.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Demostrar conocimiento de la tecnología Java, el lenguaje de programación Java, y el ciclo de
vida del producto.
Utilizar el lenguaje de programación Java para crear aplicaciones de la tecnología J2SE
Utilizar instrucciones para toma de decisiones y control de flujos
Aplicar conceptos de programación Java nivel intermedio y programación a orientada a objetos
(OO) en el desarrollo de programas Java.
Componentes del Kit Java Associate :
Curso Presencial y Manual de Fundamentos del Lenguaje de Programación Java (SL-110)
Curso Web Fundamentals of the Java Programming Language (WJB-110-SE6)
e Practice for the Sun Certified Associate for the Java Platform, Standard Edition, Exam Version
1.0 (WGS-PREX-J019)
Voucher con Retake Sun Certified Associate for the Java Platform, Standard Edition, Exam
Version 1.0 (CX-310-019)
El contenido del paquete en especifíco se detalla en el anexo A.
2) KIT SUN CERTIFIED JAVA PROGRAMMER 6
Esta certificación básica es para programadores interesados en demostrar destreza en los
fundamentos del lenguaje de programación Java.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Crear aplicaciones de la tecnología Java que aprovechen las ventajas de la programación
orientada a objetos características del lenguaje Java, como encapsulación, herencia y
polimorfismo
Ejecutar una aplicación de la tecnología Java desde la línea de comandos
Utilizar tipos de datos y expresiones en Java.
Utilice el control de flujo en Java.
Utilice matrices y otras colecciones de datos
Aplicar tratamiento de errores utilizando las técnicas de manejo de
excepciones.
6
Crear una aplicación usando interfaz gráfica de usuario (GUI) utilizando componentes Swing:
paneles, botones, etiquetas, campos de texto, y áreas de texto.
Aplicar funcionalidad de entrada / salida (I / O), para leer y escribir a funciones y archivos de
texto y comprender instrucciones avanzadas de I / O.
Componentes del Kit Java Programmer 6 :
Curso Presencial y Manual de Lenguaje de Programación Java (SL-275)
Curso Web Java Programming Language (WJB-275-SE6)
e Practice exam for the Sun Certified Programmer for the Java Platform, Standard Edition 6
(WGS-PREX-J065C)
Voucher con Retake Sun Certified Programmer for the Java Platform, Standard Edition 6 (CX310-065)
El contenido del paquete en especifíco se detalla en el anexo B.
3) KIT SUN CERTIFIED JAVA WEB COMPONENT DEVELOPER
Está dirigida a desarrolladores que desean especializarse en las tecnologías JavaServer Pages
y servlet utilizadas para crear servicios y contenidos dinámicos en la Web. Los candidatos a
esta certificación ya deben poseer el título de Programador Certificado en Sun (SCJP), en
cualquiera de las ediciones.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Escribir servlets usando el lenguaje de programación Java (Java Servlets)
Crear aplicaciones web robustas usando Struts, gestión de período de sesiones, filtros, y la
integración de bases de datos
Escribir páginas JSP
Crear fáciles de mantener las páginas JSP utilizando el lenguaje de expresión, JSP estándar de
etiquetas (JSTL), y Frames Struts
Crear aplicaciones web robustas que integren Struts y páginas JSP
Componentes del Kit Java Developer Web Component:
Curso Presencial y Manual de Web Component Developer with JSP and Servlet (SL-314)
Curso Web Developing Applications for the Java EE Platform (WJB-310-EE5)
Web Component Development With Servlet and JSP Technologies (WJB-314-EE5)
e Practice Exam for the Sun Certified Web Component Developer for the Java Platform,
Enterprise Edition 5 (WGS-PREX-J083C)
Voucher con Retake Sun Certified Web Component Developer for the Java Platform, Enterprise
Edition 5 (CX-310-083)
El contenido del paquete en específico se detalla en el anexo C.
7
4) KIT SUN CERTIFIED SOLARIS ASSOCIATE
Este curso es indicado para personas que deben realizar tareas básicas de administración de
sistemas y no conocen el sistema operativo Solaris, o personas sin experiencia en el sistema
operativo UNIX. En este curso se enseñan las funciones y capacidades fundamentales del
sistema operativo Solaris 10 de Sun. El temario incluye la administración de directorios, el
control del entorno de trabajo del usuario, el almacenamiento de archivos y el uso de comandos
remotos. En el curso también se explican las funciones esenciales de la línea de comandos de
Solaris, lo que incluye el desplazamiento por los sistemas de archivos, el editor de texto vi, los
permisos de archivos, las listas de control de acceso (ACL), los shells de comandos, la
compresión de archivos, el uso básico de la red y la lectura de las secuencias de comandos de
shell. Se trata del primero de una serie de dos cursos que los alumnos pueden utilizar como
preparación para el examen de Administrador Certificado de Sistemas Solaris, Parte I.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Utilizar los componentes del sistema de escritorio.
Usar las funciones de la línea de comandos y los recursos de ayuda.
Ver y manejar archivos y directorios, y cambiar el contenido de los directorios.
Crear y modificar archivos, y utilizar los permisos de archivos básicos.
Crear listas de control de acceso (ACL) y controlar el entorno de trabajo del usuario.
Usar comandos en el shell.
Realizar un control básico de los procesos y los jobs.
Crear archivos de almacenamiento y guardarlos.
Comprimir, ver y descomprimir archivos.
Transferir archivos remotos.
Componentes del Kit Sun Certified Solaris Associate:
Curso presencial y Manual Unix Essentials Featuring the Solaris 10 OS (SA-100-S10)
Solaris 10 Operating System Essentials (WSB-100-S10)
E Practice Exam for the Sun Certified Solaris Associate (WGS-PREX-S105C)
Voucher con Retake Sun Certified Solaris Associate (SCSAS) (CX-310-105)
El contenido del paquete en específico se detalla en el anexo D.
8
5) KIT SUN CERTIFIED JAVA BUSINESS COMPONENT DEVELOPER
Esta certificación está dirigida a desarrolladores de componentes EJB (Enterprise JavaBeans)
encargados de diseñar, desarrollar, probar, implantar e integrar aplicaciones EJB.
Los candidatos a esta certificación ya deben poseer el título de Programador Certificado en
Sun (SCJP), en cualquiera de las ediciones.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Aplicar niveles de negocio utilizando la funcionalidad de la tecnología EJB
Describir las mejores prácticas y otra cuestiones avanzadas en el desarrollo del componente en
las empresas de EJB
Reunir y desplegar los componentes de nivel de negocio de la tecnología EJB en un servidor
de aplicaciones
Integrar la tecnología EJB en una aplicación basada en Java utilizando el servicio de
mensajería API
Crear y utilizar objetos de consulta utilizando el Lenguaje de la Pregunta de la Persistencia de
Java
Componentes del Kit Java Business Component Developer:
Curso Presencial y Manual de Business Component Development with Enterprise Java Beans
Technology (SL-351)
Curso Web Business Component Develop with EJB (WJB-351-EE5)
Curso Web Developing Applications for the Java EE Platform (WJB-310-EE5)
e Practice Exam for the Sun Certified Business Component Developer for the Java Platform,
Enterprise Edition 5 (WGS-PREX-J091C)
Voucher con Retake Sun Certified Business Component Developer for the Java Platform,
Enterprise Edition 5 (CX-310-091)
El contenido del paquete en específico se detalla en el anexo E.
6) KIT SUN CERTIFIED DEVELOPER FOR JAVA WEB SERVICES
stá certificación es para desarrolladores que crean aplicaciones de servicios web empleando
componentes Java. Los candidatos a esta certificación ya deben poseer el título de
Programador Certificado en Sun (SCJP), en cualquiera de las ediciones.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Describir la arquitectura orientada a servicios (SOA).
Describir los servicios web como una implementación de SOA.
Describir las tecnologías Java utilizadas para desarrollar servicios web.
Implementar un servlet como servicio web utilizando la API de Java para servicios web XML.
Implementar un componente Enterprise JavaBeans (EJB) como servicio web utilizando JAXWS.
Describir e implementar diversos diseños y patrones de
implementación basados en servicios web.
9
Describir y aplicar diversas mejores prácticas en el diseño de servicios web.
Manejar excepciones en servicios web utilizando SOAPFaultException.
Implementar excepciones definidas por el usuario en servicios web.
Identificar los requisitos y las soluciones de seguridad de los servicios web.
Proteger un servicio web utilizando autenticación básica.
Implementar la seguridad de capa de mensajes en los servicios web.
Componentes del Kit Developer for Java Web Services:
Curso Presencial y Manual de Creating Web Services using Java Technology (DWS-3111-EE5)
Curso Web Services Infrastructure and Organizations (WJO-1114)
Curso Web Services Enabling Technologies (WJO-1118)
e Practice Exam for the Sun Certified Developer For Java Web Services 5 (WGS-PREX-J230C)
Voucher con Retake Sun Certified Developer for Java Web Services 5 (CX-310-230)
El contenido del paquete en específico se detalla en el anexo F.
7) KIT SUN CERTIFIED MOBILE APPLICATION DEVELOPER
Está dirigida a desarrolladores que utilicen tecnologías Java para crear aplicaciones destinadas
a teléfonos móviles y otros dispositivos "inteligentes". Los candidatos a esta certificación ya
deben poseer el título de Programador Certificado en Sun (SCJP), en cualquiera de las
ediciones.
Habilidades Obtenidas:
Una vez cubierto el entrenamiento de este paquete, el estudiante será capaz de :
Explicar la arquitectura de la plataforma J2ME, las configuraciones y perfiles.
Construir Aplicaciones básicas MIDP (Midlets) e incorporar aplicaciones basadas en multimedia
MIDP.
Crear e implementar interfaces de usuario usando la programación de alto y bajo nivel.
Implementar almacenamiento local en los dispositivos usando RMS
Crear aplicaciones que usen información en Red.
Describir la seguridad de MIDP 2.0
Componentes del Kit Developer for Java Web Services:
Curso Presencial y Manual de Developing Mobile Phone Applications With J2ME Technology
(DTJ-365)
Curso Web An Introduction to Mobile Java Technologies (WJB-450)
Curso Web J2ME and Mobile Phone Development Topics (WJB-460)
e Practice Exam for the Sun Certified Mobile Application Developer for J2ME, Version 1.0
(WGS-PREX-J110C)
Voucher con Retake Sun Certified Mobile Application Developer For the Java Platform Micro
Edition 1.0 (CX-310-110)
El contenido del paquete en específico se detalla en el anexo G.
10
8) KIT SUN CERTIFIED MYSQL FOR BEGINNERS
Este curso cubre los fundamentos de SQL y bases de datos relacionales utilizando MySQL
como una herramienta de aprendizaje.
Componentes del Kit Sun Certified MySQL for Beginners
MySQL for Beginners (SQL-4491) Voucher con retake Sun Certified MySQL Associate (CX-310-814 )
El contenido del paquete en especifíco se detalla en el anexo H.
9) KIT ORACLE CERTIFIED ASSOCIATED
Componentes del curso :
Curso Presencial y Manual de Oracle Database 11g: Introduction to SQL
Curso Presencial y Manual de Oracle Database 11g: Administration Workshop I
CD´s Auto Introduction to SQL and CD autoestudio Oracle database 11g Workshop I
2 Vouchers de certificación para Oracle Certified Associated.
Lo que aprenderá:
En este curso, los asistentes aprenderán los conceptos de las Bases de Datos Relacionales.
Este curso proporciona las bases esenciales de SQL que permite a los desarrolladores escribir
consultas contra una o varias tablas, manipular tablas y crear objetos de la base de datos. Los
alumnos aprenderán a controlar los privilegios a nivel de objeto y de sistema. Este curso cubre
la creación de índices y restricciones, y modificaciones de objetos del esquema ya existentes
en la base de datos. También aprenderán a utilizar las funciones avanzadas de SQL para
consultar y manipular datos dentro de la base de datos, utilizar las vistas del diccionario para
devolver y crear informes acerca de sus objetos del esquema. También se tratan funciones de
fecha y ora disponibles en la base de datos Oracle. Este curso termina tratando la utilización de
las expresiones regulares. Learn To:
• DDL - Lenguaje de Definición de Datos
• Control de Transacciones
• Consulta
• DML- Lenguaje de Manipulación de Datos
Objetivos:
• Ejecutar sentencias de manipulación de datos (DML) para actualizar datos
• Controlar el acceso de usuario y gestionar objetos de esquema
• Gestionar objetos con las vistas del diccionario de datos
• Devolver datos de filas y columnas de las tablas
• Crear informes para ordenar y filtrar
El contenido del paquete en especifíco se detalla en el anexo I
11
PROPUESTA COMERCIAL
CERTIFICACIONES
PRECIO MX1
IVA
PRECIO
FINAL
Sun Certified Java Associate Certification
17,386.00
2,782
20,168
Sun Certified Java Programmer 6
17,386.00
2,782
20,168
Sun Certified Java Web Component Developer
17,386.00
2,782
20,168
Sun Certified Solaris Associate
14,000.00
2,240
16,240
Sun Certified Java Business Component Developer
17,386.00
2,782
20,168
Sun Certified Developer for Java Web Services
17,386.00
2,782
20,168
Sun Certified Developer Mobile Application Developer
17,386.00
2,782
20,168
Sun Certified MySQL for Beginners
14,000.00
2,240
16,240
Oracle Certified Associate
32,043.00
5,127
37,170
12
TÉRMINOS Y CONDICIONES
TERMINOS Y CONDICIONES DE ORACLE
UNIVERSITY
















Los precios expresados en esta propuesta son por participante.
Los precios están expresados en Pesos. La facturación será en MXN.
En caso de que el curso sea en las instalaciones de un Partner, posteriormente se le notificará la dirección.
Se manejarían 8 horas por día.
El horario sugerido de los cursos es de 8:00 a 16:30. En caso contrario El Cliente lo define siempre
considerando 8 horas por día.
Para definir la fecha de inicio, requerimos al menos 2 semanas de anticipación y por escrito.
Las instalaciones donde se impartirá el curso presencial serán asignadas por Oracle University México,
posteriormente se le notificará oportunamente la dirección donde deberá presentarse el o los participantes.
Se requiere de un contacto por parte del organismo promotor, la universidad o Empresa de TI para coordinar el
proyecto.
Los grupos de participantes serán como mínimo 12 personas por cada evento de capacitación.
Los cursos presenciales serán impartidos en fechas calendario o bien en las fechas designadas por el cliente (
previa revisión de disponibilidad de instructores y ambiente requerido para el curso.
Se consideran entregables los siguientes documentos:
1. Manual del Estudiante en formato electrónico
2. Lista de Asistencia firmada
3. Identificación Oficial vigente y/o credencial de estudiante con fotografía
4. Certificado de asistencia
5. Diploma de certificación y / o resultados de examen de certificación de acuerdo a la empresa
certificadora
Es importante mencionar que la certificación no la hace Oracle, la certificación se realiza por una empresa
ajena a Oracle.
Esta propuesta tiene una validez de 30 días naturales a partir de la fecha de la misma.
Los manuales de capacitación son electrónicos y su idioma es en Ingles
La instrucción presencial será en idioma español
13
Programa de 100% de Satisfacción de Alumnos: El programa de Oracle 100% Student Satisfaction
es aplicable para los cursos disponibles al público de Oracle University Instructor Led Training que se
identifique como parte del programa 100% Student Satisfaction en la dirección de red
www.oracle.com/education en la fecha en la que el curso es adquirido. En caso de que un estudiante
haya completado dicho curso y haya estado presente en todas las clases ofertadas no esté, en su
opinión, satisfecho con el curso, entonces el estudiante debe de notificar a Oracle por escrito de su
insatisfacción mediante correo electrónico a [email protected] dentro de los 5 días
hábiles siguientes a que completo el curso. En este caso, Oracle le permitirá al estudiante tomar la
misma versión del curso con la misma denominación (o a la elección del estudiante, un curso equivalente
provisto en línea si es que está disponible) por una segunda ocasión sin costo alguno dentro de los 90
días a la fecha en la que Oracle recibió la notificación (o si el curso no está disponible dentro de ese
período de 90 días, tan pronto como el curso esté disponible en la misma ubicación o en una facultad
ubicada dentro de los 85 kilómetros a la redonda). El programa de Student Satisfaction no aplica: (i) a
una clase tomada por segunda vez; (ii) si el estudiante no puede satisfacer los requisitos anteriores por
causas ajenas al control de Oracle. Oracle no es ni se hace responsable por cualesquier impuesto
aplicable, costos de transporte, de viaje o de estancia o cualesquier otro costo o gasto adicional derivado
de la retoma del curso. Oracle tiene la facultad discrecional de rembolsar el costo del curso en lugar de
permitir la toma por segunda ocasión del curso en caso de que Oracle juzgue que por causa de agenda
o por cualquier otra, el reembolso es lo más apropiado. Este es el único derecho y remedio previsto bajo
el programa y la responsabilidad total de Oracle por la insatisfacción de un estudiante con el curso
tomado.
Honorarios, Impuestos y Facturas: Todos los honorarios pagaderos a Oracle deberán ser abonados
en el plazo de 30 días a partir de la fecha de la factura. Usted acuerda pagar cualquier impuesto a las
ventas, de valor agregado u otro similar aplicable por ley que Oracle debe pagar basado en los productos
y/o los servicios que usted ordenó, a excepción del impuesto sobre la renta causados por los ingresos
Oracle. Usted también reembolsará a Oracle los costos razonables relacionados con la prestación de los
servicios. No obstante lo anterior, los costos de las clases privadas/onsite serán cobrados sobre una
base diaria según lo señalado en nuestro web site e http://www.oracle.com/education/privateevents.html.
Los honorarios por los servicios enumerados en su pedido, establecidos en nuestro web site en
http://www.oracle.com/global/cl/education/ o cotizado telefónicamente no incluyen impuestos y gastos.
Para los productos de Oracle University , se le cobrará o se le facturará cuando se envían los productos.
Para las clases de Oracle University Instructor Led Training y Live Web Class se le cobrará o se le
facturará después de asistir a la clase.
Política de Cancelación /Reprogramación de Clases : Oracle puede cancelar o reprogramar una clase
a su discreción, y si lo hace, utilizará esfuerzos razonables para notificárselo con por lo menos una
semana de anticipación. Usted no será facturado por la cancelación o reprogramación de una clase por
Oracle. Por favor notifíquenos lo antes posible antes de cualquier cambio en la programación de su
entrenamiento. Deberá llamar a Lucía Manzur o enviar un correo electrónico a [email protected]
para cancelar o modificar la fecha de la clase.
14
Calendario de Eventos Públicos de entrenamiento con Instructor
Si Usted...
Oracle determinará...
Cancela su inscripción con 7 días o más de
antelación al día programado de comienzo del
curso
Sin cargo
Cancela su inscripción de 1- 6 días previos al día
del comienzo del curso
50% del costo del curso
NO se presenta al evento; o cancela el mismo día 100% del costo del curso
del evento
Eventos de Entrenamiento Privado/Onsite
Si Usted...
Oracle determinará...
Cancela su inscripción con 14 días o más de
antelación al día programado de comienzo del
curso
Sin cargo
Cancela su inscripción de 1-13 días previos al día
del comienzo del curso
50% del costo del curso
NO se presenta al evento; o cancela el mismo día 100% del costo del curso
del evento
Examen en Centros Examinadores de Oracle (OTC)
Si Usted...
Oracle determinará...
Cancela o cambia la fecha la inscripción al examen con 7
días o más de antelación al día programado de
comienzo del curso
Sin cargo
Cambia la fecha la inscripción al examen de 1 a 6 días de Sin cargo
antelación al día programado de comienzo del curso
Reprogramación de su fecha de examen 1 a 6 días antes
de la fecha programada para el examen.
Sin cargo
Cancela la inscripción al examen de 1 a 6 días de
antelación al día programado de comienzo del curso;
cancela el día del examen; o no se presenta al examen
100% del costo del curso o dejará inválido
su voucher OCP en caso de que su
método de pago sea OCP Voucher
_______________
Fima del cliente
____________
Fecha
15
ANEXO A
PAQUETE SUN CERTIFIED JAVA ASSOCIATE
A.1 Curso Presencial
Fundamentals of the Java Programming Language (SL-110-SE6)
The Fundamentals of the Java Programming Language course provides students with an excellent choice
for beginning to learn programming using the Java programming language. This course is intended for
students with little or no programming experience. The course teaches the significance of object-oriented
programming, the keywords and constructs of the Java programming language, and the steps required to
create simple Java technology programs. Students taking this course can receive a solid basis in the
Java programming language upon which to base continued work and training. The course features the
Java Platform, Standard Edition 6 (Java SE 6) platform, and uses the Java SE Development Kit 6 (JDK 6)
product.
Prerequisites
To succeed fully in this course, students should be able to:
Create programs using a procedural language, such as C, or a scripting language, such as Perl
Create and edit text files using a text editor
Use a World Wide Web (WWW) browser
Solve logic problems
Describe the concept of a variable
Execute commands using a command-line interface
Course Content
Module 1 - Explaining Java Technology
Describe key concepts of the Java programming language
List the three Java technology product groups
Summarize each of the seven stages of the product life cycle
Module 2 - Analyzing a Problem and Designing a Solution
Analyze a problem using object-oriented analysis
Design classes from which objects will be created
Module 3 - Developing and Testing a Java Technology Program
Identify the four components of a class in the Java programming language
Use the main method in a test class to run a Java technology program from the command line
Compile and execute a Java technology program
Module 4 - Declaring, Initializing, and Using Variables
Identify the use the syntax for variables and define the syntax for a variable
List the eight Java programming language primitive data types
Declare, initialize, and use variables and constants according to Java programming language guidelines
and coding standards
Modify variable values using operators
Use promotion and type casting
Module 5 - Creating and Using Objects
Declare, instantiate, and initialize object reference variables
Compare how object reference variables are stored in relation to primitive variables
Use a class (the String class) included in the Java Software Developer Kit (SDK)
Use the Java 2 Platform, Standard Edition (J2SE[TM]) class library specification to learn about other
classes in this application programming interface (API)
Module 6 - Using Operators and Decision Constructs
Identify relational and conditional operators
Create if and if/else constructs
Use the switch construct
Module 7 - Using Loop Constructs
16
Create while loops
Develop for loops
Create do/while loops
Module 8 - Developing and Using Methods
Describe the advantages of methods and define worker and calling methods
Declare and invoke a method
Compare object and static methods
Use overloaded methods
Module 9 - Implementing Encapsulation and Constructors
Use encapsulation to protect data
Create constructors to initialize objects
Module 10 - Creating and Using Arrays
Code one-dimensional arrays
Set array values using length attribute and a loop
Pass arguments to the main method for use in a program
Create two-dimensional arrays
Module 11 - Implementing Inheritance
Define and test your use of inheritance
Explain abstraction
Explicitly identify class libraries used in your code
A.2 Curso Web
Fundamentals of the Java Programming Language (WJB-110-SE6)
The Fundamentals of the Java Programming Language course provides students with an excellent choice
for beginning to learn programming using the Java programming language. This course is intended for
students with little or no programming experience. The course teaches the significance of object-oriented
programming, the keywords and constructs of the Java programming language, and the steps required to
create simple Java technology programs. Students taking this course can receive a solid basis in the
Java programming language upon which to base continued work and training. The course features the
Java Platform, Standard Edition 6 (Java SE 6) platform, and uses the Java SE Development Kit 6 (JDK 6)
product.
Who Can Benefit
Students who can benefit from this course are individuals who have basic mathematical, logical, and
analytical problem-solving skills and who want to begin learning the Java programming language. This
includes technical writers, web developers, technical managers, and individuals with a technical, nonprogramming background, such as system administrators. This course is also appropriate for novice
programmers and those programmers who prefer to start learning the Java programming language at an
introductory level. However, individuals are encouraged to have had some programming experience,
whether with a scripting language, such as Perl, or a third-generation language (such as Basic or C) prior
to attend this course.
Prerequisites
To succeed fully in this course, students should be able to:
Create programs using a procedural language, such as C, or a scripting language, such as Perl
Create and edit text files using a text editor
Use a World Wide Web (WWW) browser
Solve logic problems
Describe the concept of a variable
Execute commands using a command-line interface
Skills Gained
Upon completion of this course, students should be able to:
Demonstrate knowledge of Java technology, the Java programming language, and the product life cycle
Use various Java programming language constructs to create several Java technology applications
Use decision and looping constructs and methods to dictate program flow
Implement intermediate Java technology programming and object-oriented (OO) concepts in Java
17
technology programs
Course Content
Module 1 - Explaining Java Technology
Describe key concepts of the Java programming language
List the three Java technology product groups
Summarize each of the seven stages of the product life cycle
Module 2 - Analyzing a Problem and Designing a Solution
Analyze a problem using object-oriented analysis
Design classes from which objects will be created
Module 3 - Developing and Testing a Java Technology Program
Identify the four components of a class in the Java programming language
Use the main method in a test class to run a Java technology program from the command line
Compile and execute a Java technology program
Module 4 - Declaring, Initializing, and Using Variables
Identify the use the syntax for variables and define the syntax for a variable
List the eight Java programming language primitive data types
Declare, initialize, and use variables and constants according to Java programming language guidelines
and coding standards
Modify variable values using operators
Use promotion and type casting
Module 5 - Creating and Using Objects
Declare, instantiate, and initialize object reference variables
Compare how object reference variables are stored in relation to primitive variables
Use a class (the String class) included in the Java Software Developer Kit (SDK)
Use the Java Platform, Standard Edition (Java SE) class library specification to learn about other classes
in this application programming interface (API)
Module 6 - Using Operators and Decision Constructs
Identify relational and conditional operators
Create if and if/else constructs
Use the switch construct
Module 7 - Using Loop Constructs
Create while loops
Develop for loops
Create do/while loops
Module 8 - Developing and Using Methods
Describe the advantages of methods and define worker and calling methods
Declare and invoke a method
Compare object and static methods
Use overloaded methods
Module 9 - Implementing Encapsulation and Constructors
Use encapsulation to protect data
Create constructors to initialize objects
Module 10 - Creating and Using Arrays
Code one-dimensional arrays
Set array values using length attribute and a loop
Pass arguments to the main method for use in a program
Create two-dimensional arrays
Module 11 - Implementing Inheritance
Define and test your use of inheritance
Explain abstraction
Explicitly identify class libraries used in your code
A.3 Simulador de Exámen de Certificación
ePractice for the Sun Certified Associate for the Java Platform, Standard Edition, Exam Version 1.0
(WGS-PREX-J019)
The ePractice Certification Exam for the Sun Certified Associate for the Java Platform, Standard Edition,
18
Exam Version 1.0 exam provides students with preparation for Sun certification by acquainting them with
the format of the exam and its questions, providing instant feedback regarding skill levels and gaps, and
suggesting specific Sun Educational Services training to fill those gaps. The exam includes sample test
questions, the correct answers including explanations, and suggestions for future study.
This Sun ePractice exam is comprised of 150 questions, divided into three forms of 50 questions each.
A.4 Voucher con Retake
Sun Certified Associate for the Java Platform, Standard Edition, Exam Version 1.0 (CX-310-019)
The Sun Certified Associate for the Java Platform, Standard Edition, Exam Version 1.0 certification exam
provides an ideal entry into an application development or a software project management career using
Java technologies. This worldwide credential validates basic knowledge of Object-Oriented Concepts,
UML representation of OO concepts, the Java programming language, and general knowledge of Java
Platforms and Technologies. Candidates for this exam include: entry level Java programmers, students
studying to become Java programmers, project or program managers working with Java technology in the
software development industry.
19
ANEXO B
PAQUETE SUN CERTIFIED JAVA PROGRAMMER
B.1 Curso Presencial
Java Programming Language (SL-275-SE6)
The Java Programming Language course provides students with information about the syntax of the Java
programming language; object-oriented programming with the Java programming language; creating
graphical user interfaces (GUIs), exceptions, file input/output (I/O), and threads; and networking.
Programmers familiar with object-oriented concepts can learn how to develop Java technology
applications. The course features the Java Platform, Standard Edition 6 (Java SE 6) platform, and utilizes
the Java SE Development Kit 6 (JDK 6) product. The students perform the course lab exercises using the
NetBeans Integrated Development Environment (IDE) 5.5.
Who Can Benefit
Students who can benefit from this course are programmers who are interested in adding the Java
programming language to their list of skills and students who are preparing for the Sun Certified
Programmer for Java examination.
Course Content
Module 1 - Getting Started
Examine Java technology
Analyze a simple Java technology application
Execute a Java technology application
Module 2 - Object-Oriented Programming
Define modeling concepts: abstraction, encapsulation, and packages
Discuss Java technology application code reuse
Define class, member, attribute, method, constructor, and package
Use the access modifiers private and public as appropriate for the guidelines of encapsulation
Invoke a method on a particular object
Use the Java technology API online documentation
Module 3 - Identifiers, Keywords, and Types
Use comments in a source program
Distinguish between valid and invalid identifiers
Recognize Java technology keywords
List the eight primitive types
Define literal values for numeric and textual types
Define the terms primitive variable and reference variable
Declare variables of class type
Construct an object using new
Describe default initialization
Describe the significance of a reference variable
State the consequence of assigning variables of class type
Module 4 - Expressions and Flow Control
Distinguish between instance and local variables
Describe how to initialize instance variables
Recognize, describe, and use Java software operators
Distinguish between legal and illegal assignments of primitive types
Identify boolean expressions and their requirements in control constructs
Recognize assignment compatibility and required casts in fundamental types
Use if, switch, for, while, and do constructions and the labeled forms of break and continue as flow control
structures in a program
Module 5 - Arrays
Declare and create arrays of primitive, class, or array types
Explain why elements of an array are initialized
Explain how to initialize the elements of an array
20
Determine the number of elements in an array
Create a multidimensional array
Write code to copy array values from one array to another
Module 6 - Class Design
Define inheritance, polymorphism, overloading, overriding, and virtual method invocation
Use the access modifiers protected and the default (package-friendly)
Describe the concepts of constructor and method overloading
Describe the complete object construction and initialization operation
Module 7 - Advanced Class Features
Create static variables, methods, and initializers
Create final classes, methods, and variables
Create and use enumerated types
Use the static import statement
Create abstract classes and methods
Create and use an interface
Module 8 - Exceptions and Assertions
Define exceptions
Use try, catch, and finally statements
Describe exception categories
Identify common exceptions
Develop programs to handle your own exceptions
Use assertions
Distinguish appropriate and inappropriate uses of assertions
Enable assertions at runtime
Module 9 - Collections and Generics Framework
Describe the general purpose implementations of the core interfaces in the Collections framework
Examine the Map interface
Examine the legacy collection classes
Create natural and custom ordering by implementing the Comparable and Comparator interfaces
Use generic collections
Use type parameters in generic classes
Refactor existing non-generic code
Write a program to iterate over a collection
Examine the enhanced for loop
Module 10 - I/O Fundamentals
Write a program that uses command-line arguments and system properties
Examine the Properties class
Construct node and processing streams, and use them appropriately
Serialize and deserialize objects
Distinguish readers and writers from streams, and select appropriately between them
Module 11 - Console I/ O and File I/O
Read data from the console
Write data to the console
Describe files and file I/O
Module 12 - Building Java GUIs Using the Swing API
Describe the JFC Swing technology
Define Swing
Identify the Swing packages
Describe the GUI building blocks: containers, components, and layout managers
Examine top-level, general-purpose, and special-purpose properties of container
Examine components
Examine layout managers
Describe the Swing single-threaded model
Build a GUI using Swing components
Module 13 - Handling GUI-Generated Events
Define events and event handling
21
Examine the Java SE event model
Describe GUI behavior
Determine the user action that originated an event
Develop event listeners
Describe concurrency in Swing-based GUIs and describe the features of the SwingWorker class
Module 14 - GUI-Based Applications
Describe how to construct a menu bar, menu, and menu items in a Java GUI
Understand how to change the color and font of a component
Module 15 - Threads
Define a thread
Create separate threads in a Java technology program, controlling the code and data that are used by
that thread
Control the execution of a thread and write platform-independent code with threads
Describe the difficulties that might arise when multiple threads share data
Use wait and notify to communicate between threads
Use synchronized to protect data from corruption
Module 16 - Networking
Develop code to set up the network connection
Understand TCP/IP
Use ServerSocket and Socket classes to implement TCP/IP clients and servers
B.2 Curso Web
Java Programming Language (WJB-275-SE6)
The Java Programming Language course provides students with information about the syntax of the Java
programming language; object-oriented programming with the Java programming language; creating
graphical user interfaces (GUIs), exceptions, file input/output (I/O), and threads; and networking.
Programmers familiar with object-oriented concepts can learn how to develop Java technology
applications. The course features the Java Platform, Standard Edition 6 (Java SE 6) platform, and utilizes
the Java SE Development Kit 6 (JDK 6) product. The students perform the course lab exercises using the
NetBeans Integrated Development Environment (IDE)
Who Can Benefit
Students who can benefit from this course are programmers who are interested in adding the Java
programming language to their list of skills and students who are preparing for the Sun Certified
Programmer for Java examination.
Skills Gained
Upon completion of this course, students should be able to:
Create Java technology applications that leverage the object-oriented features of the Java language,
such as encapsulation, inheritance, and polymorphism
Execute a Java technology application from the command line
Use Java data types and expressions
Use Java flow control constructs
Use arrays and other data collections
Implement error-handling techniques using exception handling
Create an event-driven graphical user interface (GUI) using Swing components: panels, buttons, labels,
text fields, and text areas
Implement input/output (I/O) functionality to read from and write to data and text files and understand
advanced I/O streams
Create a simple Transmission Control Protocol/Internet Protocol (TCP/IP) networked client that
communicates with a server through sockets
Create multi-threaded programs
Course Content
Module 1 - Getting Started
Examine Java technology
22
Analyze a simple Java technology application
Execute a Java technology application
Module 2 - Object-Oriented Programming
Define modeling concepts: abstraction, encapsulation, and packages
Discuss Java technology application code reuse
Define class, member, attribute, method, constructor, and package
Use the access modifiers private and public as appropriate for the guidelines of encapsulation
Invoke a method on a particular object
Use the Java technology API online documentation
Module 3 - Identifiers, Keywords, and Types
Use comments in a source program
Distinguish between valid and invalid identifiers
Recognize Java technology keywords
List the eight primitive types
Define literal values for numeric and textual types
Define the terms primitive variable and reference variable
Declare variables of class type
Construct an object using new
Describe default initialization
Describe the significance of a reference variable
State the consequence of assigning variables of class type
Module 4 - Expressions and Flow Control
Distinguish between instance and local variables
Describe how to initialize instance variables
Recognize, describe, and use Java software operators
Distinguish between legal and illegal assignments of primitive types
Identify boolean expressions and their requirements in control constructs
Recognize assignment compatibility and required casts in fundamental types
Use if, switch, for, while, and do constructions and the labeled forms of break and continue as flow control
structures in a program
Module 5 - Arrays
Declare and create arrays of primitive, class, or array types
Explain why elements of an array are initialized
Explain how to initialize the elements of an array
Determine the number of elements in an array
Create a multidimensional array
Write code to copy array values from one array to another
Module 6 - Class Design
Define inheritance, polymorphism, overloading, overriding, and virtual method invocation
Use the access modifiers protected and the default (package-friendly)
Describe the concepts of constructor and method overloading
Describe the complete object construction and initialization operation
Module 7 - Advanced Class Features
Create static variables, methods, and initializers
Create final classes, methods, and variables
Create and use enumerated types
Use the static import statement
Create abstract classes and methods
Create and use an interface
Module 8 - Exceptions and Assertions
Define exceptions
Use try, catch, and finally statements
Describe exception categories
Identify common exceptions
Develop programs to handle your own exceptions
Use assertions
23
Distinguish appropriate and inappropriate uses of assertions
Enable assertions at runtime
Module 9 - Collections and Generics Framework
Describe the general purpose implementations of the core interfaces in the Collections framework
Examine the Map interface
Examine the legacy collection classes
Create natural and custom ordering by implementing the Comparable and Comparator interfaces
Use generic collections
Use type parameters in generic classes
Refactor existing non-generic code
Write a program to iterate over a collection
Examine the enhanced for loop
Module 10 - I/O Fundamentals
Write a program that uses command-line arguments and system properties
Examine the Properties class
Construct node and processing streams, and use them appropriately
Serialize and deserialize objects
Distinguish readers and writers from streams, and select appropriately between them
Module 11 - Console I/ O and File I/O
Read data from the console
Write data to the console
Describe files and file I/O
Module 12 - Building Java GUIs Using the Swing API
Describe the JFC Swing technology
Define Swing
Identify the Swing packages
Describe the GUI building blocks: containers, components, and layout managers
Examine top-level, general-purpose, and special-purpose properties of container
Examine components
Examine layout managers
Describe the Swing single-threaded model
Build a GUI using Swing components
Module 13 - Handling GUI-Generated Events
Define events and event handling
Examine the Java SE event model
Describe GUI behavior
Determine the user action that originated an event
Develop event listeners
Describe concurrency in Swing-based GUIs and describe the features of the SwingWorker class
Module 14 - GUI-Based Applications
Describe how to construct a menu bar, menu, and menu items in a Java GUI
Understand how to change the color and font of a component
Module 15 - Threads
Define a thread
Create separate threads in a Java technology program, controlling the code and data that are used by
that thread
Control the execution of a thread and write platform-independent code with threads
Describe the difficulties that might arise when multiple threads share data
Use wait and notify to communicate between threads
Use synchronized to protect data from corruption
Module 16 - Networking
Develop code to set up the network connection
Understand TCP/IP
Use ServerSocket and Socket classes to implement TCP/IP clients and servers
B.3 Simulador de Exámen
24
ePractice exam for the Sun Certified Programmer for the Java Platform, Standard Edition 6 (WGS-PREXJ065C)
The ePractice Certification Exam for the Sun Certified Programmer for the Java Platform, Standard
Edition 6 exam provides students with preparation for Sun certification by acquainting them with the
format of the exam and its questions, providing instant feedback regarding skill levels and gaps, and
suggesting specific Sun Learning Services training to fill those gaps. The exam includes sample test
questions, the correct answers including explanations, and suggestions for future study. This Sun
ePractice exam is comprised of 120 questions, divided into two forms of 60 questions each.
B.4 Voucher con Retake
Sun Certified Programmer for the Java Platform, Standard Edition 6 (CX-310-065)
Sun Certified Programmer for the Java Platform, Standard Edition 6 The Sun Certified Programmer for
Java Platform, Standard Edition 6 certification exam is for programmers experienced using the Java
programming language. Achieving this certification provides clear evidence that a programmer
understands the basic syntax and structure of the Java programming language and can create Java
technology applications that run on server and desktop systems using Java SE 6.
25
Anexo C
PAQUETE SUN CERTIFIED JAVA DEVELOPER WEB COMPONENT
C.1 Curso Presencial
Web component Developer with JSP and Sevlet (SL-314-EE5)
JavaServer Pages (JSP page) technology and servlets are the key web-tier technologies defined in the
Java Platform, Enterprise Edition (Java EE platform). The Web Component Development With Servlet
and JSP Technologies course provides experienced developers of Java technology applications the
knowledge and skills to quickly build web applications from JSP page and servlet technologies using the
Sun Java System Application Server, and the Apache Struts framework. Students are exposed to the
current methods for analyzing, designing, developing,and deploying web applications with Java
technologies. Lab exercises provide students with experience in constructing and deploying the small-tomedium scale web applications found in intranet and low-volume commercial sites. The course features
the Java EE 5 technology, and uses the Java EE 5 SDK. The students perform the lab exercises using
the NetBeans Integrated Development Environment (IDE) 5.5. This course is also an ideal method of
preparing for the revised Sun Certified Web Component Developer (SCWCD) for Java EE 5 certification
examination. However, an SCWCD candidate should also spend six months building web applications
using the JSP page and servlet technologies before taking the exam.
Who Can Benefit
Developers with skills equivalent to that of a Sun Certified Java Developer, who are creating web
components (such as servlets and custom tags), can benefit. This is not a course for web page designers
using Hypertext Markup Language (HTML), JavaScript technology, or other web presentation
technologies.
Prerequisites
To succeed fully in this course, students should be able to:
Write Java technology applications, demonstrating significant programming ability
Integrate existing Java code (for example, reuse existing classes created by other team members)
Design Java technology applications
Functionally describe the benefits of an n-tier architecture
Write a web page using HTML
Skills Gained
Upon completion of this course, students will be able to:
Write servlets using the Java programming language (Java servlets)
Create robust web applications using Struts, session management, filters, and database integration
Write JSP pages
Create easy to maintain JSP pages using the Expression Language, JSP Standard Tag Library (JSTL),
and the Struts Tiles framework
Create robust web applications that integrate Struts and JSP pages
C.2 Curso WebDeveloping Applications for the Java EE Platform (WJB-310-EE5)
The Developing Applications for the Java EE Platform course provides students with the knowledge to
build and deploy enterprise applications that comply with the Java Platform, Enterprise Edition 5
technology standards. The enterprise components presented in this course include Enterprise JavaBeans
(EJB) technology,the Java persistence API (JPA), servlets, and JavaServer Pages (JSP) technology, web
services, and the Java technology clients that use them. Students gain hands-on experience through labs
that build an end-to-end, distributed business application. The labs explore session EJB components,
which implement the Session Facade pattern and provide a front-end to entity components using the
Java persistence API. The labs also explore message-driven EJB components, which act as Java
Message Service (JMS) consumers. Students use web and Java technology clients to access Java
technology-based enterprise services using servlets and pages created with JSP technology (JSP
pages). Students are taught how to assemble an application from reusable
components and how to deploy an application into the Java EE platform runtime
26
environment. The students perform the course lab exercises using the NetBeans 5.5 Integrated
Development Environment (IDE)
Who Can Benefit
Students who can benefit from this course are Sun Certified Java technology programmers who want to
develop enterprise applications that conform to the Java EE platform standards.
Skills Gained
Upon completion of this course, students should be able to:
Describe the application model for the Java EE platform and the context for the model
Develop and run an EJB technology application
Develop a web-based user interface to an EJB technology application
Develop simple web services for the Java EE platform
Configure the Java EE platform services layer
Course Content
Module 1 - Placing the Java EE Model in Context
Describe the needs of enterprise applications and describe how Java EE 5 technology addresses these
needs
Describe the Java EE 5 platform application programming interfaces (APIs) and supporting services
Describe the Java EE platform tiers and architectures
Describe how to simplify Java EE application development using architecture patterns
Module 2 - Java EE Component Model and Development Steps
Describe the principles of a component-based development model
Describe the asynchronous communication model
Describe the process used and roles involved when developing and executing a Java EE application
Compare the different methods and tools available for developing a Java EE application and related
components
Describe how to configure and package Java EE applications
Module 3 - Web Component Model
Describe the role of web components in a Java EE application
Define the HTTP request-response model
Compare Java servlets and components and JSP components
Describe the basic session management strategies
Manage thread safety issues in web components
Describe the purpose of web-tier design patterns
Module 4 - Developing Servlets
Describe the servlet API
Use the request and response APIs
Forward control and pass data
Use the session management API
Module 5 - Developing With JavaServer Pages Technology
Evaluate the role of JSP technology as a presentation mechanism
Author JSP pages
Process data received from servlets in a JSP page
Describe the use of tag libraries
Module 6 - EJB Component Model
Describe the role of EJB components in a Java EE application
Describe the EJB component model
Identify the proper terminology to use when discussing EJB components and their elements
Module 7 - Implementing EJB 3.0 Session Beans
Compare stateless and stateful behavior
Describe the operational characteristics of a stateless session bean
Describe the operational characteristics of a stateful session bean
Create session beans
Package and deploy session beans
Create a session bean client
Module 8 - The Java Persistence API
Describe the role of the Java Persistence API (JPA) in a Java EE application
27
Describe the basics of Object Relational Mapping
Describe the elements and environment of an Entity component
Describe the life cycle and operational characteristics of Entity components
Module 9 - Implementing a Transaction Policy
Describe transaction semantics
Compare programmatic and declarative transaction scoping
Use the Java Transaction API (JTA) to scope transactions programmatically
Implement a container-managed transaction policy
Support optimistic locking with the versioning of entity components
Predict the effect of transaction scope on application performance
Describe the effect of exceptions on transaction state
Module 10 - Developing Java EE Applications Using Messaging
Describe JMS technology
Create a queue message producer
Create a synchronous message consumer
Create an asynchronous message consumer
List the capabilities and limitations of EJB components as messaging clients
Module 11 - Developing Message-Driven Beans
Describe the properties and life cycle of message-driven beans
Create a JMS message-driven bean
Create life-cycle event handlers for a JMS message-driven bean
Module 12 - Web Service Model
Describe the role of web services
List the specifications used to make web services platform independent
Describe the Java APIs used for XML processing and web services
Module 13 - Implementing Java EE Web Services with JAX-WS
Describe endpoints supported by the Java EE 5 platform
Describe the requirements of JAX-WS Servlet Endpoints
Describe the requirements of JAX-WS EJB Endpoints
Develop Web Service Clients
Module 14 - Implementing a Security Policy
Exploit container-managed security
Define user roles and responsibilities
Create a role-based security policy
Use the security API
Configure authentication in the web tier
C.3 Curso Web
Web Component Development With Servlet and JSP Technologies (WJB-314-EE5)
JavaServer Pages (JSP page) technology and servlets are the key web-tier technologies defined in the
Java Platform, Enterprise Edition (Java EE platform). The Web Component Development With Servlet
and JSP Technologies course provides experienced developers of Java technology applications the
knowledge and skills to quickly build web applications from JSP page and servlet technologies using the
Sun Java System Application Server, and the Struts framework. Students are exposed to the current
methods for analyzing, designing, developing,and deploying web applications with Java technologies. Lab
exercises provide students with experience in constructing and deploying the small-to-medium scale web
applications found in intranet and low-volume commercial sites.The students perform the lab exercises
using the NetBeans Integrated Development Environment (IDE). This course is also an ideal method of
preparing for the revised Sun Certified Web Component Developer (SCWCD) for Java EE 5 certification
examination. However, an SCWCD candidate should also spend six months building web applications
using the JSP page and servlet technologies before taking the exam.
Skills Gained
Upon completion of this course, students will be able to:
Write servlets using the Java programming language (Java servlets)
Create robust web applications using Struts, session management, filters, and database integration
Write JSP pages
28
Create easy to maintain JSP pages using the Expression Language, JSP Standard Tag Library (JSTL),
and the Struts Tiles framework
Create robust web applications that integrate Struts and JSP pages
Course Content
Module 1 - Introduction to Web Application Technologies
Describe web applications
Describe Java Platform, Enterprise Edition 5 (Java EE 5)
Describe Java servlet technology
Describe JavaServer Pages technology
Define three-tier architecture
Define Model-View-Controller (MVC) architecture
Module 2 - Developing a View Component
Design a view component
Describe the Hypertext Transfer Protocol
Describe the web container behavior
Develop a simple HTTP servlet
Configure and deploy a servlet
Module 3 - Developing a Controller Component
Design a controller component
Create an HTML form
Describe how HTML form data is sent in an HTTP request
Develop a controller servlet
Dispatch from a controller servlet to a view servlet
Module 4 - Developing Dynamic Forms
Describe the servlet life cycle
Customize a servlet with initialization parameters
Explain error reporting within the web form
Repopulate the web form
Module 5 - Sharing Application Resources Using the Servlet Context
Describe the purpose and features of the servlet context
Develop a servlet context listener to initialize a shared application resource
Module 6 - Designing the Business Tier
Describe the Analysis model
Design entity components
Design service components
Module 7 - Developing a Web Application Using Struts
Design a web application using the Struts MVC framework
Develop a Struts action class
Configure the Struts action mappings
Module 8 - Developing Web Applications Using Session Management
Describe the purpose of session management
Design a web application that uses session management
Develop servlets using session management
Describe the cookies implementation of session management
Describe the URL-rewriting implementation of session management
Module 9 - Using Filters in Web Applications
Describe the web container request cycle
Describe the Filter API
Develop a filter class
Configure a filter in the web.xml file
Module 10 - Integrating Web Applications With Databases
Map a sample data structure into database entities
Design a web application to integrate with a DBMS
Configuring a DataSource and Java Naming and Directory Interface (JNDI)
API
29
Module 11 - Developing JSP Pages
Describe JSP page technology
Write JSP code using scripting elements
Write JSP code using the page directive
Write JSP code using standard tags
Write JSP code using the Expression Language (EL)
Configure the JSP page environment in the web.xml file
Module 12 - Developing JSP Pages Using Custom Tags
Describe the Java EE job roles involved in web application development
Design a web application using custom tags
Use JSTL tags in a JSP page
Module 13 - Developing Web Applications Using Struts Action Forms
Describe the components in a Struts application
Develop an ActionForm class
Develop a JSP page for a View form
Configure the View forms
C.4 Simulador de Examen
ePractice Exam for the Sun Certified Solaris Associate (WGS-PREX-S105C)
The ePractice Certification Exam for the for Sun Certified Solaris Associate provides students with
preparation for Sun certification by acquainting them with the format of the exam and its questions,
providing instant feedback regarding skill levels and gaps, and suggesting specific Sun training to fill
those gaps. The exam includes sample test questions, the correct answers including explanations, and
suggestions for future study.
This Sun ePractice exam is comprised of 120 questions, divided into two forms of 60 questions each.
C.5 Voucher con Retake
Sun Certified Web Component Developer for the Java Platform, Enterprise Edition 5 (CX-310-083)
The Sun Certified Web Component Developer for the Java Platform, Enterprise Edition 5 certification
exam is for Sun Certified Programmers (any edition) who are using the Java technology servlet and
JavaServer Pages (JSP) application program interface (APIs) to develop web applications. Prior to
beginning the Sun Certified Web Component Developer program, you must be a Sun Certified
Programmer for the Java platform (any edition).
30
Anexo D
Paquete SUN CERTIFIED SOLARIS ASSOCIATE
D.1 Curso Presencial
Curso presencial y Manual Unix Essentials Featuring the Solaris 10 OS (SA-100-S10)
Objetivo Las personas que realicen el curso aprenderán a:
Utilizar los componentes del sistema de escritorio.
Usar las funciones de la línea de comandos y los recursos de ayuda.
Ver y manejar archivos y directorios, y cambiar el contenido de los directorios.
Crear y modificar archivos, y utilizar los permisos de archivos básicos.
Crear listas de control de acceso (ACL) y controlar el entorno de trabajo del usuario.
Usar comandos en el shell.
Realizar un control básico de los procesos y los jobs.
Crear archivos de almacenamiento y guardarlos.
Comprimir, ver y descomprimir archivos.
Transferir archivos remotos.
Descripción En este curso se enseñan las funciones y capacidades fundamentales del sistema operativo
Solaris 10 de Sun. El temario incluye la administración de directorios, el control del entorno de trabajo del
usuario, el almacenamiento de archivos y el uso de comandos remotos. En el curso también se explican
las funciones esenciales de la línea de comandos de Solaris, lo que incluye el desplazamiento por los
sistemas de archivos, el editor de texto vi, los permisos de archivos, las listas de control de acceso
(ACL), los shells de comandos, la compresión de archivos, el uso básico de la red y la lectura de las
secuencias de comandos de shell. Se trata del primero de una serie de dos cursos que los alumnos
pueden utilizar como preparación para el examen de Administrador Certificado de Sistemas Solaris,
Parte I.
A quién va dirigido Este curso es indicado para personas que deben realizar tareas básicas de
administración de sistemas y no conocen el sistema operativo Solaris, o personas sin experiencia en el
sistema operativo UNIX.
Pre-requisitos Para obtener el máximo aprovechamiento del curso, los alumnos necesitan:
Utilizar los componentes básicos de un PC (monitor, teclado y ratón).
Saber introducir comandos y caracteres de control desde un teclado.
Cursos relacionados (Después) SA-200-S10: Administración de Sistemas Solaris 10 Parte 1 (SA-200S10)
SA-245: Programación Shell para Administradores de Sistemas (SA-245)
Contenido Uso del escritorio en el sistema operativo Solaris 10
Describir los componentes de hardware de un PC.
Describir los componentes del sistema operativo Solaris.
Describir el sistema operativo SunOS.
Iniciar una sesión en el sistema.
Utilizar el entorno de escritorio.
Uso de las funciones de la línea de comandos y de los recursos de ayuda en línea
Crear y ejecutar comandos desde la línea de comandos.
Utilizar la documentación en línea.
Visualización de directorios y archivos
Trabajar con directorios.
Trabajar con archivos.
Imprimir archivos.
Cambio del contenido de los directorios de Solaris
Copiar archivos y directorios.
Mover archivos y directorios, y cambiar su nombre.
31
Crear archivos y directorios.
Eliminar archivos y directorios.
Utilizar enlaces simbólicos.
Uso del editor vi
Describir los conceptos fundamentales del editor vi.
Modificar archivos con el editor vi.
Uso de comandos en el shell
Utilizar metacaracteres de shell.
Describir las variables del shell Korn.
Mostrar el historial de comandos.
Describir el intérprete de la línea de comandos.
Trabajar con archivos de inicialización de usuario.
Uso de permisos de archivos básicos
Visualizar permisos de archivos y directorios.
Determinar el acceso a archivos o directorios.
Cambiar los permisos.
Modificar los permisos predeterminados.
Configurar las listas de control de acceso (ACL).
Describir las listas de control de acceso (ACL).
Configurar listas de control de acceso mediante el uso de la línea de comandos.
Configurar listas de control de acceso utilizando la interfaz gráfica del administrador de archivos (File
Manager).
Búsqueda de archivos y directorios
Buscar contenido en archivos.
Buscar archivos y directorios.
Operaciones de control básico de los procesos
Describir los procesos del sistema Solaris.
Visualizar un proceso.
Buscar un proceso específico.
Enviar una señal a un proceso.
Funcionalidad avanzada de shell
Administrar trabajos en el shell Korn.
Describir la utilidad de alias del shell Korn.
Utilizar las funciones del shell Korn.
Definir las opciones del shell Korn.
Lectura de secuencias de comandos de shell
Describir las secuencias de comandos de shell.
Ejecutar secuencias de comandos de shell.
Pasar valores a las secuencias de comandos de shell.
Utilizar el comando test.
Ejecutar comandos condicionales.
Creación de archivos de almacenamiento
Archivar la información.
Comprimir y almacenar archivos con el comando jar.
Compresión, visualización y descompresión de archivos
Comprimir archivos con el comando compress.
32
Ver archivos comprimidos con el comando zcat.
Descomprimir archivos con el comando uncompress.
Comprimir un archivo con el comando gzip.
Ver archivos con el comando gzcat.
Comprimir y almacenar varios archivos con el comando zip.
Establecimiento de conexiones remotas y transferencias de archivos
Establecer una sesión de inicio remota.
Copiar archivos o directorios entre sistemas.
Transferir archivos entre sistemas.
D.2 Curso Web
On Demand Labs - Solaris 10 Essentials (WSPL-SA-100-S10)
Objetivo Upon completion of this course, students should be able to:
Use command-line features and on-line help resources
Manage and view files and directories
Search for files and directories and change directory contents
Use the vi text editor
Create and modify files and use basic file permissions
Configure access control lists
Perform basic process and job control
Descripción The On Demand Labs for Solaris 10 Essentials provides a hands-on experience in a Solaris
environment with the key features and capabilities of the Solaris 10 operating
system. These self-paced labs guide you through the use of fundamental
command-line features in Solaris, managing and viewing directories and files,
navigating the Solaris file system, viewing and searching for files and directories,
using the vi text editor, creating and modifying file and directory permissions,
configuring access control lists, and performing basic process control activities.
A quién va dirigido Students who can benefit from this course are those individuals who are new to the
Solaris Operating System, are unfamiliar with Solaris commands, or those preparing to perform basic
system administration tasks
Pre-requisitos To succeed fully in these lab activities, students should be able to:
Use basic computer hardware (monitor, keyboard, and mouse)
Input commands and control characters from a keyboard
Contenido
Lab 1
Construct and execute commands
Use command-line features
Scroll through on-line man pages
Use on-line documentation
Lab 2
Work with directories
Access files and file content
Lab 3
Copy files and directories
Move and rename files and directories
Create files and directories
Remove files and directories
Use symbolic links
Lab 4
33
Describe the fundamentals of the vi text editor
Modify content in files using the vi editor
Lab 5
View file and directory permissions
Determine file or directory access
Change the permissions on files and directories
Modify the default permissions
Lab 6
Describe Access Control Lists (ACLs)
Configure ACLs by using the command-line
Configure ACLs using the File Manager graphical user interface (GUI)
Lab 7
Search for content in files
Search for files and directories
Lab 8
Describe Solaris OS processes
View a process
Search for a specific process
Send a signal to a process
D.3 Curso Web
On Demand Labs - Solaris 10 Essentials (WSPL-SA-100-S10)
Who Can Benefit
Students who can benefit from this course are those individuals who are new to the Solaris Operating
System, are unfamiliar with Solaris commands, or those preparing to perform basic system administration
tasks
Prerequisites
To succeed fully in these lab activities, students should be able to:
Use basic computer hardware (monitor, keyboard, and mouse)
Input commands and control characters from a keyboard
Skills Gained
Upon completion of this course, students should be able to:
Use command-line features and on-line help resources
Manage and view files and directories
Search for files and directories and change directory contents
Use the vi text editor
Create and modify files and use basic file permissions
Configure access control lists
Perform basic process and job control
Course Content
Lab 1
Using Command-Line Features and On-line Help Resources
Construct and execute commands
Use command-line features
Scroll through on-line man pages
Use on-line documentation
Lab 2
34
Viewing Directories and Files
Work with directories
Access files and file content
Lab 3
Changing the Solaris OS Directory Contents
Copy files and directories
Move and rename files and directories
Create files and directories
Remove files and directories
Use symbolic links
Lab 4
Using the vi Editor
Describe the fundamentals of the vi text editor
Modify content in files using the vi editor
Lab 5
Using Basic File Permissions
View file and directory permissions
Determine file or directory access
Change the permissions on files and directories
Modify the default permissions
Lab 6
Configuring Access Control Lists
Describe Access Control Lists (ACLs)
Configure ACLs by using the command-line
Configure ACLs using the File Manager graphical user interface (GUI)
Lab 7
Searching Files and Directories
Search for content in files
Search for files and directories
Lab 8
Performing Basic Process Control
Describe Solaris OS processes
View a process
Search for a specific process
Send a signal to a process
D.4 Voucher con Retake
Sun Certified Solaris Associate (SCSAS) (CX-310-105)
The Sun Certified Solaris Associate Certification exam is for candidates with a basic knowledge of
Solaris. This exam is primarily for university students and Solaris beginners wishing to demonstrate
competency in the ability to perform basic tasks in a Solaris environment or with specific applications. The
test candidate will benefit from a general knowledge of basic Solaris commands in a Solaris environment,
such as those covered in the SA-100-S10 courseware. This certification exam includes multiple-choice
and scenario-based questions and requires knowledge of basic Solaris topics, including using basic
Solaris commands to work with directories and files, creating and editing files, compressing, viewing and
uncompressing files, managing permissions and ownership, configuring access control lists, searching
directories and files, performing basic process control, working with advanced shell functionality, archiving
file, and performing remote file transfers.
35
Anexo E
Paquete Sun Certified Business Component Developer
E.1 Curso Presencial
Business Component Development with Enterprise JavaBeans Technology
(SL-351-EE5)
The Business Component Development with Enterprise JavaBeans Technology course provides students
with the
knowledge of how to develop robust back-end functionality using Enterprise JavaBeans (EJB[TM])
version 3.0
technology. This course uses an online auction scenario to demonstrate how to leverage containermanaged services
with session and message beans, and entity classes to resolve the real-world problems presented by an
electronic
commerce application. The emphasis of this course is on providing practical EJB technology coding
experience, while
also covering the designs and best practices used to solve transaction, messaging, and security issues.
The course
features the Java Platform, Enterprise Edition 5 (Java EE 5) technology, and uses the Java EE 5 SDK.
The students
perform the course lab exercises using the NetBeans Integrated Development Environment (IDE) 5.5.
The hands-on lab
environment uses the Java EE reference implementation server to provide students with a non-vendorspecific
experience.
who Can Benefit
Students who can benefit from this course are EJB technology business component developers who are
tasked with the
following responsibilities:
• Analyzing, designing, developing, and testing EJB technology applications
• Deploying an EJB technology application
• Integrating an EJB technology application with a legacy application
Prerequisites
To succeed fully in this course, students should be able to:
• Display experience with the Java programming language
• Integrate existing Java code (for example, reuse existing classes created by other team members)
• Design Java technology applications
• Although not required, experience with distributed computing concepts in Java technology is an
advantage
Course Content
Module 1 - Examining EJB Applications
• Introduce the Java Platform, Enterprise Edition (Java EE)
• Examine the Java EE application architecture
• Examine the Java EE application creation process
Module 2 - Introducing the Auction Application
• Describe the auction application
• Define the domain objects of the auction application
• Describe the implementation model for the auction system
Programa Nacional de Certificación Java & Solaris
36
41 © Sun Microsystems ltd, 2010
Module 3 - Implementing EJB 3.0 Session Beans
• Create session beans: Essential tasks
• Create session beans: Add life-cycle event handlers
• Package and deploy session beans
• Create a session bean client
Module 4 - Implementing Entity Classes: The Basics
• Define entity classes: Essential tasks
• Manage the life-cycle of an entity instance
• Define entity beans: Add life-cycle event handlers
• Package and deploy entity classes
Module 5 - Implementing Entity Classes: Modelling Data Association Relationships
• Examine association relationships in the data and object models
• Use relationship properties to define associations
• Implement unidirectional and bidirectional associations
Module 6 - Implementing Entity Classes: Modelling Inheritance Relationships
• Examining entity class inheritance
• Inheriting from an entity class
• Inheriting from an abstract entity class
Module 7 - Using the Java Persistence Query Language (QL)
• Examine the Java Persistence query language
• Create and use the SELECT statement
• Create and use the BULK UPDATE statement
• Create and use the DELETE statement
• Create and use Query objects
Module 8 - Developing Java EE Applications Using Messaging
• Describe the roles of the participants in the JMS API messaging system
• Write a message producer
• Write an asynchronous message listener
• Write a synchronous message listener
• List the messaging capabilities and limitations of session, entity, and message-driven beans
Module 9 - Developing Message-Driven Beans
• Describe the properties and life cycle of message-driven beans
• Create a JMS message-driven bean
• Create a non JMS message-driven bean
Module 10 - Implementing Interceptor Classes and Methods
• Create business interceptor method in the enterprise bean class
• Create an interceptor class
• Associate multiple business interceptor methods with an enterprise bean
• Include life-cycle callback interceptor methods in an interceptor class
• Create entity life-cycle callback methods
Module 11 - Implementing Transactions
• Describe the transaction demarcation task
• Implement Container-Managed Transactions (CMT)
• Interact programmatically with an ongoing CMT transaction
• Implement Bean-Managed Transactions (BMT)
• Apply transactions to messaging
37
Module 12 - Handling Exceptions
• Introduce exceptions in Java EE applications
• Describe the exception path in a Java EE application environment
• Describe EJB container exception handling
• Handle exceptions in an enterprise bean's methods
• Handle exceptions in an enterprise bean's client code
• Review specific issues relating to exception handling in EJB technology applications
Module 13 - Using Timer Services
• Create a timer callback notification
• Process a timer callback notification
• Manage timer objects
Module 14 - Implementing Security
• Understand the Java EE security architecture
• Authenticate the caller
• Examine Java EE authorization strategies
• Use declarative authorization
• Use programmatic authorization
• Examine the responsibilities of the deployer
Module 15 - Using EJB Technology Best Practices
• Define best practices and state the benefits of using EJB technology best practices
• Select and apply known patterns to Java EE application design
E.2 Curso Web
Business Component Development With Enterprise JavaBeans Technology
(WJB-351-EE5)
The Business Component Development with Enterprise JavaBeans Technology course provides students
with the
knowledge of how to develop robust back-end functionality using Enterprise JavaBeans (EJB) version 3.0
technology.
This course uses an online auction scenario to demonstrate how to leverage container-managed services
with session
and message beans, and entity classes to resolve the real-world problems presented by an electronic
commerce
application. The emphasis of this course is on providing practical EJB technology coding experience,
while also covering
the designs and best practices used to solve transaction, messaging, and security issues. The course
features the Java
Platform, Enterprise Edition 5 (Java EE 5) technology, and uses the Java EE 5 SDK. The students
perform the course
lab exercises using the NetBeans 5.5 Integrated Development Environment.The hands-on lab
environment uses the
Java Platform, Enterprise Edition (Java EE) reference implementation server to provide students with a
non vendorspecific experience.
Skills Gained
Upon completion of this course, students should be able to:
1. Implement business-tier functionality using EJB technology
2. Describe best practices and other advanced issues in business component
development with EJB technology
38
3. Assemble and deploy EJB technology business-tier components in an application server
4. Integrate an EJB technology-based application using the Java Messaging Service API (and the Java
Connector
Architecture)
Course Content
Module 1 - Examining EJB Applications
• Introduce the Java Platform, Enterprise Edition (Java EE)
• Examine the Java EE application architecture
• Examine the Java EE application creation process
Module 2 - Introducing the Auction Application
• Describe the auction application
• Define the domain objects of the auction application
• Describe the implementation model for the auction system
Module 3 - Implementing EJB 3.0 Session Beans
• Create session beans: Essential tasks
• Create session beans: Add life-cycle event handlers
• Package and deploy session beans
• Create a session bean client
Module 4 - Implementing Entity Classes: The Basics
• Define entity classes: Essential tasks
• Manage the life-cycle of an entity instance
• Define entity beans: Add life-cycle event handlers
• Package and deploy entity classes
Module 5 - Implementing Entity Classes: Modelling Data Association Relationships
• Examine association relationships in the data and object models
• Use relationship properties to define associations
• Implement unidirectional and bidirectional associations
Module 6 - Implementing Entity Classes: Modelling Inheritance Relationships
• Examining entity class inheritance
• Inheriting from an entity class
• Inheriting from an abstract entity class
• Inheriting from a non-entity class
• Inheriting using an embedded superclass
• Examining Inheritance mapping strategies
• Define entity classes: Using an embedded class
• Define entity classes: Using a composite primary key
Module 7 - Using the Java Persistence Query Language (QL)
• Examine the Java Persistence query language
• Create and use the SELECT statement
• Create and use the BULK UPDATE statement
• Create and use the DELETE statement
• Create and use Query objects
E.3 Simulador de Examen
39
ePractice for the Sun Certified Business Component Developer for the Java
Platform, Enterprise Edition 5 (WGS-PREX-J091)
This Sun Certified Business Component Developer for the Java Platform, Enterprise Edition 5.0
certification is for advanced programmer and developers with extensive job-role experience in
designing, developing, testing, deploying, and integrating Enterprise JavaBeans EJB Edition 3.0.
The exam includes multiple-chioice, scenario-based questions and drag-and-drop questions and
requires extensive knowledge of EJB Edition 3.0.
E.4 Voucher con Retake
Sun Certified Business Component Developer for the Java Platform, Enterprise
Edition 5 (CX-310-091)
This Sun Certified Business Component Developer for the Java Platform, Enterprise Edition 5 certification
is
for advanced programmer and developers with extensive job-role experience in designing, developing,
testing, deploying, and integrating Enterprise JavaBeans EJB Edition 3.0. The exam includes
multiplechoice,
scenario-based questions and drag-and-drop questions and requires extensive knowledge of EJB
Edition 3.0.
40
Anexo F
Paquete Sun Certified Developer for Java Web Services
F.1 Curso Presencial
Creating Web Services Using Java Technology (DWS-3111-EE5)
The Creating Web Services Using Java Technology course provides business component and client
developers with the
information they need to create, implement, and deploy web services and web service clients using Java
technology
components and the Java Platform, Enterprise Edition 5 SDK(Java EE 5 SDK).The students perform the
course lab
exercises using the NetBeans 5.5 Integrated Development Environment (IDE) and Sun Java System
Application Server
Platform Edition 9.0.
Course Content
Module 1 - Identifying the Building Blocks of Web Services
• Define a web service
• Explore the need for web services
• Identify the characteristics of a web service
• List the primary web service initiatives, specifications, and Application Programming Interfaces (APIs)
• Recognize the Web Services Interoperability Organization (WS-I) Basic Profile and its importance to the
web
services community
• Examine the sample application
• Recognize the various example and demonstration scenarios used in this course
• Deploy and test the sample application
Module 2 - Analyzing the Java Web Services Technology and Platform
• Deploy and test a web service as a servlet endpoint
• Deploy and test a web service as an Enterprise JavaBeans? (EJB?) component endpoint
• Run client applications that consume a web service
Module 3 - Applying XML Processing APIs
• Apply Java Architecture for XML Binding (JAXB) in a REST-based web service
• Apply Simple API for XML (SAX) to format the output of a REST-based web service
Module 4 - Examining SOAP Messages
• Examine various SOAP messages
• Monitor SOAP messages being transmitted from a web service to a client and review SOAP fault
messages
Module 5 - Developing Web Services Using the SOAP With Attachments API for Java (SAAJ
• Create a web service using SOAP with Attachments API for Java (SAAJ)
• Consume a SAAJ-based web service
Module 6 - Explaining the Web Services Description Language (WSDL)
• Identify the abstract model and concrete model of a WSDL file
• Create a WSDL file to describe a web service
41
Module 7 - Recognizing the Role of Service Registry
• Describe the purpose of a service registry
• Describe Universal Description, Discovery, and Integration (UDDI)
• Describe electronic business XML(ebXML)
• Identify the features of the ebXML registry
• Use the Java API for XML Registries (JAXR) to access an ebXML registry
• Describe the JAXR API
Module 8 - Implementing Web Services Using Java API for XML Web Services (JAX-WS) Technology
• Create a web service from a WSDL file
• Create a JAX-WS web service as a servlet endpoint
• Create a JAX-WS web service as an EJB component endpoint
Module 9 - Developing Web Service Clients
• Create a JAX-WS web-service client using a Dynamic Proxy
• Enable a web application to consume a JAX-WS-based web service
F.2 Curso Web
Web Services Infrastructure and Organizations (WJO-1114)
The Web Services Infrastructure and Organizations course discusses web services, web services
infrastructure,and the
web services models such as the WS model. In addition, the course explains the Java EE 5 Web
Services APIs. The
course also describes web services organizations, such as W3C, WS-I, OASIS, and JCP.
F.3 Curso Web
Web Services Enabling Technologies (WJO-1118)
Web services enabling technologies are a set of technologies based on XML standards that help
describe, access, and
interact with web services. The Web Services Enabling Technologies course describes these standards,
which include
the Simple Object Access Protocol (SOAP), the Web Services Description Language (WSDL), and
Universal Description,
Discovery, and Integration (UDDI). In addition, the course describes how to create and test JAX-WS web
services with
NetBeans(TM) Interface Development Environment (IDE) and Sun Java System Application Server
(Application Server).
F.4 Simulador de Examen
ePractice Certification Exam for the Sun Certified Developer for Java Web
Services 5 (WGS-PREX-J230C)
The ePractice Certification Exam for the Sun Certified Developer for Java Web Services 5, provides
students with
preparation for Sun certification by acquainting them with the format of the exam and its questions,
providing instant
feedback regarding skill levels and gaps, and suggesting specific Sun Educational Services training to fill
those gaps.
The exam includes sample test questions, the correct answers including explanations, and suggestions
for future
42
study.This Sun ePractice exam is comprised of 48 questions.
F.5 Voucher con Retake
Sun Certified Developer for Java Web Services (CX-310-230)
Product Description
The Sun Certified Developer for Java Web Services 5 certification exam is for developers who have been
creating web
services applications using Java technology components such as those supported by the Glassfish Metro
web service
stack and the Java Enterprise Edition 5 platform. Passing this exam certifies that the candidate has
achieved a standard
level of proficiency with web services, as well as with the Java technologies that support web services. To
take the Sun
Certified Developer for Java Web Services exam, you must have already achieved the status of Sun
Certified Java
Programmer (any version).
43
Anexo G
Paquete Sun Certified Mobile Application Developer
G.1 Curso Presencial
Developing Mobile Phone Applications With J2ME Technology (DTJ-365)
The Developing Mobile Phone Applications With J2ME Technology course provides students with handson experience
with developing mobile applications on the Java 2 Platform, Micro Edition (J2ME platform) using
Connected, Limited
Device Configuration (CLDC) and the Mobile Interface Device Profile (MIDP). The course provides
information about
MIDP 1.0 and MIDP 2.0 specifications, concepts, and capabilities.
Who Can Benefit
Students who can benefit from this course are Java technology developers, designers, and architects,
who want to
develop mobile applications for the MIDP. In addition, this course will benefit architects who design
mobile technology
solutions, and Java migration technologists, who need to leverage existing code to the new platform.
Course Content
Module 1 - Overview of the J2ME Architecture
• Describe J2ME Architecture
• Run the J2ME Wireless Toolkit demonstrations
Module 2 - Building and Executing MIDP Applications
• Define the MIDP 2.0 application environment
• Define the MIDP development process
• Write and build a MIDP application (MIDlet)
• Interrogate the device to verify that it can run the new MIDlet
Module 3 - Creating a High-Level User Interface
• Describe the MIDP user interface (UI) architecture
• Describe the MIDP high-level UI API
• Describe the Display object
• Define the Item class and subclass components
• Implement high-level item event handling
• Display a message on the MIDlet screen
• Implement a user input interface
• Handle user input through item state changes
• Verify form data using a Command object
• Implement the menu system
Module 4 - Creating a Low-Level User Interface
• Describe the MIDP low-level UI API
• Describe the low-level UI event handling
• Handle pointer events
• Create and implement a splash screen using the Canvas class
• Implement a skip option on the splash screen
Module 5 - Enhanced High and Low-Level Interfaces
• Describe the CustomItem abstract class
• Describe CustomItem class event handling
44
Programa Nacional de Certificación Java & Solaris
48 © Sun Microsystems ltd, 2010
• Describe the javax.microedition.lcdui.game package
• Create a form and add CustomItem, TextBox, and Gauge objects to download a game
• Create the StarShip Battle 2004 game
Module 6 - Managing Data on the Device
• Define data persistence and the RMS package in the MIDP
• Access RecordStore objects on the device object
• Store and retrieve data in a RecordStore object
• Describe the RecordEnumeration interface
• List RecordStore objects
• Share a RecordStore object between MIDlet suites
• Implement an option screen, and save and retrieve the data in the RecordStore object
Module 7 - Accessing Network Data and Services
• Access data with the Generic Connection Framework (GCF) interface
• Exchange Data over Hypertext Transfer Protocol (HTTP)
• Use the HttpConnection interface to retrieve text for an application help screen
Module 8 - Media Control
• Describe media control in the MIDP
• Describe the Mobile Media API (MMAPI) class hierarchy and interfaces
• Add sound to the StarShip Battle 2004 game
Module 9 - MIDP Security
• Describe the MIDlet security model and define three MIDP security concerns
• Describe the MIDP Push technology
• Create a certificate
• Authenticate a MIDlet suite
• Create a MIDlet that handles static Push connections
• Create a MIDlet that handles dynamic Push connections
G.2 Curso Web
An Introduction to Mobile Java Technologies (WJB-450)
The Introduction to Mobile Java Technologies bundle provides students with an introduction to wireless
application
infrastructures and those Java technologies for use in mobile applications. The first course provides a
high-level
overview of the market for wireless technologies and an explanation of how wireless and device-based
technology work
together. Students evaluate how wireless technologies can impact a company's business model and plan
the steps to
adopt a solution. The second course provides a discussion of the Java 2 Platform, Micro Edition (J2ME
platform)
configurations, profiles, and standard extensions. Students will have an overall awareness of the J2ME
architecture and
its technological fit in mobile computing. Course materials also address how the software layers integrate
to provide a
coherent application environment as compared to other mobile frameworks.
Prerequisites
To succeed fully in these courses, students should be able to:
• Demonstrate an understanding of business strategy and its relationship
with new technologies
45
• Require an understanding of the impact of the Internet on IT and business
• Show a general understanding of large-scale technology implementations, including the architecture and
processes involved
• Display an awareness of mobile technology
• Be able to describe the principles of object oriented software technologies
• Display proficiency with software technology concepts
Skills Gained
Upon completion of this bundle, you should be able to:
• Describe the developments in wireless technologies
• Recognize a successful wireless solution
• Analyze the technologies involved in the wireless and device markets
• Evaluate the impact of wireless technologies on business models and technology environments
• Devise and plan a wireless solution that delivers tangible business value
• Describe the configurations, profiles and standard packages found in J2ME
• Illustrate a J2ME wireless architecture
G.3 Curso Web
J2ME and Mobile Phone Development Topics (WJB-460)
The J2ME and Mobile Phone Development Topics bundle provides students with a set of instruction
designed provide a
high level of advanced proficency with Java 2 Platform, Micro Edition (J2ME). The courses in this bundle
begin with
review of key Java programming language topics exception handling and thread optimization as well as
the usage of the
Abstract Windowing Toolkit (AWT). They then progress with an overview of the new features of J2ME
Wireless Toolkit
and how they support Mobile Interface Device Profile (MIDP) 2.0 development.
Who Can Benefit
Students who can benefit from this course are Java programing language developers working for
independent software
vendors, system integrators, or mobile device manufacturers, as well as enterprise information
technology personnel
involved in mobile computing projects.
Prerequisites
To succeed fully in these courses, students should be able to:
• Apply the principles of object-oriented (OO) programming
• Create or compile simple programs in a programming language, such as C or C++
• Use a text editor to create and edit text files
• Use basic UNIX and Windows text-based commands
• Use a World Wide Web (WWW) browser, such as Netscape Navigator(TM)
G.4 Simulador de Examen
ePractice Exam for the Sun Certified Mobile Application Developer for the
Java 2 Platform, Micro Edition, Version 1.0 (WGS-PREX-J110C)
The ePractice Certification Exam for the Sun Certified Mobile Application Developer for the Java 2
Platform, Micro
Edition, Version 1.0 prepares students for Sun certification by acquainting them with
46
the format of the exam and its
questions, providing instant feedback regarding skill levels and gaps, and suggesting specific Sun
Educational Services
training to fill those gaps. The exam includes sample test questions, the correct answers including
explanations, and
suggestions for future study.
This Sun ePractice exam is comprised of 210 questions, divided into three forms of 70 questions each.
G.5 Voucher con Retake
Sun Certified Mobile Application Developer for the Java Platform, Micro
Edition, Version 1.0 (CX-310-110)
The Sun Certified Mobile Application Developer for the Java Platform, Micro Edition, Version 1.0
certification exam is for
programmers and developers who are using Java 2 Platform, Micro Edition (J2ME) technologies to
develop mobile
applications for cell phones or other Java enabled devices. Passing this exam certifies that the candidate
has achieved a
standard level of proficiency with mobile Java technologies, as well as with the Java Technology for
Wireless Industry
(JTWI) specification, including the Wireless Messaging application programming interface (API) and
Mobile Media APIs.
To take the Sun Certified Mobile Application Developer exam, you must have already achieved the status
of Sun
Certified Programmer for the Java 2 Platform.
47
Anexo H
H.1 MySQL for Beginners (SQL-4401)
This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using
MySQL as a
teaching tool.
At completion of this course, you should be able to:
• Understand the features and benefits of MySQL
• Be able to find information about products, support and training
• Be able to install and start the MySQL server
• Understand the basics of Relational Databases
• Understand the SQL and MySQL languages
• Understand Data/Column types with regard to efficient database design
• Be able to view a database design structure/content
• Create a database design using an efficient structure
• Be able to extract basic database information using the SELECT command
• Be able to troubleshoot syntax and understand typical warnings and errors
• Be able to delete or modify a database
• Be able to delete or modify table row data
• Grouping query data with Aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use of Simple Functions (String, Date, Numerical)
• Understand the primary methods for exporting and importing data
• Describe MySQL connectors, their major features and differences.
• Understand MySQL storage engines, transactions and features of the common engines
Products Covered
MySQL 5.0, command-line and graphical clients/tools.
Who Should Attend
New or existing users of MySQL, who have little or no previous experience with a relational database
management system. Both new MySQL Developers and Database Administrators will benefit from this
class.
Prerequisites
Basic computer literacy is required. Previous experience with any command-line program (such as MSDOS) is
beneficial. Some knowledge of database concepts would be very helpful but is not necessary. If you have
previous database experience, we recommend you compile a set of questions before the course. This will
ensure
you get the most out of your time with the instructor.
H.2 Voucher con Retake
Sun Certified MySQL Associate (CX-310-814)
Descripción The Sun Certified MySQL Associate certification (SCMA) is an entry level certification. It is
intended for
those that are relatively new to using the MySQL database server and covers basic database
management system
concepts as well as basic SQL. We recommend the SCMA certification for MySQL users that know the
basics, but have
not yet obtained the experience gained by professional MySQL DBAs or
48
Developers.
Details
• Delivered at: Authorized Prometric Testing Centers
• Prerequisites: None
• Other exams/assignments required for this certification:
• Exam type: Multiple choice
• Number of questions: 50
• Pass score: 60%
• Time limit: 60 minutes
Pre-requisitos Ninguno
Theory, Terminology and Concepts (10%)
• Client/Server Concepts
• Database and Database Objects
Data Definition using SQL (25%)
• Databases
• Data Types
• Tables
• Constraints and Indexes
• Views
Basic Data Manipulation using SQL (25%)
• Recurring SQL Constructs
• Adding data
• Modifying data
• Removing data
• Searching data
Advanced Data Manipulation using SQL (20%)
• Expressions
• Grouping and Aggregate Functions
• Joining Tables
Transactions (10%)
• Transaction Concepts
• SQL for working with Transaction
Import/Export (10%)
• Tools for Import/Export
• SQL for Import/Export
49
Anexo I
9) KIT ORACLE CERTIFIED ASSOCIATED
Oracle Database 11g: Introduction to SQL Release 2
Lo que aprenderá
In this course students learn the concepts of relational databases. This course provides the essential SQL
skills that allow developers to write queries against single and multiple tables, manipulate data in tables,
and create database objects. Students learn to control privileges at the object and system level.
This course covers creating indexes and constraints, and altering existing schema objects. Students also
learn how to create and query external tables. Students learn to use the advanced features of SQL in
order to query and manipulate data within the database, use the dictionary views to retrieve metadata and
create reports about their schema objects.
Students also learn some of the date-time functions available in the Oracle Database. This course
discusses how to use the regular expression support in SQL.
This course is a combination of Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g:
SQL Fundamentals II courses.
In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is available
as an optional development tool.
This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
Learn To:Create reports of sorted and restricted dataRun data manipulation statements (DML) to update
dataControl database access to specific objectsManage schema objectsManage objects with data
dictionary views Retrieve row and column data from tables
Audiencia
Application Developers
Business Analysts
Data Warehouse Administrator
Developer
Forms Developer
PL/SQL Developer
System Analysts
Prerequisitos
Prerequisitos Requeridos
Familiarity with data processing concepts and techniques
Data processing
Objetivos Del Curso
Employ SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Identify the major structural components of the Oracle Database 11g
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables with the SELECT statement
Run data manipulation statements (DML) to update data in the Oracle Database 11g
Create tables to store data
Utilize views to display and retrieve data
Control database access to specific objects
Manage schema objects
Manage objects with data dictionary views
Write multiple-column sub-queries
Use scalar and correlated sub-queries
Use the regular expression support in SQL
Create reports of sorted and restricted data
Temas Del Curso
Introducing Oracle Database 11g
50
List the features of Oracle Database 11g
Discuss the basic design, theoretical and physical aspects of a relational database
Categorize the different types of SQL statements
Describe the data set used by the course
Log onto the database using the SQL Developer environment
Save queries to files and use script files in SQL Developer
Retrieving Data Using the SQL SELECT Statement
List the capabilities of SQL SELECT statements
Generate a report of data from the output of a basic SELECT statement
Select All Columns
Select Specific Columns
Use Column Heading Defaults
Use Arithmetic Operators
Understand Operator Precedence
Learn the DESCRIBE command to display the table structure
Restricting and Sorting Data
Write queries that contain a WHERE clause to limit the output retrieved
List the comparison operators and logical operators that are used in a WHERE clause
Describe the rules of precedence for comparison and logical operators
Use character string literals in the WHERE clause
Write queries that contain an ORDER BY clause sort the output of a SELECT statement
Sort output in descending and ascending order
Using Single-Row Functions to Customize Output
Describe the differences between single row and multiple row functions
Manipulate strings with character function in the SELECT and WHERE clauses
Manipulate numbers with the ROUND, TRUNC and MOD functions
Perform arithmetic with date data
Manipulate dates with the date functions
Using Conversion Functions and Conditional Expressions
Describe implicit and explicit data type conversion
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Nest multiple functions
Apply the NVL, NULLIF, and COALESCE functions to data
Use conditional IF THEN ELSE logic in a SELECT statement
Reporting Aggregated Data Using the Group Functions
Use the aggregation functions in SELECT statements to produce meaningful reports
Create queries that divide the data in groups by using the GROUP BY clause
Create queries that exclude groups of date by using the HAVING clause
Displaying Data From Multiple Tables Using Joins
Write SELECT statements to access data from more than one table
View data that generally does not meet a join condition by using outer joins
Join a table by using a self join
Using Sub-queries to Solve Queries
Describe the types of problem that sub-queries can solve
Define sub-queries
List the types of sub-queries
Write single-row and multiple-row sub-queries
Using the SET Operators
Describe the SET operators
Use a SET operator to combine multiple queries into a single query
Control the order of rows returned when using the SET operators
Manipulating Data
Describe each DML statement
Insert rows into a table with the INSERT statement
Use the UPDATE statement to change rows in a table
Delete rows from a table with the DELETE statement
51
Save and discard changes with the COMMIT and ROLLBACK statements
Explain read consistency
Using DDL Statements to Create and Manage Tables
Categorize the main database objects
Review the table structure
List the data types available for columns
Create a simple table
Decipher how constraints can be created at table creation
Describe how schema objects work
Creating Other Schema Objects
Create a simple and complex view
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
Controlling User Access
Differentiate system privileges from object privileges
Creating Users
Granting System Privileges
Creating and Granting Privileges to a Role
Changing Your Password
Granting Object Privileges
Passing On Your Privileges
Revoking Object Privileges
Managing Schema Objects
Adding, Modifying and Dropping a Column
Adding, Dropping and Deferring a Constraint
Enabling and Disabling a Constraint
Creating and Removing Indexes
Creating a Function-Based Index
Performing Flashback Operations
Creating an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
Querying External Tables
Managing Objects with Data Dictionary Views
Explain the data dictionary
Using the Dictionary Views
USER_OBJECTS and ALL_OBJECTS Views
Table and Column Information
Querying the dictionary views for constraint information
Querying the dictionary views for view, sequence, index and synonym information
Adding a comment to a table
Querying the dictionary views for comment information
Manipulating Large Data Sets
Using Subqueries to Manipulate Data
Retrieving Data Using a Subquery as Source
Inserting Using a Subquery as a Target
Using the WITH CHECK OPTION Keyword on DML Statements
Types of Multitable INSERT Statements
Using Multitable INSERT Statements
Merging rows in a table
Tracking Changes in Data over a period of time
Managing Data in Different Time Zones
Time Zones
CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
Comparing Date and Time in a Session’s Time Zone
DBTIMEZONE and SESSIONTIMEZONE
52
Difference between DATE and TIMESTAMP
INTERVAL Data Types
Using EXTRACT, TZ_OFFSET and FROM_TZ
Using TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL
Retrieving Data Using Sub-queries
Multiple-Column Subqueries
Pairwise and Nonpairwise Comparison
Using Scalar Subquery Expressions
Solving problems with Correlated Subqueries
Updating and Deleting Rows Using Correlated Subqueries
Using the EXISTS and NOT EXISTS operators
Using the WITH clause
Using the Recursive WITH clause
Regular Expression Support
Using the Regular Expressions Functions and Conditions in SQL
Using Meta Characters with Regular Expressions
Performing a Basic Search using the REGEXP_LIKE function
Finding patterns using the REGEXP_INSTR function
Extracting Substrings using the REGEXP_SUBSTR function
Replacing Patterns Using the REGEXP_REPLACE function
Using Sub-Expressions with Regular Expression Support
Using the REGEXP_COUNT function
ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I
This course is designed to give students a firm foundation in basic administration of Oracle Database
11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a
conceptual understanding of the Oracle database architecture and how its components work and interact
with one another. Students learn how to create an operational database and properly manage the various
structures in an effective and efficient manner including performance monitoring, database security, user
management, and backup/recovery techniques. The lesson topics are reinforced with structured handson practices.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator
Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the
Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet
the Hands-on Requirement.
Learn To:
•
•
•
•
Manage users
Manage storage structures
Backup and Recovery
Install and configure an Oracle database
Prerrequisitos:
Prerrequisitos requeridos:
•
Working knowledge of SQL
Prerrequisitos sugeridos:
•
Oracle Database 11g: Introduction to SQL
53
Objetivos del curso:
•
•
•
•
•
•
•
•
•
•
•
•
Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor
Contenido del curso:
Exploring the Oracle Database Architecture
•
•
•
•
•
•
•
•
Oracle Database Architecture Overview
Interacting with an Oracle Database
Process Architecture
Database Storage Architecture
Logical and Physical Database Structures
Tablespaces and Data Files
SYSTEM and SYSAUX Tablespaces
Segments, Extents, and Blocks
Preparing the Database Environment
•
•
•
•
•
•
•
•
Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database
Installation: System Requirements
Optimal Flexible Architecture (OFA)
Setting Environment Variables
Oracle Universal Installer (OUI)
Database Configuration Options
Advanced Installation Options
Creating an Oracle Database
•
•
•
•
•
•
•
Planning the Database
Configuring the Listener
Using the DBCA to Create a Database
Password Management
Creating a Database Design Template
Using the DBCA to Delete a Database
Using DBCA For Additional Tasks
Managing the Oracle Instance
•
Management Framework
54
•
•
•
•
•
•
•
Oracle Enterprise Manager
Initialization Parameter
Database Startup and Shutdown
Shutdown Modes
Viewing the Alert History
Using Trace Files
Data Dictionary: Overview
Configuring the Oracle Network Environment
•
•
•
•
•
•
•
•
Oracle Net Services & Listener
Establishing Net Connections
Tools for Configuring and Managing the Oracle Network
Net Services Administration Pages
Naming Methods
Directory Naming
SGA and PGA
When Not to Use a Shared Server
Managing Database Storage Structures
•
•
•
•
•
•
•
•
Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Space Management in Tablespaces
Tablespaces in the Preconfigured Database
Actions with Tablespaces
Oracle Managed Files (OMF)
ASM: Concepts
Administering User Security
•
•
•
•
•
•
•
Database User Accounts
Predefined Accounts: SYS and SYSTEM
Administrator Authentication
Benefits of Roles
Predefined Roles
Implementing Password Security Features
Assigning Quota to Users
Managing Schema Objects
•
•
•
•
•
•
•
•
What Is a Schema?
Accessing Schema Objects
Specifying Data Types in Tables
Creating and Modifying Tables
Understanding Data Integrity
Indexes & Views
Sequences
Temporary Tables
Managing Data and Concurrency
55
•
•
•
•
•
•
•
•
Manipulating Data Through SQL
PL/SQL
Administering PL/SQL Objects
Functions, Procedures, Packages & Triggers
Data Concurrency
Enqueue Mechanism
Resolving Lock Conflicts Using SQL
Deadlocks
Managing Undo Data
•
•
•
•
•
•
•
Data Manipulation
Transactions and Undo Data
Undo Data Versus Redo Data
Configuring Undo Retention
Guaranteeing Undo Retention
Using the Undo Advisor
Viewing System Activity
Implementing Oracle Database Security
•
•
•
•
•
•
•
•
Industry Security Requirements
Principle of Least Privilege
Monitoring for Compliance
Value-Based Auditing
Fine-Grained Auditing
DBA Auditing
Security Updates
Applying Security Patches
Database Maintenance
•
•
•
•
•
•
•
•
Introducing Terminology
Optimizer Statistics
Automatic Workload Repository (AWR)
Automatic Database Diagnostic Monitor (ADDM)
Advisory Framework
Automated Maintenance Tasks
Server-Generated Alerts
Reacting to Alerts
Performance Management
•
•
•
•
•
•
•
Performance Monitoring
Managing Memory Components
Enabling Automatic Memory Management (AMM)
Automatic Shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
56
•
Invalid and Unusable Objects
Backup and Recovery Concepts
•
•
•
•
•
•
•
•
Part of Your Job
Statement Failure
User Error
Understanding Instance Recovery
Phases of Instance Recovery
Using the MTTR Advisor
Media Failure
Archive Log Files
Performing Database Backups
•
•
•
•
•
•
•
•
Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configuring Backup Settings
Backing Up the Control File to a Trace File
Monitoring the Flash Recovery Area
Performing Database Recovery
•
•
•
•
•
•
•
•
Opening a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Recovery Advisor
Data Failures
Listing Data Failures
Data Recovery Advisor Views
Moving Data
•
•
•
•
•
•
•
Moving Data: General Architecture
Directory Object: Overview
SQL*Loader: Overview
Data Pump: Overview
Performance Initialization Parameters
Using Enterprise Manager to Monitor Data Pump Jobs
Data Dictionary
Enhancing Database Capabilities
•
•
•
•
Using EM Support Workbench
Create a Service Request
Package and upload diagnostic data to Oracle Support
Track the SR and Implement Repairs
57
•
•
•
•
Incident Packaging Configuration
Working with Oracle Support
MetaLink Integration
Managing Patches
58