OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

Archive for April, 2008

Oracle Database 10g: Data Guard Administration

Thursday, April 24th, 2008

Duration: 3 Days

In this course, students learn how to use Oracle Data Guard to help protect their Oracle Database against planned and unplanned downtimes. Data Guard architecture is discussed, as well as the creation of physical and logical standby databases. In addition, the course examines the performance implications of using various Data Guard features and offers some troubleshooting tips. Students use Enterprise Manager Grid Control to create and manage their Data Guard configuration in the classroom. The course includes a workshop where students have the opportunity to apply what they have learned to meet stated business requirements.

• Prepare the primary database for a Data Guard Configuration
• Monitor a Standby configuration
• Create a Physical Standby database
• Create a Logical Standby database

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

Target Audience
• Technical Consultant
• Database Administrators
• Support Engineer

Prerequisite
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

• Configure Primary Database
• Create physical Standby
• Create logical standby
• Manage Data Guard configuration with Enterprise Manager Grid Control
• Use Data Guard with Real Application Clusters

Course Outline

  • Oracle Data Guard: Overview
  • Understanding the Oracle Data Guard Architecture
  • Data Guard Broker and Enterprise Manager
  • Creating a Configuration with Enterprise Manager
  • Creating a Physical Standby Database by Using SQL
  • Data Protection Modes and Log Transport Services
  • Data Guard SQL Apply Architecture
  • Creating a Logical Standby Database by Using SQL
  • Switchover and Failover
  • Using Data Guard with RAC
  • Other Considerations for Oracle Data Guard
  • Workshop

Print this page Print this page

Oracle Database 10g: Security Release 2

Thursday, April 24th, 2008

Duration: 4 Days

In this course, the students learn how they can use Oracle database features to meet the security and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data Protection Act, and others requires better security at the database level. Students learn how to secure their database and how to use the database features that enhance security. The course provides suggested architectures for common problems.

This course explains the security features of the database like auditing, column and file encryption, virtual private database, label security and enterprise user security. Some of the Oracle Network security topics like securing the listener and restricting connections by IP address are also covered.

Target Audience
• Database Administrators
• Support Engineer
• Technical Consultant
• System Analysts

Prerequisites
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop I Release 2

Course Objectives

  • Use basic database security features
  • Choose a user authentication model
  • Secure the database and its listener
  • Use the Enterprise Security Manager tool
  • Manage users using proxy authentication
  • Implement Enterprise User Security
  • Describe the benefits and requirements associated with the Advanced Security Option
  • Manage secure application roles
  • Implement fine-grain access control
  • Manage the Virtual Private Database (VPD)
  • Implement fine-grain auditing
  • Use Transparent Data Encryption
  • Use file encryption
  • Encrypting and Decrypt table columns
  • Setup a simple Label Security policy

Course Outline

  • Security Requirements
  • Security Solutions
  • Internal Database Security
  • Database Auditing
  • Fine-Grained Auditing
  • Basic User Authentication
  • Strong Authentication
  • Enterprise User Security
  • Proxy Authentication
  • Authorization Methods
  • Using Application Context
  • Fine-Grained Access Control
  • Installing Label Security
  • Implementing Label Security
  • Encrypting Data: Concepts
  • Use Application Based Encryption
  • Use Transparent Data Encryption
  • Use File Encryption
  • Oracle Net Services Security Checklist
  • Securing the Listener
  • Using Connection Manager as a Firewall
  • Securing SQL*Plus and iSQL*Plus

Oracle Database 10g: Introduction to SQL

Thursday, April 24th, 2008

Duration: 5 Days

This course offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones.

Target Audience
• Application Developers
• Business Intelligence Developer
• Database Administrators
• End Users
• Forms Developer
• PL/SQL Developer
• Portal Developer

Prerequisites
• Familiarity with Data Processing Concepts and Techniques
• Ability to use a graphical user interface (GUI)

Course Objectives
• Retrieve row and column data from tables with the SELECT statement.
• Employ SQL functions to generate and retrieve customized data.
• Run data manipulation statements (DML) to update data in the Oracle Database 10g.
• Control user access and manage schema objects
• Search data using advanced sub queries

