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. 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.
Prerequisites: 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 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.
- 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 via PayPal. 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.