Faites confiance à votre formation en TI |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.
ExitCertified renforce sa relation avec Red Hat en obtenant le statut de revendeur avancés.
Oracle University décerne à ExitCertified le prix de Qualité exceptionnelle des instructeurs.
ExitCertified en vedette dans le répertoire des Entrepreneurs dynamiques du 21e siècle.
ExitCertified est mis en candidature une troisième fois pour les prix de la Chambre de commerce.
ExitCertified élargit sa relation avec Apple en ajoutant la diffusion de formation agréée Mac OS à Phoenix, en Arizona.
 |
Fast Path to DB2 9 for Experienced Relational DBAs - Self Paced Virtual Course (2L282) |
 |
|
| Format: Formation individualisée en ligne |
| Autres formats: |
|
|
|
|
|
|
| |
This course is also offered as Classroom course CL282 and Instructor Led OnLine 3L282 This is a self-paced online course and includes hands-on remote labs. The average amount of time to complete this course is 16 hours. Once you receive your access information, you will have 30 days to complete this course and its labs. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pureXML (native XML storage) will be introduced. This course provides a fast path to DB2 database administration skills for experienced relational DBAs. The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but lab system access is allocated on a first-come, first-served basis. You will have a total of 40 hours allocated to complete all of the lab exercises, so when you are not using the system, ensure that you log out to maximize ability to use the lab system. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours. Course Materials The course materials address DB2 9.7 for Linux, UNIX, and Windows. Hands-On Labs Six labs are included to address DB2 9.7 for Linux, UNIX, and Windows. Certification Program Descriptions Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. |
|
|
|
|
|
|
|
 |
|
 |
Compétences acquises |
| |
- List and describe the components of DB2
- Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles
- Administer a DB2 database system using commands and GUI tools
- Implement a given logical database design using DB2 to support integrity and concurrency requirements
- Use autonomic features of DB2
- Define a DB2 recovery strategy and perform the tasks necessary to support the strategy
- Implement DB2 security
- Describe the application development process with respect to DB2 considerations
|
|
|
|
|
Préalables |
| |
You should be able to: - Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor
- State the functions of the Structured Query Language (SQL), and be able to construct Data Definition Language (DDL), Data Manipulation Language (DML), and authorization statements
- Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
These skills can be developed by taking: - OS Training:
- AIX 5L Basics
- Linux Basics and Administration
- Windows Systems Administration
- or by having equivalent HP-UX or Solaris administration experience
- DB2 SQL Workshop
- DB2 Family Fundamentals
|
|
|
|
| |
 | Ce cours autoformation est certifié par le .
À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.
Il y a une différence. Découvrez-la  |
|
 |
| Code: |
2L282 |
| Format: |
Formation individualisée en ligne |
|
| Durée: |
< select item > days |
| Certifié par: |
IBM |
|
| Frais d’inscription (CAD): $contact |
|
|
 |
|
|
|
|
|
|
|
|
Fast Path to DB2 9 for Experienced Relational DBAs - Self Paced Virtual Course (2L282) Contenu détaillé |
| |
| |
| Overview of DB2 9 on Linux, UNIX and Windows | - Contrast the DB2 Family of products
- Identify the DB2 Products
- Describe the functions of DB2 components
- Explore installation and parameters
| |
| Command Line Processor (CLP) and GUI usage | - Use the Command Line Processor
- Explore the GUI environment
- Describe the DAS role with GUI tools
| |
- Specify the key features of an Instance
- Create and drop an Instance
- Use db2start and db2stop
- Distinguish between types of configuration
- Describe and modify the Database Manager Configuration
| |
| Creating databases and data placement | - Review specifics of creating a database
- Explore the System Catalog tables and views
- Compare DMS versus SMS table spaces
- Describe how to setup and manage a DB2 database with Automatic Storage enabled
- Differentiate between table spaces, containers, extents, and pages
- Define table spaces
- Use the get snapshot for tablespaces command to display table space statistics
- Explore Database configuration parameters
| |
| Creating database objects | - List DB2 object hierarchy and physical directories and files
- Create the following objects: Â Schema, Table, View, Alias, Index
- Explore the use of table partitioning
- Review the use of Temporary Tables
- Explore the use and implementation of Check Constraints, Referential Integrity and Triggers
- Explore the need for and the use of Large Objects
- Recognize XML and its native store as critical infrastructure for emerging technologies
| |
| |
- Discuss the INSERT statement and recognize its limitations
- Explain the differences between IMPORT and LOAD
- Explain the EXPORT, IMPORT, and LOAD syntax
- Create and use Exception Tables and Dump-Files
- Distinguish and resolve Table States: Load Pending and Set Integrity Pending
- Use the SET INTEGRITY command
- Discuss the db2move and db2look commands
| |
- Describe the major principles and methods for backup and recovery
- State the three types of recovery used by DB2
- Explain the importance of logging for backup and recovery
- Describe how data logging takes place, including circular logging and archival logging
- Use the BACKUP, RESTORE, and ROLLFORWARD commands
- Perform a table space backup and recovery
- Restore a database to the end of logs or to a point-in-time
- Discuss the configuration parameters and the recovery history file and use these to handle various backup and recovery scenarios
| |
- Explain why locking is needed
- List objects that can be locked
- Describe and discuss the various lock modes and their compatibility
- Explain four different levels of data protection
- Set isolation level and lock time out for current activity
- Explain lock conversion and escalation
- Describe the situation that causes deadlocks
| |
- Collect information for problem analysis and resolution
- Use error logs for basic problem analysis
- Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor, Health Monitor
- Describe the function of EXPLAIN and use this facility to assist basic analysis
- Use a series of basic commands to better work with connections and sessions
- Retrieve statistics and other information from a running DB2 instance
- Use RUNSTATS, REORGCHK, and REORG to resolve application performance problems
| |
- Use DB2 access control mechanisms to implement security within the database
- Use group IDs to create a control hierarchy
- Describe privileges within a database
- Describe privileges required for binding and executing a package
- Describe the difference between explicit privileges and implicit privileges
- Describe the different DB2 authorization levels
- Describe Label Based Access Control (LBAC)
- Explain the use of Roles and Trusted Context
| |
- Welcome
- Unit 1: Overview of DB2 on Linux, UNIX, and Windows
- Unit 2: Command Line Processor (CLP) and GUI usage
- Unit 3: The DB2 environment
- Exercise 1: Create a new DB2 instance
- Unit 4: Creating databases and data placement
- Exercise 2: Creating Databases/Table spaces
- Unit 5: Creating database objects
- Exercise 3: Create objects
- Unit 6: Moving data
- Exercise 4 Moving data
- Unit 7: Backup and recovery
- Exercise 5: Backup and recovery
- Unit 8: Locking and concurrency
- Unit 9: Problem determination
- Exercise 6: Investigating DB2 Locking
| |
| |
|
