SQL for Finance Professionals

Offered By: LinkedIn Learning

Tags

Finance Courses Data Analysis Courses SQL Courses Financial Analysis Courses Predictive Modeling Courses Financial Statements Courses Database Management Courses Financial Modeling Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

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

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX