Hi, I have several interviews coming up and the recruiters told me they might test my SQL knowledge too. What kind of questions should I expect? One is a consultant swe / data scientist and the other is application developer
Basically just make sure you understand different kinds of joins, how to use subqueries, and how to aggregate/group, etc. I've had a bunch of sql interviews and never had anything all that complicated... It doesn't hurt to be ready for needing to go above and beyond, but generally knowing the basics really well is enough
There is a Database section in Leetcode. You can probably go through all SQL questions in few days.
This is what you are looking for - https://www.interviewbit.com/sql-interview-questions/
Great Sql interview questions - https://antoonvandaal.com
Interviews generally depend on the experience and the answer given by you. I am sharing some questions asked in my interview for Wipro and also the topics which I prepared for the interview. Q.1 Tell us something about SSL and TLS Protocols. Q.2 Explain RDBMS with a few examples. Q.3 Name of databases used by Facebook and Twitter. Q.4 What do you know about Stored Procedure, what is its purpose? Q.5 How to return a value in the procedure. Q.6 Differentiate primary and Unique Key with the help of examples. You can check this, I have also prepared from here https://hackr.io/blog/top-sql-interview-questions
What is the difference between union and union all