Explain steps required to import data from external sources.Explain steps required to attach and detach a database.
The purpose of this assessment is to demonstrate an understanding of how data and information can be used to help an organization make data driven decisions
11-16 page Employee Training Manual for WeWin Legal Services.
As a database administrator, it is important to be familiar with the various types of databases and database management systems available and be able to distinguish between rational data models, schemas, manipulations, and attributes. Being familiar with these tools will allow you to perform common maintenance tasks that will be required to improve the performance and functionality of your database. In addition, it will allow you to take the appropriate steps to secure your database, protect the integrity of data, and ensure that your system is scalable and can support future growth.
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, you will 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.