Introduction db2

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

Hi, My name is Upendra Shinde. I will be taking the AS/400 classes online. Interested people can contact me for further information. Below is my brief profile and Course structure. I have 10+ years of experience working on AS400, RPGLE, free format and latest version of BPCS - ODW programming. For the past 6 years I have managed and mentored teams of 2 to 26 people. I used to train the Freshers who used to join our project as and when required. I did the training's by taking classroom sessions on different AS400 topics and giving assignments. My training for AS400 is divided into 1. AS400 introduction 2. CL/400 commands and programing 3. DB2/400 (PF, LF's, Keywords and commands) 4. SQL/400, WRKQRY, OPNQRY, 5. RPG400 (fixed format opcodes) 6. Display File Programming 7. Report (RPU) programming 8. Free format programming (with same RPG400 codes to be written in free format) 9. ILE concepts. I have provided AS400 and DB2/400 admin training to Associates of Bally technologies and Zensar. I have Automobile, Retail and Manufacturing domain knowledge which will help the team i may train in future. Most of my experience in on Development and Maintenance. I have done support and batch optimization works for few years. Thanks and Regards, Upendra Shinde

Data Stage Course Content at Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Data Stage Data Stage Course Content at Learning Hub Contents • Introduction about Data Stage • Difference between Server Jobs and Parallel Jobs • Difference between Pipeline Parallelisms • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto) • Configuration File • Difference between SMP/MPD architecture • Data Stage Components (Server components/Client Components) • Package Installer Data Stage Administrator • Creating project, Editing project and Deleting project • Permissions to user • .Apt Config file • Environment variable creation, permission Data stage director • Introduction to Data stage Director • Job status View • View logs • Scheduling • Batches Creation Designer • Introduction about Designer • Repository • Palatte • Types of Links • File Stages • Sequential File • Data set File • Lookup file set • Difference between Sequential file/Dataset/File set • Database stages • Dynamic RDBMS • Oracle Enterprise • ODBC Enterprise • Stored Procedure Processing stages • Change Capture (Caption) • Compare stage • Difference Stage • Aggregate Stage • Transformer Stage • Surrogate Generator Stage • Join Generator Stage • Merge Generator Stage • Lookup Generator Stage • Difference between join/Lookup/Merge • Difference between join/Lookup • Remove Duplicates • Switch • Pivot • Modify • Funnel Debugging stage • Head • Tail • Pea • Row Generator • Column Generator • Sample • Job Parameters Manager • Introduction About Data stage Manager • Importing the Job • Exporting the Job • Importing Table Definition • Importing Flat File Definition • Routines Containers • Difference between Local Container and Shared Container • Local Container • Shared Container Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in Data Stage Online Training, Data Stage Class Room Training, Data Stage Training in Magarpatta City, Data Stage Jobs and Placement, Data Stage Remote Support, Data Stage Online Help,Data Stage Videos training, Data Stage training by Learning Hub, Fast track classes in Data Stage, Best Data Stage training institutes in Pune, Best Faculty in Data Stage, Best online Faculty in Data Stage, Professional classroom training in Data Stage, Professional online training in Data Stage,Data Stage Certification, Data Stage training in Dubai, Data StageTraining in Melbourne, Data Stage Training in Dubai, Data Stage Training, Data Stage Training,Data Stage Training, Data StageOnline Training, Data Stage certfication and suppor

PMS Information Systems is a leading Application Development, Maintenance & Training provider of IBM i (aka AS/400, iSeries, eServer, System i, i5) & IBM Mainframe technologies with its headquarters in Chennai, India. Managed by a veteran with more than 23+ years experience in IBM i technology, the PMS team consists of highly qualified consultants having experience in this technology. Professionalism and high performance combined with innovative and creative IT solutions and development is what PMS offers. We provide the following courses through classroom training: 1.IBM i(AS/400) Programming •AS/400 Basic concepts and facilities •DDS and DB2 •CL Programming •RPG III and IV Programming •ILE Concepts 2.IBM i(AS/400) System Operations and Administration •AS/400 iSeries Architecture Introductions •Work Management •Working with Printer Output •Handling Messages •Backup and Recovery •Working with Devices and Communications •System Monitoring Tasks •System Level Security •Working with User Profiles •Auditing Capabilities •PTF and FIX Management 3.CA/2E (SYNON) Programming •Introduction to SYNON •Data Modelling •Access Path •Functions •Action Diagram •Advanced Datamodelling Relations 4.LANSA •Repository & Integrated Development Environment •Working with the Visual LANSA IDE •The Repository Tab •Working with the Repository •Create a LANSA RDML Process / Function Application •Additional Exercises and Notes •Format Source Code •Edit Source Code •Auto Complete and Command Assistant •Execute Applications •Introduction to Object Oriented Lab •Working with Basic Controls in Visual LANSA Forms 5.COBOL/400 Programming •Introduction •Working with Screen Indicators •COBOL/400 Specifics •Designing Display files •Handling Error and Informational Messaging •Avoiding Record Locking Problems •Using Subfiles in COBOL •Windows Please feel free to contact us, PMS Information Systems, # 50, Janani Landmarks, Mahalakshmi Street, T.Nagar, Chennai - 600 017. India Contact - +91 044 45528298 / +91 9600079773.

Peridot systems Peridot Systems is one of the best training institutes for Software Testing, Oracle 10g/11gDBA, Dot Net 4.0, Salesforce.com, Core Java, J2EE, DB2, Solaris Admin, Websphere, WebLogic, Solaris, LINUX commands in Chennai with placement. We give Job oriented training apart from the theoretical topics. We give 100% Placement assistance and guide the students during their Interview sessions and on their Communication Skills Initiated by a crew of highly competent and expert professionals with an unique objective to bridge the gap between the field of education and IT industry. Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind. SharePoint Server 2010 Administration Topics • Introduction to SharePoint 2010 Technologies. • Collaboration and Web Content Management. • SharePoint 2010 Client Integration. • Creating and Configuring SharePoint Web Applications. • Administering Sites and Site Collections. • Architecting a SharePoint Infrastructure. • Installing and Configuring a SharePoint Farm. • Configuring SharePoint Security. • Managing Metadata and Content Types. • Document and Records Management. • Configuring InfoPath and Workflow Services. • Configuring SharePoint Search and Indexing. • Configuring SharePoint Personalization Services. • Introduction to Business Intelligence. • SharePoint Disaster Recovery. Venue: Peridot Systems #84/8 Venkatarathinam Main Street, Venkatarathinam Nagar,Adyar, Chennai - 600 020.(Near Adyar BSNL Telephone Exchange) Contact: 9952954654

Peridot systems Peridot Systems is one of the best training institutes for Software Testing, Oracle 10g/11gDBA, Dot Net 4.0, Salesforce.com, Core Java, J2EE, DB2, Solaris Admin, Websphere, WebLogic, Solaris, LINUX commands in Chennai with placement. We give Job oriented training apart from the theoretical topics. We give 100% Placement assistance and guide the students during their Interview sessions and on their Communication Skills Initiated by a crew of highly competent and expert professionals with an unique objective to bridge the gap between the field of education and IT industry. Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind. Salesforce Salesforce.com Administrator Essentials & Advanced Administration • Introduction to SalesForce • Security and Identity Confirmation • Salesforce CRM Ideas • Customizing Your Display • Customizing Salesforce CRM Ideas • Enabling Custom Fiscal Years • Managing Salesforce CRM Ideas • Managing Email Templates • Salesforce CRM Content • Managing Record Types • Uploading and Publishing Content • Setting Field-Level Security • Customizing Salesforce CRM Content • Custom Field Types • Custom Button Considerations • Mapping Custom Lead Fields • Managing Workflow Rules • Labeling of a Standard Object • About Archived ActivitiesUser Fields • Defining Custom Report Types • Transferring Records • Setting Up Custom Report Types • Setting Up Web-to-Lead • Salesforce Connect for Microsoft Outlook • Exporting Backup Data • Installing Salesforce Offline • Refreshing Dashboard Data • Managing Your Developer Sandboxes • Scheduling a Dashboard Refresh • Development as a Service • General Permissions • Updating Campaign History • Search Fields • Defining Custom Report Types • Displaying and Editing Campaigns • Deleting Cases • Categorizing Solutions • Creating Custom Object Tabs • Creating Events • Creating Custom List Views • Enabling Territory Management • Google AdWords • Creating and Modifying Presentations in Salesforce CRM Content Course Duration : 24 Hrs SalesForce Development (Certified Force.com Developer) • Creating an App with Point-and-Click Tools • Creating Custom Objects • Creating Custom fields • Creating a Tab • Creating an Application • Creating an App with the Force.com IDE • Creating a project in IDE • Creating Custom Objects in IDE • Creating Custom fields in IDE • Creating a Tab in IDE • Creating an Application in IDE • Testing Application • Using Formulas and Validation • Creating field validation • Creating Formula fields • Creating address field using Formula field • Using Workflow and Approvals • Creating Users • Creating Email Templates • Creating Workflow Testing Workflow • Creating an Approval Process • Testing Approval Process • Apex • Creating an Apex Class • Creating an Apex Trigger • Testing the Trigger • Visualforce • Visualforce Developer Mode • Creating Visualforce Page • Creating custom view • Creating Visualforce Controller • Displaying data table on Visualforce Page • Adding Tests to Your Application • Working with Force.com Sites • Registering Force.com domain name • Creating Force.com site • Testing site • Adding Email Services • Downloading and Deploying an App Using Code Share • Packaging and Distributing an Application • Create a Package • Add components to your package • Uploading Package • Installing package Venue: PeridotSystems #84/8 Venkatarathinam Main Street, Venkatarathinam Nagar,Adyar, Chennai - 600 020.(Near Adyar BSNL Telephone Exchange) Contact: 9952954654

