Index file

With the help of advanced facility, we are capable to provide an extensive range of School Notebook. In addition, we also provide customized options to cater the diverse demands of our patrons. Price range: Rs. 35 to 100 per piece About us Khurana International is providing Index File, Leather Folder, Lever Arch File and Report File. Our claim to success is hallmarked by the offered quality products that gained us huge recognizance. We are working towards development through a dedicated team of people to meet the most stringent requirements of customers.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

SAP BODS 4.2 On-line & Classroom Training Bangalore 1. Data ware housing concepts Describe dimensional modeling 2. Understanding Data Integrator Describe components, management tools, and the development process Explain object relationship 3. Defining source and target metadata Create a database data store and import metadata Create a new file format and handle errors in file formats 4. Validating, tracing, and debugging jobs Use description and annotations Validate and trace jobs Use view data and the Interactive Debugger 5. Creating a batch job Create a project, job, work flow, and data flow Use the query transform in a data flow Use template tables 6. Using built-in transforms and nested data Use the case, merge, and validation transforms Use the Pivot, reverse Pivot Hierarchy flattening 7. Using built-in functions Use date and time functions and the date generation transform to build a Dimension table Use the lookup functions to look up status in a table Use match pattern functions to compare input strings to patterns Use database type functions to return information on data sources 8. Using Data Integrator Scripting Language and Variables Explain differences between global and local variables Create global variables and custom functions Use strings and variables in Data Integrator scripting language 9. Capturing Changes in Data Use Change Data Capture (CDC) with time-stamped sources Create an initial and delta load job Use history preserving transform 10. Handling errors and auditing Recover a failed job Create a manual, recoverable work flow Define audit points, rules and actions on failures 11. Supporting a multi-user environment Describe terminology and repository types in a multi-user environment Create and activate the central repository 12. Migrating Projects Work with projects in the central repository Creation of Profile Repository Understand Profiling 13. Using the Administrator Execute, schedule, and monitor batch jobs Understand architecture, load balance index, and job execution in server Groups 14 Profiling Data Set up the Data Profiler and users Submit a profiling task Monitor profiling tasks in the Administrator 15. Managing Metadata Import and export metadata Use Metadata Reports 16. Data Quality Management 17. SAP Integration Data extraction from ECC system to File, Table and SAP BI. Extract the data from SAP BI & NON SAP Systems using Open hub Services and Data services as 3rd party system.

RCP Technologies is a unique and pioneer institute mainly started with the soul objective of imparting cutting edge, technologically superior and state-of-art, high-end, and career oriented curriculum based courses in Big Data Hadoop and other courses like Data Science, Apache Storm, Spark, Python, Agile, MongoDB, SOA, OSB, Tableau, Cassandra, ADF, Informatica, Obiee, Obia etc. We have trainers who consultants worked in MNC companies. We make sure the best trainers are selected and students gain a lot of knowledge once the training is completed. We don't target lot of students for our training classes but will make sure the exact number of students who are the best fit for carrying out a curriculum are selected. We are not quantity oriented but quality oriented. If you are looking for a professional training in the IT, then we are the best in the business. We have inhouse training facilities along with server setup which makes it a complete corporate environment. For more details call us at share your contact details. What is Hadoop? Hadoop is a free, Java-based programming framework that supports the processing of large data sets in a distributed computing environment. It is part of the Apache project sponsored by the Apache Software Foundation. Hadoop was born out of a need to process big data, as the amount of generated data continued to rapidly increase. As the Web generated more and more information, it was becoming quite challenging to index the content, so Google created MapReduce in , then Yahoo! created Hadoop as a way to implement the MapReduce function. Hadoop is now an open-source Apache implementation project. Hadoop makes it possible to run applications on systems with thousands of nodes involving thousands of terabytes. Its distributed file system facilitates rapid data transfer rates among nodes and allows the system to continue operating uninterrupted in case of a node failure. This approach lowers the risk of catastrophic system failure, even if a significant number of nodes become inoperative. As for the more specific functions, Hadoop has a large scale file system (Hadoop Distributed File System or HDFS), it can write programs, it manages the distribution of programs, then accepts the results, and generates a data result set. Only RCP technologies provides training designed by the leaders and committers of Hadoop. We present valuable real world scenario-based training developed by the core architects, builders and operators of Hadoop with unmatched depth and expertise so that you can be assured you are learning from the experts. RCP technologies is a Interactive Learning Portal started by industry experts with an aim to provide Quality Training in Hadoop Technology. RCP Technologies is offering quality Training services to hadoop to students worldwide. HADOOP Classroom & Online Training by RCP Technologies with an excellent and real time faculty. Our Big Data Hadoop course content designed as per the current IT industry requirement. Apache Hadoop is having very good demand in the market. We provide regular and weekend classes as well as Normal track/Fast track based on the learners requirement and availability Visit us at: RCP technologies Pvt Ltd, #302, Annapurna Block,Aditya Enclave, Near Mitrivanam, Ameerpet, Hyderabad. Helpline:

