Orden Tecnologia Nivel Duracion Status link10 PL SQL Principiante 210 Pendiente20 Apex Principiante 164 Pendiente30 Html,Ajax Principiante 120 Pendiente40 Useful Tools Principiante 0 Pendiente45 Useful Links Principiante 0 Pendiente50 PL SQL Medio 210 Pendiente60 Apex Medio 900 Pendiente70 Tunning Principiante 15 Pendiente80 Html,Ajax Medio 0 Pendiente90 PL SQL Avanzado 580 Pendiente

100 Apex Avanzado 1080 Pendiente110 Html,Ajax Avanzado 0 Pendiente120 Tunning Avanzado 120 Pendiente

Click HereClick HereClick HereClick HereClick HereClick HereClick HereClick HereClick HereClick HereClick HereClick HereClick Here

ID Categoria1.02 Guias o Libros1.03 Best Practices1.04 Best Practices1.05 Best Practices1.06 Guias o Libros1.07 Guias o Libros1.08 Triggers1.09 Usefull Functions

1.1 Usefull Functions1.11 Usefull Functions

1.12 Guias o Libros2.01 Best Practices2.02 Best Practices2.03 Best Practices2.04 Best Practices

3.01 10g/11g3.02 10g/11g3.03 Best Practices3.04 Best Practices3.05 Best Practices3.06 Best Practices3.07 Usefull Functions3.08 Usefull Functions3.09 Usefull Functions

Return to Path - Index

Titulo LinkOracle® Database ConceptsBest practices for changing headers and handling different WHERE clauses Cursor best practices

PL/SQL Packages and Types Reference PL/SQL User's Guide and Reference http://download.o

Building with BlocksBULK COLLECTnvl2(),NULLIF,COALESCE,CASE,

Best practices for invoker rights and functions Best practices for where, when, and how to handle exceptions Common Mistakes in Oracle PL/SQL ProgrammingPL/SQL Best Practices with Steven Feuerstein

What’s New in PL/SQL in Oracle Database 10g

Best Practices for Retrieving ObjectsBest practices—and preparation—for PL/SQL in Oracle Database 11g Doing sql from plsqlSecurity - How to avoid sql injectionConditional compilationPL/SQL Utility - Who called me?Zoom In on Your Code

http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::NO::P4_QA_ID:15524

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::::P4_QA_ID:242The Right Place for PL/SQL http://www.oracle.com/technetwork/issue-archive/2007/07-jan/o17plsql-086256.html

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/toc.htm

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm

http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21plsql-242570.htmlhttp://www.oracle.com/technetwork/issue-archive/2008/08-mar/o28plsql-095155.html

Oracle® Database Advanced Application Developer's Guide11g Release 2 (11.2) http://download.oracle.com/docs/cd/E11882_01/appdev.112/e17125/toc.htm

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::NO::P4_QA_ID:12502

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::NO::P4_QA_ID:15522

http://www.youtube.com/watch?v=ecNP8KBX_sc

http://www.youtube.com/watch?v=nLZlR3nSrsc

http://www.oracle.com/technetwork/database/features/plsql/new-in-10gr1-096989.htmlhttp://www.oracle.com/technetwork/database/features/plsql/overview/plsql-new-in-11gr1-128133.pdf

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::NO::P4_QA_ID:9762

http://apex.oracle.com/pls/otn/f?p=2853:4:1772405143489639::NO::P4_QA_ID:13582

http://www.oracle.com/technetwork/database/features/plsql/overview/doing-sql-from-plsql-129775.pdf

http://www.oracle.com/technetwork/database/features/plsql/overview/how-to-write-injection-proof-plsql-1-129572.pdfhttp://www.oracle.com/technetwork/database/features/plsql/overview/plsql-conditional-compilation-133587.pdf