Course Outline

  • Introduction
  • Writing SQL SELECT Statements
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the SET Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Manage Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Searching Data Using Advanced Sub queries
  • Hierarchical Retrieval
  • Regular Expression Support

Suggested Follow-Up Course
Oracle Database 10g: Program with PL/SQL [NEW]

Oracle Database 10g: Performance Tuning

Thursday, April 24th, 2008

Duration: 5 Days

Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Target Audience
• Database Administrators
• Support Engineer
• Technical Consultant

Prerequisites
Knowledge of Database Administration
Oracle Database 10g: Administration Workshop I
Oracle Database 10g: Administration Workshop II

Course Objectives

  • Use the Oracle Database tuning methodology appropriate to the available tool
  • Utilize database advisors to proactively tune an Oracle database
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Use Statspack reports to tune the database
  • Diagnose and tune common database performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle database

Course Outline

  • Performance Tuning Overview
  • Statistics and Wait Events
  • Metrics, Alerts, and Baselines
  • Using Statspack
  • Using AWR
  • Reactive Tuning
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Automatic Shared Memory
  • Checkpoint and Redo Tuning
  • Tuning I/O
  • Tuning PGA and Temporary Space
  • Tuning Block Space Usage
  • Initial Configuration

Suggested Follow-Up Courses
Oracle Enterprise Manager 10g Grid Control
Oracle Enterprise Manager 10g Grid Control Release 2
Oracle Database 10g: SQL Tuning Workshop
Oracle Database 10g: Real Application Clusters

Defining Business Systems with Unified Modeling Language (UML)

Thursday, April 24th, 2008

Duration: 2 Days

UML (Unified Modeling Language) is a dynamic, flexible, and standardized language that can be used to model many scenarios and applications. Business Systems are the underlying engines that run all businesses. Creating, changing, optimizing and maintaining these systems will be improved with the use of UML. UML gives a commonly understood platform that all members of a company can use. In this course we take a look at a method of defining, eliciting information about the systems, and using UML to model those systems with an aim to giving management better control over their business.

UML modeling allows for the finding of potential areas of change, such as:

  • Inefficiencies
  • Performance issues
  • Redundant processes
  • Incorrect or conflicting business rules
  • Areas of risk/exposure to your business systems
  • Potential areas of consolidation
  • Underutilized/over-utilized systems and people

Target Audience

  • Business Analyst who needs to define or gather user’s business requirements
  • Business Systems Analyst who wants to understand userÕs business requirements, translate them into clear statements of functional and systems requirements and add value to IT projects.
  • Systems Analyst who must develop correct technical specifications from functional and system requirements
  • System Auditors who are responsible for making sure that a company’s systems are working exactly as defined by the company’s needs
  • Compliance officers who are responsible for making sure that the company policies, systems and actions do not violate regulations, rules and laws.
  • Risk Managers who are responsible for assessing company vulnerabilities and other areas of risks posed by changes and implementations of business systems and rules
  • Project Managers who must ensure that a projectÕs team members correctly understand customer needs and deliver high-quality solutions within project constraints
  • Database Developers who must develop correct database specifications for business use from user requirements.
  • Business Owners who want to understand the interoperations of their businesses so that they can solve business problems and work more effectively.
  • Six Sigma/Lean Sigma Practitioners who want to increase the effectiveness of their efforts.
  • Independent IT/Telecom/Business Consultants who want to accurately capture the expectations of the customer before designing a system, network or process.
  • Web page/GUI Interface designers who must design and develop interactive web pages and applications

Course Objectives
1. Learn to design so that you can accommodate unplanned changes.
2. Create a well-documented design so that others who are new to the design can still work with it.
3. Have a visual model of an architecture to help you determine implications of changes.
4. Have a common way to understand what needs to be built to help teams of different organizations, languages, and countries communicate effectively to successfully deliver an application that is on time and, more importantly, meets the requirements of the end users.
5. Model your business and its legacy applications to help minimize the costs and impact on productivity when software is transitioned to new staff members.
6. Creating a clear model of how your systems are to be used operationally will reduce the learning curve of new users.
7. Avoid unnecessary maintenance due to operator error or misunderstanding.
8. Model your business to clarify how different parts of your operations interact.
9. Learn to make your business rules explicit.
10. Building an enterprise architecture helps you understand what exists within your organization, including software, hardware, business processes, and organizational resources.
12. Providing a view of your enterprise architecture to others helps to ensure interoperability across organizations.
13. Learn how to use modeling techniques in creative ways to extract greater value from them.
14. Learn how to identify stakeholders when modeling and designing systems.
15. Learn how to quickly and easily find the root cause of a system problem.
16. Get hands-on experience using the different types of diagrams available for system design.
17. Learn how to affect changes in your organization and introduce UML as a “common language”.
18. Learn how to use UML for your specific job function.
19. Learn how to define and create your own company UML “dictionary”.

