June 4, 2022 at 8:17 am
Hi Community,
Can someone provide some helpful links to where I can find SQL Query Questions on certain industries.
For example, there is a book called "Query Answers with SQL Server", by Adam Aspin & Karine Aspin. This book gives lots of Sample Query questions on the Automotive Industry. I was wondering someone could help point me to a site which provides similar SQL Query questions on various industries?
June 5, 2022 at 4:36 am
You'd have better luck with the following search in your favorite search engine. I didn't look at the specific articles themselves but I replaced the XXXXXXXXX with "mortgage", "automotive", and "food service" and the titles seemed to be pretty interesting. Here's the search...
SQL for the xxxxxxxxx industry
--Jeff Moden
June 6, 2022 at 12:25 pm
I have to say, I find this a little odd. I worked in the insurance industry for ten years. However, I worked for a fairly unique organization. We had almost all hand-built databases. There's no way a "here are insurance SQL queries" list would work for us at all. Our tables were not remotely the same as other insurance companies. I'm not saying we were 100% unique, because lots of the problems are somewhat common. I am saying our data structures were not some standard upon which all insurance companies operate. Having done work for Jaguar motor cars quite a few years back, I'd say the same there. Banking also, 10 years with Merrill and consulting with a couple of other banks. While there is lots of common problem spaces, so the logic within an industry is similar, the structures are so very different, I just can't imagine something like this working well.
Maybe it's just me.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 6, 2022 at 10:11 pm
Grant,
This is a perfect response.
I would say that I can get typical industry queries from LeetCode, Hackerrank, StrataSearch
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply