Online MEDITECH Data Repository training.

Brought to you by the DR experts.


One-day, instructor-led live classes.

learn meditech online

You asked, we listened. We're pleased to announce our training classes are now taught online with a live instructor. These separate one-day sessions are affordable, convenient and geared toward your skill level and experience with DR and SQL Server. We host a live session with Microsoft Teams, including lecture, real-time demonstrations with SQL tools, and time for you to work on learning exercises on a SQL Server instance using Management Studio. Check out each class topic and agenda below to determine which one is best for you.

 

Our Classes

DR101: Reporting Fundamentals  just getting started with DR? This is the class for you. 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.

  1. An introduction to MEDITECH and Data Repository training beginner
  2. Relational database concepts
  3. All about DR tables
  4. Meet SQL Server Management Studio
  5. Using Management Studio to write queries
  6. Learn T-SQL basics with DR database examples
  7. Coding best practices and tips

Prerequisites: none, although some familiarity with MEDITECH is helpful. SQL Server Management Studio 2016 or newer installed on your desktop or laptop. (Available as a free download from Microsoft.)

Schedule: 10:00 - 4:30pm ET, includes breaks and lunch.

See schedule and registration information for the next DR101 class on our Events page.


DR201: Intermediate T-SQL  ready for more? 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.

  1. The basics of using JOINtraining intermediate
  2. Follow the primary keys
  3. JOIN techniques in DR
  4. What are T-SQL expressions?
  5. Commonly used system functions
  6. Using parameters in stored procedures

Prerequisites: our DR101 class, or proficiency with basic T-SQL query statements and an understanding of MEDITECH applications. SQL Server Management Studio 2016 or newer installed on your desktop or laptop. (Available as a free download from Microsoft.)

Schedule: 10:00 - 4:30pm ET, includes breaks and lunch.

See schedule and registration information for the next DR201 class on our Events page.


DR301: Conversion to Expanse – are you an experienced MAGIC or C/S report writer? Is your organization moving to Expanse? If so, this class teaches you 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.

  1. Expanse / 6.1 overviewtraining advanced
  2. DR database schema changes and object-naming conventions
  3. Goodbye ADM and MRI, hello REG and HIM
  4. Changes in ABS, including common table conventions
  5. What's new in patient accounts/BAR

Prerequisites: intermediate T-SQL skills in a MAGIC or C/S Data Repository environment. Working knowledge of NPR-based ABS, ADM and BAR applications is helpful, but not required. SQL Server Management Studio 2016 or newer installed on your desktop or laptop. (Available as a free download from Microsoft.)

Schedule: 10:00 - 4:30pm ET, includes breaks and lunch.

See schedule and registration information for the next DR301 class on our Events page.


Scheduling & cost

See our events page for all upcoming online training classes and other events. The online training classes cost $395 per seat, per class.