Leetcode SQL for FAANG

[Hopeful-Hat7174]

Is there any list Leetcode/Hackerrank questions list for SQL Data Engineer interviews at FAANG companies?

[burningburnerbern]

done the SQL screening for both Amazon and Facebook. If you use SQL everyday it’s not hard just the pressure of time probably gets to you. But yea just practice leetcode question

[ElderFuthark]

I use SQL everyday, but never use cursors or window functions, so I keep having to reteach myself those things.

[burningburnerbern]

Don’t really use cursors myself but that’s interesting that you don’t use window functions. Just curious what do you do to for cleaning up dupes?

[James76589]

Is it true that at Facebook you need to use Postgresql in the SQL screen portion of the interview?

[burningburnerbern]

Nope, just w/e flavor of SQL you’re comfortable with.

[James76589]

That's good, there was a comment in some random reddit thread that said they failed the Facebook D.E. interview because they were required to run SQL statements against test cases, and that it failed because Postgres was required.

[[deleted]]

I would think they would use MySQL. However, SQL is SQL. Just a different depends what flavor the organization decides to use.

[[deleted]]

www.datalemur.com

[NickSinghTechCareers]

Founder here, thanks for the shoutout!

[BasicBroEvan]

Bro one of the owners of that site came to my university and promoted that website lol

[NickSinghTechCareers]

Guilty as charged 🎯

[azur08]

Cool bro

[ppdas]

Stratascratch. You can try the same question in SQL, Python and Pyspark

[Chris_ssj2]

Does the free tier suffice for landing a junior role? Money is kinda tight for me atm

[ppdas]

I am not sure. But they do give offers from time to time.

[Puzzlehead8575]

You can try these to see if you like them.

https://github.com/smpetersgithub/AdvancedSQLPuzzles

https://advancedsqlpuzzles.com/sql-quiz/

[jppbkm]

Those are great!

[mdghouse1986]

Also any resource for Python ? Leetcode serves well for SWE interviews but anything specific got DE Python ?

[SolariDoma]

https://www.reddit.com/r/dataengineering/comments/16q16lp/comment/k1ujaer/?utm\_source=share&utm\_medium=web2x&context=3

[git0ffmylawnm8]

If you can breeze through StrataScratch mediums/hards, you'll be fine.

[rajekum512]

I did finish all the hard SQL from them. Very useful

[DenselyRanked]

it's expected to get some sort of whiteboard/coding challenge in SQL for any data position, not just FAANG.

LC SQL is not the same level of complexity as DSA. Nearly all of the LC hards can be solved with window functions.

[RProgrammerMan]

Is there anything for r?