Training

Finance for IT Managers

Course Objectives:

This course will enable the trainee to understand the concepts of finance and apply to IT projects. The trainee will be able to perform cost benefit analysis and prepare business cases.

Curriculum:

  • Time Value of Money - This chapter covers interest rate, present value (PV), Future Value (FV), Net Present Value (NPV) and Payment. It explains how NPV is used for deciding IT Projects.
  • Internal Rate of Return (IRR) - This chapter explains IRR. It presents several examples of IRR. It presents how IRR is used for deciding IT projects as well as the limitations of IRR.
  • Opportunity Cost - This chapter explains the economic value of the best alternative given up by making a decision.
  • Sunk Cost - This chapter explains how the money spent does not impact future decision on a project.
  • Cost of Capital - This chapter explains the concept behind cost of capital and how to calculate one. This rate is used for discounting cash flows for IT projects.
  • Payback Period - This chapter explains the payback period is. It presents a detail example of payback period.
  • Expected Value (EV) - This chapter describes what EV is and presents examples to calculate EV of a project based on different outcome.
  • Expected Annual Cost (EAC) - This chapter presents how to compare machines of unequal lives.
  • Capital vs. Operating Expense - This chapter explains what these are. It presents IT costs and categorizes them into Capital vs. Operating Expense. SDLC Waterfall and Agile methodology are presented and a phase within each life cycle is categorized into Capital vs. Operating Expense. Purchase of package software, customization of package software, software development, equipment purchase and maintenance cost are categorized into Capital vs. Operating Expense with plenty of examples.
  • Depreciation and Amortization - This chapter explains how hardware is depreciated while software and goodwill are amortized with examples.
  • Total Cost of Ownership (TCO) - This chapter explains what the concept behind TCO is. It presents TCO for a server, a web site, an ERP system, a Data Warehouse System and a mobile app.
  • Chargeback - This chapter explains how to develop a chargeback model. It presents examples of chargeback model for a Load Testing CoE, Incident Management System and Private Cloud.
  • Financing vs. Leasing - This chapter explains the concepts behind financing and leasing. It presents examples to explain the concepts.
  • Cost Benefit Analysis (CBA) - This chapter explains the concepts behind cost benefit analysis. It presents examples to explain the concepts. It explains how NPV and IRR play a role in deciding a project from among multiple competing projects.
  • Off Shoring and Outsourcing - This chapter explains the concepts. It presents various scenarios to understand costs associated with off shoring and out-sourcing.
  • Business Case - This chapter presents how to develop a business case. It presents a mobile app project and the sales volume and income statement. In the end, the analysis calculates IRR from the cash flow.

Audience:

IT Project Managers, Aspiring Project Managers, IT Management

Training Method:

This will be instructor led training via WebEx. Trainee will be able to practice establishing and troubleshooting replication along with the trainer.

Duration:

1 Day

Schedule:

Available every Monday and Tuesday starting from 9 AM Eastern Time

Price:

$799.99 per attendee per location

Registration:

Schedule Quantity Coupon Code Buy
 

MySQL Replication

Course Objectives:

This course will enable the trainee to establish and troubleshoot MySQL Replication.

Curriculum:

  • What is MySQL Replication
  • Benefits of MySQL Replication
  • MySQL Replication Configurations
  • Replication Components
  • Methods to synchronize replica from master
  • my.cnf parameters related to replication
  • Commands
  • Replication User
  • Master-Master Active-Active
  • Master-Master Active-Passive Replication
  • Master-Slave Replication
  • Master-Slave-Slave Replication
  • Master-Multiple Slaves Replication
  • Master-Master-Master Replication
  • Master-Master-Slave-Slave Replication
  • Skipping Error
  • Skipping databases and tables
  • Repairing broken replication
  • Troubleshooting Replication
  • Monitoring MySQL Replication

Audience:

MySQL DBAs or Aspiring DBAs.

Pre-requisite:

Understanding of MySQL or any other relational database.

Training Method:

This will be a instructor led training via WebEx. Trainee will be able to practice establishing and troubleshooting replication along with the trainer.

Duration:

1 Day

Schedule:

Available every Friday and Saturday starting from 9 AM Eastern Time

Price:

$799.99 per attendee per location

Registration:

Schedule Quantity Coupon Code Buy
 

Cancellation Policy:

  • Cancellation refunds will be processed based on when the cancellation request is received as follows.
  • Within 1 week - 25%
  • Within 1-2 weeks - 50%
  • Before 2 weeks - 100%
  • Substitutions are allowed.