Ithub online training gives Hadoop online training. The Hadoop circulated file framework (HDFS) is suitable record framework written in Java, versatile, and an conveyed. Every hub usually has a lone namenode; a bunch of datanodes construction the HDFS group. Each datanode serves squares of advice up within the system using a bit custom specific to HDFS. The record framework uses TCP/IP attachments. Unwavering quality is accomplished by it by duplicating the info over distinct hosts, and later hypothetically doesn't need RAID stockpiling on hosts (but rather to construct I/O performance some RAID arrangements remain precious). Together with the default option replication regard, 3, advice is put away on one on an alternative stand, and three hubs: two on the exact same stand. Information hubs can converse to move duplicates about to rebalance advice, and to keep the replication of info high. HDFS isn't fully POSIX-agreeable, in light of how the prerequisites to get a POSIX record framework change from your objective aims to get a Hadoop program. The tradeoff of lacking a fully POSIX- record framework that is consistent is enlarged execution for backing and information throughput for non-POSIX operations Append. Hadoop in order to prepare gave bytesonlinetraining is for specialist who needs change or to build their profession in smashing invention area like Cloud Computing,Company Intelligence and Big Data. As a characteristic of internet Hadoop Training we could give 3 Jobs, Assignments, numerous Hadoop Tutorial, 200 Questions Quiz, Virtual Machine and Hadoop preparing records. Hadoop online educational activity concentrates on preparing understudies from crucial to propel amount of Hadoop and are extremely intelligent. These are generally used merely in programs that were nonstandard. The typical startup and shutdown scripts need Secure Shell (ssh) to be put in place between nodes in the bunch. In a bunch that was bigger, the HDFS is handled via a committed NameNode server to host a secondary NameNode that will create pictures of the memory constructions of the namenode, as well as the file system index, reducing loss of information and thereby preventing filesystem corruption. Likewise, job scheduling can be managed by a standalone JobTracker server. And DataNode structure is replaced by the file system-unique equivalent. Contact:- India: +91 USA: +

Program Name: Basic Excel 2010 Duration: 8 hrs Training Content:. Creating a Basic Worksheet · Customize the Quick Access Toolbar · Enter Data and Save a Workbook · Explore the User Interface and the Ribbon · Navigate and Select in Excel · Obtain Help Performing Calculations · Calculate with Functions · Copy Formulas and Functions · Create Basic Formulas Modifying a Worksheet · Insert and Delete Cells, Columns, and Rows · Manipulate Data · Search for Data in a Worksheet · Spell Check a Worksheet Formatting a Worksheet · Add Borders and Color to Cells · Apply Cell Styles · Apply Number Formats · Change Column Width and Row Height · Modify Fonts · Position Cell Contents Printing Workbook Contents · Print Workbook Contents Using Default Print Options · Set Page Breaks · Set Print Options Managing Large Workbooks · Format Worksheet Tabs · Manage Worksheets in a Workbook Training Name: HB Certified Programme in Intermediate Excel 2010 Duration: 16 hrs Training Content: Creating and Editing Formulae • Concept of Formulae • Creating Formulae, Editing Formulae • Mathematical Order • Copying Formulae • Using Functions - Sum, Average, Max, Min, Count, Counta • Applying Absolute (Fixed) Referencing Formatting and Proofing • Formatting Cells with Number formats, Font formats, Alignment, Borders, etc • Basic conditional formatting • Copying and Clearing Formats • Working with Styles • Spell Check, Find & Replace and AutoCorrect Range Names • Naming individual or range cells • Deleting and amending named ranges • Using named cells/ranges in formulae Conditional Functions & Formats and Date Calculations • Benefits and purpose • If Statements, Nested If • And, Or, Not • Combining If, And, Or, Not • Sumif, Countif • Conditional Formatting • Entering Dates and Times • Different date/time formats • How dates are stored • Calculating working days • Using the DAY(),MONTH(),YEAR() functions Formulae Auditing • Formula Auditing Tools • Revealing Formulae • Tracing Precedents/Dependents • Goto Special Worksheet Management & Linking • Linking sheets in the same file • Linking different Excel files • Using Edit, Links • Viewing different files at once • Saving a workspace • Viewing different sheets at once • Window Split • Data consolidation Basic List Management • Sorting Data • Adding Subtotals • Autofilter • Freeze Panes • Group and Outline • Data Form Excel Charts / Graphs • Using the Chart Wizard • Editing and Formatting charts • Saving custom chart types • Setting a default chart type Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsValue, IsDate, IsNull, IsErr, Is Error, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Protecting file • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Introduction to Macros • Purpose of Macros • Recording macros • Where to save macros • Running macros: • Custom buttons, menu items, keyboard shortcuts Visual Basic for Applications Environment • Visual Basic Editor and its options • Component Management • Shortcuts Connecting to Database/Outlook • Connect to MS Access • Access Database & Retrieve Data from MS Access • Create Table & Query Data Filter DB using Query • Update and Modify DB • Retrieve the Information through Excel from Outlook using VBA Advanced Excel 2010 Training Name: HB Certified Programme in Advanced Excel 2010 Duration: 24 hrs Training Content: Getting started with Macros · Recording and Modifying Macros · Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment · Visual Basic Editor and its options · Component Management · Shortcuts Introduction to Procedural Programming · Procedures: Functions and Sub-routines · Data Types Control Flow · If...Then....Elseif....Else....Endif · Case · Do...Loop, While · For... Next · Exit · VBA and Sheet Data Exchange (Cells, Range Methods) · Getting and Printing Data from Users (InputBox, MsgBox) · how to link with Ms Access and SQL Call/Whatsapp 8939693655

