I'm looking for how is good with concepts on Advanced database queries. I would like to do some sample projects with the person who I will hiring as I would like to prepare for an interview which is similar to these skill sets.
1. Advanced SQL queries handling - Examples, resources
a. All joins b. Aggregations c. Handling null values d. Ranking e. Case statements
2. SQL Tuning and optimization - Example and resources
I need some one to help me build sample projects and my expectation is take guidance from you and replicate it while you help me with it. It is going to be like live coding session where you can tutor me on the concepts I like the ones I mentioned above.