Profile

Login

Catalog

Search

Contact

Cart

	IBM DB2 Universal Database V6.1 Administration
	DB2V61A
	English
Audience Details:
	16
	Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed.
	These courses are intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of databases, tables, rows/columns, data types, etc., prior to taking this course. Limited exposure to SQL is also assumed. Learners must have an understanding of the general database administrator role and function. When coupled with appropriate on-the-job experience, these courses will help prepare students for the IBM Certified Solutions Expert Certification Database Administration exam 510.
	The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses eeded to prepare for IBM Certified Solutions Expert certification exams 509 and 510. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL. Students will also learn how to plan, implement and maintain ew and existing DB2 databases. This curriculum consists of 2 Skill Builder courses: Course 13431 IBM DB2 Universal Database V6.1 Fundamentals Course 13432 IBM DB2 Universal Database V6.1 Administration Certification: This curriculum will help candidates prepare for the ILT exams DB2 UDB Fundamentals and DB2 UDB Administration Workshop for Windows T.
	After learning this courses you should be able to:
	Identify DB2 UDB product editions, their installation and verification, user interfaces, and security features. Create and access DB2 database objects, ensure data validation and integrity, and create views and indexes. Master basic Structure Query Language (SQL). Manage database operations. Implement a new DB2 database or application. Maintain an existing DB2 database.
	Hands on pratice - Simulations
Course Structure:	Modules and Learning Events
	Unit 1: Introduction to DB2 Universal Database V6.1 (1 - 2 hours) -Match the product editions of DB2 UDB with their characteristics. -Identify the satellite administration functions of the Satellite Administration Center. -Match the DB2 UDB clients with their functions. -Match the communication protocols that DB2 supports with their associated platform environments. -Identify which DB2 Connect product to use given a specific scenario. -Match the DB2 UDB products with their functions. -Install a DB2 UDB server given system specifications. -Identify tasks performed to verify a DB2 installation using First Steps. -Install a DB2 client given a scenario. -Sequence the steps of a distributed installation for DB2 clients. -Match the database directories with their descriptions. -Catalog a node and a database using the CATALOG command. -Identify the functions of the DB2 Administration Server instance. -Match the DB2 command interfaces with their characteristics. -Identify the tasks performed using the Control Center. -Match security levels with their definitions. -Sequence the steps in the authentication process a user follows when accessing a DB2 instance. -Identify the characteristics of DB2 authorization levels. -Provide a user with privileges on database objects using Data Control Language (DCL). Unit 2: Creating and Accessing Database Objects Unit 2 - Creating and Accessing Database Objects (1 - 2 hours) -Match the data placement objects with their definitions. -Select the type of table space needed given a scenario. -Create a database and table space given a set of parameters. -Match data elements with their data types. -Identify column definitions that allow the insertion of null values. -Create a table based on a set of instructions. -Locate information in system catalogs by viewing a system catalog table. -Create a view with specific characteristics. -Create an index with specific characteristics. -Identify the effects of table check constraints given a CREATE table statement. -Identify characteristics of a trigger. -Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions. Unit 3: Basic Structured Query Language Usage (2 hours) -Display data using a SELECT statement. -Specify rows to be retrieved from a table given certain requirements. -Apply DB2 functions to groups within a table for a given scenario. -Retrieve data from multiple tables given a scenario. -Enter data into a table using an INSERT statement. -Modify data in a table using an UPDATE statement. -Remove data from a table using a DELETE statement. -Identify considerations in embedding SQL in applications for DB2. -Sequence the steps to prepare to run an application program. Unit 4: Managing Databases (2 hours) -Identify the effect of COMMIT and ROLLBACK processing given a scenario. -Identify the objects on which locks can be obtained. -Match row lock modes with their characteristics. -Identify ways that DB2 resolves lock contention. -Match isolation levels with their properties. -Transfer data between databases using data movement utilities. -Match maintenance utilities with their functions. Unit 5: Design for a New DB2 Implementation (3 - 4 hours) • Match the authentication parameter settings with their outcomes. • Identify the authority level required for a specified privilege. • Set access to objects given a scenario. • Analyze the security system catalogs to determine the privileges a user holds. • Identify the events that the DB2 audit facility can capture. • Match the data placement objects with their descriptions. • Construct a table space using the CREATE TABLESPACE statement. • Choose the required number of containers given a scenario. • Construct a buffer pool of a specified page size using the CREATE BUFFERPOOL statement. • Select the effects of a CREATE DATABASE statement. • Select data placement attributes given the system catalogs. • Construct the appropriate type of index using the CREATE INDEX statement. • Identify effects of index re-creation strategies. • Construct a referential integrity (RI) constraint for a table using the ALTER TABLE statement. • Construct a view on a table using the CREATE VIEW statement. • Construct a schema using the CREATE SCHEMA statement. • Change communications parameters using the UPDATE DATABASE MANAGER CONFIGURATION command. Unit 6: Maintenance of an Existing Database (3 - 4 hours) • Match Control Center tools with their functions. • Create a scheduled script using the Script Center. • Identify which type of logging is required for a given recovery situation. • Make a copy of a database using the BACKUP DATABASE command. • Perform the RESTORE procedure using the RESTORE DATABASE command. • Disengage a connection to DB2 using the FORCE command. • Capture EXPLAIN data to use with VISUAL EXPLAIN. • Analyze the access plan from the EXPLAIN tables using the VISUAL EXPLAIN graphical interface. • Create an Event Monitor using the CREATE EVENT MONITOR statement. • Collect snapshot data using the GET SNAPSHOT command. • Change configuration parameters related to performance using DB2 commands. • Identify the purposes of the DB2 Governor. • Identify information in the diagnostic file DB2DIAG.LOG. • Extract data from a table using the EXPORT utility. • Enter data into a table using the IMPORT utility. • Enter data into a table using the LOAD utility. • Select the required data exchange utility for specified criteria. • Reorganize a table using data organization utilities. • Update the statistics for database objects using the RUNSTATS command. • Identify the functions of DB2MOVE and DB2LOOK.
Curriculum Info:
	IBM
	Personal Use License Price $895.00
	Contact your Eno Learning Consultant or call 877-298-1322 to order. For organizational purchases, please contact the sales office nearest you. Available on Multimedia CDs