[{"_1":2,"_64":-5,"_65":-5},"loaderData",{"_3":4,"_33":34,"_62":-5,"_63":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_20":-5,"_21":22,"_23":24,"_27":28},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":12},"count",0,"free",true,"updatedAt","2025-12-24T03:44:25.165Z","paymentGateway","STRIPE","cartItems",[],"loading","toast","locale","en","constants",{"_25":26},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_29":30,"_31":32},"companies",[],"universities",[],"routes/_store+/_readers+/email_author.$slug/route",{"_35":36,"_61":-5},"book",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMzc0MjU","title","Accounting Database Design","state","unpublished","contactAuthorMethod","email","aboutText","

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!

","authors",[49],{"_37":50,"_51":52,"_5":53},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8zOTE0MA","name","Kenneth Infante",{"_54":55},"avatar",{"_56":57,"_58":59,"_60":12},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/343681/medium/avatar.jpg?1584915899","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author