Enterprise Justice ECR: Writing a Better SQL Virutal Learning Lab

This course aims to instruct users in the methods to design and review SQL statements necessary for the creation of Enterprise Custom Reports (ECRs). The workshop will focus on SQL development, review and performance.

Enterprise Custom Reports is a licensed feature in Enterprise Justice. Participation in this course does not translate to licensure for Enterprise Custom Reports in your Enterprise Justice environments.

Agenda

  • Ways to review SQLs and their performance
  • Common hints that improve performance
  • Rank and Row Number aggregation
  • Ways to handle Cartesian Sets
  • Q&A

Additional Information

Cancellation Policy: You may cancel up to 3 business days before your scheduled class. If you provide Tyler with less than 3 days’ notice, or fail to attend, you will be liable for the entire class fee. Session will be billed as per our Cancellation Policy. Note: Class size is limited to 30 attendees. *To benefit from the hands-on nature of this workshop, students should have access to your non-Production Enterprise Justice environment.