Online Training: DR101-Reporting Fundamentals

Presenter: Ian Proffer

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.

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

Complete Details