I'm looking to hire a tutor that can teach mid to advance SQL to analysts in my company. We're London based so the tutor should be available to come in to our office for 3 days.
This is SQL for analysts not developers, so there's no need to teach how to build and maintain a DB, only query it.
Improving performance with indexes
Querying Multiple Tables via Joins
Combining results with set operators
Functions in Data Retrieval e.g. use of CASE expression
Analysis with aggregate functions
Nested Queries & Subqueries
Developing In-Line and Stored Views/Breaking down complex problems
Creating and Managing Databases
Designing and adding schemas
The candidate needs to demonstrate both that they have taught SQL to analysts before and that they are proficient in SQL. They need to be able to come into a London office and tailor the curriculum based on the skill set of the audience, rather than being inflexible.