How to Use This Tutorial
The lessons in this tutorial are arranged sequentially. However, if you
have experience in writing and executing queries, select the lessons you
need to know more about. If you do not have experience in writing and
executing queries, read the lessons in the order in which they are listed.
To help retain what you've learned, complete the activities for each lesson.
More exercises are being planned and in the future, exercises will be
provided so you can practice querying in a training database before you
query the actual Salary Management data in the Warehouse.
Lesson 1. Security, Etiquette, and Ethics - Learn the disclosure
rules for releasing Salary Management data within and outside Penn and
the ways in which you can secure the data on your desktop.
Lesson 2. Salary Management Data Diagram -
Become familiar with the data diagram that depicts the Salary Management
Data Collection.
Lesson 3. Table and Data Element Documentation
- Learn the components of table and data element help, and then strengthen
your understanding of Salary Management tables. Particular emphasis is
placed on the RSALMGT Universe.
Lesson 4. Questions to Ask Before Writing
a Salary Management Query - Focuses on recalling the types of questions,
with explanations, that you should ask before you write a Salary Management
query. For example, "What accounting period do you want?" Also includes
a link to the document General Guidelines for Executing Queries.
Lesson 5. Evaluating Query Results - Introduces
you to methods that you can use to help you determine if your query results
are correct.
Lesson 6. Getting Salary Management Help -
Learn how to use the listserv when needing help with a Salary Management
query.
If you have any questions, please e-mail them to the listserv.
|