https://www.samplecode.oracle.com/tracker/tracking/linkid/prpl1004?sfLoginToken=A5F32F431CAE66AFD17D8E0BC3A1882C&sfProj=codesamples&isLoggedIn=true&sfLoginToken=0145D84A149A3A4F1BDA871B8E0431E7&sfProj=codesamples&isLoggedIn=true&sfLoginToken=C0BB163B937E52DCFD5FE8106D2BE097&sfProj=codesamples&jSessionId=9F68AACCE4D633556C4BD063D0733039&isLoggedIn=false&id=S476&dapCheckedPassed=false&dapCheckedPassed=false

http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o50plsql-165471.html

Return to Path - Index

Formato Duracion (min) Nivel Status ObservacionesManual Web 90 Principiante Pendiente Capitulos 1 a 12Nota 15 Principiante PendienteNota 15 Principiante Pendiente no andaHtml 15 Principiante PendienteNota 0 Principiante Pendiente ReferenciaNota 0 Principiante Pendiente ReferenciaNota 30 Principiante PendienteNota 30 Principiante PendienteNota 15 Principiante PendienteNota Principiante PendienteManual Web 60 Medio Pendiente Capitulos 1 a 9Nota 15 Medio PendienteNota 15 Medio PendienteVideo 60 Medio PendienteVideo 60 Medio Pendiente

Nota 20 Avanzado PendienteNota 15 Avanzado Pendiente 14 PaginasNota 15 Avanzado PendienteNota 15 Avanzado Pendiente Base 11gPdf 140 Avanzado Pendiente 74 paginasHow To 120 Avanzado Pendiente 62 paginasPdf 180 Avanzado Pendiente 91 paginasNota 15 Avanzado PendienteNota 60 Avanzado Pendiente

16.666666666667 Hs 11

Utl_Mail,Utl_Compress,Dbms_Warning

ID Categoria Titulo Link Formato1.1 On Tuning, Planning, and Contexts Nota1.2 Database 2 Day + Performance Tuning Guide Manual Web

http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21asktom-312223.html

http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/toc.htm

Return to Path - Index

Duracion (min) Nivel Status Observaciones15 Principiante Pendiente TECHNOLOGY: Ask Tom

120 Avanzado Pendiente2.25 Hs

ID Categoria Titulo1.01 Guias o Libros 2 Day Developer - HTML1.02 Guias o Libros 2 Day Developer -PDF1.03 Sitio Web Importante1.04 Training Creating reports and Forms1.05 Training Create Interactive Reports1.06 Training Create Tabular Form1.07 Training Create a Form and a Report 1.08 Training Add Security1.09 Training Create Reports Dynamic Layout

1.1 Training Create PDF Report1.11 Training Upload Files2.01 Training Apex 4 new features2.02 Training2.03 Training2.04 Apex2.05 Documentacion o Tutorial2.06 Documentacion o Tutorial2.07 Documentacion o Tutorial2.08 Training2.09 Guias o Libros API Reference

3.01 PlugIn3.02 PlugIn3.03 PlugIn3.04 PlugIn3.05 PlugIn3.06 Training3.07 Guias o Libros Administration Guide3.08 Guias o Libros Application Builder User’s Guide3.09 Guias o Libros SQL Workshop Guide

Trainings

Return to Path - Index

Link Formato Duracion (min) Nivel Statushtml 32 Principiantepdf 32 Principiante 0 Principiante 5 Principiante 5 Principiante 5 Principiante 5 Principiante 40 Principiante 15 Principiante 15 Principiante 10 Principiante 60 Medio 60 Medio 60 Medio 120 Medio 120 Medio 120 Medio 120 Medio 120 Medio 120 Medio 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado 120 Avanzado

35.733333333333 Hs

2 Day + Developer's Guide => http://download.oracle.com/docs/cd/E17556_01/doc/appdev.40/e15516/toc.htm

http://download.oracle.com/docs/cd/E17556_01/doc/appdev.40/e15516.pdfForo de Oracle para APEX => http://forums.oracle.com/forums/forum.jspa?forumID=137

