Where can i practice some heavy SQL questions for a 1 hr sql interview with linkedin? I am very comfortable with select statements and can easily think through even window functions. Since it is for 45 mins is completely for SQL round I feel it may be more tougher than i think.
When to use indexes and when not to
This is for Microsoft SQL Server Specifically I take it? I'd maybe read up a little on STUFF, maybe just general query optimizations, query plans, not sure if you have to know SSIS and SSAS, but maybe brush up.
Leetcode has some sql questions
Is it common to ask sprocs for data scientist too
Was on HN recently. https://franchise.cloud/
Which role is this for?
Its for a data scientist role
Do all hackerrank sql exercises. Will be in great shape after that
Tech Industry
3h
1338
Are tech workers as rich as they think we are?
World Conflicts
Yesterday
425
Remember folks, all Israel wants is the hostages back
Today I Learned
Yesterday
814
My understanding of the Holocaust was incorrect!
Tech Industry
Yesterday
1097
Brother beaten severely as a kid. Doesn’t speak to dad at all now.
Tech Industry
2d
2158
Is filling for divorce reasonable given my situation
I would think: Select Case Subquery Union Joins(all the joins) Window functions Where Having Group by Order by Concat Date formatting Update Insert Delete Truncate Triggers Stored procedures Indices Etc... So probably expect multi table joins (4+) with a mix of whatever the hell they want