Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SQL for Finance Professionals

via LinkedIn Learning

Write review

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Boot.dev

Learn Backend Development Part-Time, Online

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Learn the fundamentals to get started in using SQL for financial analysis and modeling.

Syllabus

Introduction

Become the Ultimate Financial Analyst Using SQL
What you should know

1. What is SQL?

Background and use cases of SQL
Types of SQL commands
SQL data types
Queries: The basic building blocks of SQL
How to use functions to perform calculations
Joins using table relationships
Setting up sample data and files
Challenge: Creating your first query
Solution: Creating your first query

2. SQL in Finance

SQL in the finance field
How data is used in finance
Data in fintech vs finance
Excel vs SQL in finance
Challenge: Creating your second SQL query
Solution: Creating your second SQL query

3. Financial analysis in SQL

What is financial analysis?
Analyzing financial statements
Analyzing tabular data
Calculating financial metrics: WACC, NPV, IRR
Challenge: Creating basic reports using SQL
Solution: Creating basic reports using SQL

4. Predictive modeling in finance

What is predictive modeling?
How predictive modeling is used in finance
Forecasting revenue trends
Developing predictive models using SQL and Python/R
Case study: Detecting fraud

Conclusion

Next steps

Taught by

Megan Lieu

Reviews

4.7 rating at LinkedIn Learning based on 1926 ratings

Start your review of SQL for Finance Professionals