Related Posts
More Posts
Itna sannata q hai bhai?
Industry-wide layoffs tomorrow or nah?
What is the average salary of a Senior 1?
Additional Posts in Consulting Exit Opportunities
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Just learn standard SQL and you should be okay. Also, for what kind of job are you applying?
Whenever I think of SQL, I think of ANSI SQL plus platform specific syntax and constructs. Ultimately, I think of it as a declarative language — give me what I ask, don’t care how you do it.
However, T-SQL (Microsoft) and PL/SQL (Oracle) are more procedural languages (e.g., how to do it) that enhance the capabilities of a specific platform. For example, PostgreSQL allows for various procedural languages that can be used (e.g., PL/Python, PL/Tcl, PL/Perl)
You can know SQL but not necessarily the procedural language associated with a particular database platform.
Ansi sql
resources to learn and practice (pgexercises doesn't have advanced stuff).
Try HackerRank for practice. You can probably do Postgres or MySQL unless you want to specifically do something with Microsoft
Do you use SQL at Bcg?
Sql is always sql.
Adding to what d1 is saying, ansi sql is a (series of) standard(s) not an actual dialect of sql.
You still need to pick an implementation to learn. And most sql implementations do contain commonly used statements that are either not specified in the ansi standards or not (fully) compliant. Other times they may comply with certain versions of ansi in parts and other versions of ansi in other parts.
Coming back to the original question I think postgresql is a great dialect to learn. Oracle and t-sql are also good.