IICT Chromepet, k k nagar provides real-time and placement focused DB2 DBA training in k k nagar . Our DB2 DBA 10g 11g dba course includes basic to advanced level and our DB2 DBA course is designed to get the placement in good MNC companies in k k nagar as quickly as once you complete the DB2 DBA certification training course. Our DB2 DBA trainers are DB2 DBA 10g 11g dba certified experts and experienced working professionals with hands on real time multiple DB2 DBA projects knowledge. We have designed our DB2 DBA course content and syllabus based on students requirement to achieve everyone's career goal.
Our DB2 DBA training center is equipped with lab facilities and excellent infrastructure. We also provide DB2 DBA certification training path for our students in k k nagar. Our DB2 DBA course fee is value for money and tailor-made course fee based on the each student's training requirements. DB2 DBA training in k k nagar conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.
Contrast the DB2 Family of products
Identify the DB2 Tools
Functions of DB2 components
Explore installation and parameters
Use the Command Line Processor
Explore the GUI environment
Describe the DAS role with GUI tools
Key features of an Instance
Create and drop an Instance
Use db2start and db2stop
Distinguish b/w types of Config.
Describe and modify the Database Manager Configuration
Creating a Database.
Explore system Catalog tables, views
Compare DMS Vs SMS table Spaces.
Database with Automatic Storage.
Differentiate between table spaces, containers, extents, and pages
Define table spaces
Get snapshot for table spaces
Explore Database Config. Parameter.
List DB2 object hierarchy and physical directories & files
Creating objects: Schema, Table, View, Alias, and Index
Explore the use of table partitioning
Review the use of Temporary Tables
Implementation of Check Constraints, Referential Integrity and Triggers
Exploring the use of Large Objects
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 & recovery
Describe how data logging takes Place –circular & 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
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 & escalation
Describe causes of 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 and Health Monitor
Basic commands to better work with connections and Sessions
Retrieve statistics and information from a running DB2 instance
Prepare applications that access DB2 data for execution
Describe the application alternatives available to access DB2 data
Define the concept of clustering, and determine the proper cluster sequence
Use RUNSTATS, REORGCHK, and REORG to enhance application performance
Work with the EXPLAIN facility
Use Access Control Mechanisms to implement database security
Use group IDs to create a control hierarchy
Describe Label Based Access Control
Describe privileges within a database
Describe privileges required for binding and executing a package
Describe the difference between explicit privileges & implicit privileges
Describe the different level of authorization
More than 7 Years of experience in DB2 DBA Technologies
Has worked on 5 realtime DB2 DBA projects
Working in a MNC company in k k nagar
Trained 50+ Students so far.
Strong Theoretical & Practical Knowledge
DB2 DBA certified Professional