Back to training page

SQL for SDE - Advanced

SQL for SDE - Advanced
This three (3) day class is intended for the student who has taken the SQL for SDE – Introduction course or is comfortable with writing basic SQL statements and wants to take their skill set to the next level with functions, triggers, and stored procedures specifically with SDE.  Real world consulting scenarios in a fully customized database are used to help you think outside the box on what is possible with SDE and simplifying your SDE Administration.

Understanding SDE Architecture – A Quick Review

Do’s and Don’ts with the SDE Database

Backup, Backup, Backup and a Restore

Importance of using a Test Server!

User Defined Functions

  • Function Best Practices
  • Modifying an existing SDE function (Copy and Rename)
  • Creating Roll Up Functions – No Cursors Required!
  • Creating Functions that create Temp Tables

Triggers

  • Trigger Best Practices
  • When to use Triggers
  • After Insert, After Update, After Delete

Stored Procedures

  • Stored Procedure Best Practices
  • Using Stored Procedures
  • Stored Procedures and Reporting

SDE Business Rules

  • Putting it all together in real world scenarios

Home Services About Contact