Accounting Database Design

By Derek Liew

Learn the powerful knowledge of using queries (sql) to generate conventional profit and loss, balance sheet, cash flow or even bank reconciliation on the fly. There are no other technical books that provide the equilibrium knowledge of both accounting and sql programming needed in developing an in house customized business or accounting application. The chapters in the book are concise and practical. You will discover realistic tables required in a relational database structure, that stores important transactional information for your payables, receivables, assets, banking and journals. You will learn normalization concepts to building accounting tables, and identifying redundant fields in third phase of the normalization process.

Discover the engine within the accounting system that runs the flow of transaction from data entry level to execution of stored procedure that controls your business logic. The professional accountant, database designer, application developer and software architect should discover these technical insights in order to design, develop and deploy a workable application across the organization.

Accounting IN SQL for Newbies

By Derek Liew

This book was written as a continuation chapters from the accounting database design ebook. It is written in appreciation of the readers who has bought a copy of his first ebook. The first few chapters will touches on the user interface in capturing invoices, applying collections and payments, to setting off VAT Input and Output. The remaining chapters will show you the coding exercise of writing conditional stored procedures and creating back-end entry automation thru the use of triggers. You will learn how to write triggers to monitor event and to control information flow from table to multiple tables. You will also learn how to code in SQL Server, and test your written sql script from your SQL Server Analyzer.

Discover the engine within the accounting system that runs the flow of transaction from data entry level to execution of stored procedure that controls your business logic. The professional accountant, database designer, application developer and software architect should discover these technical insights in order to design, develop and deploy a workable application across the organization.