SQL for Finance: Income Statement Project

سرفصل های دوره

SQL is a powerful tool to have in your toolkit, when you need to create financial reports. How do you get started, though? In this course, data analytics expert Gabriela Baldivia Soncini guides you through the fundamental concepts of financial accounting via an income statement project. Learn how to extract data from a relational database, manipulate data using SQL queries, and transform the data. Find out how to prepare basic financial statements like balance sheets and income statements. Plus, solidify what you learn with a course-spanning project, as well as several hands-on challenges.

01 - Introduction

01 - The power of SQL in financial reports

02 - 1. Balance Sheets and Assets Accounts

01 - Financial reports

02 - Understanding the projects data

03 - Exploring the user case

04 - Cash Account, part 1 Using CTE

05 - Cash Account, part 2 Using CTE

06 - Cash Account, part 3 Union

07 - Cash Account, part 4 Window function and materialized view

08 - Creating the Accounts Receivable Account

09 - Understanding Property Land and Equipment Account

10 - Window function and depreciation

11 - Completing the depreciation transaction

12 - Challenge Inventory Account

13 - Solution Inventory Account

03 - 2. Balance Sheets Liability and Owners Equity Accounts

01 - Building the Loan Account

02 - Retained Earnings Account, part 1

03 - Retained Earnings Account, part 2

04 - Challenge Retained Earnings Account

05 - Solution Retained Earnings Account

04 - 3. Building the Balance Sheet

01 - Building the Assets section

02 - Building the Liabilities section

03 - Building the Owners Equity section

04 - Challenge Balance sheet year 1

05 - Solution Balance sheet year 1

05 - 4. Income Statement

01 - Understanding the income statement

02 - Challenge Income statement

03 - Solution Income statement

06 - Conclusion

01 - Balance sheet and income statement considerations

02 - Your SQL journey

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)