Define the availability, performance and recovery targets for complex query optimisation.
Building Strategies to Optimise the Performance of Complex Queries
A structured, applied course in complex query optimisation — designed to be used the week you return.
📍 Abu Dhabi🗓️ 5 training days📚 4 modules🎓 Accredited certificate
5intensive training days
4scientific modules
8training sessions
32detailed points
Course Overview
Security and delivery speed are traded against each other in complex query optimisation whether or not anyone says so. The documentation for the wider technology and systems delivery agenda is accurate only until the next release. The professional literature on this part of technology and systems delivery converges on a small set of controls that reliably work. The difficulty is not agreeing that complex query optimisation matters — it is deciding what to stop doing to make room for it. It concentrates on the parts of the wider technology and systems delivery agenda that determine outcomes and treats the rest proportionately. Every module pairs a short input on this aspect of technology and systems delivery with structured practice on the participant's own material. The level assumes working familiarity with the technical platform but no prior formal training in complex query optimisation. The course leaves participants able to diagnose weaknesses in this part of technology and systems delivery before they become incidents. The final session converts the week's work on the wider technology and systems delivery agenda into commitments with owners and dates.
Expected Learning Outcomes
Structure the service desk and support model for complex query optimisation.
Establish monitoring and alerting on complex query optimisation that reflects user experience.
Verify that improvements to complex query optimisation have held six months after they were introduced.
Document complex query optimisation to the level a new engineer could operate it.
Sequence improvements to complex query optimisation so that each step makes the next one easier.
Select indicators that show whether complex query optimisation is improving, and reject those that only look useful.
Who Should Attend
Service desk and support leads handling incidents in complex query optimisation.
Department heads accountable for the results of complex query optimisation.
Operations staff who encounter the consequences of complex query optimisation directly.
Vendor managers overseeing suppliers involved in complex query optimisation.
Network and communications engineers supporting complex query optimisation.
Information security specialists protecting complex query optimisation.
Course Modules
Complex query optimisation: incident response and severity
2 sessions · 8 pointsSession 1Testing complex query optimisation before relying on it
- Prepare the summary of complex query optimisation that senior management will read.
- Rank the weaknesses in complex query optimisation by consequence rather than by ease of fixing.
- Build the competence framework that supports complex query optimisation.
- Define incident severity levels for complex query optimisation and the response each triggers.
Session 2Running an incident on complex query optimisation calmly
- Record the technical debt in complex query optimisation and schedule repayment.
- Run a load test on complex query optimisation at expected peak plus a margin.
- Review logging on complex query optimisation for coverage and retention.
- Plan the sequence in which improvements to complex query optimisation will be introduced.
Complex query optimisation: backup, recovery and continuity
2 sessions · 8 pointsSession 1Comparing complex query optimisation with recognised practice
- Inventory third-party dependencies inside complex query optimisation and their update status.
- Agree what will be standardised in complex query optimisation and what will not.
- Confirm the support model and escalation path for complex query optimisation.
- Configure alerting on complex query optimisation that reflects what users experience.
Session 2Dependencies and supply chain risk in complex query optimisation
- Confirm data retention and deletion rules applied within complex query optimisation.
- Close out actions on complex query optimisation rather than leaving them open indefinitely.
- Collect evidence on the present handling of complex query optimisation before proposing changes.
- Write down the assumptions underpinning the approach to complex query optimisation.
Complex query optimisation: capacity, performance and load
2 sessions · 8 pointsSession 1The change to complex query optimisation that caused the last outage
- Rehearse the briefing on complex query optimisation that would follow an incident.
- Distinguish symptoms from causes when complex query optimisation underperforms.
- Assess the exit route from any cloud or vendor dependency in complex query optimisation.
- Restore a backup of complex query optimisation in a test environment and time it.
Session 2Monitoring complex query optimisation from the user's point of view
- Set delivery and reliability indicators for complex query optimisation the team trusts.
- Remove steps in complex query optimisation that add effort without adding assurance.
- Test the failover for complex query optimisation rather than assuming it works.
- Measure current load on complex query optimisation and project it forward twelve months.
Complex query optimisation: security, identity and least privilege
2 sessions · 8 pointsSession 1Proving the backup of complex query optimisation by restoring it
- Apply change control to complex query optimisation including emergency changes.
- Establish what evidence demonstrates complex query optimisation is under control.
- Record the rationale for each significant choice made about complex query optimisation.
- Identify where judgement in complex query optimisation is legitimate and where it is not.
Session 2The decisions in complex query optimisation that cannot be delegated
- Define the trigger that would require complex query optimisation to be redesigned.
- Confirm every release of complex query optimisation can be rolled back within a defined time.
- Check that records of complex query optimisation answer the questions likely to be asked.
- Identify the single points of failure in complex query optimisation.
Choose the package that suits you
Silver Package
At least 3 people
USD1,250
- Workshop or Program Participation
- Airport Transfers
- Customized Badge
- Expert Mentorship (Private Sessions)
- Supervision & Secretarial Services
- Accredited Certificate of Participation
- Complete Training Kit
- Coffee Break
- Closing Ceremony
Gold Package
At least 3 people
USD1,850
- 5-night stay in a 5-star hotel
- Workshop or Program Participation
- Airport Transfers
- Customized Badge
- Expert Mentorship (Private Sessions)
- Supervision & Secretarial Services
- Accredited Certificate of Participation
- Complete Training Kit
- Coffee Break
- Closing Ceremony
Complete your registration
We will contact you within one business day to confirm.