Case Binding Machines ,Case Making Machines, Manufactures case binding machines, automatic feeders, automatic lamination machine, Case Maker Automatic Machine, Semi-automatic case maker, Edge Squaring Machine, Joint Forming Machine, Nipping Machine, Corner Cutting Machine, Case Corner Rounding Machine, Single Clamp Perfect Binding Machine, book binding machines. Mark Manufacturers, Heavy duty case binding machine, gluing conveyer manufacturers, gluing machine manufacturers, rigid box v grooving machine, rigid boxwrapping machine manufacturers, exporter, most reliable machine Manufacturers Bangalore Karnataka, India http://www.indobound.com Case Binding Machine, Case Binding, Case Binder, Case Making Machine, Case Making, Case Making Machine, Case Binding Machine Manufacturer, Book Binding Machine, Binding Machine, Bookbinding Machines, , automatic lamination machine, Case Maker Automatic Machine, Semi-automatic case maker, Edge Squaring Machine, Joint Forming Machine, Nipping Machine, Corner Cutting Machine, Case Corner Rounding Machine, Single Clamp Perfect Binding Machine, Mark Bookbinding, Mark Case Binding, Hard Bound Book, Hard Bound Books, Hard Case Binding, Case Maker, Case maker, Case, Binding, Machines, Case Binding Machines, case binding machine for diary, case binding machine for file, case binding machine for clip board, case binding machine for hard bound book, case binding machine for hard bound notebook, case binding machine for hard cover, case binding machine manufacturer in India, case binding machine manufacturers, gluing conveyer manufacturers, gluing machine manufacturers, rigid box v grooving machine, rigid boxwrapping machine manufacturers from Bangalore Karnataka, India Perfect Binding Machine, Rounding Machine and Case Making Machine Manufacturer offered by IndoBound from Bengaluru, Karnataka, India IndoBound Manufacturer of Perfect Binding Machine and Rounding Machine from Bengaluru INDOBOUND Case Binding Machine Manufacturer, Perfect Binding Machine from Bengaluru gluing conveyer manufacturers, gluing machine manufacturers, rigid box v grooving machine, rigid boxwrapping machine manufacturers Case Binding Machines manufacturers in Bangalore Case Binding Machine Supplier in bangalore Case Making Machine, Book Binding Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers, gluing conveyer manufacturers, gluing machine manufacturers, rigid box v grooving machine, rigid boxwrapping machine manufacturers Bangalore Karnataka Case Making Machine, Perfect Binding Machine, Book Binding Machine Manufacturers Case Maker Machine, Semi Auto matic Case Maker Machine Manufacturers Single Clamp Perfect Binding Machine Case Corner Rounding Machine – Manufacturers Fully Automatic Case Making Machine, Case Maker Machine Semi Automatic Case Making Machine Corner Cutting, Round Corner Cutting Machine, Corner Cutters Edge Squaring Machine Manufacturer, Notebook Edge Squaring Machine Joint Forming Machine Manufacture Nipping Machine, Automatic Hydraulic Nipping Machine Edge squaring machine, Case Maker Machine, Cutting Machine Manufacturers Case Maker Automatic Edge Squaring Machines Nipping-Machines-Manufacturers Pinning Folding Machine Case Maker - Semi Automatic Single Clamp Perfect Binding Machines Manufacturer of Case Making Machine & Perfect Binding Machine from Bengaluru, Book Binding Manufacturers, Dealers and Suppliers in Bangalore binding-machine-manufacturers Case Binding Machine | Case Binding Machine Manufacturer | Case Binding Machine Supplier | Case Binding | Case Binder | Case Making Machine | Case Making | Case Making Machine | Case Binding Machine Manufacturer | Book Binding Machine | Binding Machine Manufacturer of File Making Machines and Case Making Machines printing-binding-machinery Note Book Binding Machines - HIGH SPEED CASE MAKER MACHINE Manufacturer Note Book Making Machines - Exercise Note Book Making Machine Manufacturer Wedding Card Making Machines - Wedding Card Case Making Machine Manufacturer Joint Forming Machines - Joint Forming Machine Manufacturer Case Binding Machines - Case Making Machines. Manufactures case binding machines, automatic feeders, automatic lamination machine, Case Maker Automatic Machine, Semi-automatic case maker, Edge Squaring Machine, Joint Forming Machine, Nipping Machine, Corner Cutting Machine, Case Corner Rounding Machine, Single Clamp Perfect Binding Machine, book binding machines. Mark Manufacturers, Heavy duty case binding machine, most reliable machine Manufacturers Bangalore Karnataka, India Case Binding Machine, Case Binding, Case Binder, Case Making Machine, Case Making, Case Making Machine, Case Binding Machine Manufacturer, Book Binding Machine, Binding Machine, Bookbinding Machines, automatic lamination machine, Case Maker Automatic Machine, Semi-automatic case maker, Edge Squaring Machine, Joint Forming Machine, Nipping Machine, Corner Cutting Machine, Case Corner Rounding Machine, Single Clamp Perfect Binding Machine, Mark Bookbinding, Mark Case Binding, Hard Bound Book, Hard Bound Books, Hard Case Binding, Case Maker, Case maker, Case, Binding, Machines, Case Binding Machines, case binding machine for diary, case binding machine for file, case binding machine for clip board, case binding machine for hard bound book, case binding machine for hard bound notebook, case binding machine for hard cover, case binding machine manufacturer in India, case binding machine manufacturer from Bangalore Karnataka, India Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, , Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers from Bangalore Karnataka, India Manufacturer of Case Making Machine & Perfect Binding Machine from Bengaluru INDOBOUND-9620180957-Case Making Machine, Perfect Binding Machine, Book Binding Machine Manufacturers Case Making Machine, Book Binding Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers Bangalore Karnataka, India Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, , Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers from Bangalore Karnataka, India INDOBOUND-9620180957-Case Making Machine, Perfect Binding Machine, Book Binding Machine Manufacturers INDOBOUND-9620180957-Case Maker Machine, Semi Auto matic Case Maker Machine Manufacturers Case Maker, Automatic Case Maker, Semi-Automatic case maker Machine Manufacturers From Bangalore Karnataka India Case Making Machine, Perfect Binding Machine, Book Binding Machine Manufacturers Manufacturer of Case Making Machine & Perfect Binding Machine from Bengaluru Case Corner Cutting Machine, Case Corner Cutting, Round Cutting Machine in Bangalore Case Maker Machine, Automatic Case Maker Machine Manufacturers in Bangalore Karnataka India Corner Cutting Machine Manufacturers, Book Binding Corner Cutting Machine Manufacturers and suppliers Edge squaring machine, Book edge square Cutting machine Manufacturers in Bangalore Joint Forming Machine Manufacturer, Perfect Binding Machine Manufacturers in Bangalore Nipping Machine Manufactuers in Bangalore Karnataka India Edge squaring machine, Case Maker Machine, Cutting Machine Manufacturers Single Clamp Perfect Binding Machine Manufacturers in India Karnataka, Bangalore Manufacturer of Case Making Machine & Perfect Binding Machine from Bengaluru, Book Binding Manufacturers, Dealers and Suppliers in Bangalore Case Making Machine, Perfect Binding Machine & Grooving Machine Manufacturer offered by IndoBound from Bengaluru, Karnataka, India Case Making Machine, Perfect Binding Machine, Grooving Machine, Press Machine, Rounding Machine, Pinning and Folding Machine, Edge Squaring Machine, IndoBound, Bengaluru Case Making Machine, Perfect Binding Machine & Grooving Machine Manufacturer offered by IndoBound from Bengaluru, Karnataka, India Case Making Machine, Book Binding Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers Bangalore Karnataka, India Case Making Machine manufacturers in bangalore Book Binding Machine manufacturers in bangalore corner cutting machine manufacturers in bangalore edge squaring machine manufacturers in bangalore joint forming machine manufacturers in bangalore nipping machine manufacturers in bangalore Book Rounding Machine manufacturers in bangalore Case Maker manufacturers in bangalore Automatic Case Maker manufacturers in bangalore Semi-Automatic case maker manufacturers in bangalore Round Corner Cutting Machine manufacturers in bangalore Special Machines for your Requirement manufacturers in bangalore SPM Machine manufacturers in bangalore creasing machines manufacturers in bangalore pinning machine manufacturers in bangalore clamp perfect binding machine manufacturers in bangalore Single Clamp Perfect Binding Machine manufacturers in bangalore Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, , Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers from Bangalore Karnataka, India Case Maker, Automatic Case Maker,Semi-Automatic case maker, Round Corner Cutting Machine, Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, , Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers from Bangalore Karnataka, India Case Making Machine, Perfect Binding Machine, Book Binding Machine Manufacturers Case Making Machine, Book Binding Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers Bangalore Karnataka, India Indobound has grown into an industrial force built upon processes and high quality which have become our standards Indobound is one of the leading manufacturer of complete hard-case solution for the books binding industries INDOBOUND - Manufacturer of Case Making Machine & Perfect Binding Machine from Bengaluru Case Making Machine, Book Binding Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, Case Maker, Automatic Case Maker, Semi-Automatic case maker, Round Corner Cutting Machine, Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers Bangalore Karnataka, India Single Clamp Perfect Binding Machines Case Corner Rounding Machines Case Maker - Automatic Case Maker - Semi Automatic Corner Cutting Machines Edge Squaring Machines Joint Forming Machines Nipping Machines Book Rounding Machines Creasing Machines Pinning Machines (Programmable) 3-4-6 Clamp Perfect Binding Machines SPM (Special Machines) for your Requirement Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine Single Clamp Perfect Binding Machine Manufacturers IndoBound Cutting Machine and Press Machine Manufacturer of Case Making Machine, Perfect Binding Machine and Rounding Machine from Bengaluru. Case Maker, Automatic Case Maker,Semi-Automatic case maker, Round Corner Cutting Machine, Case Making Machine, Automatic Case Making Machine, Semi-Automatic Case Making Machine, corner cutting machine, edge squaring machine, joint forming machine, nipping machine, Book Rounding Machine, , Special Machines for your Requirement, SPM Machine manufacturers, creasing machines, pinning machine, clamp perfect binding machine Manufacturers from Bangalore Karnataka, India #Case Binding Machines #Case Making Machines #Manufactures case binding machines #Case Maker Automatic Machine #Semi-automatic case maker #Edge Squaring Machine #Joint Forming Machine #Nipping Machine #Corner Cutting Machine #Case Corner Rounding Machine #Single Clamp Perfect Binding Machine #book binding machines #Mark Manufacturers #Heavy duty case binding machine #gluing conveyer manufacturers #gluing machine manufacturers #rigid box v grooving machine #rigid boxwrapping machine manufacturers #exporter #most reliable machine Manufacturers https://youtu.be/gdMPZAu7ZMY https://youtu.be/5MgUDt7HwyA https://youtu.be/5-w-0Gq0Z0Y https://youtu.be/G8wel22J4SE https://youtu.be/JLw6w-YTEds https://youtu.be/O9oXeSC9Nuc https://youtu.be/eOgY_CUD5L8 https://youtu.be/CGWK1iMw_IY https://youtu.be/MH_hb6XYHTo https://case-binding-machine-manufacturers.blogspot.com/ http://www.indobound.com/index.html http://www.indobound.com/case-maker-semi-automatic-case-maker-machine-manufacturers-exporters-india-ABOUTUS.html http://www.indobound.com/Book-binding-machine-manufactuers-case-maker-manufacturers-Products.html http://www.indobound.com/Binding-Machine-edge-sqaring-case-maker-corner-cutting-machine-manufacturers.html http://www.indobound.com/SINGLE-CLAMP-PERFECT-BINDING-MACHINE-MANUFACTURERS-VIDEOS.html http://www.indobound.com/Case-Making-Machine-Perfect-Binding-Machine-Grooving-Machine-book-binding-machine-manufacrturers.html https://www.google.com/maps?ll=13.015637,77.484143&z=11&t=m&hl=en&gl=IN&mapclient=embed&cid=6672513942710020332 http://www.indobound.com/Book-binding-machine-manufactuers-case-maker-manufacturers-Products.html http://www.indobound.com/Case-Corner-Rounding-Machine.html http://www.indobound.com/Case-Maker-Automatic-Machine-ManufacturersIndia-Karnataka-India.html http://www.indobound.com/Case-Maker-Semi-Automatic-Machine-Manufacturers-Bangalore-Karnataka-India.html http://www.indobound.com/Corner-Cutting-Machine-manufacturers-india-Karnataka-India.html http://www.indobound.com/Edge-Squaring-Machine-Manufacturers-Bangalore-India.html http://www.indobound.com/Joint-Forming-Machine-India-Jointforming-Machine-Manufacturers.html http://www.indobound.com/Nipping-Machine-Manufacturers.html http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/Case-Maker-Automatic-Machine-ManufacturersIndia-Karnataka-India.png http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/Edge-Squaring-Machines-Manufacturers-Bangalore-India.png http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/Nipping-Machines-Manufacturers.png http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/pinning-folding-machine-manuacturers-bangalore-karnataka-india.png http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/semi-automatic-Case-Maker-Automatic-Machine-ManufacturersIndia-Karnataka-India.png http://www.indobound.com/images/Binding-Machines-case-maker-machine-manufacturers/single-clamp-perfect-binder.png https://www.youtube.com/watch?time_continue=11&v=JLw6w-YTEds&feature=emb_title

Product Highlights Support for overlap/partial overlap fields Complete support for case sensitive indexes Complete support for mixed ascending and descending index segments Preservation of RECNUM values during data migration High-speed data migration Record Locking instead of file locking Complete Support for Transaction Access views and synonyms as DataFlex files Seamless integration with existing TABLES and VIEWS by automatic generation of FD and TAG files from existing tables and views NO CODE RECOMPILATION! The table structure is exactly like DataFlex! Support for DataFlex restructure commands Detailed migration report Generate SQL Script for creating tables and indexes Required Components To be able to run a DataFlex program from any platform and connect to an Oracle database server, the user needs to install or have access to the Oracle SQL*Net client, properly configured to access the Oracle server. Mertech’s driver and license file is installed in the same directory as the DataFlex runtime and must also be accessible to the program.

Proposal for INtools Training (Smart Plant Instrumentation, Version 7.0) Greetings of the day! We are grateful for your interest in our training services. Cell No: +91 - 9677116760, Smart Plant Instrumentation (INTOOLS V7) Intergraph's instrument and controls design module is called 'Smartplant Instrumentation or SPI. It was previously known as INTOOLS. It is intended to cover all of the instrument and control design requirements in a modern industrial plant. It is also intended to be a replacement for AutoCAD in producing I&C deliverables such as loop diagrams, control wiring diagrams and installation details. This Course is designed for instrumentation specialist involved in the definition and specification of instrumentation and control system using the smart plant instrumentation software. In this course, students learn how to define the instruments using smart plant instrumentation as per the specifications of project deliverables. Topics Covered: Introduction of INtools& Auto Cad Introduction of system administration Introduction of domain administration System and Project Administration Overview Creating new user, domain, owner, plant, area, unit in Admin Module Significance of INtools Instrument Index Module User Report Interface (Browser Module) Process Data Module Calculations Module Binder Module Specifications Module Loop Diagrams Hookups Wiring Module (Foundation fieldbus) Micro Station V8 2004 Edition sets the direction for the continued evolution of Bentley's “V8 Generation” products. This topic highlights the 2004 Edition enhancements to Micro Station. Topics Covered: Introduction to Micro station Micro station File Management Drawing creation Seed Files & Work Space Tool bars Attributes Primary & Secondary Information’s Levels Snap Tool bar Menu bars & elements Cells, Dimensions, Line Style, Models, Tags Multi-line Style, Text Style, Key-in, Customize Element Manipulation and Modification Tools Settings Color Table, Design File, Workspace Preferences Function Keys & its Customization Button Assignments and Views Advance 2D Drafting Techniques Sample Project Eligibility: M.Tech/BE Or B.Tech/Dip. Disciplines: E&Inst/E&Control/Elec/Inst. Duration of the course: 15 Days Course fee: Total Cost: Rs. 40,000 Kindly contact me if you need further clarification on this. I am waiting for your response. We look forward to seeing you come for our training(s). Should you have any query, please feel free to contact me Cell No: +91 - 9677116760,

