Contact us
500 characters left

DR101: Reporting Fundamentals (Expanse)

Thursday December 8, 2022 11:00am - 5:00pm ET

training 567 intermediate

If you're just getting started with DR in MEDITECH 6.1 or Expanse, 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 into 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.

Prerequisite experience and software: 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.)

Logistics: classes are taught via Microsoft Teams (an account is not required). If you don't use MS Teams already, you'll need Microsoft Edge v81.0 or Google Chrome as your browser.

Class hours: we start at 11:00am ET and finish by 5:00pm ET, including breaks and lunch.

Payment: the cost is $395 per seat, payable at time of registration via credit card.

Our Syllabus

  • An introduction to MEDITECH and Data Repository
  • Relational database concepts
  • All about DR tables
  • Meet SQL Server Management Studio
  • Using Management Studio to write queries
  • Learn T-SQL basics with DR database examples
  • Coding best practices and tips

The fine print: payment can only be made by credit card. If you need to reschedule or cancel your registration, your payment will be credited to another class of your choice. We reserve the right to reschedule the class if necessary due to instructor or student unavailability.

button reserve

Visit the Live online training page for information on other classes.