Email the Author
You can use this page to email Kenneth Infante about Accounting Database Design.
About the Book
Learn how to design an accounting database system - a complex, real-world project - instead of the usual blogs and "toy" apps in other books so you could truly master SQL.
We're going to build this using SQLite - the free, lightweight, and open-source database relationship management system or DBMS.
You'll learn how to create tables, insert data, update data, or delete data all in the context of an accounting database system. You'll also learn how to use database relationships and create queries using join.
What's the use of an accounting system if you can create reports? Hence, I'm also going to show you how to create the standard Financial Statements and other custom reports using views and common table expressions or CTEs.
I'm sure this book will be useful to anyone learning SQL especially in the field of finance and accounting.
Let's dive right in!
About the Author
Kenneth Infante is a Certified Public Accountant with expertise in data analysis and data visualization. He is also a Certified Microsoft Excel Expert and a self-taught Python programmer.
Kenneth is passionate with accounting-related technologies that enable accountant to turn data into insights and insights into business actions. He believes that Data Science is the future of accounting industry and hence every accountant should learn how to program.
In his spare time, he likes watching sci-fi movies, reading books, and learning new skills. And yes, he's your Geek Accountant.