1.Module – I (Database/SQL) •Database Overview •DBMS, RDBMS, ORDBMS •Why Database Required •SQL Overview •DDL, DML, DCL, TCL •Data types •SELECT Statement •Restricting and Sorting Data •Aggregating Data using Group Functions •Creating and managing Tables •Manipulating Data •Sub queries •Important Functions •Joins and different types •Views •Index •Synonym •Constraints •Set Operator 2.Module – II (UNIX/LINUX) •Overview of UNIX Operating System •Basic commands and concepts •Command Manuals •Regular Expressions •Input/Output Redirection •Piping •Filter •Details explanation of File Attributes •Job Scheduling •Archive/Compress File •Environment variables •Basic of Editor: vi, sed •Quoting and Escape Mechanism •Types of Variables •Operator •Shell Arithmatic •How to to write, execute and debug Shell Script Program •Function •Working with UNIX Server •Different Statement and Loops in Shell Script 3.Module – III (Datawarehousing Concepts) •What is Datawarehouse ? •Why Datawarehouse require ? •DWH Architecture •DWH Characteristics •Data Mart and types •DM vs DWH •Common Datawarehouse tasks •Data cleansing •Partitioning •Staging area •Metadata •OLTP, OLAP, ROLAP, MOLAP •Surrogate Key •Materialized View •Dimension Modeling •Facts and Dimensions •DWH Schema designing •Advantages of Datawarehouse •Star Schema, Snow-flake Schema, Galaxy Schema •OBIEE/BI Overview •Overview of Reports 4.Module – IV (ETL Concepts) •Types of Source Files •Data Extraction •Different types of Transformations •Data Loading •Slowly Changing Dimension •SCD (Type-1, Type-2 and Type-3) •Introduction of ETL Tool •Overview of ETL Tool Architecture •ETL Tool Environment •Tracing Level 5.Module – V (Informatica Power Center Tool) •How developers work on Power Center •Different components of Power Center and uses •Tasks developed in different components •Mapping, Session, Worklet, Workflow, Mapplet

Duration: 40 Hours Prerequisites •Basic knowledge of Software Testing. Course Content 1.Module – I (Database/SQL) •Database Overview •DBMS, RDBMS, ORDBMS •Why Database Required •SQL Overview •DDL, DML, DCL, TCL •Data types •SELECT Statement •Restricting and Sorting Data •Aggregating Data using Group Functions •Creating and managing Tables •Manipulating Data •Sub queries •Important Functions •Joins and different types •Views •Index •Synonym •Constraints •Set Operator 2.Module – II (UNIX/LINUX) •Overview of UNIX Operating System •Basic commands and concepts •Command Manuals •Regular Expressions •Input/Output Redirection •Piping •Filter •Details explanation of File Attributes •Job Scheduling •Archive/Compress File •Environment variables •Basic of Editor: vi, sed •Quoting and Escape Mechanism •Types of Variables •Operator •Shell Arithmatic •How to to write, execute and debug Shell Script Program 3.Module – III (Datawarehousing Concepts) •What is Datawarehouse ? •Why Datawarehouse require ? •DWH Architecture •DWH Characteristics •Data Mart and types •DM vs DWH •Common Datawarehouse tasks •Data cleansing •Partitioning •Staging area •Metadata •OLTP, OLAP, ROLAP, MOLAP •Surrogate Key •Dimension Modeling •Facts and Dimensions •DWH Schema designing •Advantages of Datawarehouse •Star Schema, Snow-flake Schema, Galaxy Schema •OBIEE/BI Overview •Overview of Reports 4.Module – IV (ETL Concepts) •Types of Source Files •Data Extraction •Different types of Transformations •Data Loading •Slowly Changing Dimension •SCD (Type-1, Type-2 and Type-3) •Introduction of ETL Tool •Overview of ETL Tool Architecture •ETL Tool Environment 5.Module – V (Informatica Power Center Tool) •How developers work on Power Center •Different components of Power Center and uses •Tasks developed in different components •Mapping, Session, Worklet, Workflow, Mapplet

