Companies Home Search Profile

SQL for Finance: Income Statement Project

Focused View

Gabriela Baldivia Soncini

2:14:26

20 View
  • 01 - The power of SQL in financial reports.mp4
    00:45
  • 01 - Financial reports.mp4
    04:33
  • 02 - Understanding the projects data.mp4
    03:03
  • 03 - Exploring the user case.mp4
    00:46
  • 04 - Cash Account, part 1 Using CTE.mp4
    06:39
  • 05 - Cash Account, part 2 Using CTE.mp4
    07:07
  • 06 - Cash Account, part 3 Union.mp4
    05:43
  • 07 - Cash Account, part 4 Window function and materialized view.mp4
    06:30
  • 08 - Creating the Accounts Receivable Account.mp4
    03:53
  • 09 - Understanding Property Land and Equipment Account.mp4
    07:59
  • 10 - Window function and depreciation.mp4
    06:33
  • 11 - Completing the depreciation transaction.mp4
    06:45
  • 12 - Challenge Inventory Account.mp4
    00:59
  • 13 - Solution Inventory Account.mp4
    08:07
  • 01 - Building the Loan Account.mp4
    07:00
  • 02 - Retained Earnings Account, part 1.mp4
    05:56
  • 03 - Retained Earnings Account, part 2.mp4
    06:56
  • 04 - Challenge Retained Earnings Account.mp4
    01:01
  • 05 - Solution Retained Earnings Account.mp4
    08:49
  • 01 - Building the Assets section.mp4
    08:13
  • 02 - Building the Liabilities section.mp4
    04:21
  • 03 - Building the Owners Equity section.mp4
    05:59
  • 04 - Challenge Balance sheet year 1.mp4
    00:40
  • 05 - Solution Balance sheet year 1.mp4
    03:01
  • 01 - Understanding the income statement.mp4
    02:34
  • 02 - Challenge Income statement.mp4
    00:27
  • 03 - Solution Income statement.mp4
    03:55
  • 01 - Balance sheet and income statement considerations.mp4
    05:11
  • 02 - Your SQL journey.mp4
    01:01
  • Description


    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.

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Gabriela Baldivia Soncini
    Gabriela Baldivia Soncini
    Instructor's Courses
    LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
    • language english
    • Training sessions 29
    • duration 2:14:26
    • English subtitles has
    • Release Date 2024/04/20