|
|
|
|
DBT Laboratory Martti Laiho, HAAGA-HELIA University of Applied Sciences Learning Objectives: -understanding the need, techniques, procedures, and major options of Database Backups -understanding basics of Database Recovery procedure of the mainstream DBMS systems
-understanding the need of disaster recovery plan and backup strategy
-understanding the need and basics of indexing technologies in the mainstream DBMS
-understanding basics of index design and management in the mainstream DBMS systems
Part A: Database Backup and Recovery Backup and recovery tutorial overview of generic database server instance and its database(s) with transaction logs, principles of database backups and recovery in case of hardware or software crashes, or other failures. Hands-on exercises part require the use of some local SQL Server instance. View Download Part B: Tunning and Index Design Index design tutorial material based on the DBTech Pro Index Design workshop (Martti Laiho and Tapio Lahdenmäki, University of Malaga DBTech Pro Workshop, 2004), and the book "Relational Database Index Design and the Optimizers" by Tapio Lahdenmäki and Michael Leach (Wiley 2005). View Download VMWare virtual machine with IBM DB2 Express-C on a Linux SUSE platform, for the hands-on laboratory practicing part of the DBT Lab: Download Database implementations, security management, database backups and restore, monitoring and tuning operations are among the essential topics to understand and manage by a database administrator (DBA). For more information, please refer to the administration manuals of the mainstream database systems: DB2, Oracle, and SQL Server. At otn.oracle.com Oracle provides also excellent, detailed tutorials on these. On DB2 administration, IBM is providing also free e-Book series via its "DB2 on Campus” program.
* The DBTech EXT project has been funded with support from the European Commission. This publication reflects the views only of the author(s), and the Commission cannot be held responsible for any use which may be made of the information contained therein |