SQL for Finance Professionals

Focused View

Megan Lieu

1:06:23

232 View

01 - Introduction

01 - Become the ultimate financial analyst using SQL.mp4

00:46

02 - What you should know.mp4

01:22

02 - 1. What Is SQL

03 - Background and use cases of SQL.mp4

00:57

04 - Types of SQL commands.mp4

02:13

05 - SQL data types.mp4

02:18

06 - Queries The basic building blocks of SQL.mp4

03:07

07 - How to use functions to perform calculations.mp4

03:30

08 - Joins using table relationships.mp4

04:50

09 - Challenge Creating your first query.mp4

00:35

10 - Solution Creating your first query.mp4

01:36

03 - 2. SQL in Finance

11 - SQL in the finance field.mp4

01:40

12 - How data is used in finance.mp4

02:18

13 - Data in fintech vs. finance.mp4

02:27

14 - Excel vs. SQL in finance.mp4

02:28

15 - Challenge Creating your second SQL query.mp4

01:27

16 - Solution Creating your second SQL query.mp4

01:59

04 - 3. Financial Analysis in SQL

17 - What is financial analysis.mp4

03:23

18 - Analyzing financial statements.mp4

02:29

19 - Analyzing tabular data.mp4

03:11

20 - Calculating financial metrics WACC, NPV, IRR.mp4

02:58

21 - Challenge Creating basic reports using SQL.mp4

01:18

22 - Solution Creating basic reports using SQL.mp4

02:38

05 - 4. Predictive Modeling in Finance

23 - What is predictive modeling.mp4

02:33

24 - How predictive modeling is used in finance.mp4

02:31

25 - Forecasting revenue trends.mp4

03:56

26 - Developing predictive models using SQL, Python, and R.mp4

03:49

27 - Case study Detecting fraud.mp4

03:31

06 - Conclusion

28 - Next steps.mp4

00:33

Description

If you work in the financial sector, one tool that may not come to mind when thinking about the day-to-day work in finance is SQL—structured query language. But SQL is the programming language used to query data, so it’s extremely useful for anyone who works with vast stores of information, including financial professionals. As more and more data gets produced from the proliferation of modern tools and technologies, it’s increasingly important to know how to handle all the new data, and in this course, Megan Lieu shows you how to do just that using SQL. She starts with the background of SQL, including use cases, SQL data types, how to query data, how to use functions to perform calculations, and more. She then delves into finance-specific applications of SQL, giving an overview of how SQL is used in finance, the difference when using data in fintech vs. finance, and shows you how to use SQL in combination with a more familiar financial sector tool, Excel.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

SQL Server

Megan Lieu

Instructor's Courses

Numbers are my best friend (not literally--I have real friends too, I promise). I have vivid memories of the highs I would get from successfully solving practice problems in algebra and calculus classes in middle school and high school. That’s where it all started. From there, my love for numbers brought me to the world of transaction advisory and business valuations, where those numbers served as the foundation for complex financial models I built to answer companies’ questions about their mergers and acquisitions and financial reporting. What ultimately led me to data science was the discovery that numbers are not only for solving problems, but for telling beautiful stories as well. Through it all, it’s been that aha! feeling from making sense of messiness that has brought me joy while also motivating me to continuously seek new challenges. These days, the challenges I’m tackling most often involve my skills with programming in Python and R, database management and querying, and data visualization tools such as Tableau and Power BI. However, there is still SO MUCH I aspire to learn and new challenges to tackle within data science--and I cannot wait. When I am not being a data nerd, I am probably writing about being a data nerd, competitive powerlifting, creating fashion blog content or reading self-help books (in that order).

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.