Brochure
Enquire
- DB2 family products overview (LUW, Mainframe, iSeries)
- DB2 LUW product editions
- DB2 product features and functions
- DB2 client connectivity options
- Home
- Mindmajix Technologies
- Courses
- IBM DB2 Training
IBM DB2 Training
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
The IBM DB2 Training course is meant to facilitate the students to gain the relevant knowledge and skills of IBM DB2 or Database 2 and help them to become Certified IBM DB2 Professionals. In this course, the students will explore various aspects of IBM DB2 including DB2 Database Manager Instance, IBM Data Studio Tool, XQuery, DB2 Security, and much more. The curriculum of the IBM DB2 Training online course will ensure that the students master the in-depth knowledge of database creation, objects, security, etc along with practical knowledge in order to have the in-demand skills of the industry.
The interested candidates who have the plan to join the IBM DB2 Training certification, offered by Mindmajix Technologies, are needed to have a basic understanding of Data Processing concepts, SQL, and XML Query to be eligible for the programme. The course will expose the students to learn Database creation, Object in Db2, DB2 Backup, DB2 Recover Database, and whatnot.
The highlights
- 100% online course
- Offered by Mindmajix Technologies
- FREE Demo on Request
- Flexible Schedule
- Online Live and Self-paced Training Options
- 24/7 Lifetime Support
- Life-Time Self-Paced Videos Access
- One-on-One Doubt Clearing
- Certification Oriented Curriculum
Program offerings
- One-on-one doubt clearing sessions
- Certification oriented curriculum
- Real-time project use cases
- Free demo on request
- 24/7 lifetime support
- Online live and self-paced training options
- 20 hours of labs
- 25 hours of sessions
Course and certificate fees
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
Who it is for
What you will learn
Database management
At the end of the IBM DB2 Training online certification, the learners will learn Information Model, Authorization, Label-Based Access Control, XQuery, and Relational Data Model. Plus, the students will study the basics of Db2, code basics, SQL statements, the processing of Db2, and their applications.
The syllabus
Introduction to IBM DB2
The DB2 Database Manager Instance
- About DB2 Instance
- Database Manager Instance overview
- Starting and Stopping an instance
- list and modify DBM configuration
- Db2set command
- Db2 history command
- DB2 instance creation pre-requisites
- Create and Drop an instance
- DB2 registry and environment variables
DB2 Fundamentals & IBM Data Studio Tool
- Product Overview
- Editions & Features
- Licensing
- DB2 Fundamentals and Architecture
- Users
- Instances
- Buffer pools
- Security
- DB2 Client
- Storage
- Table spaces
- SQL and XQuery
- IBM Data Studio
- DSAC
Creating databases and data placement
- Database creation pre-requisites
- Database storage requirements
- Table spaces overview
- Storage management overview (SMS, DMS, Automatic)
- Default Table spaces
- List DB configuration parameters
- Database directories and files introduction
- System catalog tables and views
- Containers, extents, pages overview
- Create Tablespace syntax
- Storage groups overview
- Assigning a tablespace to a storage group
- Introduction to db2pd command
- Alter Tablespace, Alter Stogroup
- DB2 List DB Directory
- Activate and deactivate a database
DB2 Security
- Authentication versus Authorization
- SYSADM, SYSCTRL, SYSMAINT, SYSMON
- DB2 security privilege hierarchies
- Grant and Revoke privileges
- Trusted Context
- Label-Based Access Control (LBAC)
- ROLES
DB2 Backup and Recovery
- Transactional logging (Circular, Archival)
- Configure database logs
- Backup utility options
- Recovery utility options
- Rollforward
- DB2 Recover Database
- Online versus Offline backup
Working with Databases and Object in Db2
- Servers, Instances, and Databases
- Managing Instances
- Creating a DB2 Database
- Cataloging
- Database (Data) Objects
Installation and Configuration
- Installation & Configuration (working with windows os)
- Database creation
- Instance creation
- Table space Creation
- Working with Buffer pool
Practice Test & Interview Questions
Instructors
Articles
Popular Articles
prev
next
Latest Articles
prev
next
