Presenter:Ian ProfferIf 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.
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
Prerequisites: none, although some familiarity with MEDITECH is helpful. SQL Server Management Studio 2016 or newer installed on your desktop or laptop.
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.
REGISTER