Type Tutoring The Best Informatica Online Training Institute From Hyderabad, India Course Content: DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache ETL UNIT TESTING ETL PERFORMANCE TESTING ETL PERFORMANCE OPTIMIZATION TECHNIQUES TASK IMPLEMENTATIONS Command EMAIL Timer Event Wait Event Raise Decision Assignment Control Worklet Session

The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts. We at DUCAT provide quality training in ORACLE DBA 10g, 11g, 11i and r12 on RHEL/Windows platforms respectively.

ADVANCE EXCEL TRAINING Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsNumber, IsDate, IsNull, IsErr, IsError, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Mail merge, Macros Etc

ADVANCE EXCEL TRAINING Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsNumber, IsDate, IsNull, IsErr, IsError, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Mail merge, Macros Etc and many more Special concession for school & college students

INFORMATICA 9 ONLINE TRAINING Informatica is one of the best ETL Tool. Mentors Inn offers a comprehensive portfolio of training on a variety of Informatica solutions. With our expertise in the field of IT training offers you training customized to your needs. INFORMATICA 9 COURSE CONTENT DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture. Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations. User Defined Functions. Tasks And Types of Tasks. Worklet and Types of Worklets. Scheduling Work flow Constraint Based Load Ordering. Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading. Push Down Optimization. PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches. Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache ETL UNIT TESTING ETL PERFORMANCE TESTING ETL PERFORMANCE OPTIMIZATION TECHNIQUES TASK IMPLEMENTATIONS. Command EMAIL Timer Event Wait Event Raise Decision Assignment Control Worklet Session

Best Informatica training institute in hyderabad india DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation

Informatica Online Training Institute From Pune India DATA WAREHOUSING CONCEPTS Data Warehouse Data Mart OLAP VS OLTP Data Warehouse Architecture (Basic) Dimensional Modeling Star Schema Snowflake Schema Dimension Fact Slowly Changing Dimension Hierarchy Confirmed Dimension Fact less Fact Summary / Aggregations table Change Data capture E T L INFORMATICA POWER CENTER 9 POWER CENTER COMPONENTS Designer Repository Manager Workflow Manager Workflow Monitor INFORMATICA CONCEPTS AND OVERVIEW Informatica Architecture Source Qualifier Target Designer Transformations Mappings Mapplets Sessions Tasks SOURCES Working with relational Sources Working with Flat Files TARGETS Working with Relational Targets Working with Flat file Targets TRANSFORMATIONS Expression Transformation Lookup Transformation Sequence Generator Transformation Filter Transformation Joiner Transformation Sorter Transformation Procedural Transformation Router Transformation Aggregator Transformation Update Strategy Transformation Union Transformation Rank Transformation Transaction Control Transformation Normalizer Transformation Source Qualifier Transformation Stored Procedure Transformation XML Source Qualifier Transformation Debugging Mappings POWER CENTER TRANSFORMATION LANGUAGE Numeric functions String Functions Date Functions Conversion Functions Cleansing Functions Aggregate Functions User Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup Transformation Unconnected Stored Procedure to Create and Drop Index Mapplet and Types of Mapplets Defining Reusable Transformations User Defined Functions Tasks And Types of Tasks Worklet and Types of Worklets Scheduling Work flow Constraint Based Load Ordering Target Load Plan Types of Batch Processing Link conditions Mapping Parameters Mapping Variables Defining Session Parameters Session Recovery Difference Between Normal and Bulk Loading Push Down Optimization PMCMD Utility PMREP Utility Incremental Aggregation TYPES Of LookUp Caches Static LookUp Cache Dynamic LookUp Cache Perisistance lookup Cache Shared LookUp Cache

