Training Courses

Avantis Asset Management

All Modules of Avantis.PRO Asset Management
Our teaching professionals will cover all of the business applications within the Avantis.PRO software package; procurement, maintenance, and inventory for Avantis.PRO.

Avantis.PRO Asset Management Automation
In a hands-on environment, you will learn how to create, use and modify objects in Avantis.PRO through Visual Basic, using the application program interface that Avantis.PRO offers.

Crystal Reports Development

Basic
If you have a basic knowledge of Windows and databases this course is for you to advance into the basic Crystal Report Development course. You will learn how to sort and create groups, summaries, formulas, create a variety of layouts, sub-reports, setting the location and source for a report.

Advanced
If you have attended our Basic course (or have equivalent knowledge) this level is for you. You will learn how to structure query language as it relates to Crystal Reports. This course also details the development of advanced formula creation and queries and retrieving information through stored procedures from Access and SQL. Scheduling, viewing, analyzing and shared reports and queries.

Data Warehousing

This hands-on course provides you with techniques used to design a data warehousing system, and implement a database design with a star schema in SQL server. Gathering of data from primary data sources, transforming it, and placing it in an SQL server staging database. Creating a cube using OLAP services, analyzing cube data using existing client applications and building custom OLAP clients using ADO MD, OLE DB for OLAP and DSO. You will also learn about maintaining and managing data warehousing.

Database Performance Improvement

Covering the creation of statistic information using the genstat procedure in order to improve Select statements over large tables, Hanco's training team has put together this course to also cover device distribution, Microsoft SQL server tuning and Microsoft SQL Database Back-up and Disaster Recovery.

FlexProcess ERP

All Modules of FlexProcess ERP
Our teaching professionals will cover all of the business applications within the FlexProcess software package; production, inventory, scheduling, planning, COM, resource costing, resource accounting and financials for FlexProcess.

Microsoft Office

We offer basic, intermediate and advanced levels in Word, Excel, Power Point and Access. You will learn everything needed to fulfill the user necessities in the office environment. We offer several levels within each program course as pre-identified.

Networking essentials

This course teaches you the basic networking essentials needed in business today, providing a strong foundation in PC based network software and hardware components.

Performance tuning ? technical reference

We will provide you with the technical reference tools associated with server tuning. Encompasses sizing and capacity planning, how to tune OLTP systems, data warehouses, data marts, replicated systems, getting optimal performance by using the query analyzer and profiler to tune SQL statements and stored procedures.

PRISM

All training and support services involving application solutions for Process manufacturing are geared to assist enterprises by increasing their operational efficiency.

The training and support program that we will provide to your staff, will reduce your implementation costs considerably and will be a solid investment for your firm.

Supporting our Clients in PRISM's AS/400 modules; planning and scheduling, quality control, regulatory compliance and performance Analysis, Hanco provides you with piece of mind.

Progress Software

Character Programming in Progress Software
You will to create and connect to a database, add and modify database definitions, read, display, create and modify records, design screen displays, handle error conditions, work with multiple tables, generate reports and manage database transactions.

GUI Programming in Progress Software
You will learn to develop an event driven application in a graphical environment, manage transactions and record logging, generate and run reports, create updateable browses, create menus, repositioning a browse.

Progress Software Database Administration NT
This course teaches you to create a database, connect to a database via various methods, optimize and analyze database performance through the use of Progress tools, facilitate database crash recovery and develop a comprehensive, efficient backup and recovery plan.

Progress Software Database Administration UNIX
This course teaches you to create a database, connect to a database via various methods, optimize and analyze database performance through the use of Progress tools, facilitate database crash recovery and develop a comprehensive, efficient backup and recovery plan.

Protean ERP

All Modules of Protean ERP
Our teaching professionals will cover all of the business applications within the Protean software package; production, inventory, scheduling, planning, COM, resource costing, resource accounting and financials for Protean.

Protean ERP Automation
In a hands-on environment, you will learn how to create, use and modify objects in Protean through Visual Basic, using the application program interface that Protean offers.

SQL

Programming
This course is offered at basic and intermediate levels and covers the development of logical data models, data services, Transact-SQL scripts programming, views and stored procedures, creation of the physical database and its maintenance.

