Udemy

SQL Masterclass for Financial Analysis & Financial Reporting

立即報名
  • 860 名學生
  • 更新於 10/2024
4.6
(195 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
5 小時 30 分鐘
教學語言
英語
授課導師
Irfan Sharif ACA ACCA | #1 Best Selling Instructor of Accounting & Bookkeeping
評分
4.6
(195 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

SQL Masterclass for Financial Analysis & Financial Reporting

A complete beginner to pro SQL course with mastery in Financial Reports & Financial Analytics

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. 

課程章節

  • 5 個章節
  • 52 堂課
  • 第 1 章 Getting our PC ready to run SQL
  • 第 2 章 Getting started with SQL
  • 第 3 章 Preparing Profit & Loss Statement
  • 第 4 章 Ratio Analysis with SQL
  • 第 5 章 Cash Flow Statement

課程內容

  • Downloading and installing database
  • Fundamentals of Database and SQL
  • Querying database with SQL
  • Extracting and summarizing data with SQL
  • Preparing Profit & Loss Statement
  • Preparing Balance Sheet
  • Preparing Cash Flow Statement
  • Preparing Key Ratios and Analytics


評價

  • S
    Shweta Mehta
    5.0

    The Course is amazing for beginner learners like me also the way it was explain quite easy to understand and apply in while working. As fresher it really helpful and the duration also short so it takes less time.

  • P
    Paresh mistry
    4.0

    The GL data is not working in Azure

  • S
    Sreenivasulu Mallili
    5.0

    The explanation is superb! i really like the course

  • P
    Prashant
    4.0

    it was great. but something it was hard to understand.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意