Our training units are categorised into topics of skill or knowledge for ease of use, however components from different units can be mixed with another to achieve your specific training objectives. If the pre-designed training programmes do not fulfil all your training needs, please see our Tailored Training Solutions or contact us and we can work with you to meet your personal requirements.

Units Covered

NHS Knowledge – Provides a holistic understanding of how the NHS works; training components include:

• An Introduction to the NHS
• NHS Strategy
• An Introduction to NPfIT
• Independent Providers
• Foundation Trust

NHS Data Standards:

• Information Governance, Security & Confidentiality
• Organisation Data Service
• NHS Data Dictionary & Data Quality

Acute, Community & Mental Health Data Sets:

• Admitted Patient Care
• Elective Admission Lists
• Outpatients, Future Appointments, Follow up Pending Lists & Outpatient Waiting Lists
• Accident & Emergency
• Choose & Book
• Mental Health
• Child Health

Demographics:

• Master Patient Index (MPI)
• NHS Numbers
• NHS Numbers for Babies
• Personal Demographics Service
• Interactive Tracing
• Batch Tracing
• Handling duplicate patients
• IQAP standards for handling demographic data

Commissioning:

• Clinical Coding
• Healthcare Resource Groups (HRG's)
• Secondary Uses Service
• Commissioning
• Payment by Results

Reporting & Measurement within the NHS:

• Healthcare Measurement
• 18 week referral to treat

NHS SQL Training – Designed to take people from having no previous data analysis training, to being competent, efficient data analysts.

SQL Foundation Course:

• Introduction to RDMS and SQL Server 2005
• The Client Server Model
• Creating Tables
• Basic Structured Query Language
• Entity modelling
• Joining Tables
• Manipulating Data
• Transforming data into information & Analysing Data
• SQL Management – Jobs

SQL Advance Course:

• Advanced Query Concepts
• Advanced Query Concepts Plus+
• Managing Complex Query Logic

Professionalising Skills – Business writing can be more than just an email or set of documentation only you may read; it can sometimes be the only form of contact you have with clients. The training is designed to build on the basics in a professional environment to ensure quality, clarity and concise business writing is achieved:

• Introduction to business writing
• How to make yourself clear
• Writing Product and Process Documentation
• Minute Taking

Practical Informatics Skills – Covers the essentials skills for handling data including; files structures, version control, auditing, loading and storing of data, to the more advance application of analysing and understanding data:

• File formats - What is a CSV, text and XML file?
• Specifications, File Definitions & Version Control
• Understanding Reference Data
• Logging Data
• Looking for data anomalies
• Checking Data
• Reconciliation & Audit
• Environment Nomenclature

Project Management & Consultancy – We recognise the importance for staff to display confidence and competence when working with others, whether it is direct with clients, or even just the team:

• Answering telephones
• Guidelines for Client Interfacing
• Effective Communication
• Chairing a meeting