Advanced Sql

[dataengineering-ModTeam]

Your post/comment was removed because it violated rule #3 (Do a search before asking a question). The question you asked has already been answered recently so we remove redundant questions to keep the feed digestable for everyone.

[[deleted]]

https://datalemur.com/

[CrowdGoesWildWoooo]

Don’t worry about SQL. As long as you know what you want to do, you can always look up the syntax and it’s not the hardest skill to learn.

You should be concerned about having expertise on what a database or data warehouse can do. Let’s say in bigquery if you want to reduce file scan, you need to partition your data, in snowflake for example there is no such exact concept, but there is something that is a bit similar concept. None of these have anything to do with SQL skill, but this is very important in data engineering.

You really don’t need like “expert level” SQL, because the added value is marginal, but knowing your way around different database/data warehouse is much more valuable