The URL can be used to link to this page

Home My WebLink AboutRESPONSE - RFP - P927 UNIX AIX DATABASE TRAININGCity of Ft. Collins / Larimer County, CO Request For Proposal #P927 Unix/AIX Operating Systems and Oracle Database Administration Training Submitted by Jay Jorgensen Senior Account Manager Batky-Howell, LLC 7245 S. Havana Street, Suite 100 Centennial, CO 80112 Phone: 303-302-5240 Due date: February 26,2004 Batley -Howell, LLC (RFP P927) Havana Street, Suite 100 a Centennial, CO 80112 - 800.868.2202 a 303.302.5300 s Fax: 303.302.5301 Custom UNIX and AIX System Administration for Fort Collins/Larimer County Learn and practice essential administration tasks. Generic system administration concepts are covered and related to specific vendors' systems. AIX specific utilities such as the Object Data Manager (ODM), and the System Management Interface Tool (SMIT) will be discussed where appropriate. Audience: New UNIX and AIX administrators. Prerequisites: Fundamentals of UNIX. Overview of System Administration The Superblock System Administrator Responsibilities The Free List A Brief History of UNIX Slices and File Systems Evolving Standards File System Types Navigating the Documentation Disk Management User Administration Making a File System What is a "user" in UNIX? The mkfs Command The /etc/passwd File Sharing Filesystems Groups The mount Command The /etc/group File The fstab File Passwords The fsck Command Adding Users The lost+found Directory Deleting Users The prtvtoc Command Modifying User Attributes Backups The Login Process Backup Strategies /etc/profile and .profile Backup Tools Communicating with Users: /etc/motd The tar Command Communicating with Users: The wall The cpio Command Command The dump Command File System Basics Network Backup Strategies The Hierarchy UNIX Processes Files Overview of Processes Directories Process Space Device Files Process Table Character and Block Devices The forklexec Mechanism The/dev Directory The ps Command Links Background Processes Symbolic Links The kill Command A File System Tour Scheduling Jobs The df Command The cron Daemon The du Command The at Command The find Command The crontab Command Advanced File System Concepts Format of cron Files The Physical File System Access to Scheduling Facilities The Inode File System Startup and Shutdown File Storage in Disk Blocks Run States All hadnnmlu, reliliatered tredanerb, and scrvfa marks are the Fwarly of their respective owner. Cave content it wbject to cheep. 02004, Batky-Howell, LLC., Rev. 2/04, Custom UNIX and AIX System Administration for Fort Collin/ arimer County Page 1 of 2 The init Daemon Kernel Reconfiguration /etc/inittab Overview of Reconfiguration The inittab Actions Kernel Parameters The init Command Steps to Reconfigure a Kernel The rc Scripts Specific Steps for SVR4 Single -User Mode Overview of NIS The shutdown Command What is NIS? UNIX System Security Why Use NIS? Security Overview NIS Design and Implementation Physical Security NIS Maps Account Security Configuring NIS SUID and SGID Settings File and Directory Permissions Software Security Course Length: 4 days Performance Monitoring and Tuning Performance Issues Methods of Improving Performance Swapping and Paging The sar Utility Using sar The truss Command IP Addressing Basic Network Needs Ethernet Addresses IP Addresses DNS vs /etc/hosts to Resolve IP Addresses Network Addresses Network Classes Broadcast Addresses Subnet Masks Configuring TCP/IP The /etc/hosts File The ifconfig Command The /etc/services File The inetd Daemon The /etc/inetd.conf File Simple TCP/IP Troubleshooting: The ping and netstat Commands The LP Print Service Printing Overview The 1p, 1pstat, and cancel Commands Adding a Printer The 1padmin Command The accept and reject Commands The enable and disable Commands Adding a Networked Printer Other Administrative Commands Network Utilities Network Services telnet - Terminal Emulator ftp - File Transfer rcp - Remote Copy rlogin - Remote Login rsh - Remote Commands An trademarks, registered adenurlm and swim marls are the property of their respective owners. Comae =tees is subject to ch®ge. - 02004, Batky-Howell, LLC., Rev. 2/04, Custom UNIX and ADC System Administration for Fort Collins/Larimer County Page 2 of 2 -B AT K Y I* HOWCLL DUCATINCD PROFESSIONAL -SOFTWARE s- 7245 South Havana Street, Sulte 100 a Centennial, CO 80112.800.868.2202.303.302.5300 a Fax: 303.302.5301 Oracle for Application Developers This course builds a solid foundation for the new Oracle user. Topics covered allow students to become effective Oracle application developers. Students learn how to create, retrieve and manipulate data in a relational database using the Structured Query Language (SQL). PL/SQL is then used to write triggers and stored procedures and packages. The course ends with embedded SQL coverage, utilizing the C programming language for examples. Audience: Programmers involved in developing database applications using Oracle. Prerequisites: Experience in a structured programming language such as Perl, C, Cobol or Java. Relational Database Concepts Relational Databases Tables Keys Relationships Foreign keys Analysis and Design E-R Modeling Entities and Attributes First Normal Form Second Normal Form Third Normal Form Relational Database Management Systems Implementation of Relational Databases Standards RDBMS Features Introduction to SQL DML and DDL System Catalog Connecting to a SQL Database Objects SQL Queries: The SELECT Statement The SELECT Statement Creating Some Order Choosing Rows with the WHERE Clause NULL Values Compound Conditions Subqueries IN and BETWEEN The LIKE Operator Expressions SQL Functions SQL Functions Using SQL Functions String Functions Numeric Functions Date Functions Conversion Functions Data Manipulation The INSERT Statement The UPDATE Statement The DELETE Statement Transaction Management Concurrency Explicit Locking Loading Tables from External Sources Data Definition and Control Statements Standard Data Types Defining Tables DEFAULT and NOT NULL Constraints Column Constraints Modifying Table Definitions Deleting a Table Definition Controlling Access To Your Tables Views and Other Schema Objects Views Creating Views Using Views Indexes Other Database Objects SQL Queries - Joins Selecting From Multiple Tables Joining Tables Joining More Than Two Tables Self Joins Outer Joins Types of Outer Joins Advanced Query Techniques Correlated Subqueries The EXISTS Operator The Aggregate Functions Grouping Rows Combining SELECT Statements All hed=arks, rcgi�M tradeamta, and savim amps arc the FAY of their respwdw ownar. Came wntent is subleet w ehmga 01996-2004, Batky-Howell, LLC., Rev. 10-01, Oracle for Application Developers Page 1 of 2 http:/Avww.batky-howell.con✓courses/datashects/products/ors.htrnl Triggers Declarative Integrity Triggers Types of Triggers Row -Level Triggers Cascading Triggers and Mutating Tables Generating an Error Maintaining Triggers PL/SQL Syntax and Logic Declaring Variables DataTypes Anchored Types Assignment and Conversions Selecting into a Variable IF Statements Comments Loops WHILE and FOR Loops Stored Procedures Stored Subprograms Creating a Stored Procedure Calling a Stored Procedure Passing Parameters Parameter Modes Default Arguments and Named Notation Maintaining Stored Procedures Records and Collections Record Variables Using the %ROWTYPE Attribute Collections Using TABLEs Using VARRAYs Collection Methods Iterating Through Collections Exception Handling SQLCODE and SQLERRM Exception Handlers Nesting Blocks Scope User -Defined Exceptions Cursors Multirow Queries Overview of Cursors Declaring Cursors Opening Cursors Fetching Rows Closing Cursors The Cursor FOR Loop Cursor Parameters The Implicit (SQL) Cursor Using Packages Packages Oracle Built -In Packages The DBMS —OUTPUT Package Using DBMS _OUTPUT The UTL_FILE Package The DBMS _UTILITY Package Creating Packages Structure of a Package The Package Interface and Implementation Subtypes Package Variables Overloading Package Functions and Procedures Package Management Stored Functions Procedures and Functions Creating a Stored Function Calling a Stored Function Stored Functions and SQL Maintaining Stored Functions Embedded SQL Embedded SQL Overview of an ESQL Program Compiling an ESQL Program Connecting and Selecting The DECLARE Block Host Variables - Connecting to the Database Query Statements DML Statements Transactions and Error Handling The SQLCA Structure WHENEVER NULL Values Indicator Variables Transaction Management Course Length: 5 days, $1,975 All tredwmr{a, resinaed teedernerim, and service mmlm are the peepwy of their respative owners. Comae ecetent it subject to clients, ® 1996-2004, Batky-Howell, LLC., Rev. 10-01, Oracle for Application Developers Page 2 of 2 http://www.batky-howell.coni/courses/datasheeWproducts/ora.htrri • • • DEVZL<DPEARS 7245 South Havana Street, Suite 100 a Centennial, CO 80112 - 800.868.2202 - 303.302.5300 - Fax: 303.302.5301 Oracle8i Database Administration This course will teach students the fundamental skills required to manage Oracle databases. Students will learn database administration skills by designing, setting up, configuring, and managing their own Oracle8i server. By the end of the class, each student will have gone through the main tasks necessary to manage Oracle8i databases. New Oracle8i features such as the Oracle8i JVM, locally managed tablespaces, partitioned tables, global and local indexes, index -organized tables, function -based indexes, object -relational features, the large pool and the Java pool will be covered. Audience: Non-Oracle8i database administrators, application developers, and system administrators. Prerequisites: Oracle for Application Developers. Previous working experience with Oracle is recommended. A solid understanding of SQL and PL/SQL is required. A base understanding of the operating system used for class (UNIX or NT) is needed as well. Understanding the Oracle8i Server Architecture Responsibilities of a DBA What is an Oracle Server? Oracle Versioning Server Architectural Overview Operating System Environment Important Subdirectories in ORACLE —HOME Oracle Product Subdirectories Oracle Instance Components Database and Control Files Redo Log Files Logical Storage Structures Blocks, Extents and Segments Tablespaces Logical Structural Design System Change Numbers Oracie8.0- The Object -Relational Release Oracle8 Size Ceilings Oracle8i- The Internet Release Oracle Architectures Optimal Flexible Architecture Optimal Flexible Architecture Requirements Oracle Memory Structures and Processes Database Buffer Cache The LRU and Dirty Lists Server Processes and the Buffer Cache DBWR and the Buffer Cache Checkpoints Determining When Checkpoints Occur Defining Multiple DB Cache Buffer Pools Defining the Database Buffer Pools Database Buffer Pool Initialization Parameters The Buffer Pool Parameter Defining Storage for Buffer Pools Calculating the Hit Ratio for Buffer Pools Latch Contention Caching Tables Calculating Cache usage of Schema Objects Redo Log Buffer Cache Shared Pool Area Large Pool Area and Parameters Java Pool Size Sort Enhancements Background Processes Server Processes and Executing SQL Program Global Areas The Parse and Fetch Phase Processing DML Statements Rule and Cost -Based Optimizers Tuning Parallel Query Parallel DML Using the Data Dictionary What is the Oracle Data Dictionary? Base Tables and Static Views in the Data Dictionary Dynamic Views in the Data Dictionary ALL _%, DBA _%, USER_% Views V$ and GV$ Views Starting and Shutting Down an Oracle Server Database Utilities New SQL*Plus Features in Oracle 8i The Server Manager Tool Specialized DBA Commands Set and Show Commands The Parameter File Oracle Installer All trademark$, registered "demerits, and service marls are the property of their respective owners. Course content is subject to change. ® 1998-2004, Batky-Howell, LLC., Rev. 4.3.3 Ver 4.5.0, Oracle8i Database Administration Page 1 of 3 http://www.batky-howell.com/courses/datasheets/products/o8dba.html The Database Configuration Assistant Setting up a Parameter File Important Parameters for Database Creation Starting an Oracle Server Shutdown Steps Alert and Trace Files Database Limits Dynamic versus Static Parameters Creating an Oracle Instance and Database Preparation for Creating a Database Follow OFA Guidelines Installing Oracle Steps for Creating a Database Setup for Unix and NT Removing Oracle Servers and Software Things to Consider when Creating a Database Creating a Database Script Preinstalled Users and Roles Troubleshooting Database Creation Managing Tablespaces and Data Files Logical and Physical Structures The SYSTEM Tablespace CREATE TABLESPACE Command and Clauses Dictionary -Managed Space Locally -Managed Tablespaces ALTER TABLESPACE Command Temporary Tablespaces CREATE TEMPORARY TABLESPACE Read-only Tablespaces Coalescing Dictionary Managed Tablespaces Taking Tablespaces ONLINE and OFFLINE Renaming a Data File Adding More Space to a Database Autoextending a Data File DROP TABLESPACE Command Converting Dictionary and Local Tablespaces Transportable Tablespace Managing Tables Creating Tables Column Datatypes Global Temporary Tables Clustered Tables Database Block Row Migration and Training Storage Clause Options and Parameters Moving Tables Removing Data from Tables Renaming Tables Modifying Column Definitions Segment High Water Mark _ Calculate the HWM of a Segment The TRUNCATE Command Oracle8i Indexing Index Attributes and Types B*Tree and Composite Indexes Reverse Key and Bitmap Indexes Cluster (B*Tree) Indexes Index Organized Tables Function Based Indexes Domain Indexes Index Options and Maintenance Analyzing and Rebuilding the Index Indexes on Primary Keys Export and Import of Indexes SQL*Loader and Indexes Managing Constraints Data Integrity Column and Table Constraints Constraint Names Primary and Foreign Key Constraints Unique and Not Null Constraints Check Constraints Enabling and Disabling Constraints Creating and Setting a Deferred Constraint Managing Rollback and Temporary Segments Data Dictionary Views on Storage Structure Rollback Segments Private versus Public Rollback Segments Typical Layout for Rollback Segments Sizing Rollback Segments The OPTIMAL Parameter ALTER/DROP ROLLBACK SEGMENT Tablespaces and Temporary Segments Administration of Control and Redo Log Files Control File Contents Working with Control Files Multiplexing Control Files Log Sequence Numbers Reviewing Checkpoints Instance Recovery Optimize Checkpointmg Controlling DBWR Activity Multiple DBWR IO Processes Adding and Clearing Online Redo Log Files Dropping Online Redo Log Files Renaming Online Redo Log Files Setting up Archiving in Oracle8 ARCHIVE LOG LIST command Data Dictionary Views for Redo Log Files Managing Users and Profiles Create and Alter Users Creating Profiles Database Resource Limits Security Guidelines Security Administration System Privileges Roles All "&m b, registered trademarks, and service marks ere the property of their respective owner. Course content is subject to change. ® 1998-2003, Satky-Howell, LLC., Rev. 4.3.3 Ver 4.5.0, Oracle8i Database Administration Page 2 of 3 http://www.batky-howell.com/courses/datEtsheets/products/o8dba.htmi Granting and Viewing System Privileges Granting Object Privileges Privileges and the User Group PUBLIC Revoking System Privileges and Roles Object Privileges Database Authentication Predefined Roles Setting up a Role Guidelines and Standards for Roles Advanced Security Features Enhanced Security Password Management Password Resource Limits and Complexity Defming a Profile with Password Limits Defining a Profile for a User Data Encryption Implementing a Security Policy Implementing an Application Context Unique and Shared Schemas Enterprise User Management Oracle Wallets Radius Authentication Dial -In User Service Oracle Security Management N-tier Authentication/Authorization Introduction to Partitioning Managing Large Tables with Oracle? Oracle8 Size Ceilings Oracle Data Storage What is Partitioning? Creating a Range Partitioned Table The Partition Key Partition Syntax Range Partitioning Advantages of Partitioning Accessing a Partitioned Table Using MAXVALUE Partitioning Rules to Follow Partition Extended Table Name Syntax Restrictions on Partition Extended Name Multi -Column Partition Keys Inserting into a Multi -Column Partition Key Modifying Partition Key Values Setting Physical Attributes for Partitions Hash and Composite Partitioning Partition Pruning Partition -Wise Joins Composite Objects Global Prefixed Indexes Local Partitioned Indexes Local Non -Prefixed Indexes List Partitioning in Oracle9l Managing Partitioned Objects New DDL Commands for Partition Management Privileges for Working with Partitions Unusable Indexes New Plan Table Adding and Merging Partitions Dropping and Renaming Partitions Truncating and Modifying Partitions Modifying Default and Logical Attributes Moving and Splitting Partitions Making Local Indexes Usable DDL Operations on Composite Partitioned Tables Subpartition Operations SQL*Loader and Partitioned Objects Export, Import, and Partitioned Objects Database Triggers Event Functions Database Trigger Event Attributes Schema Triggers and Client Events Advanced Cost -Based Optimizer Features Cost -Based Optimizer Enhancements Generating Statistics Stored Outlines Oracle Utilities and Managing Data Oracle Utilities The Export Utility Export Modes and Parameters Import Utility and Parameters Rebuilding a Database Logical Backups Direct -Load Inserts SQL*Loader Conventional versus Direct Path Loads The Control File DBVERIFY Loadjava and Dropjava Oracle8i's JVM Architecture (EJE) The Move to Java Java Virtual Machines Oracle's Enterprise Java Engine 300% Java Features of Oracle's EJE Aurora Java Database Connectivity Oracle Java and Object Based Products Oracle JDeveloper JDeveloper File Types and Environments Course Length: 5 days, $1,975 All trademarks, registertd Imdemarks, and service marks arc the propwy of their respective ownm. Course content is subject to change. m 1998-2003, Batky-Howell, LLC., Rev. 4.3.3 Ver 4.5.0, Oracle8i Database Administration Page 3 of 3 http://www.batky-howell.com/courses/datasheets/products/o8dba.httnl mArrtudaD 6220 Greenwich Drive San Diego, CA 92122-5988 Batky-Howell Inc. 10333 East Dry Creek Road, Suite 150 Englewood, CO 80112 To whom it may concern: I would like to take a moment to let you know what an outstanding job your organization has done. We have been delighted with the quality of training that Batky-Howell has provided. Batky-Howell remains a favorite of ours for training. This is because of their friendly, knowledgeable instructors who teach cirriculums that are no-nonsense and no fluff. Setting up classes has been an effortless task. Our engineers and management staff have had nothing but good things to say about the training they have received from your establishment. Our account manager, Curt Bellum, has been excellent to work with. He has always been there to answer our questions, help us determine what training is best for us, and do whatever is necessary to meet our needs. He is very professional and efficient. Aside from that, he is a sure pleasure to talk with! What Batky-Howell does better than other training vendors that we have worked with is that they understand the needs of the industry and their customers. The content of the courses is always at the appropriate level and the instructors are educators, not just facilitators. Students are excited to go to the courses and walk away with a newfound understanding for the subject matter. This value -add that Batky-Howell provides is why we will continue to call on Batky-Howell for future training services. Sincerely, Ao&ido Anna McCormick Project Manager OppenheimffRinds TheRotWaytohest Batky-Howell, Inc. 10333 E Dry Creek Rd, Ste 150 Englewood CO 80112-1562 Dear Sir or Madam: OppenheimerFunds 6803 S Tucson Way Phone 303 768 3249 Englewood CO 801123924 Fax 303 645 0956 I warded to let you know what great experiences I've had working with Batky--Howell as one of our education vendors. FrA, every time I've scheduled a class to be held in-house, I've been given a'heads up' on the instructor and what their background is. Materials are always delivered early and dearly marked, which has been a great help when there have been two or more classes being taught concurrently. Also, our contrails for on -site classes are easfly understood, usually comparable to prices offered by othervendors, and have always been done in a timely manner. Another positive we ve experienced is the on -site course curriculum. There have been several occasions in which we've made requests to have specific things included, excluded, or even combined with another class. In most instances our requests have been granted immediately and done exactly as we've asked. I've had several co-workers, including upper management, comment on the flexibility of Batky-Howell and how accommodating they have been. Ngxtvsould be the quality of training we've received from Balky -Howell, both in public and private classes. I often receive comments from people who have participated in classes from different vendors that the Batky- Howell courses are some of the best they've attended. One specific example would be the Fundamentals of Software Testing class which we've brought in-house several times due to the course content and knowledge of the instructors. Having certified instructors for different types of courses (Le.: Java) is a positive factor as well. Many of our technical people have backgrounds in the course(s) being taught so it's nice to know we're getting instructors who should be truly -knowledgeable in the subject. Lastly, and very importantly, is OppenheimerFunde account manager. His ability to work with his group at Batky-Howell to ensure timely responses for contracts, curriculum, etc to the satisfaction of everyone involved is fantastic. There have been several occasions when I've relied on his organizational skills to help straighten out issues involving cancelled classes or credits held for public courses. He has also been more than willing to suggest vendors who might offer a class needed although Batky-Howell doesn't offer that particular course. I appreciate the confidence of knowing whatever we've asked of him, he's done his best to help. His positive naturee and upbeat attitude are always refreshing, as well as his ability to be friendly yet professional at all times. I enjoy working with Batky-Howell and look forward to continuing to do so in the future. Sincerely )4au Kristi Woodward OppenheimerFunds CTG Training Coordinator TRW Systems & Information Data Systems Operations Technology Group 16201 Centretech Parkway Aurora, CO 80011 To Whom It May Concern: TRW has had wonderful experiences working with Batky-Howell. Our Account Manager as done everything possible to make our learning experiences both effective and enjoyable. In working with Batky-Howell, we have had the opportunity to meet our specific corporate training requirements through customized, turnkey training courses. The staff at Batky-Howell takes care of enrollment through course completion. During our initial contact with Batky-Howell, we asked if we could review the curriculum for their JAVA Programming courses. During our review we decided that the most efficient way for us to go was to have the course content customized to meet our corporate requirements. When I requested this tailoring, our Account Manager was more than happy to accommodate. He set-up meetings with the Batky-Howell instructors and own our in-house JAVA programming specialists. This has provided TRW with high quality; just in time training that can be immediately applied in the work environment. The quality of the courses is top-notch. We receive student evaluations after each course offering and all students have rated the BH courses as some of the best they have ever attended. A number of our learners have mentioned that on numerous occasions, the instructors have gone past the normal class time to provide additional help for the entire class or even an individual. In as much as technology training is becoming increasingly expensive, Batky-Howell provides high quality training at very affordable prices. They also provide all of the support resources necessary to assist trainee in learning the material. We are very happy with the partnership that we have established with Batky-Howell and intend to continue this arrangement. In the future we will be adding a number of course to our course list and we intend for Batky-Howell to be our supplier. Ray MAL, Learning and Organizational Development Manager TRW lnc, RFP #P927 - Unix/AIX and Oracle Database Administration Training Batky-Howell, LLC appreciates the opportunity to bid on the training for Ft. Collins / Larimer County. Included in this Proposal is background information about Batky- Howell and our ability to deliver all the courses that are listed in the RFP. Also included are testimonial letters from existing clients, plus a sample class evaluation form that we can provide for students to complete after each class. Also included in this Proposal are Batky-Howell's standard course outlines for each of the required classes. As addressed below, these outlines can be modified if necessary to meet any unusual needs, so long as our technical experts believe that the flow and content aren't adversely affected in such a way that the learning experience is unreasonably compromised. Hereunder, we address each of the criteria listed in the "Training Requirements" section of the RFP: Location: Batky-Howell is comfortable with the training environment as described, and we are happy to liaise closely with nominated CRISP technicians to ensure that the necessary setup is completed in advance of each class. We understand that CRISP will provide all hardware/software required for classes, but we are available to assist where necessary. Please note — some of the classes specified have quite complex setup requirements and will need advance planning and cooperation between our technical staff and CRISP's. Batky-Howell assumes no responsibility for the availability of suitably -configured hardware or software licenses. Schedule: Batky-Howell accepts that all training sessions need to,be completed between March and June, 2004. We are completely confident that we can meet these deadlines unless there are extenuating circumstances beyond our control — such as unexpected and substantial schedule changes by CRISP. We can certainly accommodate reasonable date changes within the designated timeframe, but would appreciate at least 10 working days' advance notice of any re -scheduling. Class Length: Batky-Howell has reviewed the class outlines supplied within the RFP and agrees to the durations nominated for the specific content therein. We also agree to amend such durations according to any agreed modifications to content. Tailoring: Batky-Howell specializes in customized classes, and we are therefore admirably equipped to meet this requirement. Indeed, a very large proportion of our on - site classes are modified in some way to meet the customers' needs, and our modular courseware methodology makes it a simple matter to produce customized workbooks on demand. Class Hours: Batky-Howell agrees to the class times defined in the RFP. Our professional instructors typically arrive 15-30 minutes before class each day in order to help the students get settled and to ensure a timely commencement to training. Balky -Howell, LLC (RFP P927) i ,CAI. Metavanter- Metavante Corporation 4900 West Brown Deer Road Milwaukee, WI53223-2459 metavante.com January 15, 2003 Dennis J. Sinnott Regional Manager Batky-Howell, LLC 10333 East Dry Creek Road, Suite 150 Englewood, CO 80112 Dear Dennis: Batky-Howell has provided Metavante Corporation with superior technical training services for nearly four years, delivering high quality curricula in JAVA2, XML and other technologies. Your organization is a valued partner in developing Metavante's technical resources and has demonstrated excellence in the following ways: • Providing knowledgeable and professional instructors who are not only good trainers but have credible experience with the technology that they are teaching • Willingness and ability to customize classes to meet Metavante's needs • Flexible pricing strategies to make training affordable • Rapid response to requests for support . We enjoy working with you and look forward to a continued partnership is providing quality education to Metavante employees. Sincerely, )0 G2 6 /D Patty Rogers Human Resources Manager, HR Education & Development Technology Subsidiary of Marshall & Ilsley Corporation Your Name: Your Company: Class Location: Course Evaluation Course: Date: Instructor: The purpose of this evaluation is to obtain student reactions to the course. We constantly strive to improve our courses and this information will provide feedback to guide us. Please rate each of the following by circling the appropriate number as follows: 5=Strongly Agree, Instructor Effectiveness 4=Agree, 3=Neutral, 2=Disagree, 1=Strongly Disagree The goals of the course were made clear by the instructor. The goals of each module were made clear by the instructor. The instructor explained concepts and techniques clearly and accurately The instructor has technical mastery of the material. The instructor encouraged questions and student interaction. The instructor answered questions accurately and clearly. The instructor was readily available for assistance when needed. The instructor demonstrated professional attitudes and behavior. 5 4 3 2 1 5 4 3 2 1 5 4 3 2 1 54321 5 4 3 2 1 5 4 3 2 1 54321 5 4 3 2 1 Specific comments about the instructor (What did you like most? What suggestions would you make for improvement of teaching effectiveness?): 2-MISC-EVAL Over 4 Materials and Environment Effectiveness The student workbook was effective as a learning tool. The student workbook was useful as a reference. The student workbook was easy to follow, The information in the student workbook was up to date. The lab exercises exemplified real situations and uses for the lecture topics. The lab exercises offered opportunity for expanding on lecture topics. The level of difficulty of the lab exercises was appropriate. Sufficient time was allowed to do the exercises at the end of each chapter. The pace of the course for you was (circle a number): 5=Too fast 4=Fast 3=Just right 2=Slow 1=Too slow 54321 5 4 3 2 1 54321 5 4 3 2 1 5 4 3 2 1 54321 54321 5 4 3 2 1 Specific comments about the student materials, computer equipment and classroom environment. (What did you like most? What suggestions would you make for improvement of materials, classroom, or equipment?): Overall Trainina Experience Did this course meet your objectives? If not, why not? What changes would you recommend to this course or to Batky-Howell training in general? What additional courses would you be interested in attending? May we please use your comments, name, title and company in our marketing? (circle one) Yes No _ YESI I would like to receive information about new courses in a quarterly email newsletter. E-mail: Do you know someone that would benefit from this training? If you would like us to contact them, please provide any information you can. Their Name: Title: Company Name: Phone: 11/14/02 S AT f< Y 0 i-IOW£LL 10333 £ost Dry Creek Rood, Suite 150 a £ngiewood, CO 801 12 a $00.868.2202 a303.302.5300 a Fcm 303.302.5301 Why Use Batky-Howell? 1. Training is Our Business - Batky-Howell's only focus is training. From the moment a class is scheduled, the entire company is working to make sure the class is a success. For over 10 years, we have focused all of our company resources on assuring that every class not only runs well, but delivers the best learning experience for every student. If your company needs one class or ten classes in a week, we can support you. We have trained over 30,000 students in 3,200 classes ranging from HTML to Advanced topics in UNIX, Java, Oracle and more. 2. Courseware - The majority of our courseware (student manuals) is written by our own developers and instructors. Our courseware is continually updated. We not only strive to include the most recent versions, but also incorporate enhancements suggested by students and corporate customers. You will find that our courseware has the most relevant material, covered in the shortest period of time. Our hands-on instruction uses real -world project methodology, which better prepares students to quickly apply what they've learned to their business applications. We have over 40 titles, covering 143 days of training with 14,000+ pages of in-house developed technical courses. 3. Course Content - Our courses are designed to make students more effective on the job: not more effective at passing a test. Our courses will prepare students for various certification tests, but the focus of the courses is knowledge transfer, not knowledge overload. Since the courseware is regularly updated, the course content becomes more focused on what students need to know in order to be more productive at their job. Our courses include hands-on labs with solutions, so students practice what they learn. The hands-on experience, 34 hours per day of training, increases both retention and the student's comfort level with new material. 4. Instructors - We have a staff of full-time Batky-Howell instructors. These people are hired using rigorous screening techniques and they continue internal training to ensure effective teaching. All of our instructors. have professional programming experience that they can use as examples to ensure that students gain real -world skills. Many have helped write the courseware that they use. They not only have an in-depth knowledge of the topic, but specific familiarity with the courseware. Many of our instructors are certified in Java, Oracle, or Microsoft — their areas of expertise. Over 100 resumes are read and 25 interviews conducted to hire just one instructor. 5. Customization and Cost Control - We know how to customize. 50% of our business is just that: customized courses! We are ready to customize our courses to your specific needs and budget. If students only need 75% of a particular course, an account manager will work with you to make sure the cost and content reflect just that. We know each customer is different. Giving customers flexibility results in better classes at the right price. 6. Continued Support - Once a class is completed, students are encouraged to contact Batky-Howell instructors about material covered in class. This support is added value to your training experience. The student always has a technical resource when they get back to the office and start working on their specific project. We also offer short-term mentoring, in which our instructor can come to your site and work with your staff and project directly. 7. Virtual Training (VClass)- Batky-Howell now delivers all of our instructor -led courses over the Internet. The combination of live interaction (not CBT or e-learning) with a Batky-Howell instructor, chat sessions, polling, and on-line white boards make it as close to being in the classroom as you can get - without the travel costs! 8. Flexibility - Our modular courseware, VClass capabilities and highly -qualified instructors allow us the flexibility to meet our customer's specialized needs. We can take a course, tailor it to your specifications, and then deliver it to students in Los Angeles, New York, and Chicago simultaneously. Neither students nor instructor ever have to get on an airplane. And we can do all of this without compromising the quality of our courses. sB AT K Y 19 i--IOW £ L L 7245 South Havana Street, Suite 100 • Centennial, CO 80112 x 800.868.2202 0 303.302.5300 r Fax: Crystal Reports 9.0 Quick Start Workshop This 2-day workshop is designed for beginning users with little or no exposure to Crystal Reports. The intent of the course is to familiarize the students with the Crystal Reports environment and get them up and reporting quickly. The workshop provides the basic steps for creating, modifying, saving and viewing reports to more flexible tasks such as basic formulas and the powerful automated features. Audience: Administrators, developers and end -users who need to create dynamic reports from varying data sources. Prerequisites: Working knowledge of Windows 9x-2000 environment is required. Familiarity with relational database concepts (tables, fields and records) is strongly recommended. Before You Begin Defining the Purpose of the Report Determining the Layout of the Report Finding the Data Organizing the Data for the Report Creating a Simple Report Starting the Crystal Reports Program Starting a New Report Choosing a Data Source The Main Components of the Design Window Exploring the Toolbars Managing Resources with Explorers Placing Fields on the Report Selecting and Sizing Objects Browsing Field Data Moving and Aligning Objects Using Guides and Guidelines to Move and Align Objects Creating Text Objects Saving the Report Autosaving the Report Previewing the Report Refreshing the Data Getting Help Formatting Features Quick Formatting with the Template Expert Formatting Objects Inserting Lines and Boxes Drawing a Line Drawing a Box Inserting Graphics Working with the Page Commands Changing Page Orientation Changing Margins Working with Text Objects Adding Fields into a Text Object Formatting Part or All of an Object Inserting Special Fields Selecting Specific Records from the Database Filtering Data with the Select Expert Selecting Records with Multiple Criteria Viewing and Editing the Select Formula Case Sensitive vs. Case Insensitive Record Selection Formula Templates Grouping and Sorting Data for Summary Purposes When and Why to Group Records Creating a Group Group and Sort Direction Customize Group Name Field Modifying Groups Creating Multiple Groups in a Report Using the Group Tree to Navigate the Report Reordering Groups Summarizing Groups Additional Summary Options Grouping Data in Date/Time Intervals Calculating Percentages Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables Understanding Tables, Records, and Fields Learning About Linking Adding Multiple Tables to a Report Creating and Using Formulas Understanding Crystal Formula Syntax without Being a Programmer About the Formula Workshop Using the Formula Workshop Using the Formula Editor An trsdamdn, reprt'ered tradmusIu, and service nwiu ere the property of their respective onnmr. Coupe content ie subject to dump. Batley -Howell, LLC., Rev.12-2"2 Crystal Reports 9.0 Quick Start Workshop Page 1 of 2 http://www.badcy-howell.com/courses/datasheets/productatcr9Ogs.hbW The Formula Editor Toolbar Performing Simple Number Calculations Manipulating Dates with Formulas Creating Boolean (True/False) Formulas Creating String Formulas Using Bookmarks to Navigate Through Formulas Conditional Formatting The Highlighting Expert Setting Highlighting Priorities Formatting Sections Formatting Sections Conditionally Conditionally Formatting Fields Creating Summary Reports and Charts Creating a Summary Report Applying the Drill Down Feature Applying the DrillDownGroupLevel Producing Charts Editing Charts Formatting Charts Using the General Chart Options Modifying Individual Objects in the Chart Using Auto -Arrange Chart Applying Chart Templates Exporting Report Results Within Your Organization Understanding Export Formats and Destinations Using an HTML Format for Crystal Reports Exporting to Windows Applications Exporting to a Report Definition Format Setting Default and Report Options Setting the Default Layout for Design and Preview Views Using the Report Wizards What are the Report Wizards? Create a Report Using the Standard Report Creation Wizard The Data Dialog Box The Fields Dialog Box The Grouping Dialog Box The Summaries Dialog Box The Group Sorting Dialog Box The Chart Dialog Box The Record Selection Dialog Box The Template Dialog Box Mapping Lesson Objectives Understanding Maps Map Layouts Map Types Formatting the Map Drilling Down on Maps Using the Analyzer Tab for Advanced Mapping Changing the Geographic Map Using the Map Navigator Changing Map Layers Resolving Data Mismatches Creating an ODBC Data Source to Attach to a Database Creating an ODBC Connection to Any Database Course Length: 2 days, $695 All Wedmadu, teaiaeted ufdmw&s, and service mats are the propaty of theirtapeWw my . Came amfmt is sutdca to chm p. ®2003, Batky-Howell, LLC., Rev.12-26-02 Crystal Reports 9.0 Quick Start Workshop Page 2 of 2 http://www.batky-howell.com/courses/datasheetglpmduct&/cr9Ogs.htmi Ak S AT i< Y iw HOW £ L L 7245 South Havana Sheet, Suite 100 - Centennial, CO 80112 a 800.888.2202.303.302.5300 -Fax: 303.302.5301 Custom Fundamentals of UNIX/AIX for Fort Collins/Larimer County This course provides a comprehensive introduction to the full range of UNDUAIX user commands and utilities, Students will develop shell programming and vi editing skills. Any differences between System V Revision 4 (SVR4) and AIX will be discussed during class. Audience: End -users and programmers who are new to the UNIX and ADC environment. Prerequisites: None Getting Started What is UNDO? A Brief History of UNIX Logging In Logging Out Try a Few More Commands Changing Your Password Using On-line Manuals The File System - Files What is a File? The Is Command The cat Command The more and pg Commands The head and tail Commands The cp Command The my Command The rm Command File names The File System - Directories Hierarchical File System Pathnames The pwd Command — Print Working Directory The cd Command — Change Directory . The mkdir Command — Make Directories The rmdir Command - Remove Directories The cp Command (again) Copy Files Two useful directory names — . and.. Editing With A What is vi? The vi Buffering Process Command Mode and Insert Mode Modes Diagram Getting Started Moving the Cursor Around Inserting Text Deleting a Character or Line Undo Last Command Opening a New Line Save Your Work or Abort the Session Review of vi Commands More Editing With vi Scrolling the Buffer Cursor Motion Commands — w, W, b, B, e, E Cursor Motion Commands - $,"0, G Cursor Motion Commands — f, t, F, T Delete Operator - d Change Operator - c Yank Operator - y . Put Commands — p, P Searching For a Pattern - /, n, N, ? The join Command The file Command - :f Edit file Command - :e Cut and Paste Between Files Read file Command - :r Set options Command Set options Command - .exre file Personal Utilities The date Utility The be Utility The expr Utility The cal Utility The news Utility The id Utility The uname Utility The finger Utility The script Utility The clear Utility Appendix: The at and crontab Utilities Text Handling Utilities The grep Utility The tr Utility All tradematlu, registered tradanadu, and service ma b are the prop" of their respective owners. cause content is ntiect to change. - ® 2004,13atky-Howell, LLC. Rev.2/04 Custom Fundamentals of UNDUAIX for Fort Colliml-arimer County Page I of 2 The cut Utility Flow Control The paste Utility The Exit Status of Commands The sort Utility Command Line Examples The we Utility The test Command The diff Utility The if -then -else Construct The 1p Utility The ehf Construct File System Security A loop Example File Permissions Variables The chmod Utility User Created Variables Directory Permissions The read Command The umask Command The Shell Environment File System Management Utilities The export Command The find Utility Sub -shells The df Utility Command Substitution The du Utility Quoting Mechanisms Compressing Files Assigning Variables — Summary The In Utility Special Variables The ulimit Utility Command Line Arguments The tar Utility $# - Number of Arguments Communication Utilities The shift Command The write and talk Utilities $ * - All Arguments The mesg Utility $$ - PID of Shell Mail Overview More Flow Control The mail Utility The for Loop The mailx Utility The while Loop Using the Shell The Case Construct What is a Shell? Appendix: Korn shell features Which Shell? Viewing your Command History The Command Line Editing and Re -executing Commands Standard Input, Standard Output and Standard Aliases Error Using Default Standard In and Standard Output Course Length: 4 days I/O Redirection Appending Output of a File Pipes The tee Utility Filename Generation Filename Generation The ? special Character The * special Character The ( ] special Characters The ! special Characters UNIX Processes What is a Process? Process Structure The ps Utility Options to the ps Utility Background Commands (&) Killing Background Processes Redirecting the Standard Error Shell Programming Concepts What is a Shell? What is a Shell Script? Why Use Shell Scripts? All tredwwh, mglitmd Irmdenah, sod swvim mer6 ere the p,upmy ofowir mpa w ovmm. Came content a subject to chmae. ® 2004, Batlry-Howell, LLC. Rev.2/04 Custom Fundamentals of UNIX/AIX for Fort Collins/Larimer County Page 2 of 2 CDUCATINO PROFCSSIONAL, SOFTWARE:. • - 7245 South Havana Street, Suite 100 a Centennial, CO 80112 - 800.868.2202 a 303.302.53DO a Fax: 303.302.6301 Custom Advanced UNIX/AIX Tools for Fort Collins/Larimer County In this course, students develop more advanced skills in using UNIX and AIX tools. Users increase their productivity by teaming how to create powerful korn shell scripts for processing text, managing files, and performing other complex tasks. Additional emphasis on subjects such as Pert can be added to the delivery of this course. Audience: Users, programmers, and system administrators who wish to develop advanced skills in UNIX or AIX. Prerequisites: Fundamentals of UNIX or equivalent practical experience. ex and vi Options Shell Commands ex and vi — Two Editors in One Command List Separators ex and vi — Options Control Flow - Conditionals How to Set Options Within vi The case Construct How to Set Options in .exrc Control Flow - Loops A Buffers The trap Command The Unnamed Buffer Korn Shell Features Named Buffers Aliases Cutting and Pasting Between Files Command History The :next Command Functions The Delete Buffers The print and read Commands Shell Interaction - Extending A The set Command File Name Shortcuts in vi Introduction to sed Invoking Shell Commands - ex About sed Reading the Output of a Command Why Use sed? Invoking Filters from vi Invoking sed A Macros How sed Works What are Macros and Why? Using sed The :map Command sed Addressing The vi Quote Mechanism sed Addressing - Formats Markers sed Functions Executing Commands from a Buffer Introduction to awk Regular Expressions Introduction to awk What is a Regular Expression? How awk Programs Work Literal Regular Expressions Running awk Programs Regular Expressions: ^, $, � . [s] Awk Patterns Regular Expressions: *,1(m n1) Summary of Patterns Subexpressions BEGIN and END Shell Programming Expressions Filename Generation String -Matching Patterns Parameters Extended REs m awk Named Parameters Range Patterns Positional Parameters Overview of Pert Special Parameters What is Pert? Parameter Substitution Running Perl programs Here Documents Sample Programs All trsdernerb, registered tradenurlu, and service marb are the property of their respective owners. Coupe eaoteat is subject to change. 0 2004, Batky-Howell, LLC., Rev, VO4, Custom Advanced r iNIX Tnnls fnr l n.+ r^n:,,en ... -- r .._.. _ __ 1 _ t 1 Course Length: 4 days All umhnaka, reaiamed vsdmmb, and mavim mule me the prop" of than m"mctive owme. Coupe cameos is auhjea to climge. 0 2004. BaOcv-Howell. LTP_ Rr Wnd AAwnrnA TiNTV Tnm.. n...-e o -e,