Accounting Database Design

Accounting Database Design

How to build an accounting database system using SQLite.

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
Kenneth Infante

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.

The Leanpub 60 Day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.

You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!

So, there's no reason not to click the Add to Cart button, is there?

See full terms...

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $13 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub