DB2 Administration
DB2 Administration Server. The DB2® Administration Server (DAS) is a control point used only to assist with tasks on DB2 database instances. You must have a running DAS if you want to use available tools like the Configuration Assistant, the Control Center, or the Development Center.
Objects:
Objects:
- RELATIONAL DATA MODEL
- DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL
- INSTALLATION AND CONFIGURATION
- WORKING WITH DATABASES AND DATABASE OBJECT IN DB2
- DB2 SECURITY
- DB2 BACKUP AND RECOVERY
- DB2 PURE XML
- DB2 PROGRAMMING FUNDAMENTALS
Duration : 20 DAYS (30 hours) `{`one & half hour per day`}`
Pre-requisite : Should have the knowledge on SQL
Course material : Only softcopy (in the form of pdf)
Software : DB2 9.7 Express-C, IBM Data Studio, Built-in Linux supported DB2 software
Pre-requisite : Should have the knowledge on SQL
Course material : Only softcopy (in the form of pdf)
Software : DB2 9.7 Express-C, IBM Data Studio, Built-in Linux supported DB2 software
COURSE CONTENT
Part 1:- RELATIONAL DATA MODEL
Agenda
- Data and Databases
- Database Management Systems (DBMS)
- Information Model & Data Model
- Relational Data Model & Relational Databases
- Normalization
Part 2:- DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL
Agenda
- Product Overview
- Editions & Features
- Licensing
- Fundamentals
- Architecture
- Users
- Instances
- DB2 Client
- Storage
- Table spaces
- Buffer pools
- Security
- SQL and XQuery
- IBM Data Studio
- DSAC
PART 3:- INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)
Agenda
- Installation
- Configuration
- Database creation
- Instance creation
- Table space Creation
- Working with Buffer pool
Part 4:- WORKING WITH DATABASES AND DATABASE OBJECT IN DB2
Agenda
- Servers, Instances, and Databases
- Managing Instances
- Creating a DB2 Database
- Cataloging
- Database (Data) Objects
Part 5:- INTRODUCTION TO SQL
Agenda
- SQL
- Data Definition Language
- Data Manipulation Language
- JOINs
- Data Control Language
- Transaction Control Statements
Part 6:- DATA CONCURRENCY
Agenda
- Database Transactions
- Concurrency
- Concurrency Issues
- Concurrency Control
- Isolation Levels
- Locking
- Specifying Isolation Levels
Part 7:- DB2 SECURITY
Agenda
- Authentication
- Trusted Context
- Authorization
- Authorities
- Privileges
- Label-Based Access Control (LBAC)
- ROLES
Part 8:- DB2 BACKUP AND RECOVERY
Agenda
- Backup
- Recovery
Part 9:- DB2 PURE XML
Agenda
- Overview of XML
- PureXML in DB2
- XML Data Movement in DB2
- XQuery and SQL/XML
- XML Indexes in DB2
- Application Development
Part 10:- DB2 PROGRAMMING FUNDAMENTALS
Agenda
- Application Development Environment
- Embedded SQL
- Static SQL
- Dynamic SQL
- Routines
- Types
- Benefits
- Usage
- Tools for Developing Routines
- Triggers
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
IBM DB2 Administration, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements.