ACCOUNTING DATABASE FUNDAMENTALS: LEARN BY EXAMPLES IN SQL SERVER

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 Read more