Learning SQL for FP&A

What is the best way to learn SQL for use in finance, namely FP&A? I've watched videos on YouTube but most of them are focused on the syntax. I do know that SQL is used in some type of DBMS like IBM / Oracle / Microsoft Excel. So, when job applications list SQL experience (like for FP&A Analyst positions), what DBMS are they referring to? Microsoft Excel? Oracle? Does it matter? If I learn the syntax, is that enough?

I have searched for resources but again, they seem to be focusing on the syntax.
https://sqlzoo.net/
https://www.reddit.com/r/SQL/wiki/index

Can someone who works in FP&A please explain or recommend a MOOC or other sources that will show me how to use SQL just like you do on the job?

Thanks.

 
Best Response

So I don't work in FP&A but do have sql experience. The DBMS doesn't matter too much cause most sql syntax is pretty standardized. MySQL, sql server, Postgres, oracle, etc. all have their nuances, but once you have a grasp of how to write queries in one, it's pretty easy to move to another.

Job postings are probably referring to one of the above or maybe ms access. Personally, I would avoid any place that relies on access as a primary tool, and there is a special place in hell for people that use excel as a database tool. Frankly, that practice is downright dangerous.

I'm pretty certain your primary reason for using sql in FP&A is to access data. Any decent size organization will have a whole IT unit dedicated to maintaining everything. Focus on learning how to use select statements; the select statement will be your workhorse and is also often the base for creating objects.

Probably the most important skill beyond mastering the basic syntax is knowing how to assess the grain of an object. That is, learn how to assess the structure of a table or view in terms of the level of data it contains (lookup table vs one record per primary key vs multiple records per primary key, etc.). Eventually you'll want to get to the point where if given the grain of an object, you can manipulate its data without really knowing that data very well.

Those resources you linked look fine. I'd guess most people don't take formal sql classes and learn everything on the job. Google is definitely valuable for this.

 
Cov:
Probably the most important skill beyond mastering the basic syntax is knowing how to assess the grain of an object. That is, learn how to assess the structure of a table or view in terms of the level of data it contains (lookup table vs one record per primary key vs multiple records per primary key, etc.). Eventually you'll want to get to the point where if given the grain of an object, you can manipulate its data without really knowing that data very well.

I'm not familiar with much of the terminology but I think I get what you're saying. https://www.thoughtco.com/primary-key-definition-1019179

Cov:
I'd guess most people don't take formal sql classes and learn everything on the job. Google is definitely valuable for this.

This is a bit of a Catch-22. Whenever I apply to FP&A roles, I never get a response. I tried using a recruiter and even they won't entertain me since I don't know SQL, despite knowing how to model + good grades + experience. Not having been exposed to this at work, I don't know how I would gain the relevant SQL skills.

Thank you!

 
Big4please:
I work in fp&a and have interest in learning SQL but do not know/use it today. We have a bunch of business intelligence support folks. I think this is pretty typical for larger businesses.

https://corporate-childrensplace.icims.com/jobs/28962/financial-plannin… Overview:

Skills and Behaviors: Quantitative skills (SQL a plus) Strong Microsoft Excel skills (experience writing macros a plus) Strong analytical skills with experience in creating reports using Hyperion financial planning and Oracle Essbase Ability to perform and remain organized in a fast-paced, deadline driven environment by multi-tasking Ability to take initiative and work independently in a sometimes unstructured environment with frequently changing priorities Strong attention to detail and exceptional organizational skills with desire to grow in finance profession

 

I haven't used essbase or Hyperion. My company uses cognos.

It's a little different to use multidimensional budgeting software if you never have. It's all about managing your data. Generally this software is used for budgeting giant businesses for reporting purposes. I think we currently have up to six dimensions in our models but this will increase dramatically once we upgrade before long.

For example, you may have an expense budget for 1500 cost centers. The dimensions that could be involved are of course the account, the cost center, the business unit, a time dimension, actual/forecast/budget and versioning (January forecast, February forecast, etc.). All of these dimensions provide you a way to look at and manipulate your data, as well as allow you to look at your data from perspectives necessary for reporting purposes to end users.

It's kind of tough to articulate what all is involved n

 

Sit debitis fugit dolores iste error. Itaque commodi nulla neque illo. Est aut illum fugiat. Dolor nobis tenetur itaque rerum tempore quibusdam.

Dolore sunt sint totam. Porro quisquam dolorum soluta in voluptatem fuga tempore. Laborum porro repellat in odit minus est soluta. Ea voluptatibus aut magnam blanditiis. Debitis culpa odio nihil velit commodi voluptatem. Occaecati aliquam quia aut ipsum tempore mollitia. Voluptatem dolorem non natus omnis officiis.

Quasi laboriosam et laborum aut. Unde eaque tempora cum assumenda nisi. Architecto sit et velit aperiam laboriosam. Laborum enim sed eaque provident.

Repellat consequatur culpa dolores laborum quod non aut nulla. Unde molestias totam eum magnam non dolore. Et nemo ad culpa maiores enim velit qui. Non maiores aut fugiat earum iure consectetur. Consequatur rerum tempora ad. Et assumenda ratione tenetur est et dolorem dolore qui. Et iure doloremque cum nulla quia temporibus et sit.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
DrApeman's picture
DrApeman
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”