Administration
This course is created for the system administrator with basic programming skills. You will learn planning, security strategies, server capacity, data availability, replication, installation and configuration, security, managing and maintaining data, optimization, and trouble-shooting.

Upgrading
You will learn the general procedures to migrate from an SQL 6.5 database to an SQL 7.0 database system. Includes the statistic stage, the conversion stage using one machine, the conversation stage using two machines in a single network, and the login corrections. General error description and interpretation, incomplete or corrupted stored procedures and data tables.

Server Database Administration

You will learn techniques to develop a logical data model, designing solutions for performance, maintain ability, scalability, availability and security. Configuring the physical database files, tables, indexes and views, implementing the stored procedures and triggers, creating and managing explicit and implicit, distributed transactions to ensure data integrity. Monitoring and optimizing database performance is also covered.

Visual Basic

The aggressiveness in business today requires an extremely high level of adaptability in the technology industry. Systems that reflect compatibility with others are a necessity. Hanco Technologies works hard at meeting clients' needs in this area of business because we are aware of the large investments that Corporations make, then only to find a new step is required in the software development process.

Information handling is targeted with all business strategies and objectives in mind. In order to achieve this, Hanco assists by blending the two - business with technology. This, targeted with the adaptability of the system can create changes as required in a quick manner that will keep up with the ever-changing competitive market.

Considering this, Hanco offers the application development service in Visual BASIC. We support Avantis Asset Management and Procurement system. This application program interface, (API) works well to meet client needs in a timely and cost-effective manner. With this platform, the level of adaptability can vary from carrying out process automation to generating a new functionality within the system. We're there for you!

Visual C++ Programming

Basic Programming
If you have taken our Visual Basic Programming course (or equivalent) this course will teach the features of Microsoft Visual C++, creating a program using App Wizard, application framework and Microsoft foundation classes. It will provide you with a clear understanding of the tools such as Visual Workbench, APP Studio, APP Wizard and Class Wizard. The Hanco training team also covers, Window classes, messages, resources, controls and variables, other operations such as printing, help and OLE support. General-purpose classes, debugging, diagnostics and errors are also covered within this basic programming course.

Advanced Programming
If you have taken our Basic Visual C++ Programming course (or equivalent) this course will teach C++ installing and configuring Visual C++ 6.0, development tools and services, including source code control for distributed applications. Using a multi-tier design to plan your solutions - developing user services/dynamic menus, status bars, dialogue boxes and data validation. Creating data access through its OLE database templates, ADO and stored procedures, handling exceptions and errors, debugging and testing is also covered in this course.

Website

Website strategies and development
How to market your product or services on the Internet using unique and creative techniques is a definite requirement in business today. By reflecting your web site strategy with your business goals and mandates, in a cost effective and efficient method, you can capture market share in this growing environment. The unique approach is to apply the strategies into the overall development of your web site plan that will prove to be a good investment for your company. This course empowers you to be able to provide accountability to your web site development.

Advanced Web Design
This course will teach you how to create dynamic web pages that will change according to the user input without downloading anything from the server. Focus will be on Internet Explorer and Netscape.

Intranet Services How to Utilize your Internal Communications
The Intranet environment is becoming an increasingly valuable tool within a corporation. It is important to produce a well thought out plan of action between the technical issues and the business requirements for the Intranet to be an impactful tool. This course will provide vital information for your firm to begin setup of an Intranet system or to grow your current system.

Intranet/Internet Application Development using Active Server Pages
You will learn how to create intranet/internet applications using a web browser as the front-end and VB scripts in the web server as the back-end. Accessing, adding and modifying information inside an SQL and Access database is also included.

Windows Operating Systems

This course teaches you to install or upgrade to Windows 2000 Professional using automated and remote setup tools, configure and manage hardware devises, drivers, network adapters, and remote mobile hardware. Troubleshooting the Windows 2000 desktop environment - user profiles, desktop settings, multiple locations, fax support and other services, monitor system memory, disc and application performance, implement the TCP/IP network protocol, link computers and shared resources using dial-up and virtual private network connections.