PROGRAMA DE ESTUDIO
ESPECIALIZACION
I.- GENERALIDADESCurso de especialización:
ESPECIALIZACION EN BASE DE DATOS Y DESARROLLO EN APLICACIONES ABIERTAS
Código Duración del curso de especialización
10 Meses Nº de horas 280 Identificación del ciclo 01-2009 Horas teóricas 40 Carrera
Horas practicas 240
II. DESCRIPCION DEL CURSO ESPECIALIZADO
Este cursos se encuentra integrado por 5 módulos para el desarrollo del cursos de especialización en base de datos y desarrollo de en aplicaciones abiertas, para lo cual se les brindara a los egresados todos los conocimientos necesarios que los preparen para poder certificar sus habilidades en herramientas de administración de base de datos y desarrollo de aplicaciones abiertas.
III. OBJETIVO GENERAL
Que el egresado obtenga los conocimientos necesarios para poder certificarse en el uso de tecnologías de base de datos y programación de aplicaciones abiertas.
IV. MODULOS DE ESTUDIO
MODULO I. PHP PROGRAMMING OBJETIVO
Proveer a los estudiantes el conocimiento necesario para poder desarrollar aplicaciones web activas del lado del servidor haciendo uso de PHP como lenguaje de desarrollo, Apache como servidor WEB y MYSQL como gestor de Datos, puntualmente el curso pretende mostrar la forma de crear páginas dinámicas con PHP, aprender a escribir funciones en PHP, manipular y manejar datos de la base de datos con PHP, manejar sesiones con PHP, validar entrada de datos utilizando expresiones regulares, conocer la sintaxis básica de PHP, manipular archivos con PHP, SQL básico, autenticar a los usuarios con PHP,
enviar correo electrónico con PHP, usar las características OOP de PHP, así como el manipulación de errores en PHP.
Outline:
1. PHP Basics
1.1. PHP Syntax
1.2. Passing Values Via the URL 1.3. HTML Forms and PHP Variables 1.4. Identifiers and Constants
1.5. Variable Scope 1.6. Magic Quotes 1.7. Operators Flow Control 1.8. If Conditions 1.9. Switch Statements 1.10. Loops
Getting the Most out of php.net
2. Reading and Writing to Files in PHP
2.1. Opening a File 2.2. Reading from a File 2.3. Writing to a File 2.4. Other File Functions 2.5. File Locking
3. Using Arrays in PHP
3.1. Standard Arrays 3.2. Associative Arrays 3.3. Two-dimensional Arrays 3.4. Array Manipulation Functions
4. String Manipulation in PHP
4.1. Formatting Strings 4.2. String Functions 4.3. Basic Form Validation
5. Reusing Code and Writing Functions in PHP
5.1. Including Files
5.2. Writing User-defined Functions
5.3. Passing by Value vs. Passing by Reference 5.4. Returning Values from Functions
6. A Quick Intro to / Review of SQL
6.1. SELECT Statements 6.2. INSERT Statements 6.3. UPDATE Statements 6.4. DELETE Statements
7. Database Manipulation and PHP
7.1. Querying a Database and Displaying Results 7.2. Inserting Records
7.3. Updating Records 7.4. Deleting Records
8. Authentication with PHP and SQL
8.1. PHP Native Database Functions 8.2. PEAR:DB as an Abstraction Layer 8.3. Encrypting Passwords
9. Session Control in PHP
9.1. Starting Sessions 9.2. Continuing Sessions 9.3. Ending Sessions
9.4. Writing and Deleting Cookies 9.5. Improving Login/Logout
10. Sending Email with PHP
10.1. The Built-in mail Function 10.2. PHPMailer
11. File System Management
11.1. Uploading Files via an HTML Form 11.2. Getting File Information
11.3. Additional File Functions 11.4. Directory Functions
12. Object-Oriented PHP Development
12.1. Classes and Objects in PHP
12.2. Constructors and Destructors in PHP 12.3. Methods and Properties
12.4. The this Variable 12.5. Constants
12.6. Exception Handling
13. Advanced Form Validation with Regular Expressions
13.1. Perl-compatible Regular Expression Functions 13.2. Regular Expressions Special Characters 13.3. Review of Basic Form Validation
13.4. Form Validation with Regular Expressions
14. Error Handling
14.1. Types of Errors 14.2. Catching Errors
15. XML and PHP
15.1. XML Basics
15.2. Parsing XML with SAX 15.3. Parsing XML with DOM 15.4. Converting XML with XSLT
16. Common PEAR Packages
16.1. Creating PDFs with PEAR and PHP 16.2. Authentication with PEAR and PHP 16.3. Handling Forms with PEAR and PHP 16.4. PEAR Templates
MODULO II. JAVA2 PROGRAMMING LANGUAGE OBJETIVO
Que el estudiante conozca conceptos de programación avanzada de aplicaciones JAVA y que sea capaz de crear, compilar y ejecutar una aplicación JAVA, controlar el flujo de un programa, trabajar con las librerías de clases de JAVA, crear clases, programar con objetos, manejar excepciones, crear Threads, usar colecciones y desarrollar interfaces de usuario.
Outline:
1. Creating, Compiling, and Running a Simple Java Application
1.1. Compile and Run a Simple Application 1.2. Create a Simple Class
1.3. Create and Initialize Variables 1.4. Write an Expression
1.5. Create and Initialize an Array 1.6. Access Array Data
2. Controlling Program Flow
2.1. Write If Statements 2.2. Write a For Loop
2.3. Write While and Do...While Loops 2.4. Break Out of a Loop
2.5. Write a Switch Statement
2.6. Write a Conditional Operator Statement
3. Working with the Java Class Libraries
3.1. Create a New Object from a Java Class Library 3.2. Call Methods
3.3. Cast and Convert Primitives and Objects 3.4. Compare Objects
3.5. Determine the Class of an Object
4. Creating Classes
4.1. Define Methods 4.2. Overload a Method 4.3. Define Constructors
4.4. Create Static Class Members 4.5. Use Command-Line Arguments
5. Programming with Objects 5.1. Import a Class 5.2. Extend a Class 5.3. Override Methods 5.4. Create Interfaces 5.5. Implement Interfaces 5.6. Create Inner Classes
6. Handling Exceptions
6.1. Handle Exceptions
6.2. Write a Method to Throw a Checked Exception 6.3. Write and Enable Assertions
7. Creating Threads
7.1. Create Threads by Extending the Thread Class
7.2. Create Threads by Implementing the Runnable Interface 7.3. Synchronize Threads
8. Using Collections
8.1. Store Data in a Set 8.2. Retrieve Data from a Set 8.3. Store Data in a List 8.4. Retrieve Data from a List 8.5. Store Data in a Map 8.6. Retrieve Data from a Map
9. Developing GUIs
9.1. Create a Container Using Swing 9.2. Create Swing Components 9.3. Apply Layout Managers 9.4. Handle Mouse Events 9.5. Handle Key Events
MODULO III. JAVA2 ADVANCE PROGRAMMING OBJETIVO
Que el estudiante conozca conceptos de programación avanzada de aplicaciones JAVA y que sea capaz de manejar excepciones, estructuras de datos, entradas y salidas del sistema, programación en Multi-Threaded, conectividad de JDBC y configuración básica de sockets con JAVA.
Outline:
1. Examination Concepts
1.1. Determining an Object's Type 1.2. Reflection
2. Exception Handling
2.1. Overview of Exceptions 2.2. Writing Exception Handlers
3. Data Structures
3.1. Arrays 3.2. Collections
3.3. Other Data Structures
4. Input/Output
4.1. Overview of the java.io Package 4.2. Reading Files
4.3. Writing Files
4.4. Reading and Writing Objects
5. Multi-Threaded Programming 5.1. Overview of Threads 5.2. Using Threads 5.3. Synchronization 6. JDBC 6.1. Overview of SQL 6.2. Using JDBC 7. Basic Networking 7.1. Overview of Networking 7.2. Sockets 7.3. Datagram Sockets
MODULO IV. ORACLE DATABASE 10G ADMINISTRATION 1 OBJETIVO
Que el estudiante ejecute tareas administrativas en bases de datos Oracle 10g, tales como: Crear y administrar una base de datos, crear y administrar los usuarios, implementar características de seguridad, monitorear el rendimiento de la base de datos y ejecutar respaldo y recuperaciones de respaldos de la base de datos.
Outline:
1. Installing Oracle Database 10g
1.1. Install Oracle Database 10g
2. Exploring the Oracle Database 10g Architecture
2.1. Understand Database Architecture 2.2. Identify Database Object Types 2.3. Recognize the Oracle Instance
2.4. Understand the User Connection Process 2.5. Identify Resources for the DBA
3. Creating a Database
3.1. Create, Configure, and Delete a Database Using the DBCA 3.2. Use Client and Administration Tools
4. Configuring Oracle Net Services
4.1. Examine Oracle Net Services
4.2. Perform Basic Oracle Net Server-Side Configuration 4.3. Perform Basic Oracle Net Client-Side Configuration 4.4. Configure Oracle Shared Server
4.5. Configure Connect-Time Failover
5. Using SQL and PL/SQL
5.1. Write Simple SQL SELECT Statements 5.2. Filter and Sort Data
5.3. Work with SQL Functions 5.4. Work with Multiple Tables 5.5. Modify Data
5.6. Control Database Transactions 5.7. Explore PL/SQL
6. Managing the Database Instance
6.1. Obtain Instance Information 6.2. Manage the Database Instance 6.3. Organize Database Objects
6.4. Describe Database Objects and Their Storage
7. Managing Tablespaces and Datafiles
7.1. Manage Tablespaces
7.2. Find Tablespace and Datafile Information 7.3. Resize and Drop Tablespaces
7.4. Configure Oracle Managed Files
8. Managing Tables and Indexes
8.1. Create Tables
8.2. Gather and Analyze Table Information 8.3. Create Indexes
8.4. Implement Integrity Constraints 8.5. Maintain Integrity Constraints
9. Creating Views and Sequences
9.1. Create Views
9.2. Create Sequences Top
10. Managing Users and Security
10.1. Manage Users
10.2. Manage Privileges and Roles
10.3. Manage Passwords and Resource Limits 10.4. Audit Database Usage
11. Monitoring Performance
11.1. Manage Locks
11.2. Gather and Use Tuning and Troubleshooting Information
12. Loading and Unloading Data
12.1. Manage Data Using the Data Pump 12.2. Move Tablespaces
12.3. Load Data Using SQL*Loader 12.4. Create and Access External Tables
13. Managing Undo Data
13.1. Configure Undo Segments and Tablespaces 13.2. Understand Automatic Undo Retention
14. Administering and Performing Backups
14.1. Create Redo Log Groups and Members
14.2. Plan and Configure the Online Redo Log Group 14.3. Manage and Maintain Control Files
14.4. Back Up the Database
14.5. Examine Recovery Manager Concepts
15. Administering and Performing Recovery Operations
15.1. Manage Recovery
15.2. Employ User-Managed and RMAN Recovery 15.3. Tune Database Recovery
MODULO V. ORACLE 10G ADMINISTRATION 2 OBJETIVO
Que el estudiante desarrolle y comprenda conceptos complejos de base de datos Oracle 10g como: rutinas de mantenimiento y recuperación y, además, administración de la base de datos. El estudiante deberá aprender como tener control y manejo de una base de datos instalada, así como el manejo del rendimiento de una base de datos.
Outline:
1. Monitoring the Database
1.1. Diagnose Issues Using Trace Files and the Alert Log 1.2. Adjust Thresholds for Tracked Metrics
1.3. Secure the Listener
2. Monitoring and Managing Memory
2.1. Manually Configure SGA Parameters for Various Memory Components 2.2. Using Automatic Shared Memory Management
3. Monitoring and Managing Database Performance
3.1. Improve Database Performance Using the SQL Tuning Advisor 3.2. Manage Resources
3.3. Tune Redo Log and Archive Log Operations
4. Monitoring and Managing Storage
4.1. Manage Tablespace Usage
4.2. Reclaim Wasted Space from Tables and Indexes 4.3. Estimate the Size of New Tables and Indexes
4.4. Improve Query Performance Using Different Storage Options 4.5. Rebuild Indexes Online
5. Restoring Data With Oracle Flashback
5.1. Recovering Data Using Flashback Technology
5.2. Flashback the Database Using the OEM Recovery Wizard 5.3. Maintaining the Flash Recovery Area
5.4. Using Automatic Undo Retention Tuning
6. Backing Up and Recovering Data
6.1. Recover Tablespaces and the Password File 6.2. Perform Incomplete Recoveries
6.3. Perform Database Recovery Through a RESETLOGS Operation 6.4. Detect Database Corruption
7. Configuring the Recovery Manager (RMAN)
7.1. Recovery Manager
7.2. Configure the RMAN Environment
8. Performing RMAN Backups
8.1. Create RMAN Image Copies 8.2. Conduct RMAN Online Backups
8.3. Conduct RMAN Incremental Online Backups 8.4. Back Up Archive Logs
8.5. Manage RMAN Backups
9. Performing RMAN Recoveries
9.1. Perform an RMAN Complete Recovery 9.2. Perform an RMAN Incomplete Recovery 9.3. Repair Block Corruptions Using RMAN
10. Utilizing Automatic Storage Management (ASM)
10.1. Automatic Storage Management
10.2. Set up Initialization Parameters and Start an ASM Instance 10.3. Administer ASM Disk Groups
10.4. Migrate Your Database to ASM Using RMAN
11. Automating Tasks with the Scheduler
11.1. Simplify Management Tasks by Using the Scheduler 11.2. Reuse Scheduler Components for Similar Tasks
12. Using Globalization Support Objectives
12.1. Obtain Globalization Support Configuration Information 12.2. Customize Language-Dependent Behavior
12.3. Specify Different Linguistic Sorts for Queries 12.4. Use Datetime Datatypes
12.5. Query Data Using Case-Insensitive and Accent-Insensitive Sorting
VI. EVALUACION
Los participantes de la especialización se someterán a una evaluación por cada módulo que consistirá en un test de batería que evalúe todos los niveles del conocimiento (cognoscitivo, afectivo y psicomotor).
VII. ESTRATEGIAS METODOLOGICAS
Clases prácticas, discusiones, ejemplos y estudios de casos.
VIII. BIBLIOGRAFIA
Java 2 Programming Language
Java 2 advanced Programming
PHP Programming
Oracle database 10g administration1
Orcale database 10g administration 2
APROBADO POR: _________________________ Firma y Sello de Secretaria General