back to Course Categories | back | print
Database Management using DBArtisan          

Duration: 2 days

Description 
This class will teach database administrators (DBAs) how to effectively use DBArtisan to manage and work with databases. Students will install and configure DBArtisan, then use DBArtisan 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 DBArtisan 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 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 previous database administration experience.


 
 
 

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