1. Creating Reports and Forms to an APEX 4.0 Application2. Creating an Interactive Report (APEX 4.0)3. Creating a Tabular Form (APEX 4.0)4. Creating a Form on a Table with a Report (APEX 4.0)5. Adding Security to your Database Application (APEX 4.0) (40 min)6. Creating Reports With Dynamic Layout Selection (APEX 3.1) (15 min)7. Creating a PDF Report with Multiple Queries (APEX 3.1) (15 min)8. Upload and Download Files in an Application

9. Apex 4.0 new Features http://apex.oracle.com/pls/otn/f?p=34738:1:0

10. Use dynamic actions in Oracle Application Express 4.0 to define interactive client-side behavior. http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60browser-176257.html

11. Oracle Application Express 4.0 Websheets enable end users to integrate, share, and maintain content. http://www.oracle.com/technetwork/issue-archive/2010/10-sep/o50browser-165475.html

OBE ( Oracle By Example ) => http://apex.oracle.com/pls/apex/f?p=44785:2:7312014786300733:FORCE_QUERY::2,CIR,RIR:P2_TAGS:AJAXDocumentacion y Tutoriales http://www.oracle.com/technetwork/developer-tools/apex/documentation/index.html?

SQL Workshop Guide => http://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15520/toc.htm

API Reference => http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519/toc.htm

Packaged Applications (Pueden bajarse o verse online)

http://download.oracle.com/docs/cd/E17556_01/doc/apirefs.40/e15519.pdfhttp://apex.oracle.com/pls/otn/f?p=34738:29:0::NO:::

Use plug-ins with Oracle Application Express 4.0 to add custom components. http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11browser-195100.html

http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-plug-ins-182042.htmlhttp://www.apex-plugin.com/http://skillbuilders.com/oracle-apex/Application-Express-APEX-Consulting-Training.cfm?tab=plug-inshttp://www.oracle.com/technetwork/developer-tools/apex/application-express/packaged-apps-090453.html

http://download.oracle.com/docs/cd/E17556_01/doc/admin.40/e15521.pdfhttp://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15517.pdfhttp://download.oracle.com/docs/cd/E17556_01/doc/user.40/e15520.pdf

http://skillbuilders.com/oracle-apex/Application-Express-APEX-Consulting-Training.cfm?tab=video-training

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D67259GC20

Observaciones

Pago

http://skillbuilders.com/oracle-apex/Application-Express-APEX-Consulting-Training.cfm?tab=video-training

ID Categoria Titulo Link1.01 Training1.02 Training1.03 Training http://download.o

1.04 Ejemplos Using ApEx (HTML-DB) with AJAX

Using AJAX in your Application (APEX 3.1) (30 mins) http://apex.oracle.com/pls/apex/f?p=44785:24:7312014786300733::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:4033,2Incorporating JavaScript into your Application (APEX 3.1) (30 mins) http://apex.oracle.com/pls/apex/f?p=44785:24:7312014786300733::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:4109,2Incorporate JavaScript into an Application

http://www.dba-oracle.com/t_html_db_apex_ajax_application_express.htm

Return to Path - Index

Formato Duracion (min) Nivel Status Observaciones 30 Principiante 30 Principiante 30 Principiante 30 Principiante

2 Hs

ID Categoria Titulo1.01 Software SQL Developer1.02 Software SQL Developer Data Modeler1.03 Software SVN1.04 Software SQL*Plus® User's Guide and Reference1.05 Software GCDP1.05 Software Beehive Workspaces1.05 Software Oracle Connect

Return to Path - Index

Link StatusPendiente

http://apex.oracle.com/pls/apex/f?p=41867:24:7312014786300733::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5238,2 PendientePendientePendientePendientePendiente

connect.oracle.com Pendiente

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

http://subversion.tigris.org/

http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/toc.htm

https://gcdp.oracle.com/

https://stbeehive.oracle.com/teamcollab/workspaces?show=my

Observaciones

ID Categoria Titulo Link Status1.01 Sitios Utiles Ejemplos1.02 Sitios Utiles Sitio Oficial1.03 Sitios Utiles Foros1.04 Sitios Utiles Oracle Magazine1.05 Sitios Utiles Foros, Blogs, Q&A1.06 Sitios Utiles Foros, Blogs, Q&A ask Tom => asktom.oracle.com

