Instructor Led Advisor Training in Massachusetts, USA
Advisor Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Corporate Education Group
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
... Performing Index Analysis by Using the Database Tuning Advisor (DTA)
After completing this unit, students will be able to:
Explain the methodology of optimizing the query environment. Describe the query performance troubleshooting process. Explain how Database Tuning Advisor can be used to troubleshoot the query environment. Review an execution plan
more...
... Performing Index Analysis by Using the Database Tuning Advisor (DTA)
After completing this unit, students will be able to:
Explain the methodology of optimizing the query environment. Describe the query performance troubleshooting process. Explain how Database Tuning Advisor can be used to troubleshoot the query environment. Review an execution plan
more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005
...essons
? Managing Indexes ? Using the Database Tuning Advisor
Lab 5: Maintaining a Database
? Defining Indexes ? Tuning a Database
After completing this module, students will be able to:
? Maintain indexes in a SQL Server 2005 database. ? Use the Database Tuning Advisor to assist with database design. ? Maintain SQL Server 2005 databases.
Module 6: Securing SQL Server
more...
...essons
? Managing Indexes ? Using the Database Tuning Advisor
Lab 5: Maintaining a Database
? Defining Indexes ? Tuning a Database
After completing this module, students will be able to:
? Maintain indexes in a SQL Server 2005 database. ? Use the Database Tuning Advisor to assist with database design. ? Maintain SQL Server 2005 databases.
Module 6: Securing SQL Server
more...
Oracle Database 10g Administration Workshop I
...llect and use baseline metrics Use tuning and diagnostic advisors Use the Automatic Database Diagnostic Monitor (ADDM) Manage the Automatic Workload Repository
Undo Management Monitor and administer undo Configure undo retention Guarantee undo retention Use the undo advisor
Monitoring and Resolving Lock Conflicts Detect and resolve lock conflicts Manage deadlocks
Backup and
more...
...llect and use baseline metrics Use tuning and diagnostic advisors Use the Automatic Database Diagnostic Monitor (ADDM) Manage the Automatic Workload Repository
Undo Management Monitor and administer undo Configure undo retention Guarantee undo retention Use the undo advisor
Monitoring and Resolving Lock Conflicts Detect and resolve lock conflicts Manage deadlocks
Backup and
more...
Oracle Database 10g Administration Workshop II
...ate measures to correct them
Use the various Database advisors and views to monitor and improve database performance
Control database resource usage with the Resource Manager
Simplify management tasks by using the Scheduler
Improve the security of the listener
Review database log files for diagnostic purposes
Customize language-dependent behavior for the database and
more...
...ate measures to correct them
Use the various Database advisors and views to monitor and improve database performance
Control database resource usage with the Resource Manager
Simplify management tasks by using the Scheduler
Improve the security of the listener
Review database log files for diagnostic purposes
Customize language-dependent behavior for the database and
more...
Oracle Database 10g: New Features for Administrators
...itoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.
more...
...itoring and tuning through the use of Oracle Database 10g Advisors, and to offer simplified database manageability. The course also covers security and some development platform changes that students need to understand if applications running in databases support the related features. Hands-on practice sessions give students an opportunity to examine many of the new features for themselves.
more...
