Author Description

Accounting Database Fundamentals presents the mechanics of accounting in the common language understood by SQL Developers, Business Analysts, Data Analysts, and Data Architects - data modelling. The book presents accounting principles and how they are applied in an accounting database. Every chapter is easily digestible, has practical takeaways, and has answers to your how-to questions, including: -Incremental construction of a data model based on the accounting equation -Modelling of double-entry accounting principles -Demonstration of the ingestion of transactional data from multiple modules into accounting -Accounting data verification -Components and data sources of the Income Statement, Balance Sheet, and Cash Flow Statement. -SQL information-retrieval code for each financial statement -Month-end and year-end data processing -Basic table structures to support budgeting and cash flow forecasting