Currently Empty: £0.00
Unlock the power of financial data with this comprehensive course designed for non-tech professionals.
All the financial data of an organization is stored in the database. Now to extract the data back for reporting and analysis is usually not considered easy by non-tech people. Most professionals are dependent on the reports that are available in the system. The best bet, you can connect a BI tool like Power BI and extract the data for analysis. However, this too has a lot of limitations.
What is SQL:
A database query tool with which you can extract any broader or specific data from the database just by writing small super-easy lines of code. No programming knowledge or database technical knowledge is required for this. Almost anyone can do that and it will empower you in the reporting and analytics like nothing else can.
What you will learn in this course:
-
Introduction to databases
-
Basic ways to query a database
-
Sorting and filtering data
-
Grouping data
-
Splitting data on multiple parameters
-
Drilling up and drilling down data
-
Preparing Financial Reports
-
Profit & Loss Statement
-
Balance Sheet
-
Cash Flow Statement
-
Preparing Financial Analytics
-
Profitability ratios
-
Efficiency ratios
-
Liquidity ratios
-
Risk management ratios
Who this course is for:
-
Financial Analysts
-
Business Analysts
-
Financial Controllers
-
Finance Managers
-
Accountants
-
Bookkeepers
-
Data Analysts
Money back guarantee:
This course comes with a 30 days money back guarantee. So, sign up risk free and if for any reason you are not satisfied with the course, you will get the full refund.
About instructor:
I am a Chartered Accountant from the UK with 14 years of experience. My major work has been in the accounting and finance transformation of organizations with tools like SAP and Oracle. So, I have been using SQL for quite some time. Now I run an accounting automation company.
Getting started with SQL
Preparing Profit & Loss Statement
-
5Understanding our Project Data
-
6ChatGPT Prompt
-
7Getting started with SQL - SELECT *
-
8SELECT specific Columns and Rows
-
9Selecting WHERE Part 2
-
10Time Intelligence - Date | Month
-
11Time Intelligence Part 2 - DATEPART
-
12Time Intelligence in Action - Basic Example
-
13SUM and Group
-
14Making and Using SubQuery
-
15PIVOT data into Columns
-
16Practice: SubQuery & PIVOT
-
17Create VIEW
-
18JOIN Tables
-
19JOIN Tables - Part 2
-
20RIGHT JOIN & LEFT JOIN
-
21JOINs Practice - Joining 4 Tables together
-
22FORMAT numbers
Ratio Analysis with SQL
Cash Flow Statement
-
32Learning the CASE WHEN statement
-
33Calculating Sales
-
34Calculating Gross Profit and Net Profit
-
35Calculating EBITDA, Operating Profit and PBIT
-
36Calculating Gross Profit Margin - Demo
-
37Breaking down values by Country
-
38Calculating Ratios
-
39Calculating Balance Sheet Related Values
-
40Compiling all key values in one VIEW
-
41Calculating Ratios
-
42Calculating further values for Ratios and updating VIEWs
-
43Calculating Receivables and Payables and updating VIEW BSValues
-
44Updating VIEW FinValues
-
45Calculating Interest Cover, Inventory | Receivables | Payables Turnover Period
-
46Slicing Ratios for Country
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Stars 5
25
Stars 4
20
Stars 3
7
Stars 2
0
Stars 1
2