Presenter:Ian ProfferIf 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.
Our Syllabus* 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
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.
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