Course Outline

Defining Business Systems
In any business there can be a significant number of systems that aren’t necessarily associated with business functions. These systems must be identified and documented as part of the complete requirement specification.

Analyzing Business Systems
Projects arise in part to solve problems with business systems, and understanding the underlying problem or problems is therefore key to being able to identify the correct requirements. During this section, you will refresh your knowledge of and practice applying a five-step analysis method.

Modeling Business Systems
Savvy analysts and project team members have a variety of techniques for analyzing business problems. This section introduces three of the most powerful and effective analysis techniques and discusses their use in requirements elicitation.

What is UML?
The UML (Unified Modeling Language) is one of the most exciting and useful tools in the world of system development. In the past system analysts would try to determine the needs of clients and note those needs in some notation that was often personal to the analyst when sending to the programmers. This could lead to indeterminate needs, incorrect designs and a costly amount of miscommunications between customer, analyst, and designer/programmer. With the UML the design process is organized in an orderly manner that is understood by all.

Modeling and Analysis with UML
We will demonstrate hands-on application of the differing ways that UML can be used in the business environment. In this workshop you will get actual hands on experience in designing different types of models with UML. The class will work in groups to design a system based upon the needs of the organization.

Applying UML to Your Specific Job Function
While UML is a powerful tool and is very adept at differing modeling scenarios, you will want to know how to use it for their own specific purposes. Whether for your specific job function, your department or company as a whole.

Defining Your Own Company UML Library
Attendees who bring their own laptops can experience the hands-on benefits of creating their own library of diagrams, tools and templates for use in their personal corporate environment.

Integrating UML into Your Company Practices
For many, the question left after attending the seminar is how to get your company to buy into the deployment of UML on all appropriate levels of the organization. In this section we will discuss processes and plans to get your company to buy into and even implement a training program.

Unix Shell Scripting

Thursday, April 24th, 2008

Duration: 5 Days

This hands on course provides the skills needed to create and maintain shell programs used in managing and enhancing the operation of user environments for UNIX systems.

Prerequisites
It is recommended that individuals have at least two years experience using UNIX commands and operating environment.

Target Audience
System Administrators, System Engineers

Course Objective

  • Introducing the Course Project
  • Understanding how Shell programs works
  • The differences between shells
  • Debugging and troubleshooting
  • Regular expressions

Course Outline

  • Shell Programming Features
  • Conditional Code
  • Loops
  • Text Processing
  • Functions
  • Command-line Parameters
  • Advanced Scripting

CompTIA Server+

Tuesday, April 22nd, 2008

Duration: 5 days

The Server+ Certification course builds on your existing mid- to upper-level knowledge and experience with personal computer operating systems and networks to validate advanced skills and concepts that you will use on the job in dealing with server technologies. If you are pursuing a CompTIA technical certification path, the CompTIA A+ and CompTIA Network+ certifications are excellent first steps to take before preparing for the CompTIA Server+ certification.

Target Audience
The CompTIA Server+ certification exam is targeted for IT professionals, Network Support Technicians, and Server Hardware Specialists with 18-24 months of experience in the Information Technology industry and hands-on experience with installation, configuration, diagnosis, and troubleshooting PC hardware.

Prerequisites

  • Hands-on experience with installation, configuration, diagnosis, and troubleshooting PC hardware and NOS issues

  • At least one industry certification, such as CompTIA A+, Compaq ACT, Novell CNA, or Microsoft MCP

