 |
|
|
MCTS Implementing and Maintaining MS SQL Server 2005
Microsoft Certified Technology Specialists course provides comprehensive understanding of implementation and maintenance of SQL Server 2005 databases. This course provides extensive knowledge of the product, understanding on how to use the tools and Transact-SQL language, and knowledge of how to explore the user interface. This course also prepare for highly recognized MCTS-SQL Server 2005 certification. After the training, individuals will be able to demonstrate the skills necessary to lead the successful implementation, and administration of SQL Server 2005 databases
Our top-notch information technology and computer training meets the growing demands of the Portland Metro area including Vancouver (WA), Southwestern Washington, and Salem, Oregon communities.
For more
details, please contact our Technical Adviser at
503-725-2395 or email it@pdx.edu.
COURSE
OUTLINE:
Install SQL Server 2005
Configure SQL Server 2005 instances and databases
Configure SQL Server security
Configure linked servers by using SQL Server Management Studio (SSMS)
Implement database mirroring
Implement log shipping
Manage database snapshots
Retrieve data to support ad hoc and recurring queries
Manipulate relational data
Import and export data from a file
Manage replication
Implement and maintain SQL Server Agent jobs
Manage databases by using Transact-SQL
Back up a database
Restore a database
Move a database between servers
Gather performance and optimization data by using the SQL Server Profiler
Gather performance and optimization data by using the Database Engine Tuning Advisor
Monitor and resolve blocks and deadlocks
Diagnose and resolve database server errors
Monitor SQL Server Agent job history
Implement a table
Implement a view
Implement triggers
Implement functions
Implement stored procedures
Implement constraints
Implement indexes
Create user-defined types
Implement partitions
PREREQUISITES:
Basic knowledge of Windows OS and RDBMS concepts.
