back to Course Categories | back | print
Database Management using Toad Professional          

Duration: 3 days

Description 
This class will teach database administrators (DBAs) how to effectively use Toad to manage and work with databases. Toad professional offers a large number of features that maximize DBA productivity. Students will install and configure Toad, then use Toad to manage a multiple database environment as a team of DBAs. This class is designed to simulate a multi-database environment. Students will be assigned trouble tickets for tasks that have to be completed. These tickets are reflective of real world problems that have to be solved by DBAs. By the end of class, the students will be able to use Toad to manage, tune, debug and support their databases. This is not a dummy point and click class. This class is designed as an intense class for professional DBAs.

Topics

  • Installation and configuration
  • Working with DBMS system catalog (dictionary)
  • Schema Browser
  • Knowledge Xpert
  • SQL Editor
  • PL/SQL Debugger
  • DBA Module
  • DBA tools
  • Schema management
  • Managing tables
  • Managing indexes
  • Managing users
  • Working with users
  • Password security
  • Working with roles
  • SQL tuning
  • SQL debugging
  • Working with XML
  • Security management
  • Storage management
  • Reorganizations
  • Extracting and loading data
  • Job management
  • Data management
  • Backup and recovery
  • Performance tuning
  • Cross-platform managment
  • Setting up database environments
  • Best practices
  • Troubleshooting

Prerequisites

  • Attendees must have a fundamental background in database adminisration.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design