Peridot systems Peridot Systems is one of the best training institutes for Software Testing, Oracle 10g/11gDBA, Dot Net 4.0, Salesforce.com, Core Java, J2EE, DB2, Solaris Admin, Websphere, WebLogic, Solaris, LINUX commands in Chennai with placement. We give Job oriented training apart from the theoretical topics. We give 100% Placement assistance and guide the students during their Interview sessions and on their Communication Skills Initiated by a crew of highly competent and expert professionals with an unique objective to bridge the gap between the field of education and IT industry. Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind. SAP FICO Introduction to SAP R/3 Financial Accounting Basic Settings: General Ledger Accounting: Accounts Payable Accounts receivable: Asset Accounting New General ledger accounting: Integration Integration of financial accounting with materials management: Integration of financial accounting with sales and distributioin: CONTROLLING Basic settings for controlling Cost element accounting: Cost Center Accounting Internal Orders Profit Center Accounting Profitability analysis Product costing:. Venue: PeridotSystems #84/8 Venkatarathinam Main Street, Venkatarathinam Nagar,Adyar, Chennai - 600 020.(Near Adyar BSNL Telephone Exchange) Contact: 9952954654

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training . Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java, .net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems.  Preferable Timinings  Free Software Installation  One Year Tech Support  Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact 9790855020 Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - 600020.

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training. Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java,.net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems. Preferable Timinings Free Software Installation One Year Tech Support Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - .

Dear Freshers, Worried about how and where to start your career? Payilagam is there to help you. We have comprehensive Mainframe training program for the freshers. The training program is powered by experts in the industry. Our Mainframe training program takes you to the introduction of Mainframes, fundamental concepts and complex functionalities to groom you into a quality mainframe professional. We provide training on Live IBM servers so that you will get used to the real time working experience. As our Trainers have vast experience in Mainframe they know what is expected from an eminent mainframe professional and feed you with what is required for a successful mainframe techie. Why you have to choose Payilagam Mainframe Training Center? •Experienced Mainframe professionals as trainers •Training program specially designed for Freshers •Job Oriented Real time Training program •No boring PPTs,only Hand on Training •Training Live IBM Mainframe servers •More emphasis on practicals •Mock Interviews •Case studies •Limited students per batch We welcome you to touch new heights with Payilagam. Course details: COBOL Training DB2 Training IMS Training CICS Training JCL Training Location: Payilagam Software Training Institute, Velachery, Chennai For FREE DEMO CLASSES Contact us: Mr. Manikandan BE.,MBA., Payilagam Mainframe Training Institute, Vijaya Nagar, Velachery, Chennai

Lamp Course Training @ Object Arena Chennai SUSE Linux Fundamentals (Novell days) SUSE Linux Administration Classes (Novell days) Advanced SUSE Linux Administration (Novell days) Implementing Databases with MySQL (5 days) Advanced PHP Programming with PostgreSQL & plPHP (5 days) Advanced PHP Programming with MySQL (5 days) Zend PHP Essentials (3 days) Professional PHP Training And Development (3 days) Zend PHP Training And Certification (3 days) MySQL 5.0 New Features (3 days) MySQL For Developers (5 days) Implementing Databases with PostgreSQL (4 days) PostgreSQL for Developers (3 days) MySQL Performance and Tuning (3 days) SUSE Linux Essentials for Windows Professionals (3 days) Introduction to PHP with MySQL/PostgreSQL/Oracle/DB2 (5 days) AJAX Programming with PHP (4 days) MySQL Administration (5 days) PostgreSQL Administration (5 days) Object Arena Software Solutions.pvt.ltd Address:no 1 nehru street co-operative nagar adambakkam,chennai-(Off Velachery Inner ring road) phone: - prasanna:

SADHGURU TECHNOLOGIES AS/400 CONCEPTS TO BE COVERED: 1. General AS/400 Concepts: • Overview of the system. • General awareness of the AS/400 system • Libraries, files and members • Library list concept and related commands. • Command structure and frequently used commands. 2. ADTS (Application Development Tool Set): • PDM (Program Development Manager) • SEU (Source Entry Utility) • SDA (Screen Design Aid) • RLU (Report Layout Utility) • DFU (Data File Utility) 3. Query/400: Creation, Executing, accessing data from different member DB2/400 • Overview of concepts • Externally described files. • Source Physical Files. • Physical files, logical files and join logical files • Field Reference Files • Relational databases and normalization • Runtime considerations • Database Integrity • Database Security: data rights and locks • Triggers CONTROL LANGUAGE (CL/400): • Capabilities of control language programs • Control language program structure & syntax • Features and limitations of control language programs • Scope of control language programs • Control language program coding rules • File handling in CL/400 • Handling errors and messages • Handling data areas • Program flow control • Program to program flow control • Overriding file attributes and the scope of variables • Open query file-concepts and use • String Operators • String Function RPG/400: • Introduction to RPG/400, explanation of all the 7 specifications. • Operation Codes • Subroutines • Constructs in RPG IF, DO, SELRC etc. • Program testing and debugging • Indicators • Tables and Arrays • File access and record manipulation • Control Breaks • Fixed Logic Cycle • Interactive Program • Data Structures • String Manipulation op-codes • Inter-Program communication • Data queue/data area • Sub-files • Load all sub-file • Expanding sub-file • Message Sub-file