Back to training page

SQL for SDE - Introduction

SQL for SDE - Introduction
This two (2) day class is intended for the novice with SQL for SQL Server or the “I know just enough to get in trouble” user of SDE.  The class covers the basics of SDE from a database standpoint so that you have a thorough understanding of the Architecture.  For example, what happens to the database when you create a Group within SDE?

Understanding SDE Architecture

Do’s and Don’ts with the SDE Database

Backup, Backup, Backup and a Restore

Importance of a Test Server – Setting it up!

SQL Management Studio – Let’s get comfortable.

Structured Query Language – Query Window

• Syntax
• Select Statements
• Where Clauses
• Group by
• Order by
• Useful Select Statements
• Case When
• Correlated vs. Non Correlated
• Calculated Fields Anyone?
• DML Statements (Insert, Update and Deletes)
• Declaring and Using SQL variables

Using SQL in Simple Business Rules