11-16 page Employee Training Manual for WeWin Legal Services
For this assessment, you will be assuming the role of database administrator for WeWin Legal Services.
You will be evaluating the existing database environment and will be making recommendations for configuration and optimization with the goal of improving performance. The organization has been very successful and continues to grow. You are planning on hiring a new employee to help you manage the database.
In preparation for your new hire, create a training manual for your new employees that provides detailed information on how to manage and administer the database.
Specifically you should include guidance on how to:
Create tables, views, and stored procedures
Explain steps required to copy a database
Explain steps required to attach and detach a database
Explain steps required to import data from external sources
Utilizing SQL Profiler explain steps required to correctly baseline a database
In addition, you will want to include an introduction that describes your plans of incorporating GIS into the database along with a description of how GIS can be used within the organization.