YoVDO

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

Financial Sustainability: The Numbers side of Social Enterprise
+Acumen via NovoEd
M&A: Free Cash Flow (FCF) Modeling
New York Institute of Finance via edX
Financial Modeling for the Social Sector
Philanthropy University via Acumen Academy
Introducción a las Finanzas Corporativas
University of Pennsylvania via Coursera
沃顿商务基础毕业项目 (中文版)
University of Pennsylvania via Coursera