- On-Site Training
-
Training for your staff on one to multi-department training.
Classes are designed for the level of the expertise desired.
-
Introduction to SQL. ANSI standard SQL. Editor overview. Basic
query development. Data Dictionary overview, table and element
selection.
-
Advanced SQL. Advanced query logic, functions, report
formatting. Emphasis is placed on developing performance-conscious
queries, and using the correct application tables.
-
Database Administrator. Security setup. Performance tuning.
Advanced coding techniques. User defined table development.
-
- Custom Report & Query Development
-
Data analysis and reporting are essential tools to help make
sound decisions for a strong healthcare system.
Knowing where to get your data, reporting it efficiently and effectively
is the key to your success.
We will design reports, queries and downloads using the most
efficient tables and comprehensive programming logic to get the data
you need fast.
- SQL System Support & Performance
Auditing
-
- Inefficient query writing can have a major impact on system
performance and take many hours to run.
Queries are analyzed for efficient table selection and optimization
standards.
SQL Interfaces-
- Interfacing to other medical systems from STAR can be tricky. On
demand or scheduled downloads can extract information from STAR for
importing into other systems.
-
SQL Tools Upgrades-
- STAR upgrades usually mean changes to the SQL Data Dictionary.
-
- We will test and update your queries during your STAR upgrades for
performance and functionality.