ORACLE 10G/11G DBA ADMINISTRATOR OVERVIEW The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts. We at AllTechZ Solution provide quality training in ORACLE DBA 10g and 11g on RHEL/Windows platforms respectively. ORACLE 10G /11G TRAINING COURSE MODULES Following modules are included in ORACLE 10g/11g training programme SQLPLUS Retrieving data using SELECT statement Restricting & sorting data Single row functions Group functions Joins DDL & DML statements Data dictionary Controlling user access Managing schema objects Advanced subqueries Workshop I Introduction Install Oracle Database 10g and configure a database Manage the oracle instance Create manage and administer user accounts Manage privileges, roles and profiles Monitor, administer and configure oracle net services Perform backup & recovery of database Using export/ import utilities Workshop II Introduction Use RMAN to create and manage backup sets and image copies Use Oracle Secure Backup to backup and recover a database Use Oracle's Flashback technology to recover your database Detect block corruptions and take appropriate measures to correct them Use the various Database advisors and views to monitor and improve database performance Control database resource usage with the Resource Manager Simplify management tasks by using the Scheduler Review database log files for diagnostic purposes Customize language-dependent behavior for the database and individual sessions Database cloning Catalog Database Patching Overview of dataguard. All the advanced concepts of 11g BENIFITS OF THE TRAINING After the completion of 10g/11g course you will be aple to find you self in a position where you are technically strong both.the are technically & practically. you will and have the knowledge of now things get done in live scenarios for this will help you in clearing the interview. For further detail cpntact @

The primary goal of this course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g OCP course is designed to provide Oracle professionals /graduates with an in-depth understanding of the DBA concepts and knowledge required for the OCA & OCP exams.This course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security table & index management. Exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCA & OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to assess your overall knowledge of Oracle DBA concepts.

Working with Formulas/Functions • Lookup and Reference Functions: VLOOKUP, HLOOKUP, INDEX, ADDRESS, MATCH, OFFSET, TRANSPOSE etc • Logical Function: IF / ELSE, AND, OR, NOT, TRUE, NESTED IF/ELSE etc • Database Functions: DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP etc • Date and Time Functions: DATE, DATEVALUE, DAY, DAY360, SECOND, MINUTES, HOURS, NOW, TODAY, MONTH, YEAR, YEARFRAC, TIME, WEEKDAY, WORKDAY etc • Information Functions: CELL, ERROR.TYPE, INFO, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, TYPE etc • Math and Trigonometry Functions: RAND, ROUND, CEILING, FLOOR, INT, LCM, MOD, EVEN, SUMIF, SUMIFS etc • Statistical Functions: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, COUNT, COUNTA, COUNTBLANK, COUNTIF,FORECAST, MAX, MAXA,MIN, MINA, STDEVA etc • Text Functions: LEFT, RIGHT, TEXT, TRIM, MID, LOWER, UPPER, PROPER, REPLACE, REPT, FIND, SEARCH, SUBSTITUTE, TRIM, TRUNC, CONVERT, CONCATENATE, DOLLAR etc Conditional Formatting • Using Conditional Formatting • Using Conditional Formatting with Multiple Cell Rules • Using Color Scales and Icon Sets in Conditional Formatting • Creating New Rules and Managing Existing Rules Data Sorting and Filtering • Sorting Data A-Z and Z-A • Using Filters to Sort Data • Advance Filtering Options Pivot Tables • Creating Pivot Tables • Using Pivot Table Options • Changing and Updating Data Range • Formatting Pivot Table and Making Dynamic Pivot Tables Pivot Charts • Creating Pivot Charts • Types of Pivot Charts and Their Usage • Formatting Pivot Charts and Making Dynamic Pivot Charts VBA Macro • Introduction to VBA Macro • Recording Macro & Understanding Code Behind • Editing, Writing VBA Code and Saving as Macro or Add-In • Adding Add-Ins in Excel Advance VBA Macro Training Syllabus • Introduction of VBA Macros • Recordings Macro • Working with VBA Editor • VBA Programming Concept • VBA Syntax and Semantics • Variable Type and Declaration • Decisions Making with Operators • Repeating Actions with a Loops • Procedures and Events • Functions • User Forms and GUI • Sort and Filter, PivotTables and Pivot charts with VBA Macros • ODBC Connectivity to SQL Database and Query Handling • File Handling