Workshop Training

ITSYS offers workshop training to help our customers learn new technologies by practice.

We offer the following workshop training:

Oracle Application Server10g Installation Topics
Oracle Application server10g administration Topics
Oracle Database server 10g New Features
Oracle Database server 9i Topics
Building J2EE Applications with the rational Unified Process
“De la conception UML au code JAVA”
Oracle Designer


Oracle Application Server10g
Installation Topics
  • Introduction
  • What's new in the installation
  • Download OracleAS R2 and burn CDs
  • Check hardware requirements
  • Check software requirements for Redhat linux
  • Check kernel parameters
  • Install OracleAS infrastructure R2
  • Install J2EE and Web Cache Middle tier
  • Uninstall OracleAS Infrastructure R2
  • Uninstall OracleAS Middle tier
  • Removing Entries for a deleted instance from OID
  • Environment variables
  • Oracle Application server10g
    administration Topics
    • Administrative Component Overview
    • Managing OracleAS R2 with Enterprise Manager (OEM)
    • Managing OracleAS R2 with Command-line interfaces
    • OracleAS R2 infrastructure
    • Single Sign-On (SSO)
    • Oracle HTTP Server (OHS)
    • Managing The Oracle Web Cache
    • J2EE in OracleAS R2
    • Management of OC4J (Oracle Container for J2EE)
    • Database connections and TopLink
    • OracleAS R2 security
    Oracle Database server 10g New Features
    • Oracle10g database management strategies
    • Oracle10g infrastructure management strategies
    • Oracle10g new features and tools
    • Oracle10g enhancements to Oracle9i features
    • Common Infrastructure
    • Automatic workload repository
    • Server generated alerts
    • Advisory framework
    • Database storage enhancements
    • The SYSAUX tablespace
    • Automated RAC Services
    • New static data dictionary views
    • New dynamic data dictionary views
    • Bigfile tablespaces
    • Extended rowid format
    • Renaming tablespaces
    • New features in temporary tablespaces
    • Transportable tablespace enhancements
    • Automatic storage management (ASM)
    • ASM disk group
    • ASM disk
    • ASM files
    • ASM instance
    • Enhancements to external tables
    • Space Management
    • Proactive tablespace monitoring
    • Segment management
    • Enhanced partitioning
    • Undo management
    • Redo logfile size advisor
    • Other Manageability Enhancements
    • Enhancements to Resource management
    • Adaptive Consumer Group Mapping
    • Fixed CPU Quota
    • Integrating Resource Manager and Profiles
    • SQL*Plus enhancements
    • SQL access advisor
    • Materialized view tuning API
    • Automatic shared memory management
    • Human Error Correction
    • Flashback database
    • Flashback drop
    • Flashback versions query
    • Flashback transaction query
    • Flashback table
    • Enhanced Log Miner features
    • Automated LogMiner configuration
    • Enhanced LogMiner support
    • Data Pump export and import
    • Transaction manageability
    • Enhanced Tuning Features
    • Automated checkpoint tuning
    • CPU costing
    • Dynamic sampling
    • Enhancements to Data Guard
    • Real time apply
    • Named data guard configurations
    • Secured redo transmission
    • Zero downtime instantiation for SQL apply
    • 10g initialization parameters
    • Grid computing
    • How Oracle10g will change database administration
    Oracle Database server 9i Topics
      1- Workshop-Installation

      1.01 Install Oracle products (OFA)
      1.02 Custom installation: choose some options to install for specific needs
      1.03 Post-installation
      1.04 Apply a patch
      1.05 Uninstall one or two options of Oracle product
      1.06 Remove Oracle product

      2- Workshop-Database Creation and sizing

      2.01 Prepare and size database disk space.
      2.02 Automate database creation using scripts or templates
      2.03 Resize and Rename online redologs and tablespaces
      2.04 Resize dynamically shared memory
      2.05 Automate PGA memory management
      2.06 Default temporary tablespace
      2.07 Automated Undo Management
      2.08 Create the server parameter file
      2.09 Setting Persistent Parameters
      2.10 Enable/Disable archivelog mode.
      2.11 Recreate the controlfile in order to change some Oracle parameters.

      3- Work-Shop Oracle New Features 9i

      3.01 Configure the database to use OMF (Oracle Managed DataFiles)
      3.02 Multiple Database Block Size Support
      3.03 Resumable Space Management and Import/Export Utilities
      3.04 Extraction of Object Metadata
      3.05 Reorganize and redefine Tables online
      3.06 Automated segment-space management:
      3.07 Identifying unused indexes.
      3.08 Quiescing the Database.
      3.09 Flashback query.
      3.10 Fast Start Time-Based Recovery
      3.11 Database Flash Freeze
      3.12 Right Outer Join
      3.13 Left Outer Join
      3.14 Full Outer Join
      3.15 Case expression enhancement
      3.16 Nullif and coalesce statements
      3.17 Scalar Subqueries

      4- Workshop-Centralized databases management using OEM

      4.01 Install and configure Oracle Management Server on a new local database
      4.02 Start/Stop Oracle Management Server service
      4.03 Connect the console to Oracle Management Server
      4.04 Configure Oracle SNMP agent.
      4.05 Discover nodes
      4.06 Enable the job system.
      4.07 Creating a New Job
      4.08 Creating and Registering an Event
      4.09 Configure Enterprise Manager Reporting

      5- Workshop-Backup and recovery strategies

      5.01 User Managed Backup of offline database
      5.02 User Managed restore of the whole database(cold backup)
      5.03 User Managed Backup of offline tablespace
      5.04 User Managed Backup of online tablespace and datafiles
      5.05 User Managed Backup of online database
      5.06 User Managed restore of the whole database(Hot backup) with controlfile
      5.07 User Managed restore of the whole database(Hot backup) using backup controlfile
      5.08 Restore backup datafiles to their default location
      5.09 Backing up the control files to a binary file
      5.10 Backing up the control files to trace file
      5.11 Backing up the archived log files
      5.12 Verifying User Managed backup
      5.13 Re-create datafiles when backup are unavailable(if all archived log generated after datafile creation are available)
      5.14 Restoring controlfiles when one member is lost
      5.15 Restoring controlfiles when all members are lost
      5.16 ….

      6- Workshops-Snapshots Advanced replication

      6.01 Before you set up your replication
      6.02 Set Up the master site
      6.03 Create Master Group at master Sites
      6.04 Create Materialized view log (fast refresh) 6.05 Set Up Materialized view site
      6.06 Create Materialized view Group at materialized view Site
      6.07 Create Materialized view Refresh group at materialized view Site
      6.08 Test the replication

      1- Concept definition

      1.01 Hibernate overview
      1.02 Configuration files
      1.03 Hibernate Mapping file
      1.04 POJO requirements
      1.05 Database design guidelines
      1.06 Collections and Associations
      1.07 Persistence lifecycle, detached objects, and object identity
      1.08 HQL and the query API
      1.09 Generating schemas, mapping files, and POJOs
      1.10 Hibernate in web apps, EJB, and standalone apps
      1.11 Hibernate Session
      1.12 Hibernate Transaction
      1.13 Hibernate?
      1.14 Hibernate and SQL

      2- Hibernate Synchronizer Plug-in Installation

      2.01 Eclipse 3.0.x
      2.02 WSAD 5.1.2

      3- How to use Hibernate

      3.01 Create a project
      3.02 Hibernate Configuration File and Mapping File

      4- Test the hibernate Class

      4.01 Prepare the session manager
      4.02 EmpCons Class
      4.03 EmpIns Class
      4.04 EmpMaj Class

      5- Hibernate and Multiple databases

      5.01 Introduction
      5.02 Example

    Building J2EE Applications with the rational Unified Process
      1- Rational Unified Process

      1.01 Introduction
      1.02 RUP Key Concepts
      1.03 RUP as a Process Framework

      2- J2EE Developer Roadmap

      2.01 What is RUP RoadMap?
      2.02 J2EE Developer Roadmap-Scope and Rational
      2.03 J2EE Developer Roadmap-J2EE-Specific Content
      2.04 Summary

      3- Software Architecture

      4- J2EE Technology

      4.01 J2EE Technology overview
      4.02 J2EE Deployment Configurations
      4.03 J2EE Components Technologies
      4.04 Assembly and Deployment

    “De la conception UML au code JAVA”
      1- Introduction

      Méthodologies UP (unified process), XP (eXtreme Programming)
      Pourquoi modéliser en UML
      Description du projet autour duquel le cours sera bâti
      Les trois axes principaux : fonctionnel, statique et dynamique

      2- Besoins utilisateurs

      Réalisation d’une maquette
      Diagramme des cas d’utilisation (use cases)

      3- Modèle du domaine

      4- Diagramme de classes participantes

      5- Diagramme de séquence système

      6- Diagramme d’activité de navigation

      7- Diagramme d’interaction

      8- Diagramme de classes de conception

      Classes de dialogue, Classes de contrôle, Classes métier

      9- Passage au code Java

      Revue des couches présentation, contrôle et métier
      Rappels sur J2EE
      Rappels sur Struts

    Oracle Designer

    Le cours est bâti autour d’un projet fictif dont les livrables attendus seront détaillés en début de séance.

      Part 1 : de l'analyse à la conception

      1- Définition du projet fictif

      1.01 Cahier des charges
      1.02 Livrables attendus

      2- Présentation de Designer

      2.01 Les différentes composantes graphiques
      2.02 Le référentiel
      2.03 La notion d’application
      2.04 La méthodologie CDM

      3- ERD : Diagramme Entités-Relations

      3.01 Reverse Engineering
      3.02 Table to Entity Retrofit
      3.03 Intégrer les entités dans des diagrammes ERD
      3.04 Travailler directement dans un diagramme ERD

        · La table CG_REF_CODES
        · Les différents types de relations
        · Types et sous-types
        · Les arcs
        · Les domaines

      4- DDT : Database Design Transformer

      4.01 Correspondance ERD – Server Model
      4.02 Incompatibilité de types (ERD/Database)
      4.03 Mapping de Super-types / Sous-types
      4.03 Détail des arcs

      5- FHD : Diagramme hiérarchique des fonctions

      5.01 Éléments d’une fonction d’affaire
      5.02 FHD et menus d’applications

      6- Matrix diagrammer

      7- ADT : Application Design Transformer

      7.01 Création de modules candidats à partir des fonctions d’affaire
      7.02 Création d’une structure de modules en vue de générer des menus

      8- BPM : Business Process Modeler

      8.01 Utilité et manipulation
      8.02 Lien avec les menus d’application

      Part 2 : conception et génération

      1- Design Editor

      Data view / Display view
      Cas particulier des lookup
      Cas particulier des LOV (list of values)

      2- Préférences de génération

      3- Définir son propre gabarit (template)

      4- Définir sa propre librairie d’objets

      5- Générer pour le client/serveur vs. Générer pour le web