navigation bar
 
 
  Our Partners
  Training
  Hire VLS consultant
  Join VLS
  Want to get bucks?
  Employement Opportunities
  Employee Benefits



TRAINING

  • IBM UDB/DB2 DBA
  • MS SQL Server DBA
  • Cognos

    		•

    IBM UDB/DB2 DBA

     Course details for DB2 / UDB Administration (DBA) for Windows NT

    1st Week :
  • Relational Database Management System & Concepts
  • Basics of SQL - the relational language
  • Client Server technology
  • Components and Concepts
  • Introduction to GUI Tools
  • Introduction to different objects in UDB server
  • Programming techniques in UDB Server

    2nd Week :
  • Installation of UDB server and clients
  • Creating Instances
  • Creating Database Objects
  • Using the Command Line Processor
  • DB2 Connect Client/Server Environment

    3rd Week :
  • Data Placement
  • Data Management
  • Backup and Restore techniques
  • Concurrency

    4th Week :
  • Performance and Problem Determination Tools Introduction
  • Application Alternatives
  • Administering Application Programs
  • Security
  • Distributed Application Development and Bind
  • Considerations for Multi-Database Access
  • Complex sub-queries and application consideration
  • User-defined types, and user defined functions

    SQL Server DBA

     Course details for SQL Server 6.5/7.0 Database Administration

    1st Week :
  • Relational Database Management System & Concepts .
  • Client Server technology .
  • Introduction to SQL Server and connectivity to front end.
  • Introduction to different tools & wizards in SQL Server .
  • Introduction to different objects in SQL server.
  • Programming techniques in SQL Server .

    2nd Week :
  • Installation & SQL server and clients .
  • Database and Devices Management .
  • Backup and Restore techniques .
  • Data transferring methods .

    3rd Week :
  • Security Management.
  • Integration with NT .
  • Windows NT Administration concepts.

    4th Week :
  • Performance monitoring & tuning .
  • Replication .
  • Trouble shooting .
  • Advanced SQL Server 7.0 features .
  • Introduction to SQL Server 2000


    COGNOS

     Course details for PowerPlay, Impromptu Report Devloper

    1st Week :
  • Introduction to Data-warehousing and Cognos
  • Impromptu6.0 Ad-hoc Reporting
  • Impromptu basics, the interface and on-line help
  • Introduction to an Impromptu Catalog and Reports.
  • Using the Impromptu Wizard.
  • Performing the Summary calculations
  • Exploring the Frame Properties

    2nd Week :
  • Impromptu6.0 Advanced Ad-hoc reporting
  • Reporting with hotfiles
  • Impromptu6.0 Catalog and Query Administration
  • The role of Impromptu Administrator.
  • Powerplay6.5 Fundamentals of Multidimensional Analysis
  • Introduction to multidimensional Data Analysis,
  • Features and Comments.

    3rd Week :
  • Data Exploration with drill-through to Impromptu and PowerPlay.
  • Building Multidimensioanl Information Systems Using PowerPlay .
  • Introduction to multidimensional technology: Features and Concepts.
  • Cube Maintenance
  • IPitfalls and work around for the Powerplay Administrator


    [Home][Looking For Work][Looking for Consultant][Referral Policy][Employee's][Employee Benefits]

    © Copyright 1997 V.L.S Systems, Inc. All rights reserved.