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