phone icon 781.329.4300  ¦  Message us  ¦ Customer support login

500 characters left

DR101: Reporting Fundamentals

Coming soon!

Contact us if you're interested in scheduling this class.

training 567 intermediate

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.

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.)

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 10:00am EST and finish by 4:30pm EST, 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.  

 

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