781.329.4300 ¦ 
Ian Proffer
Training
Coming soon!
Contact us if you're interested in scheduling this class.
If you're just getting started with DR, this is the class for you. Applicable to all MT versions from MAGIC to Expanse. This beginner-level training is geared toward report writers with little or no experience with SQL Server. We'll provide an overview of MEDITECH application architecture and Data Repository before diving in to the DR database schema and commonly-used reporting tables. You'll learn how to write T-SQL queries with Management Studio and get some hands-on experience with realistic examples from MEDITECH systems.
If you've taken our DR101 class, or have a little DR experience under your belt, take the next step! This intermediate-level T-SQL class is for the report writer looking to move beyond the basics. We'll discuss the specific challenges of developing reports from Data Repository, while working with realistic scenarios from typical MEDITECH environments. You'll learn about the most frequently used T-SQL system functions to make your code more efficient, and how to create stored procedure objects as the basis for your reports.
If you're an experienced MAGIC or C/S Data Repository report writer and your organization is moving to Expanse, this is the class for you. You'll learn how to transition to the latest DR database schema, including review of the “split” of applications into two separate databases. We'll highlight the significant changes within key applications, with an eye toward helping you plan how to convert your existing library of DR and NPR reports.