No worries :)
I went through the standard process for a DA role here in NZ. This usually consists of a screening interview over the phone from HR/recruiter, then a technical interview/take-home test, then an interview for cultural fit.
These are more about talking through how and why you would do something or which approach you would take, rather than the 'whiteboard' interview that the Devs here talk about.
The generally cover:
To prepare I would recommend knowing the projects you have worked on really well:
The testing site we use at my workplace is Hackerrank, I'd recommend giving it a go to test your skills - hackerrank.com/domains/sql
I'd also recommend downloading the free version of SQL Server and SQL Server Management Studio (SSMS) if you have only used a browser based tutorial so far.
Download SQL Server - this is the query engine
Download SSMS - this is the UI you interact with
Download and restore the backup of the AdventureWorks DB
Work through some of the examples
Good luck in your preparation
Your recommendations are extremely valuable! Thank you so muchhh!
You’re welcome 😊
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.