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

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

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.