1.07 Sitios Utiles Sitio Oficial1.08 Sitios Utiles Documentacion1.09 Sitios Utiles Libros

1.1 Sitios Utiles Foros, Blogs, Q&A

https://www.samplecode.oracle.com

http://apex.oracle.com

http://forums.oracle.com

Magazine => http://www.oracle.com/technetwork/oramag/magazine/home/index.html

Steven Feuerstein => http://apex.oracle.com/pls/otn/f?p=2853:3:1772405143489639

Oracle PLSQL http://www.oracle.com/technetwork/database/features/plsql/index.html

10g documentation Library http://www.oracle.com/pls/db102/homepage

Books http://www.oracle.com/pls/db102/portal.all_books

http://apex.oracle.com/pls/otn/f?p=24793:12:0

Return to Path - Index

Observaciones

ID Categoria Titulo1.01 Certificacion Todas las certificaciones1.02 Certificacion 11 G1.03 Certificacion1.04 Certificacion1.05 Certificacion Proximos cursos de BD1.06 Certificacion Proximos cursos APEX

2.01 Examen Tests

Oracle Database 11g: Performance TuningPuede obtenerse una certificacion despues del cursoOracle Application Express Developer Certified ExpertIncluye APEX4

Return to Path - Index

Link Nivel

Hs

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=39http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=143#1http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=287http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=376http://education.oracle.co.uk/html/oracle/14515ESA/SCHED_MP_4.htmhttp://education.oracle.co.uk/html/oracle/14515ESA/SCHED_MP_7.htm

PL SQL http://apex.oracle.com/pls/otn/f?p=2853:13:1772405143489639

Status

Fecha 14-Jun-11

Status_CurPendienteStatus_CurCursadoStatus_CurN/ANivel_CursPrincipianteNivel_CursMedioNivel_CursAvanzado

Course: CEL Oracle 10g Performance Analysis and Tuning with Kyle Hailey LVCCourse: CEL Writing Optimal SQL & Troubleshooting & Tuning with Jonathan Lewis

Oracle Database 11g: PL/SQL Developer - Plan de AprendizajeOracle Database 11g: SQL (New) - Plan de AprendizajeOracle Database 11g: Database Administrator (New) - Plan de AprendizajeOracle Application Express - Plan de Aprendizaje

https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!ja7hERpczTmxajR3F3AIng}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=AqR8oqc-AUR7Qd2g1l1d4A..https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!-f2uPWBZ7S89wpoUrIr6Uw}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=VxoeBnq3ZyNrBtyaFgg_mA..

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=212&path=DBPShttp://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=212&path=DBSLhttp://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=212&path=DBANhttp://education.oracle.com/pls/web_prod-plq-dad/db_pages.getlppage?page_id=212&path=OAED

https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!ja7hERpczTmxajR3F3AIng}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=AqR8oqc-AUR7Qd2g1l1d4A..https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!-f2uPWBZ7S89wpoUrIr6Uw}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=VxoeBnq3ZyNrBtyaFgg_mA..

https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!ja7hERpczTmxajR3F3AIng}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=AqR8oqc-AUR7Qd2g1l1d4A..https://global-ebusiness.oraclecorp.com/OA_HTML/OA.jsp?OAFunc=OTA_LEARNER_CATALOG_CRS_DTL_SS&OASF=OTA_LEARNER_CATALOG_SS&pActVerId={!!-f2uPWBZ7S89wpoUrIr6Uw}&addBreadCrumb=Y&pCourseCategory={!!bC0rK5fMaF3ue2EA3CDZqg}&pFromLink=BC%2CC%2CC&pFromCrseIds={!!8pRc65etJwFrLpRYG5FZdQ&pFromCatIds={!!VPD.GcNUgOQbiKB3dCzeNxDpClggyWDCbw0AQ7.BzT0.d2hHlxeiFJCREbHFVJFO&_ti=1707748264&oapc=33&oas=VxoeBnq3ZyNrBtyaFgg_mA..