Wednesday Feb. 15, 2023 11:00am - 5:30pm ET
If you've taken our DR101 class, or have a little DR experience under your belt, take the next step! This intermediate-level T-SQL class is for the report writer looking to move beyond the basics. Note: this class applies to MEDITECH 6.1 and Expanse only.
We'll discuss the specific challenges of developing reports from Data Repository, while working with realistic scenarios from typical MEDITECH environments. You'll learn about the most frequently used T-SQL system functions to make your code more efficient, and how to create stored procedure objects as the basis for your reports.
Prerequisite experience and software: our DR101 class, or proficiency with basic T-SQL query statements and an understanding of MEDITECH applications. 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 EST and finish by 5:00pm EST, including breaks and lunch.
Payment: the cost is $395 per seat, payable at time of registration via credit card.
- The basics of using JOIN
- Follow the primary keys
- JOIN techniques in DR
- What are T-SQL expressions?
- Commonly used system functions
- Using parameters in stored procedures
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.
Visit the Live online training page for information on other classes.