Ibm as400 os access

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 TOOL 1.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 DB2 1.Servers, Instances, and Databases 2.Managing Instances 3.Creating a DB2 Database 4.Cataloging 5.Database (Data) Objects INTRODUCTION TO SQL 1.SQL 2.Data Definition Language 3.Data Manipulation Language 4.JOINs 5.Data Control Language 6.Transaction Control Statements DATA CONCURRENCY 1.Database Transactions 2.Concurrency 3.Concurrency Issues 4.Concurrency Control 5.Isolation Levels 6.Locking 7.Specifying Isolation Levels DB2 SECURITY 1.Authentication 2.Trusted Context 3.Authorization 4.Authorities 5.Privileges 6.Label-Based Access Control (LBAC) 7.ROLES DB2 BACKUP AND RECOVERY 1.Backup 2.Recovery DB2 PURE XML 1.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 FUNDAMENTALS 1.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 Our Courses WebSphere SAP Oracle Java Microsoft Tibco PROFESSIONAL COURSES Address Rakesh Kumar +91 9700330693 +1 234 200 0813 info@pradhikatechnology.com pradhikatechnology@gmail.com