| 1. Downloading Database.mp4 | 18.7 MB | ||
| 1. Introduction and foundation.mp4 | 125.9 MB | ||
| 1. Learning the CASE WHEN statement.mp4 | 36.5 MB | ||
| 1. Preparing Profit & Loss Statement - Part 1.mp4 | 66.6 MB | ||
| 1. Understanding our Project Data.mp4 | 80.9 MB | ||
| 1.1 CF.csv | 7.1 KB | ||
| 10. Calculating Ratios.mp4 | 73 MB | ||
| 10. PIVOT data into Columns.mp4 | 25.7 MB | ||
| 11. Calculating further values for Ratios and updating VIEWs.mp4 | 65.6 MB | ||
| 11. Practice SubQuery & PIVOT.mp4 | 24.5 MB | ||
| 12. Calculating Receivables and Payables and updating VIEW BSValues.mp4 | 64.8 MB | ||
| 12. Create VIEW.mp4 | 15.5 MB | ||
| 13. JOIN Tables.mp4 | 45.3 MB | ||
| 13. Updating VIEW FinValues.mp4 | 45.9 MB | ||
| 14. Calculating Interest Cover, Inventory Receivables Payables Turnover Period.mp4 | 67.8 MB | ||
| 14. JOIN Tables - Part 2.mp4 | 26.2 MB | ||
| 15. RIGHT JOIN & LEFT JOIN.mp4 | 40.2 MB | ||
| 15. Slicing Ratios for Country.mp4 | 16.8 MB | ||
| 16. JOINs Practice - Joining 4 Tables together.mp4 | 49.3 MB | ||
| 17. FORMAT numbers.mp4 | 10.5 MB | ||
| 2. Calculating Sales.mp4 | 75.2 MB | ||
| 2. Downloading & Connecting Azure Data Studio.mp4 | 23.5 MB | ||
| 2. Getting started with SQL - SELECT .mp4 | 24.9 MB | ||
| 2. Profit & Loss Statement - Part 2.mp4 | 83.2 MB | ||
| 2. Uploading CF Table to our Database.mp4 | 11.6 MB | ||
| 3. CSV files for Database tables.html | 307.2 B | ||
| 3. Calculating Gross Profit and Net Profit.mp4 | 48.7 MB | ||
| 3. Calculating Values for Cash Flow Statement - Part 1.mp4 | 219.8 MB | ||
| 3. Profit & Loss Statement Part 3.mp4 | 56.1 MB | ||
| 3. SELECT specific Columns and Rows.mp4 | 29.5 MB | ||
| 4. Calculating Cash & Cash Equivalents at the end of the Year.mp4 | 55.1 MB | ||
| 4. Calculating EBITDA, Operating Profit and PBIT.mp4 | 80.3 MB | ||
| 4. Creating our Database project & uploading data.mp4 | 41.1 MB | ||
| 4. Preparing Balance Sheet - Understanding the problem.mp4 | 40.2 MB | ||
| 4. Selecting WHERE Part 2.mp4 | 49.8 MB | ||
| 5. Calculating Cash & Cash Equivalents at the start of the year.mp4 | 54.3 MB | ||
| 5. Calculating Gross Profit Margin - Demo.mp4 | 36.7 MB | ||
| 5. SQL for Cumulative SUM.mp4 | 29 MB | ||
| 5. Time Intelligence - Date Month.mp4 | 47.9 MB | ||
| 6. Breaking down values by Country.mp4 | 60.8 MB | ||
| 6. Compiling Cash Flow Statement.mp4 | 18.8 MB | ||
| 6. Cumulative SUM Part 2.mp4 | 26.4 MB | ||
| 6. Time Intelligence Part 2 - DATEPART.mp4 | 54 MB | ||
| 7. Calculating Ratios.mp4 | 44.5 MB | ||
| 7. Cumulative SUM Part 3.mp4 | 11.9 MB | ||
| 7. Time Intelligence in Action - Basic Example.mp4 | 30.8 MB | ||
| 8. Balance Sheet Part 1.mp4 | 64.4 MB | ||
| 8. Calculating Balance Sheet Related Values.mp4 | 193.2 MB | ||
| 8. SUM and Group.mp4 | 38.6 MB | ||
| 9. Balance Sheet - Final.mp4 | 79.4 MB | ||
| 9. Compiling all key values in one VIEW.mp4 | 98.5 MB | ||
| 9. Making and Using SubQuery.mp4 | 18.6 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 54 total files | |||
SQL for Financial Data Analysis & Reporting - Zero to Pro
https://CourseWikia.com
Published 12/2023
Created by Irfan Sharif ACA ACCA
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 51 Lectures ( 5h 29m ) | Size: 2.6 GB
Master SQL fundamentals and apply them to financial data for comprehensive analysis, reporting, and decision making.
What you'll learn
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
Requirements
Basic knowledge of Financial Reports
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.6 GB | freecoursewb | 3 days | 0 | 0 | |
| 1.3 GB | freecoursewb | 3 days | 0 | 0 | |
| 258.8 MB | freecoursewb | 3 days | 0 | 0 | |
| 3.8 GB | freecoursewb | 1 month | 23 | 3 | |
| 1.7 GB | freecoursewb | 1 month | 16 | 1 |
All Comments