SQL for accountants: a crash course

A hands on introduction for accountants.

SQL is an important computing language to learn. It is the language of data and databases. SQL allows us to store and manipulate data so that we can make the best decisions with the data that we have.

SQL is perfect for accountants. 

We love data. We analyse a tonne of data. And while there are many courses that teach SQL, none are focused on the accounting side.

They also tend to give you a list of the syntax but don’t encourage you to practice using the language! 

This crash course has been designed with one the School of FinOps fundamental philospohpies front of mind; you learn through doing.

Don't think, do!

We’ll give you a brief overview to SQL for accountants and then let you get crackin’ on some problems!

House rules

Before the fun begins, there is some admin to go through first.

You will need a google account.

A perfect tool for learning SQL is Google Sheets

I know I know, you probably spend the majority of your day in Excel or Google sheets. The last thing you want to do is spend more time in it. But there is a reason to my madness.

Using the Query function within Google Sheets enables you to use Google Visualisation API Query language (build on SQL) to directly write SQL based code within Google Sheets. 

It’s a great way to teach theory and application; without needing to install any programmes!

Let's get Started!

This is where you will find the introduction to SQL for accountants crash course. You will need to make a copy and save your own file to your drive

The google sheet has been setup to run provide a crash course in SQL for accountants. It introduces you to the basics of the language and then gets you started on a big project to test your new found skills.

Before you start, if you would rather be introduced to SQL for accountants in a lesson format, we do run frequent classes remotely. You can check them out here.

The Google Sheet has been written as a crash course for SQL for accountants. 

Hope you enjoy! 

School of FinOps

This course showcases just one of the many skills that we teach at the School of FinOps.

The School Of FinOps is there to: 

School of FinOps

This course showcases just one of the many skills that we teach at the School of FinOps.

Find out more about the course and how to apply here.