In addition to these exam requirements, to ensure your success with this course, we recommend you first take the following courses or have equivalent knowledge:

  • A+ Certification, course C002 A+ Accelerated Training

  • Network+ Certification, course C003 A+ Network+

Upon successful completion of this course, students will be able to:

  • Explore server fundamentals.

  • Describe the characteristics of the system processing core subsystem.
  • Describe storage system components, so that you can effectively implement several types of storage solutions.
  • Explore the communication, power, and input/output subsystems.
  • Install servers.
  • Configure servers.
  • Maintain servers.
  • Upgrade server components.
  • Explore environmental issues surrounding servers. Troubleshoot servers.
  • Explore disaster recovery concepts and techniques.

Course Outline
Lesson 1: Introduction to Servers
Lesson 2: Exploring the System Processing Core
Lesson 3: Exploring the Storage Subsystem
Lesson 4: Exploring the Communication, Power, and Input/Output Subsystems
Lesson 5: Installing Servers
Lesson 6: Configuring Servers
Lesson 7: Maintaining Servers
Lesson 8: Upgrading Server Components
Lesson 9: Exploring Environmental Issues Surrounding Servers
Lesson 10: Troubleshooting Servers
Lesson 11: Exploring Disaster Recovery Concepts and Techniques

Print this page Print this page

Oracle Database 10g: Administration Workshop II

Tuesday, April 22nd, 2008

Duration: 5 Days Instructor Led

Oracle DBAs manage the industry’s most advanced information systems and command some of the highest salaries. This course advances your success as an Oracle professional in the area of database administration.

In this class, you’ll learn how to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and the steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structured hands-on practices and a workshop. This course is designed to prepare you for the corresponding Oracle Certified Professional exam.

Target Audience

  • Database Administrators

  • Sales Consultants
  • Support Engineer
  • Technical Consultant

Prerequisites

  • Oracle Database 10g: SQL Fundamentals I

  • Oracle Database 10g: Administration Workshop I
  • Oracle Database 10g: SQL and PL/SQL Fundamentals

Course Objectives

  • Use RMAN to create and manage backup sets and image copies

  • Recover the database to a previous point in time
  • Use Oracle’s Flashback technology to recover your database
  • Detect block corruptions and take appropriate measures to correct them
  • Use the various Database advisors and views to monitor and improve database performance
  • Control database resource usage with the Resource Manager
  • Simplify management tasks by using the Scheduler
  • Improve the security of the listener
  • Review database log files for diagnostic purposes
  • Customize language-dependent behavior for the database and individual sessions

Course Outline

  • Using Globalization Support

  • Securing the Oracle Listener
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Diagnostic Sources
  • Recovering from non-critical losses
  • Database Recovery
  • Flashback database
  • Recovering from User Errors
  • Dealing with Database Corruption
  • Automatic Database Management
  • Monitoring and Managing Storage
  • Automatic Storage Management
  • Monitoring and Managing Memory
  • Managing Resources
  • Automating Tasks with the Scheduler

Print this page Print this page

MS 2524: Developing XML Web Services Using Microsoft ASP.NET

Tuesday, April 22nd, 2008

Duration: 3 Days Instructor Led

The goal of this course is to provide students with the knowledge and skills that are required to develop Extensible Markup Language (XML) Web services-based solutions to solve common problems in the distributed application domain. The course focuses on using Microsoft Visual Studio .NET and Microsoft ASP.NET to enable students to build, deploy, locate, and consume Web services.

Target Audience
This course is intended for experienced software developers who have previously built component-based applications.

After completing this course, students will be able to:

  • Explain how Web services solve problems encountered with traditional approaches to designing distributed applications.

  • Describe the architecture of a Web services-based solution.
  • Describe the underlying technologies of Web services and explain how to use the Microsoft .NET Framework to implement them.
  • Implement a Web service consumer by using Visual Studio .NET.
  • Implement a simple Web service by using Visual Studio .NET.
  • Publish and deploy a Web service.
  • Secure a Web service.
  • Implement caching in a Web service.
  • Evaluate the trade-offs and issues that are involved in designing a real-world Web service.
  • Implement nonstandard Web services such as Hypertext Markup Language (HTML) screen scraping and aggregating Web services.

