IBM DB2 Administration
TIBM DB2 is a family of database server products developed by IBM. These products all support the relational model, but in recent years some products have been extended to support object-relational features and non-relational structures, in particular XML.
DB2 can be administered from either the command-line or a GUI. The command-line interface requires more knowledge of the product but can be more easily scripted and automated. The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users. DB2 supports both SQL and XQuery. DB2 has native implementation of XML data storage, where XML data is stored as XML (not as relational data or CLOB data) for faster access using XQuery.
DB2 has APIs for REXX, PL/I, COBOL, RPG, FORTRAN, C++, C, Delphi, .NET CLI, Java, Python, Perl, PHP, Ruby, and many other programming languages. DB2 also supports integration into the Eclipse and Visual Studio integrated development environments.
RELATIONAL DATA MODEL :1.Data and Databases 2.Database Management Systems (DBMS) 3.Information Model & Data Model 4.Relational Data Model & Relational Databases 5.Normalization
DB2 FUNDAMENTALS AND IBM DATA STUDIO TOOL1.Product Overview 2.Editions & Features 3.Licensing 4.Fundamentals 5.Architecture 6.Users 7.Instances 8.DB2 Client 9.Storage 10.Table spaces 11.Buffer pools 12.Security 13.SQL and XQuery 14.IBM Data Studio 15.DSAC
INSTALLATION AND CONFIGURATION (WORKING WITH WINDOWS OS)1.Installation 2.Configuration 3.Database creation 4.Instance creation 5.Table space Creation 6.Working with Buffer pool
WORKING WITH DATABASES AND DATABASE OBJECT IN DB21.Servers, Instances, and Databases 2.Managing Instances 3.Creating a DB2 Database 4.Cataloging 5.Database (Data) Objects
INTRODUCTION TO SQL1.SQL 2.Data Definition Language 3.Data Manipulation Language 4.JOINs 5.Data Control Language 6.Transaction Control Statements
DATA CONCURRENCY1.Database Transactions 2.Concurrency 3.Concurrency Issues 4.Concurrency Control 5.Isolation Levels 6.Locking 7.Specifying Isolation Levels
DB2 SECURITY1.Authentication 2.Trusted Context 3.Authorization 4.Authorities 5.Privileges 6.Label-Based Access Control (LBAC) 7.ROLES
DB2 BACKUP AND RECOVERY1.Backup 2.Recovery
DB2 PURE XML1.Overview of XML 2.PureXML in DB2 3.XML Data Movement in DB2 4.XQuery and SQL/XML 5.XML Indexes in DB2 6.Application Development
DB2 PROGRAMMING FUNDAMENTALS1.Application Development Environment 2.Embedded SQL 3.Static SQL 4.Dynamic SQL 5.Routines 6.Types 7.Benefits 8.Usage 9.Tools for Developing Routines 10.Triggers