Online Training: DR201-Intermediate T-SQL

Presenter: Ian Proffer

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.

Syllabus:
* The basics of using JOINtraining intermediate
* Follow the primary keys
* JOIN techniques in DR
* What are T-SQL expressions?
* Commonly used system functions
* Using parameters in stored procedures

Compete Details