From the course: SQL for Finance Professionals
Join today to access over 25,600 courses taught by industry experts.
SQL in the finance field - SQL Tutorial
From the course: SQL for Finance Professionals
SQL in the finance field
- SQL can be a very powerful tool in a financial analyst's toolkit. It's great for business intelligence, forecasting, and financial modeling. Let's talk about why SQL is such an effective tool to use in finance. Knowing how to manipulate and analyze financial data and records is at the heart of financial analysis. Financial analysts often deal with large volumes of data to be able to create their financial models. Two common concepts used by financial analysts are pivot tables and V-lookups. These are spreadsheet concepts we will learn more about later, but for now, be aware that they are widely used for building reporting that financial analysts are responsible for. Both pivot tables and V-lookups have direct translations in the world of SQL and can make the analyst's job much easier and faster. Another reason analysts in the field greatly benefit from using SQL in their day-to-day is that they often may need to get…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.