| 001-Downloading-Database-ye6T-english-onehack.us.srt | 3.2 KB | ||
| 001-Downloading-Database-ye6T-onehack.us.mp4 | 5 MB | ||
| 001-Downloading-Database-ye6T-persian-onehack.us.srt | 4.7 KB | ||
| 002-Downloading-Connecting-Azure-Data-Studio-yNuJ-english-onehack.us.srt | 3.7 KB | ||
| 002-Downloading-Connecting-Azure-Data-Studio-yNuJ-onehack.us.mp4 | 7.1 MB | ||
| 002-Downloading-Connecting-Azure-Data-Studio-yNuJ-persian-onehack.us.srt | 5.6 KB | ||
| 004-Creating-our-Database-project-uploading-data-0VDr-english-onehack.us.srt | 10.3 KB | ||
| 004-Creating-our-Database-project-uploading-data-0VDr-onehack.us.mp4 | 17 MB | ||
| 004-Creating-our-Database-project-uploading-data-0VDr-persian-onehack.us.srt | 15.8 KB | ||
| 005-Understanding-our-Project-Data-6WKv-english-onehack.us.srt | 9.3 KB | ||
| 005-Understanding-our-Project-Data-6WKv-onehack.us.mp4 | 19.4 MB | ||
| 005-Understanding-our-Project-Data-6WKv-persian-onehack.us.srt | 14.2 KB | ||
| 007-Getting-started-with-SQL-SELECT-izeU-english-onehack.us.srt | 6.7 KB | ||
| 007-Getting-started-with-SQL-SELECT-izeU-onehack.us.mp4 | 10.3 MB | ||
| 007-Getting-started-with-SQL-SELECT-izeU-persian-onehack.us.srt | 10.3 KB | ||
| 008-SELECT-specific-Columns-and-Rows-kjPa-english-onehack.us.srt | 5.8 KB | ||
| 008-SELECT-specific-Columns-and-Rows-kjPa-onehack.us.mp4 | 9.8 MB | ||
| 008-SELECT-specific-Columns-and-Rows-kjPa-persian-onehack.us.srt | 8.8 KB | ||
| 009-Selecting-WHERE-Part-2-13tW-english-onehack.us.srt | 8.8 KB | ||
| 009-Selecting-WHERE-Part-2-13tW-onehack.us.mp4 | 16.4 MB | ||
| 009-Selecting-WHERE-Part-2-13tW-persian-onehack.us.srt | 13.2 KB | ||
| 010-Time-Intelligence-Date-Month-qAqz-english-onehack.us.srt | 9.1 KB | ||
| 010-Time-Intelligence-Date-Month-qAqz-onehack.us.mp4 | 16 MB | ||
| 010-Time-Intelligence-Date-Month-qAqz-persian-onehack.us.srt | 13.9 KB | ||
| 011-Time-Intelligence-Part-2-DATEPART-mZ5K-english-onehack.us.srt | 11.3 KB | ||
| 011-Time-Intelligence-Part-2-DATEPART-mZ5K-onehack.us.mp4 | 19 MB | ||
| 011-Time-Intelligence-Part-2-DATEPART-mZ5K-persian-onehack.us.srt | 16.9 KB | ||
| 012-Time-Intelligence-in-Action-Basic-Example-qCAt-english-onehack.us.srt | 5.7 KB | ||
| 012-Time-Intelligence-in-Action-Basic-Example-qCAt-onehack.us.mp4 | 9.4 MB | ||
| 012-Time-Intelligence-in-Action-Basic-Example-qCAt-persian-onehack.us.srt | 8.7 KB | ||
| 013-SUM-and-Group-SAuY-english-onehack.us.srt | 10.5 KB | ||
| 013-SUM-and-Group-SAuY-onehack.us.mp4 | 15.9 MB | ||
| 013-SUM-and-Group-SAuY-persian-onehack.us.srt | 15.8 KB | ||
| 014-Making-and-Using-SubQuery-RgfA-english-onehack.us.srt | 4.4 KB | ||
| 014-Making-and-Using-SubQuery-RgfA-onehack.us.mp4 | 6.8 MB | ||
| 014-Making-and-Using-SubQuery-RgfA-persian-onehack.us.srt | 6.8 KB | ||
| 015-PIVOT-data-into-Columns-kvMW-english-onehack.us.srt | 7 KB | ||
| 015-PIVOT-data-into-Columns-kvMW-onehack.us.mp4 | 10 MB | ||
| 015-PIVOT-data-into-Columns-kvMW-persian-onehack.us.srt | 10.1 KB | ||
| 016-Practice-SubQuery-PIVOT-vtYV-english-onehack.us.srt | 4.8 KB | ||
| 016-Practice-SubQuery-PIVOT-vtYV-onehack.us.mp4 | 7.9 MB | ||
| 016-Practice-SubQuery-PIVOT-vtYV-persian-onehack.us.srt | 7.2 KB | ||
| 017-Create-VIEW-S116-english-onehack.us.srt | 3.4 KB | ||
| 017-Create-VIEW-S116-onehack.us.mp4 | 5.5 MB | ||
| 017-Create-VIEW-S116-persian-onehack.us.srt | 5.3 KB | ||
| 018-JOIN-Tables-hmko-english-onehack.us.srt | 7.1 KB | ||
| 018-JOIN-Tables-hmko-onehack.us.mp4 | 12.7 MB | ||
| 018-JOIN-Tables-hmko-persian-onehack.us.srt | 10.2 KB | ||
| 019-JOIN-Tables-Part-2-hFJj-english-onehack.us.srt | 4.1 KB | ||
| 019-JOIN-Tables-Part-2-hFJj-onehack.us.mp4 | 6.9 MB | ||
| 019-JOIN-Tables-Part-2-hFJj-persian-onehack.us.srt | 6.2 KB | ||
| 020-RIGHT-JOIN-LEFT-JOIN-Lm1s-english-onehack.us.srt | 8.5 KB | ||
| 020-RIGHT-JOIN-LEFT-JOIN-Lm1s-onehack.us.mp4 | 13.5 MB | ||
| 020-RIGHT-JOIN-LEFT-JOIN-Lm1s-persian-onehack.us.srt | 12.6 KB | ||
| 021-JOINs-Practice-Joining-4-Tables-together-4hoT-english-onehack.us.srt | 5.8 KB | ||
| 021-JOINs-Practice-Joining-4-Tables-together-4hoT-onehack.us.mp4 | 12.2 MB | ||
| 021-JOINs-Practice-Joining-4-Tables-together-4hoT-persian-onehack.us.srt | 8.6 KB | ||
| 022-FORMAT-numbers-jc9H-english-onehack.us.srt | 2.5 KB | ||
| 022-FORMAT-numbers-jc9H-onehack.us.mp4 | 3.9 MB | ||
| 022-FORMAT-numbers-jc9H-persian-onehack.us.srt | 3.7 KB | ||
| 023-Preparing-Profit-Loss-Statement-Part-1-8UQe-english-onehack.us.srt | 9.7 KB | ||
| 023-Preparing-Profit-Loss-Statement-Part-1-8UQe-onehack.us.mp4 | 18.7 MB | ||
| 023-Preparing-Profit-Loss-Statement-Part-1-8UQe-persian-onehack.us.srt | 14.4 KB | ||
| 024-Profit-Loss-Statement-Part-2-ZxkJ-english-onehack.us.srt | 10.1 KB | ||
| 024-Profit-Loss-Statement-Part-2-ZxkJ-onehack.us.mp4 | 20.4 MB | ||
| 024-Profit-Loss-Statement-Part-2-ZxkJ-persian-onehack.us.srt | 15.7 KB | ||
| 025-Profit-Loss-Statement-Part-3-2Qjn-english-onehack.us.srt | 5.9 KB | ||
| 025-Profit-Loss-Statement-Part-3-2Qjn-onehack.us.mp4 | 12.6 MB | ||
| 025-Profit-Loss-Statement-Part-3-2Qjn-persian-onehack.us.srt | 8.9 KB | ||
| 026-Preparing-Balance-Sheet-Understanding-the-problem-anZ3-english-onehack.us.srt | 4.7 KB | ||
| 026-Preparing-Balance-Sheet-Understanding-the-problem-anZ3-onehack.us.mp4 | 9.3 MB | ||
| 026-Preparing-Balance-Sheet-Understanding-the-problem-anZ3-persian-onehack.us.srt | 6.6 KB | ||
| 027-SQL-for-Cumulative-SUM-YA0O-english-onehack.us.srt | 6 KB | ||
| 027-SQL-for-Cumulative-SUM-YA0O-onehack.us.mp4 | 10.1 MB | ||
| 027-SQL-for-Cumulative-SUM-YA0O-persian-onehack.us.srt | 9.4 KB | ||
| 028-Cumulative-SUM-Part-2-X6Cw-english-onehack.us.srt | 4.7 KB | ||
| 028-Cumulative-SUM-Part-2-X6Cw-onehack.us.mp4 | 8.2 MB | ||
| 028-Cumulative-SUM-Part-2-X6Cw-persian-onehack.us.srt | 7.2 KB | ||
| 029-Cumulative-SUM-Part-3-301m-english-onehack.us.srt | 2.1 KB | ||
| 029-Cumulative-SUM-Part-3-301m-onehack.us.mp4 | 3.4 MB | ||
| 029-Cumulative-SUM-Part-3-301m-persian-onehack.us.srt | 3.1 KB | ||
| 030-Balance-Sheet-Part-1-XGj1-english-onehack.us.srt | 7.6 KB | ||
| 030-Balance-Sheet-Part-1-XGj1-onehack.us.mp4 | 15 MB | ||
| 030-Balance-Sheet-Part-1-XGj1-persian-onehack.us.srt | 11.1 KB | ||
| 031-Balance-Sheet-Final-cb4u-english-onehack.us.srt | 7 KB | ||
| 031-Balance-Sheet-Final-cb4u-onehack.us.mp4 | 15.5 MB | ||
| 031-Balance-Sheet-Final-cb4u-persian-onehack.us.srt | 10.5 KB | ||
| 032-Learning-the-CASE-WHEN-statement-lF5H-english-onehack.us.srt | 6.9 KB | ||
| 032-Learning-the-CASE-WHEN-statement-lF5H-onehack.us.mp4 | 12.6 MB | ||
| 032-Learning-the-CASE-WHEN-statement-lF5H-persian-onehack.us.srt | 10.3 KB | ||
| 033-Calculating-Sales-HS9M-english-onehack.us.srt | 10.8 KB | ||
| 033-Calculating-Sales-HS9M-onehack.us.mp4 | 20 MB | ||
| 033-Calculating-Sales-HS9M-persian-onehack.us.srt | 16.1 KB | ||
| 034-Calculating-Gross-Profit-and-Net-Profit-i527-english-onehack.us.srt | 7.1 KB | ||
| 034-Calculating-Gross-Profit-and-Net-Profit-i527-onehack.us.mp4 | 13.2 MB | ||
| 034-Calculating-Gross-Profit-and-Net-Profit-i527-persian-onehack.us.srt | 10.6 KB | ||
| 035-Calculating-EBITDA-Operating-Profit-and-PBIT-lQT9-english-onehack.us.srt | 9.6 KB | ||
| 035-Calculating-EBITDA-Operating-Profit-and-PBIT-lQT9-onehack.us.mp4 | 20.2 MB | ||
| 035-Calculating-EBITDA-Operating-Profit-and-PBIT-lQT9-persian-onehack.us.srt | 13.7 KB | ||
| 036-Calculating-Gross-Profit-Margin-Demo-LAEH-english-onehack.us.srt | 5.9 KB | ||
| 036-Calculating-Gross-Profit-Margin-Demo-LAEH-onehack.us.mp4 | 10.4 MB | ||
| 036-Calculating-Gross-Profit-Margin-Demo-LAEH-persian-onehack.us.srt | 9.1 KB | ||
| 037-Breaking-down-values-by-Country-Qjer-english-onehack.us.srt | 6.9 KB | ||
| 037-Breaking-down-values-by-Country-Qjer-onehack.us.mp4 | 14.1 MB | ||
| 037-Breaking-down-values-by-Country-Qjer-persian-onehack.us.srt | 10.6 KB | ||
| 038-Calculating-Ratios-i2wN-english-onehack.us.srt | 8.3 KB | ||
| 038-Calculating-Ratios-i2wN-onehack.us.mp4 | 14.8 MB | ||
| 038-Calculating-Ratios-i2wN-persian-onehack.us.srt | 12.6 KB | ||
| 039-Calculating-Balance-Sheet-Related-Values-5vlH-english-onehack.us.srt | 21.6 KB | ||
| 039-Calculating-Balance-Sheet-Related-Values-5vlH-onehack.us.mp4 | 45.7 MB | ||
| 039-Calculating-Balance-Sheet-Related-Values-5vlH-persian-onehack.us.srt | 32.2 KB | ||
| 040-Compiling-all-key-values-in-one-VIEW-78CU-english-onehack.us.srt | 9.5 KB | ||
| 040-Compiling-all-key-values-in-one-VIEW-78CU-onehack.us.mp4 | 20.7 MB | ||
| 040-Compiling-all-key-values-in-one-VIEW-78CU-persian-onehack.us.srt | 13.7 KB | ||
| 041-Calculating-Ratios-fV6M-english-onehack.us.srt | 10.5 KB | ||
| 041-Calculating-Ratios-fV6M-onehack.us.mp4 | 20.2 MB | ||
| 041-Calculating-Ratios-fV6M-persian-onehack.us.srt | 15.8 KB | ||
| 042-Calculating-further-values-for-Ratios-and-updating-VIEWs-wx4Q-english-onehack.us.srt | 6.8 KB | ||
| 042-Calculating-further-values-for-Ratios-and-updating-VIEWs-wx4Q-onehack.us.mp4 | 15 MB | ||
| 042-Calculating-further-values-for-Ratios-and-updating-VIEWs-wx4Q-persian-onehack.us.srt | 10.3 KB | ||
| 043-Calculating-Receivables-and-Payables-and-updating-VIEW-BSValues-7rAG-english-onehack.us.srt | 5.1 KB | ||
| 043-Calculating-Receivables-and-Payables-and-updating-VIEW-BSValues-7rAG-onehack.us.mp4 | 13.4 MB | ||
| 043-Calculating-Receivables-and-Payables-and-updating-VIEW-BSValues-7rAG-persian-onehack.us.srt | 7.9 KB | ||
| 044-Updating-VIEW-FinValues-pn7v-english-onehack.us.srt | 4.7 KB | ||
| 044-Updating-VIEW-FinValues-pn7v-onehack.us.mp4 | 10.2 MB | ||
| 044-Updating-VIEW-FinValues-pn7v-persian-onehack.us.srt | 7.1 KB | ||
| 045-Calculating-Interest-Cover-Inventory-Receivables-Payables-Turnover-Period-ugQH-english-onehack.us.srt | 6.8 KB | ||
| 045-Calculating-Interest-Cover-Inventory-Receivables-Payables-Turnover-Period-ugQH-onehack.us.mp4 | 14.7 MB | ||
| 045-Calculating-Interest-Cover-Inventory-Receivables-Payables-Turnover-Period-ugQH-persian-onehack.us.srt | 10.1 KB | ||
| 046-Slicing-Ratios-for-Country-7kmP-english-onehack.us.srt | 1.6 KB | ||
| 046-Slicing-Ratios-for-Country-7kmP-onehack.us.mp4 | 3.5 MB | ||
| 046-Slicing-Ratios-for-Country-7kmP-persian-onehack.us.srt | 2.5 KB | ||
| 047-Introduction-and-foundation-HCuf-english-onehack.us.srt | 11 KB | ||
| 047-Introduction-and-foundation-HCuf-onehack.us.mp4 | 26.2 MB | ||
| 047-Introduction-and-foundation-HCuf-persian-onehack.us.srt | 16 KB | ||
| 048-Uploading-CF-Table-to-our-Database-dHll-english-onehack.us.srt | 1.9 KB | ||
| 048-Uploading-CF-Table-to-our-Database-dHll-onehack.us.mp4 | 3.4 MB | ||
| 048-Uploading-CF-Table-to-our-Database-dHll-persian-onehack.us.srt | 3 KB | ||
| 049-Calculating-Values-for-Cash-Flow-Statement-Part-1-Zela-english-onehack.us.srt | 23.7 KB | ||
| 049-Calculating-Values-for-Cash-Flow-Statement-Part-1-Zela-onehack.us.mp4 | 50 MB | ||
| 049-Calculating-Values-for-Cash-Flow-Statement-Part-1-Zela-persian-onehack.us.srt | 34.2 KB | ||
| 050-Calculating-Cash-Cash-Equivalents-at-the-end-of-the-Year-Vyjt-english-onehack.us.srt | 6.9 KB | ||
| 050-Calculating-Cash-Cash-Equivalents-at-the-end-of-the-Year-Vyjt-onehack.us.mp4 | 14.2 MB | ||
| 050-Calculating-Cash-Cash-Equivalents-at-the-end-of-the-Year-Vyjt-persian-onehack.us.srt | 10.1 KB | ||
| 051-Calculating-Cash-Cash-Equivalents-at-the-start-of-the-year-SEuR-english-onehack.us.srt | 8 KB | ||
| 051-Calculating-Cash-Cash-Equivalents-at-the-start-of-the-year-SEuR-onehack.us.mp4 | 15.1 MB | ||
| 051-Calculating-Cash-Cash-Equivalents-at-the-start-of-the-year-SEuR-persian-onehack.us.srt | 11.5 KB | ||
| 052-Compiling-Cash-Flow-Statement-koSD-english-onehack.us.srt | 2.1 KB | ||
| 052-Compiling-Cash-Flow-Statement-koSD-onehack.us.mp4 | 4.3 MB | ||
| 052-Compiling-Cash-Flow-Statement-koSD-persian-onehack.us.srt | 3 KB | ||
| 1.-Getting-our-PC-ready-to-run-SQL-__-3.-CSV-files-for-Database-tables.html | 307.2 B | ||
| 5.-Cash-Flow-Statement-__-1.1-CF.csv | 7.1 KB | ||
| ????-Request-a-Course-????.txt | 307.2 B | ||
| ▲ 153 total files | |||
???? Request a Course: ???? docs.google.com/forms
???? Official Course URL: udemy.com/course/sql-for-financial-data-analysis
???? Course Overview:
Unlock the power of SQL to analyze and report financial data with ease. This course is designed for non-tech professionals seeking to streamline financial reporting and analytics. Learn how to extract, process, and present critical financial data like Profit & Loss Statements, Balance Sheets, and Key Ratios through practical examples and hands-on exercises.
???? What You'll Learn:
- ???? SQL Basics: Extract, sort, and group data for analysis.
- ???? Financial Reports: Create Profit & Loss Statements, Balance Sheets, and Cash Flow Statements.
- ???? Key Analytics: Calculate profitability, efficiency, liquidity, and risk management ratios.
- ????️ Database Skills: Query data without programming knowledge.
???? Course Benefits:
- ✅ Empower Reporting: Gain independence from system-generated reports.
- ✅ Hands-On Learning: Practical exercises for real-world scenarios.
- ✅ Beginner Friendly: Learn without prior programming or technical knowledge.
- ✅ Expert Instruction: Taught by a Chartered Accountant with 14+ years of experience.
⏱️ Total Hours of Course: 5 hours 29 minutes
????️ Course Size: 701 MB
???? Subtitles: English, Persian
Who is this course for?
Ideal for Financial Analysts, Business Analysts, Accountants, Bookkeepers, and Data Analysts looking to enhance their data analysis and reporting capabilities with SQL.
All Comments