Prerequisites
Before attending this course, students must have:

  • Familiarity with C# or Microsoft Visual Basic .NET.

  • Programming in C++, Java, or Microsoft Visual Basic.
  • An understanding of how to read and write XML documents.
  • Experimented with simple C# applications.
  • Developed distributed applications by using Visual Basic, Java, or C++.

Course Outline
Module 1: The Need for XML Web Services
Module 2: XML Web Service Architectures
Module 3: The Underlying Technologies of XML Web Services
Module 4: Consuming XML Web Services
Module 5: Implementing a Simple XML Web Service
Module 6: Publishing and Deploying XML Web Services
Module 7: Securing XML Web Services
Module 8: Designing XML Web Services
Module 9: Global XML Web Services Architecture

Print this page Print this page

MS 2310: Developing MS ASP.NET Web Applications using Visual Studio.NET

Tuesday, April 22nd, 2008

Duration: 5 Days Instructor-Led

This five-day, instructor-led course will teach Microsoft Visual Basic programmers and beginning Web developers the fundamentals of Web application site implementation by using Microsoft ASP.NET and Microsoft Visual Basic .NET. This course focuses on using the Microsoft Visual Studio .NET environment and the Microsoft .NET platform to create an ASP.NET Web application that delivers dynamic content to a Web site.

Target Audience
This course is intended for beginning Web developers who have knowledge of the Hypertext Markup Language (HTML) or dynamic HTML (DHTML), along with some knowledge of a scripting language, such as Visual Basic Scripting Edition or Microsoft JScript. This course is also appropriate for Visual Basic 6.0 developers wanting to learn ASP.NET.

After completing this course, students will be able to:

  • Explain the Microsoft .NET Framework and ASP.NET

  • Create a component in Visual Basic .NET or C#.
  • Create an ASP.NET Web application project by using Visual Studio .NET.
  • Add server controls to an ASP.NET Web Form.
  • Create and populate ASP.NET Web Forms.
  • Add functionality to server controls that are on an ASP.NET Web Form.
  • Use the Trace and Debug objects that are provided with Visual Studio .NET.
  • Use validation controls to validate user input.
  • Create a user control.
  • Access data by using the built-in data access tools that are available in Visual Studio .NET.
  • Use Microsoft ADO.NET to access data in an ASP.NET Web application.
  • Accomplish complex data access tasks from an ASP.NET Web application.
  • Access Extensible Markup Language (XML) data and read it into a DataSet.
  • Call an XML Web service from an ASP.NET Web application and incorporate the returned data into a Web application.
  • Store application and session data by using a variety of methods.
  • Configure and deploy an ASP.NET Web application.
  • Secure an ASP.NET Web application by using a variety of technologies.

Prerequisites
Before attending this course, students must have:
• The ability to create HTML or DHTML, including tables, images, forms.
• Programming experience using Visual Basic .NET, including, declaring variables, using loops, using conditional statements.

Students can satisfy the prerequisites for this course by completing:
• Course 1912: Introduction to Web Development Technologies,
• Course 2559: Introduction to Visual Basic .NET Programming with Microsoft .NET, or
• Course 2373: Programming with Microsoft Visual Basic .NET.

This course will help the student prepare for the following Microsoft Certified Professional exams:
• Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
• Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET

Course Outline
Module 1: Overview of the Microsoft .NET Framework
Module 2: Using Microsoft Visual Studio .NET
Module 3: Using Microsoft .NET-Based Languages
Module 4: Creating a Microsoft ASP.NET Web Form
Module 5: Adding Code to a Microsoft ASP.NET Web Form
Module 6: Tracing in Microsoft ASP.NET Web Applications
Module 7: Validating User Input
Module 8: Creating User Controls
Module 9: Accessing Relational Data Using Microsoft Visual Studio .NET
Module 10: Accessing Data with Microsoft ADO.NET
Module 11: Calling Stored Procedures with Microsoft ADO.NET
Module 12: Reading and Writing XML Data
Module 13: Consuming and Creating XML Web Services
Module 14: Managing State
Module 15: Configuring, Optimizing, and Deploying a Microsoft ASP.NET Web Application
Module 16: Securing a Microsoft ASP.NET Web Application
Module 17: Review

Print this page Print this page