Top Hiring Company
Industry Trends
Course curriculum / Syllabus
Overview of DB2 9.7 on Windows
- Contrast the DB2 Family of products
- Identify the DB2 Tools
- Functions of DB2 components
- Explore installation and parameters
Command Line Processor (CLP) & GUI Usage
- Use the Command Line Processor
- Explore the GUI environment
- Describe the DAS role with GUI tools
The DB2 Environment
- 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 Databases and Data Placement
- Creating a Database.
- Explore system Catalog tables, views
- Compare DMS Vs SMS table Spaces.
- Database with Automatic Storage.
- Concept of containers, table spaces, extents, and pages
- Define table spaces
- Get snapshot for table spaces
- Explore Database Config. Parameter.
Creating Database Objects
- DB2 object hierarchy, physical directories and files
- Creating objects: Table, Schema, Alias, View, and Index
- Explore the use of table partitioning
- Review the use of Temporary Tables
- Exploring the use of Large Objects
Moving Data
- INSERT statement and 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
- Use the SET INTEGRITY command
- Discuss the db2move and db2look commands
Backup And Recovery
- Backup and recovery principles
- Types of recovery in DB2
- Logging for backup and recovery
- About circular & archival logging
- Use the BACKUP, RESTORE, and ROLLFORWARD commands
- Perform a table space backup and recovery
- Database restore
- Backup and recovery scenarios
Locking And Concurrency
- Explain why locking is needed
- List objects that can be locked
- Various lock modes and compatibility of each lock mode
- Explain four different levels of data protection
- Set lock time out and isolation level for current activity
- Explain lock conversion & escalation
- Describe causes of Deadlocks
Problem Determination
- Collect information for problem analysis and resolution
- Use error logs for basic problem analysis
- Describe four types of monitors
- Basic commands for connections and Sessions
- Statistics and information retrieval from a running DB2 instance
Application Issues and Performance
- Applications development by accessing DB2 data for execution
- Application alternatives to access DB2 data
- Clustering and cluster sequence
- Use REORGCHK, RUNSTATS, and REORG for improving application performance
- Work with the EXPLAIN facility
Security
- Implement database security through Access Control Mechanisms
- Create a control hierarchy through group IDs
- Describe Label Based Access Control
- Describe privileges within a database
- Privileges for binding and executing a package
- Difference between privileges : explicit and implicit
- Describe the different level of authorization
DB2 Training FAQ’s:
1.Can we get the facility of mock interview sessions?
Yes, you will be offered the sessions of mock interview. You will also be get DB2 interview questions after the course.
2.When will we receive our certificate?
If you successfully complete the course, you will receive a certificate.
3.Will we receive a practical environment?
Yes. You will receive a hands-on environment, including lab time, installation, set-up, etc.
4.Is there a demonstration session prior to the course?
Yes. Demonstration sessions are available prior to the start of the course.
5.How soon will I receive the course materials?
You will receive the course materials after you have paid the course fee.
Enquire Now
Related Courses
.jpg)
Why QTS INFO
Best Virtual training classrooms for IT aspirants
Real time curriculum with job oriented training.
Around the clock assistance
We are eager to solve your queries 24*7 with help of our expert faculty.
Flexible Timings
Choose your schedule as per your convenience. No need to delay your work
Mock projects
Real world project samples for practical sessions
