SQL for Finance Professionals with Zero Experience
Empower your financial analysis with SQL: Learn to extract, manipulate, and analyze financial data, even with no prior coding experience.
...
Share
SQL Fundamentals for Finance
Unit 1: Relational Database and SQL Basics
Databases & Finance
SQL: The Language of Data
Setting Up Your SQL
SQL Syntax Essentials
Your First SQL Query
Unit 2: Retrieving and Filtering Financial Data
Selecting Columns
Filtering with WHERE
Filtering on Date Ranges
Sorting with ORDER BY
Limiting Results
Unit 3: Joining Tables for Financial Insights
Understanding Joins
Inner Joins
Left Joins
Right Joins
Joining Multiple Tables
Financial Calculations with SQL
Unit 1: Aggregate Functions in Finance
Summing Financial Data
Averaging Financial Data
Counting Financial Data
Min/Max in Finance
Variance & Standard Dev
Unit 2: Financial Functions in SQL
Calculating Returns
Compounding Interest
Depreciation Calc
Present & Future Value
Loan Amortization
Unit 3: Time-Series Analysis with Window Functions
Rolling Sums
Rolling Averages
Lag and Lead
Ranking Financial Data
Percent Change
Generating Financial Reports with SQL
Unit 1: Income Statement Generation
Income Statement Basics
Querying Revenue Data
Calculating Gross Profit
Operating Expenses
Net Income Calculation
Unit 2: Balance Sheet Generation
Balance Sheet Basics
Querying Asset Data
Liabilities Data
Equity Data
Balance Sheet Equation
Unit 3: Cash Flow Statement Generation
Cash Flow Statement
Operating Activities
Investing Activities
Financing Activities
Statement Reconciliation
Unit 4: Report Formatting and Automation
SQL Formatting
Data Export
SQL Views
Stored Procedures
Scripting
Advanced Financial Data Analysis with SQL
Unit 1: Stock Market Analysis with SQL
Intro to Stock Data
Calculating Simple MA
Exp. Moving Average
Identifying Signals
Bollinger Bands
Unit 2: Risk Management with SQL
Intro to Risk Metrics
Calculating VaR
Historical Simulation
Expected Shortfall
Stress Testing
Unit 3: Data Validation and Quality
Data Validation Intro
Checking Data Types
Checking for Nulls
Checking for Duplicates
Data Range Validation