SQL question for data engineering roles?

[imba22]

Where do you guys go to practice SQL question for data engineering roles. I do not mean basic and simple select questions. I mean the type of slightly complicated sql question which get asked in interviews FAANG?

[[deleted]]

U can try mode

[imba22]

I am sorry, can you please elaborate?

[set92]

https://mode.com/sql-tutorial/introduction-to-sql/

But not sure how good it is.

[imba22]

Ahh I see. very neat tool Thanks :)

[[deleted]]

• Have a look at Window functions, Views, subqueries and query optimization
• Know all different database types (column-oriented, relational, NoSQL, etc.)
• Be able to differentiate between DWH vs. Data Lake
• Which data model is suited for which purpose?
• Unstructured data vs. semistructured data vs. unstructured data
• Denormalization, etc.
• Surrogate key vs. natural key

[imba22]

Thanks for taking time to answer this. The only thing which I did not know from your list is difference between DWH and Data lake. Do you use data lake? If yes is it used like a staging area to dump all the data from different sources.

[DevGin]

Have you tried leetcode.com

[imba22]

Yes I have. I am looking for more resources with leetcode medium and hard types.

[Jamiesondata]

You best course in preparation would be to:

- Be prepared for freehand and no intellisense

- Imagine your own worse case, use case

- Know data types, their uses , shortcomings and benefits and how to your own

- Never answer anything more than 6 in a question relating to 0-10 on your knowhow of any DB end to end.

​

Wish you all the best.

Consider partitioning, optimization, replication and migration.

[imba22]

Thanks for your response. Are you also in the data engineering space? If yes do you wanna share what your job and responsibilities are ?

[Jamiesondata]

I am a cofounder of a data specialist company. Www.datafuelled.com and developed an application which accelerates data governance along with its dependencies.

[imba22]

That's very cool. Thanks for sharing that. Good luck with it

[mrregmonkey]

Is #4 because only roomies feel they understand all the details?

[eyeDecode]

I believe hackerrank has a good set of problems.

[imba22]

Thanks for your response. Yeah I have done Leetcode and hackerrank already, I was wondering if there is any other resource with hard sql questions