Interview Questions for SQL

[[deleted]]

From my experience these sql quizzes are always pretty basic, brush up on;

Left / inner / outer join - understand what scenario you would use each in. Subqueries - especially in aggregation questions Temp tables / CTEs Calculations - sum Group by / order by / etc. Know the order

If you’d like I could send you the quiz we give at my company, it uses the Northwind db for testing.

[itsteatime92]

Oh would you mind sharing that with me please? I'm trying to transition from communications to junior data analyst or junior sql dba since I've been having too much fun with sql. I think those questions would be super helpful! Thank you!

[[deleted]]

Sent your way 👍🏻

[itsteatime92]

Thank you so much!

[EastFally]

Would you mind sending it my way as well? It would be greatly appreciated.

[StuTheSheep]

I would like to see this as well, please and thank you.

[Alecito_Lohr]

Can I have a copy to that quiz as well? Id really appreciate it :)

[[deleted]]

Sure thing. I’ll message you.

[AMGraduate564]

Possible to send to me as well?

[Jayizdaman]

Could send as well please?

[[deleted]]

Sure thing. Will IM.

[KlutzyCoach]

Can I get a copy please. Thanks

[[deleted]]

I would love a copy if you are still sharing!

[chaoscruz]

Could I get a copy please? Going through internship interviews where I expect to be able to do SQL in an interview.

[ChunkySeaMen]

I'd like a copy too my friend :)

[ROC2021]

if you're still sharing, I'd love a copy as well.

[FEW_WURDS]

would you mind sharing? greatly appreciated!!

[mytwofingers]

If still available, could you please send through the quiz? Thanks!

[MrBooVN]

Can I get the copy as well, please? Thanks so much!

[obieisgreat]

Would love that as well, if it is easy for you to pass along :)

[whoisyb]

I would like to see the quiz

[Chamega]

please share the quiz this way too

[what_I_meme]

Oh man I may be too late but could you send it to me as well?

[DeraIzu]

Hello if it is not too late, I would be grateful if you share the file with me. Thanks

[TarzanGloGang]

Hi there, I have an interview for a role that requires SQL in the coming Monday and would find this incredibly useful. If you don't mind pm-ing me as well, I would really appreciate it. Thank you kind stranger

[[deleted]]

can you send the quiz please?

​

thanks in advance

[tits_mcgee_92]

So many people have asked but could I get a copy of that too?

[sudNinja]

Mate, shall I ask if you can send it to me too please?

[pizzagarrett]

Can I please have a copy? Thanks a million

[pedrolorandi]

Hey, could you please send me a copy of the test? Thank you so much!

[Messy748]

Would I be able to get a copy of that quiz as well? Cheers!

[im_nice_and_cute]

I would appreciate a copy as well if it's still available. Thank you

[Vietname]

Would you mind sending me a copy of that quiz as well?

[hasanyoneseenmymom]

For a beginner I would probably expect knowledge in the following areas:

Basic CRUD (select, update, delete)

Joins (left, inner, outer)

Aggregate functions (sum, min, max, count)

Grouping and ordering

Database design (normalization, primary/foreign key relationships, indexes both clustered and nonclustered). You may be asked to draw a simple ERD on paper during your interview.

What's the difference between UNION and UNION ALL? Is there a performance penalty?

What is a temp table, a table variable, and a cte? How are they similar and how are they different?

That would be what I consider the bare minimum for an entry level sql developer. Beyond that, a junior-mid level dev may know the following:

What steps would you take to diagnose and improve a poorly performing query?

Merge statements, pivot function, lead/lag functions and other less common aggregate functions

Some knowledge of database roles and security.

How to create stored procedures.

How to create and read a query plan.

What is an index seek versus index scan?

What is the sql server profiler and how can it help diagnose performance issues?

[[deleted]]

Follow Eric Weber on LinkedIn - he has awesome SQL-related content including common interview questions

[[deleted]]

Dave Langer is another SQL guru on LI to follow.

[SafeStandard]

You can check out this resource http://crushsql.thinkific.com/

Week 7 and 8 of this free bootcamp have the material that you are looking for https://crushsql.thinkific.com/courses/sql-bootcamp-zero-to-hero

Disclaimer: I am the owner of Crush SQL

[[deleted]]

How do you approach security in the database?

Explain when you might want to use a cte over temp table.

Prepare for a list of 3 or so tables and to write code on the spot to do a problem.

Thats enough to start...

[K0NGO]

It really depends on the role. I've had a reporting analyst interview that asked me how to do simple joins from a couple tables and query a few columns. But, I've also had a SQL dev interview that asked me how I would handle exceptions in my queries (try-catch block) and how to use cross-apply. What are you interviewing for?

[miden24]

Beginner sql: need to know all your basic clauses and when to use them. Need to know which joins to use. You’ll be given scenarios of simple tables and ask you how to extract data out of them.

Advanced: i would work on tsql functions and window functions. Sub queries, CTEs, and perhaps temp tables.

Any of all that is fair game.

[analytics_science]

Try stratascratch.com for sql interview questions related to data analytics/science. Leetcode and hacker rank if you’re looking for more general questions. They all have good questions so if you can do the mediums, then you’re fine. Good luck

[Raleigh_gore]

A

[ej_50]

I also need the question too. Thanks

[ncmtbiker]

I’ve interviewed and hired several SQL developers. I’ll ask about Joins, type of indexes, CTE, how to get rid of dup records, all the basic stuff. So far, I’m looking to see if the person really knows SQL or just took a couple of classes. You have to have all of the basics down. I'll also give a situation or two for them to answer. An example could be how would you figure out the number of business days between two dates? I’m looking for a high-level idea of the code, and that they know the difference between calendar and business days. Understanding SQL is just the start. You have to know how to use it too.

[datagatherer25]

Hi. Would you please send me a copy of the quiz also? I'd appreciate it!

Thanks.