Finance for IT Managers Simplfied

This book offers valuable finance concepts to IT Managers and Project Managers so that they can carry out cost benefit analysis, develop a business case to justify ROI of a project, secure funding and execute the project. NPV, IRR, Payback Period, ROI, TCO, Capital vs. Operating Expense, Depreciation & Amortization, Outsourcing & Offshoring, Cost Benefit Analysis and Business Case are presented in detail. This book presents wide array of examples in each chapter with easy to understand diagrams. In the end, the reader will be comfortable with IT Finance concepts. This book covers the following.

  • Chapter 2 – 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.
  • Chapter 3 – 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.
  • Chapter 4 – Opportunity Cost – This chapter explains the economic value of the best alternative given up by making a decision.
  • Chapter 5 – Sunk Cost – This chapter explains how the money spent does not impact future decision on a project.
  • Chapter 6 – 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.
  • Chapter 7 – Payback Period – This chapter explains the payback period is. It presents a detail example of payback period.
  • Chapter 8 – Expected Value (EV) – This chapter describes what EV is and presents examples to calculate EV of a project based on different outcome.
  • Chapter 9 – Expected Annual Cost (EAC) – This chapter presents how to compare machines of unequal lives.
  • Chapter 10 – 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, eqlipment purchase and maintenance cost are categorized into Capital vs. Operating Expense with plenty of examples.
  • Chapter 11 – Depreciation and Amortization – This chapter explains how hardware is depreciated while software and goodwill are amortized with examples.
  • Chapter 12 – 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.
  • Chapter 13 – 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.
  • Chapter 14 – Financing vs. Leasing – This chapter explains the concepts behind financing and leasing. It presents examples to explain the concepts.
  • Chapter 15 – 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.
  • Chapter 16 – Off-Shoring and Outsourcing – This chapter explains the concepts. It presents various scenarios to understand costs associated with off shoring and out-sourcing.
  • Chapter 17 – 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.
MySQL Replication Simplified

MySQL Replication Simplified explains how the replication process works and what the benefits are. Then, it provides detailed step-by-step east to understand examples with visuals to set up a variety of replication configurations including the process of copying master to replica, making configuration changes and commands to establish replication. This book offers ways to troubleshoot, especially to interpret errors and to repair broken replication. In the end, it provides a mechanism to monitor working replication to alert on the event of replication issues.

This book covers the following topics.

  • What is MySQL Replication
  • Benefits of replication
  • How replication process works
  • Replication configurations
  • Components of Replication system
  • Approach to replication
  • Copying master to replica
  • MySQL configuration parameters
  • Commands useful to establish replication
  • Setting up of replication user account
  • Establishing various replication configurations
  • Skipping SQL Errors
  • Experimenting with auto increment variables
  • Interpreting show slave status output
  • Understanding shows processlist
  • Including & excluding databases & tables in replication
  • Interpreting binary and relay log files using mysqlbinlog
  • Troubleshooting and repairing broken replication
  • Monitoring MySQL replication
SQLite for Mobile Apps

This book presents the architecture, functionalities, and data types supported by SQLite. It demonstrates how to use SQLite Command-Line shell. Then, the book presents the approach to use SQLite in Mobile Apps. Later, it presents developing Android, BlackBerry and iOS Applications using SQLite to store and retrieve data with step-by-step details as well as list of source code. In addition, it presents how to use Android ADB Shell to open SQLite Database created for the application. Similarly, it shows the database contents from BlackBerry SD Card and iOS database file.

  • Chapter 1 — Introduces SQLite and describes the chapters.
  • Chapter 2 — SQLite Overview — Architecture, functionality, data types, Data Definition Language (DDL) statements, DML (Data Manipulation Language) statements and function call process flow and mobile devices.
  • Chapter 3 — Command line shell — This chapter describes how to use SQLite Command line shell.
  • Chapter 4 — Set up for use in Mobile Apps — This chapter presents a process flow. It presents the database structure, DDL and DML executed in the database. It also presents the sample Part Maintenance application user interface to be used repeated in Android, BlackBerry, iOS and Web App.
  • Chapter 5 — Use in Android Apps — This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through launching ADB shell and opening SQLite command line.
  • Chapter 6 — Use in BlackBerry App — This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through opening SQLite database in command line.
  • Chapter 7 — Use in iOS App — This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through opening SQLite database in command line.

Part Maintenance Application Code

Great Math Tricks

This book presents ways to perform fast calculations.

Chapter 1 – Introduction.

Chapter 2 – Time Table – This chapter presents the times table up to 25.

Chapter 3 – Square – This chapter presents the squares of numbers up to 25. Then, it presents how square of numbers ending with 0, starting with 1 and ending with all 0’s, comprising of all 1’s, comprising of all 9’s and ending with 5.

Chapter 4 – Divisibility – This chapter presents ways to detect divisibility up to number 11.