Instructor Led Department Training in Canada

Oracle 10g 11g Advanced SQL ...on support problems such as ranking (e. g. top earners by department), percentages within a group (e. g. each employees percent of total payroll), cumulative totals (e. g. cumulative salary by department), lag and lead functions (compare to next / previous row - without a self-join), windowing functions and more. Use the Oracle CUBE and ROLLUP extensions to create super-aggregate rows of  more...

Ultraviolet UV Disinfection for Water and Wastewater Treatment Workshop 12 CEUs Daily Schedule: 8: 00am - Registration and coffee (1st day only) 8: 30am - Session begins 4: 30pm - Adjournment Breakfast, two refreshment breaks and lunch are provided daily. Description This course is a practical two-day program, where the emphasis is on learning by doing problems. Each lecture session will be followed by a problem-solving period, where participants can gain further  more...

Wear of Engineering Materials and Protection 18 CEUs ...ications Instructor Dr. D. Y. Li, is a Professor at the department of Chemical and Materials Engineering. His main research interests include surface science and engineering, wear of materials and protection, and functional materials. Dr. D. Y. Li obtained his B. Sc. in Solid Mechanics from University of Science and Technology China (1982), M. Sc. in Solid Physics from Zhongshan University  more...

LEED - Sustainable Design and Operation of HVAC Systems in Buildings 18 CEUs ...r. M. S. Hamed, P. Eng., is an Associate Professor at the Department of Mechanical Engineering and the founding director of the Thermal Processing Laboratory (TPL) at McMaster University. Dr. Hamed has 25 years of industrial experience in the field of thermal engineering, five years of which as Director of Research and Product Development in Canada. Dr. Hamed has developed and presented  more...

ESL - English for Engineers Technicians and Technologists 40 Hrs ... requirements. writing rate change notices informing all departments of changes in an order. writing notes to themselves about action required. writing descriptions on the layout drawings they produce. writing rate change notices informing all departments of changes in an order. writing notes to themselves about action required. writing descriptions on the layout drawings they produce.  more...

Energy Conservation and Management for Industrial Facilities 18 CEUs ...r. M. S. Hamed, P. Eng., is an Associate Professor at the Department of Mechanical Engineering and the founding director of the Thermal Processing Laboratory (TPL) at McMaster University. Dr. Hamed has 25 years of industrial experience in the field of thermal engineering, five years of which as Director of Research and Product Development in Canada. Dr. Hamed has developed and presented  more...

Optimized Product and Service Portfolios - Methods Tools and Applications ... the programs and projects supporting business processes. Department managers need to know the current project and application health in their department level portfolios. Well-implemented portfolio management processes allow stakeholders at all levels of the organization to view the portfolio data and make strategic and tactical decisions. Release and service portfolio decisions address the  more...

Management Training and Leadership Development Your success and hard work has earned you a promotion to Manager. Are you ready? Do you know how to plan for the success of your department, effectively mentor and motivate your team members, manage projects, create budgets and manage people conflicts?  more...