Parameters

TABLEAU HANDS-ON ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY SOFTWARE WORKING FACULTY FOR FREE DEMO contact: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 214-628-3894 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Course Curriculum (we can customize the course agenda as per your requirements) TABLEAU Course Content Introduction Tableau Desktop and the Tableau Product Line Application Terminology Creating a Live Data Connection Saving a Data Source Sharing a Data Source Understanding Changes to Data Other Data Connection Options in Tableau Creating Basic Visualizations Getting Started in Tableau Desktop Elements of a Visualization Formatting Your View Simplifying and Sorting Your Data Data Filtering Sorting Organizing your Data Using Groups Creating and Using Hierarchies Creating a Combined Field Using Sets Slicing your Data by Date Working with Dates Using Discrete Date Parts Creating Date Filters Defining a Fiscal Year Creating Custom Dates Using Multiple Measures on the Same Axis Comparing Views with Multiple Measures Using Measure Values and Measure Names Combo Charts Combined or Shared Axis Charts Creating Dual Axis Charts Showing the Relationship between Numerical Values Options for Showing Numerical Relationships Creating Scatter Plots Creating Heat Maps Mapping Data Geographically Mapping in Tableau Geographic Mapping Viewing Distributions Bins and Histograms Viewing Specific Values Creating Crosstabs Creating Highlight Tables Grand Totals, Sub-totals, and Changing Aggregation Customizing your Data Calculation Types Creating Calculated Fields Using Logic Statements Type Conversions and Date Calculations Using Quick Table Calculations Calculations and Aggregations Using Parameters for Dynamic Values Showing Breakdowns of the Whole Pie Charts and Parts of the Whole Creating Tree Maps Highlighting Data with Reference Lines Using Reference Lines and Reference Bands Showing Data History Creating Motion Charts Making Your Views Available Building Dashboards Dashboard Actions Using Drill Downs Sharing Your Work Export to an Image File Exporting the Data Only Other Sharing Options Working with Single Data Sources Desktop Data Architecture Using Data Extracts Custom SQL Data Connection Using Multiple Data Sources All About Joins Using Data Blending Using Calculations in Tableau Creating and Editing Calculated Fields Calculations Performed on the Database Calculations and Aggregations Aggregating Dimensions in Calculations Record Level Calculations for Date Conversion Advanced Table Calculations Table Calculation Scope and Direction Null Values in Table Calculations Table Calculations for Statistical Analysis Creating and Using Parameters Using Parameters and Reference Lines Using Parameters with Filters Comparing Measures Against a Goal Showing Total Progress Toward a Goal (Bar in Bar Graph) Showing Staged Progress Toward a Goal (Bullet Graph) Showing the Biggest and the Smallest Values Tableau Geocoding How Tableau Performs Automatic Geocoding of Data Modifying Geocode Locations within Tableau Custom Geocoding Advanced Mapping Dual Axis Maps Mapping Paths Using Background Images for Spatial Analysis Showing Distributions of Data Creating a Pareto Chart Box and Whisker Plots Reference Distributions Statistics and Forecasting Trend Lines Forecasting Dashboards: Quick Filters, Actions, and Parameters Comparing Quick Filters, Actions, and Parameters Highlight Actions Filter Actions URL Actions Dashboard Best Practices Sizing Using Instructions Dashboard Formatting Sharing Your Work Sharing Packaged Workbooks Export to an Image File Exporting the Data Only Other Sharing Options Server Concepts Installation Create Users Assign Security Create Sites Publish and share dashboards with customers FOR More Details contact us at: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 214-628-3894

TABLEAU HANDS-ON ONLINE TRAINING,CORPORATE TRAINING BY REALTIME CORPORATE EXPERTS FOR FREE DEMO contact: Phone/WhatsApp: +91-(850) 012-2107 Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided TABLEAU ONLINE TRAINING Course Content Introduction Tableau Desktop and the Tableau Product Line Application Terminology Creating a Live Data Connection Saving a Data Source Sharing a Data Source Understanding Changes to Data Other Data Connection Options in Tableau Creating Basic Visualizations Getting Started in Tableau Desktop Elements of a Visualization Formatting Your View Simplifying and Sorting Your Data Data Filtering Sorting Organizing your Data Using Groups Creating and Using Hierarchies Creating a Combined Field Using Sets Slicing your Data by Date Working with Dates Using Discrete Date Parts Creating Date Filters Defining a Fiscal Year Creating Custom Dates Using Multiple Measures on the Same Axis Comparing Views with Multiple Measures Using Measure Values and Measure Names Combo Charts Combined or Shared Axis Charts Creating Dual Axis Charts Showing the Relationship between Numerical Values Options for Showing Numerical Relationships Creating Scatter Plots Creating Heat Maps Mapping Data Geographically Mapping in Tableau Geographic Mapping Viewing Distributions Bins and Histograms Viewing Specific Values Creating Crosstabs Creating Highlight Tables Grand Totals, Sub-totals, and Changing Aggregation Customizing your Data Calculation Types Creating Calculated Fields Using Logic Statements Type Conversions and Date Calculations Using Quick Table Calculations Calculations and Aggregations Using Parameters for Dynamic Values Showing Breakdowns of the Whole Pie Charts and Parts of the Whole Creating Tree Maps Highlighting Data with Reference Lines Using Reference Lines and Reference Bands Showing Data History Creating Motion Charts Making Your Views Available Building Dashboards Dashboard Actions Using Drill Downs Sharing Your Work Export to an Image File Exporting the Data Only Other Sharing Options Working with Single Data Sources Desktop Data Architecture Using Data Extracts Custom SQL Data Connection Using Multiple Data Sources All About Joins Using Data Blending Using Calculations in Tableau Creating and Editing Calculated Fields Calculations Performed on the Database Calculations and Aggregations Aggregating Dimensions in Calculations Record Level Calculations for Date Conversion Advanced Table Calculations Table Calculation Scope and Direction Null Values in Table Calculations Table Calculations for Statistical Analysis Creating and Using Parameters Using Parameters and Reference Lines Using Parameters with Filters Comparing Measures Against a Goal Showing Total Progress Toward a Goal (Bar in Bar Graph) Showing Staged Progress Toward a Goal (Bullet Graph) Showing the Biggest and the Smallest Values Tableau Geocoding How Tableau Performs Automatic Geocoding of Data Modifying Geocode Locations within Tableau Custom Geocoding Advanced Mapping Dual Axis Maps Mapping Paths Using Background Images for Spatial Analysis Showing Distributions of Data Creating a Pareto Chart Box and Whisker Plots Reference Distributions Statistics and Forecasting Trend Lines Forecasting Dashboards: Quick Filters, Actions, and Parameters Comparing Quick Filters, Actions, and Parameters Highlight Actions Filter Actions URL Actions Dashboard Best Practices Sizing Using Instructions Dashboard Formatting Sharing Your Work Sharing Packaged Workbooks Export to an Image File Exporting the Data Only Other Sharing Options Server Concepts Installation Create Users Assign Security Create Sites Publish and share dashboards with customers FOR FREE DEMO contact: Phone/WhatsApp: +91-(850) 012-2107 USA Number: 214-628-3894

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.

PL/SQL – Part 1 1. PL/SQL Basics 1. PL/SQL Block 2. Anonymous Block Structure 3. Named Block Structure 4. Executing Blocks 5. Calling PL/SQL Functions 6. Executing PL/SQL Blocks and Functions 2. Declaring Variables 1. Variable Data Types 2. Variable Naming 3. Variable Assignment 4. Complex Variable Types 3. Within the Block 1. Conditional Processing 1. The IF Statement 2. The CASE Statement 2. Iterative Processing 1. The LOOP Statement 2. The WHILE Statement 3. The FOR Statement 4. Handling Exceptions 1. Overview of Exceptions 2. Causing System Generated Exceptions 3. Handling System Generated Exceptions 4. Identifying System Generated Exceptions 5. OTHERS Exception Handler 6. User Defined Exceptions 5. Use of SQL in PL/SQL 1. Implicit Cursors 2. %TYPE and %ROWTYPE Attributes 3. EXECUTE IMMEDIATE statement 4. Cursors Attributes 5. Implicit Cursor 6. Explicit Cursors 7. Explicit Cursor 8. Cursor FOR loop 6. Nested Blocks 1. Nesting Blocks 2. Scope of Variables 3. Scope of Exceptions 4. Nested Subprograms 5. Exception Propagation in Nested Blocks 6. Block Variable Visibility 7. Introducing Subprograms 1. Anonymous blocks 2. Types of Subprograms 3. Finding Subprograms in the Oracle Data Dictionary 4. Object Dependencies 5. Subprogram information in the Oracle Data Dictionary 8. Stored Procedures and Functions 1. Creating Subprograms 2. Modifying Subprograms 3. Removing Subprograms 4. Application Maintenance 5. Exercise Title 6. Parameters 7. Cursors as Parameters 8. Subprogram Development Techniques 9. Addressing Compilation Errors 10. PL/SQL Subprograms with Parameters 9. Packages 1. Structure of Packages 2. Purpose of Packages 3. Wrap Utility 4. Positional vs Named Parameter Notation 5. Subprograms Omitted from Specifications 6. Using PL/SQL Packages 10. Database Triggers 1. Purpose of Triggers 2. Invocation of Triggers 3. Coding Triggers 4. Validation Trigger 5. Modifying Triggers 6. Viewing Triggers 7. Enabling/Disabling Triggers 8. Trigger Errors 11. Data Retrieval Techniques 1. Cursor Review 2. Cursor Parameters 3. Cursor Variables 4. Dynamic SQL 12. Using Oracle Supplied Packages 1. Oracle Supplied Packages 2. Identifying Available Packages 3. Identifying Package Subprograms 4. Selected Oracle Supplied Package Demos 5. Packages related to Input/Output PL/SQL – Part 2 – Advaced 1. Arrays and Bulk Binds Populating Collections Using Bulk Operations Bulk collect Bulk Collect from an Explicit Cursor Chunking Bulk Collections Using the LIMIT Clause Manually Limiting Bulk Collection Volumes Bulk Collection of DML Results FORALL Bulk INSERT Operations Bulk UPDATE Operations Bulk DELETE Operations Sparse Collections Host Arrays in Bulk Operations BULK_ROWCOUNT Handling Exceptions in Bulk Operations Unhandled Exceptions Handled Exceptions Bulk Operations that Complete Dynamic SQL and Bulk Operations 2. Table Functions and Pipelining Introduction Pipelining Table Functions Parallel Enabled Table Functions Creating Transformation Pipelines Deterministic Miscellaneous Information SQL – Part 1 1. Users and Schemas 1. Introduction to Users and Schemas 1. Definitions and Client Tools 2. SQL Developer Login 2. Creating An Application Schema 2. Pseudo Columns & Functions 1. Using The Dual Table 2. Functions 3. Pseudo-Columns 4. Using Rowid 5. Using Rownum 3. Using Subqueries 1. Simple Subqueries 2. Inline Views 3. Correlated Subqueries 4. Scalar Subquery 4. Joining Tables 1. Review of Joins 2. Equijoins 1. Inner Joins 2. Outer Joins 3. Cross Joins 4. Natural Joins 5. Using Named Subqueries 5. Group Operations 1. About Group Processing 2. Simple GROUP BY 3. ROLLUP Function 6. Using Set Operators 1. Set Operators Defined 2. Relationship to Mathematical Set Theory 3. Restrictions on Set Operators 7. Conditional Processing 1. The DECODE Function 2. The Case Expression 3. Exercise: Conditional Processing 8. SQL Functions (Character) 1. What Are SQL Functions? 2. Character Functions 1. CONCAT 2. LENGTH 3. INSTR 4. REPLACE http://www.bizsmart.in Bizsmart solutions India pvt ltd 354,Aswath nagar,

Type Computer Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Oracle Apps Training Courses in bangalore. Our Oracle Apps training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Oracle Apps projects knowledge which will provide you an edge over other training institutes. Our Oracle Apps training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Oracle Apps Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Oracle Apps Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Oracle Apps Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Oracle Apps Training in our centres located across bangalore. We also provide Online Training Classes for Oracle Apps Training Course. Contact us today to schedule a free demo and complete course details on Oracle Apps Training Course. What is Oracle Apps Training ? Introduction to ERP Definition of ERP, Overview of popular ERP S Comparison of Oracle Apps with other ERP S Types of Roles Types of Projects AIM documentation standards Oracle Application Architecture. Database structure of OA Using TOAD Application Object Library Creating Users WHO columns Creating Responsibilities Request group construction Application development Defining concurrent program Concurrent programs with parameters Working with multiple concurrent programs Scheduling the Concurrent Program Concurrent Program incompatibilities Creating Request Set Procedure registration Value sets Value sets Overview of value sets Options in value sets Types of value sets Creation of value set Overview of value set tables Registration of Custom Objects Registration of Application Report development Report registration Parametric report registration Registration of a Table Registration of Sql, Sql Loader, PL/SQL programs Report Development: Customization of Reports – Adding DFF Info Customization of Reports – Removing Parameters Flexfields Report with Single Structure Report Coding Standards User Exits in Report design Customization of Reports – Adding Parameters Customization of Reports – Adding Logos Discoverer Administration Edition: Creating a end user layer database user Connecting to discoverer administrator, using the load wizard and the work area Modifying the Business Area Working with Custom Folders Creating Joins Customizing Items Designing a complex Folder Discoverer User Edition: Creation of Simple Workbook To design parameterized workbook To change Heading items To insert new sheet in the Workbook To add and remove items from Workbook To create duplicate sheet in Workbook To add title to the Worksheet To insert date, time, page numbers and image on Header/Title of Workbook To apply Conditional Formatting Interfaces Introduction to Interfaces Outbound Interfaces Using UTL_FILE package Inbound Interfaces Using SQL * Loader tool / dynamic table for files read(New concept) SQL * Loader Concepts Data File. Control File. Bad File. Discard File. Log File. Commands in Sql * Loader Registration Of control File in Oracle Apps. Conversions Overview on conversions Difference between Interfaces and conversions Working with staging table script Developing validations package Standards to be followed in conversions Flex Fields Overview of flex fields Types of Flex Fields Descriptive Flex Fields Key Flex Fields Step in creation of DFF Flex fields tables and relations Profiles Overview of profile options Different levels in Setting profiles Steps in setting a profile option Some important profile options Some important API’s of profiles Multi Org Concepts What is Multi Org and why we need. Multi Org Tables. Multi Org Views. PO Overview and tables Overview of purchasing Major setups and transactions Overview of some purchasing tables INV Overview and Tables Overview of inventory Major setups and transactions Overview of some INV Tables OM Overview and Tables Overview of order management Major setups and transactions Overview of some Order Management Tables GL Overview and Tables Overview of GL Major setups and transactions Overview of some GL tables AP Overview and tables Overview of payables Major setups and transactions Overview of some payable tables Alerts Overview on alerts Types of alerts Creation of alerts Workflows Introduction to workflow Workflow builder Attributes Creating Processes XML Publisher Introduction to XML Publisher Generating XML file using reports Creating Templates Creating Data Definitions Oracle Apps Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 3 - 4 Hours per day: 12 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Not Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Type Tutoring INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

Type Tutoring The Best OWB Online Training Institute From Hyderabad, India Course Content: INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

Type Computer Oracle RAC Training in Bangalore & Best Oracle RAC Training Institutes in Bangalore Not Rated About Oracle RAC Training ? Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Oracle RAC Training Courses in bangalore. Our Oracle RAC training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Oracle RAC projects knowledge which will provide you an edge over other training institutes. Our Oracle RAC training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Oracle RAC Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Oracle RAC Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Oracle RAC Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Oracle RAC Training in our centres located across bangalore. We also provide Online Training Classes for Oracle RAC Training Course. Contact us today to schedule a free demo and complete course details on Oracle RAC Training Course. What is Oracle RAC Training ? Grid Infrastructure Concepts What is a Cluster Grid Foundation Components Oracle Clusterware Architecture Oracle Clusterware Software and Storage Describe ASM Architecture Creating and Managing ASM Disk Groups Creating and Managing ASM Cluster Filesystems Grid Infrastructure Installation and Configuration Hardware Requirements Network Requirements DNS and DHCP Configuration Grid Plug and Play Considerations Single Client Access Names Post installation tasks Administering Oracle Clusterware Managing Clusterware with Enterprise Manager Determining the Location of the Oracle Clusterware Configuration Files Backing Up and Recovering the Voting Disk Adding, Deleting, or Migrating Voting Disks Locating the OCR Automatic Backups Oracle Local Registry Migrating OCR Locations to ASM Managing Network Settings Managing Oracle Clusterware Prerequisite Steps for Extending a Cluster Using addNode.sh to Add a Node to a Cluster Rolling Patches, And Rolling Upgrades Comparing Software Versions With the Active Version Installing A Patchset With the OUI Utility Installing A Patch With The opatch Utility Administering ASM Instances ASM Initialization Parameters Adjusting ASM Instance Parameters in SPFILEs Starting and Stopping ASM Instances Using srvctl Starting and Stopping ASM Instances Using ASMCA and ASMCMD Starting and Stopping ASM Instances Containing Cluster Files Starting and Stopping the ASM Listener Administering ASM Disk Groups Creating And Deleting ASM Disk Groups ASM Disk Group Attributes ASM Disk Group Maintenance Tasks Preferred Read Failure Groups Viewing ASM Disk Statistics Performance And Scalability Considerations For ASM Disk Groups ASM Files, Directories, and Templates Using Different Client Tools to Access ASM Files Fully Qualified ASM File Name Format Creating and Managing ASM files, Directories and Aliases Managing Disk Group Templates Real Application Clusters Database Installation Installing The Oracle Database Software Creating A Cluster Database Post–database Creation Tasks Single-Instance Conversion Using the DBCA Single-Instance Conversion Using rconfig Background Processes Specific to Oracle RAC Oracle RAC Administration Enterprise Manager Cluster Database Pages Redo Log Files In A RAC Environment Undo Tablespaces In A RAC Environment Starting And Stopping RAC Databases And Instances Initialization Parameters In A RAC Environment Quiescing RAC Databases Managing Backup and Recovery for RAC Protecting Against Media Failure Parallel Recovery in RAC Archived Log File Configurations Archived Redo File Conventions in RAC Channel Connections to Cluster Instances Distribution of Backups Monitoring and Tuning the RAC Database Determining RAC-Specific Tuning Components Tuning Instance Recovery in RAC RAC-Specific Wait Events, Global Enqueues, and System Statistics Implementing the Most Common RAC Tuning Tips Using the Cluster Database Performance Pages Using the Automatic Workload Repository in RAC Using Automatic Database Diagnostic Monitor in RAC Services Configure and Manage Services in a RAC environment Using Services with Client Applications Using Services with the Database Resource Manager Configuring Services Aggregation and Tracing Managing Services From the Command Line Managing Services With Enterprise Manager Rac Advanced Topics 1 Discussion about CRS proces The order of crs startup and discussion about the important diagnostic log files Discussion about RAC background process CacheFusion discussion Rac Advanced Topics 2 Single Node to RAC conversion RAC to single node conversion Rebuild of RAC system after clusterware lost Adding a Non RAC database to cluster RAC version upgrade Workshop Extend your cluster using Grid Control Patch Oracle Clusterware Testing Transparent Application Failover Oracle RAC Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 3 - 4 Hours per day: 12 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

Contact us: Swathi, +91-, OWB Online Training Institute from Hyderabad India Course Content: INSTALLING AND SETTING UP THE WAREHOUSE BUILDER ENVIRONMENT What Is Oracle Warehouse Builder? Basic Process Flow of Design and Deployment Oracle Warehouse Builder Licensing and Connectivity Options Installing Oracle Warehouse Builder 11.2 OWBSYS Schema Using OWB 11.2 with Database 10g R2 Using the Repository Assistant to Manage Workspaces Supported operating systems (OS), sources, targets, and optional components GETTING STARTED WITH WAREHOUSE BUILDER Logging In to OWB Design Center Overview of the Design Center OWB Projects Overview of Objects within a Project Overview of Objects within an Oracle Module Organizing Metadata Using Foldering Locations Navigator and Globals Navigator panels Setting Projects Preferences: Recent Logons UNDERSTANDING THE WAREHOUSE BUILDER ARCHITECTURE Warehouse Builder Development Cycle Overview of the Architecture for Design, Deployment, Execution Overview of Configurations, Control Centers, and Locations Creating Target Schemas Registering DB User as an OWB User Roles and Privileges of Warehouse Builder Users Registering an Oracle Workflow User DEFINING SOURCE METADATA Data warehouse implementation: Typical steps Difference Between Obtaining Relational and Flat File Source Metadata Creating Flat File Module Sampling Simple Delimited File Sampling Multi-record Flat File Creating an Oracle Module Selecting the Tables for Import DEFINING ETL MAPPINGS FOR STAGING DATA Purpose of a Staging Area Define OWB Mappings Mapping Editor Interface: Grouping, Ungrouping, and Spotlighting Creating External Tables Create and Bind process Levels of Synchronizing Changes Using the Automapper in the Mapping Editor Set loading type and target load ordering USING THE DATA TRANSFORMATION OPERATORS Component Palette Using a Joiner Lookup Operator: Handling Multiple Match Rows Using the Subquery Filter Operator Using the Set, Sequence, and Splitter Operators Pivot and Unpivot Operators Using the Aggreagator, Constant, Transformation, and Pre/Post Mapping Operators Deploying and Executing in Projects Navigator Panel CLEANSING AND MATCH-MERGING NAME AND ADDRESS DATA Integrating Data Quality into ETL Name and Address Data Cleansing Name and Address Server Name and Address Software Providers Settings in the Name and Address Operator Reviewing a Name and Address Mapping Consolidating Data Using the Match Merge Operator Using the Match Merge Operator in a Mapping USING PROCESS FLOWS Process Flow Concepts Creating a Process Flow Module, a Process Flow Package and a Process Flow Types of Activities: Fork, And, Mapping, End Activity Creating Transitions Between Activities Some More Activities: Manual, SQLPLUS, Email Generating the Process Flow Package DEPLOYING AND REPORTING ON ETL JOBS Logical Versus Physical Implementation Setting Object Configuration Deployment Concepts Invoking the Control Center Manager Deploy Options and Preferences Repository Browser Starting OWB Browser Listener and the Repository Browser Browsing Design Center and Control Center Reports USING THE MAPPING DEBUGGER Overview of the Mapping Debugger Initializing a Mapping Debugging Session Preparing the testing environment and test data Setting breakpoints and watch points Evaluating the flow of data to detect mapping errors ENHANCING ETL PERFORMANCE Performance Tuning at Various Levels Performance-Related Parameters in ETL Design Configuring Mappings for Operating Modes, DML Error Logging, Commit Control, and Default Audit Levels Enabling Partition Exchange Loading (PEL) for Targets Performance-Related Parameters in Schema Design Configuring Indexes, Partitions, Constraints Enabling Parallelism and Parallel DML Setting Tablespace Properties and Gathering Schema Statistics MANAGING BACKUPS, DEVELOPMENT CHANGES, AND SECURITY Overview of Metadata Loader Utilities (MDL) Managing Metadata Changes by Using Snapshots Using Change Manager Version Management of Design Objects Graphical UI for Security Management Object-Level Security Setting Security Parameters INTEGRATING WITH ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION (OBI EE) Business Justification: Tools Integration Integrating with OBI EE and OBI SE Transferring BI Metadata to OBI EE Server Setting Up the UDML File Location Deriving the BI Metadata (OBI EE) Deploying the BI Module Converting the UDML File for OBI EE Oracle BI Admin and Answers Tool APPENDIX B: CREATING EXPERTS Harnessing OWB Power and Complexity for New Users OWB "Experts": Directed Guidance and Knowledge Management Creating an Expert Starting an Expert Creating Your Own Custom Dialog Scenario: ROLAP to MOLAP in Five Easy Steps Scenario: Expert for Creating External Table APPENDIX C: USING DIAGNOSIS AND DEBUGGING TECHNIQUES Collecting Information Before Contacting Oracle Support Sequence Used by Oracle Support Representatives to Process Calls Activating Debugging and Logging for Full Java Debug Trace Activating Tracing Using the Service_Doctor.sql Script Troubleshooting and Diagnosing Errors in Control Center Agent (CCA) Run-Time Views and Utilities Online Warehouse Builder Resources

SHARE MARKET TECHNICAL ANALYSIS TRAINING Guided by Practical Experience and Observation rather than Theory “A Way To Learn, Analyse, Invest, Gain And Help Others To Gain And Prosper” 1.What is a Chart and its Interpretation? 2.What is Data i.e. Open, High, Low, Close, Volume and how to use it? 3.What is a Line Study? Overview, Drawing, Interpretation 4.What is an Indicator? Overview, Parameters, Calculations, Plotting, Interpretation Types of Indicators: Trend Indicators: MACD, Moving Averages, Trend lines Volatility Indicators: Bollinger Bands Bottom & Top, Moving Average (variable), Relative Volatility Index, Standard Deviation Momentum Indicators: MACD, Momentum Indicator, Relative Momentum Index, Relative Strength Index, Stochastic Momentum Index, Stochastic Oscillator, Accumulation/Distribution Cycle Indicators: Cycle Lines, Fibonacci Time Zones Market Strength Indicators: Accumulation/Distribution, Moving Average (volume adjusted), Open Interest, Price Volume Trend, Volume Support and Resistance Indicators: Fibonacci Arcs, Fans, Retracements, Fibonacci Studies, Gann Lines, Fans, Trend Lines 5.Patterns: Reversal Upward and Downward, Double Bottom, Triple Bottom, Double Top, Triple Top Reversal Pattern, Rounding Bottom or Top Reversal Pattern, V-Shaped or Spike Reversal Pattern, Head and Shoulder and Inverse Head and Shoulder Reversal Pattern, Triangles, Rectangles, The flag or pennant pattern, The Rising and Falling wedges, Rising Falling Flat Channel 6.The Gap Theory 7.The Elliott wave theory 8.Candlestick: Overview, Functions 9.Gann Studies: Overview, Parameters 10.Fibonacci Studies: Overview, Interpretation, Parameters, Drawing Tips Fibonacci Arcs, Fibonacci Fans, Fibonacci Projections, Fibonacci Time Zones 11.The Dow Theory 12.What is a Layout?, 13.What is System Test?, 14.What is Template?, 15.What is Expert Advisor?, 16.What is The Explorer?, 17.What is Indicator Builder?, 18.What is Formula Language? Charges Rs.250/- Per Day, Duration Minimum 5 Days (Topics 1 to 6), Timing as suitable to candidates Mr. Sanjay Goyal is senior faculty, possesses more than 15 years experience, has trained more than 500 successful professionals. He has written many informative articles on the subject. Contact At 2A/208, Azad Nagar, Kanpur- or On Numbers , -.

SQL School is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Online and Classroom Trainings for the last SEVEN years. All our training sessions are COMPLETELY PRACTICAL. SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING: SQL Server Design Architecture SQL Server R2 - Installation SQL Server - Installation Service Accounts and Authentication SQL Server Database Design & Planning SQL Server Table Design & Pages Table Compression Techniques Data Integrity Concepts and Column Value Consistency PRIMARY KEY, UNIQUE and IDENTITY Constraints CHECK and DEFAULT Constraints SQL Server Views and Schemabinding of Views Updatable Vies adn ALTER consequences Schema depedancy and Encryptions JOINS, Sub Queries and Nested Queries Nested and Linking Tables Uses of Indexes and Performance Query Execution Plans and QO Components Stored Procedures and OUTPUT Parameters Dynamic SQL and Usage User Defined Functions, Table Return Values and Parameters Table Valued Parameters and Variables DDL Triggers and DML Triggers Cursors Usage and Limitations TEMP Tables and Table Variables T-SQL Transactions Concepts & Types Locks and Memory Concepts & Locking Hints Blocking Issues and Open Transactions New Features in SQL Server All Sessions are Completely Practical and Realtime. SQL School Training Institute Address SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) Plot No 108, Lane No: 2, Road No: 1 Diag Opp: Almas Hotel, Beside SR Nagar Bus Stop, Sanjeev Reddy Nagar (SR Nagar), Hyderabad - 38, India. India: 040 (Off) (Mobile) USA: (

SQL School is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Online and Classroom Trainings for the last SEVEN years. All our training sessions are COMPLETELY PRACTICAL. SQL SERVER & T-SQL COURSE DETAILS - FOR ONLINE TRAINING: ◾SQL Server Design Architecture ◾SQL Server 2008 R2 - Installation ◾SQL Server 2012 - Installation ◾Service Accounts and Authentication ◾SQL Server Database Design & Planning ◾SQL Server Table Design & Pages ◾Table Compression Techniques ◾Data Integrity Concepts and Column Value Consistency ◾PRIMARY KEY, UNIQUE and IDENTITY Constraints ◾CHECK and DEFAULT Constraints ◾SQL Server Views and Schemabinding of Views ◾Updatable Vies adn ALTER consequences ◾Schema depedancy and Encryptions ◾JOINS, Sub Queries and Nested Queries ◾Nested and Linking Tables ◾Uses of Indexes and Performance ◾Query Execution Plans and QO Components ◾Stored Procedures and OUTPUT Parameters ◾Dynamic SQL and Usage ◾User Defined Functions, Table Return Values and Parameters ◾Table Valued Parameters and Variables ◾DDL Triggers and DML Triggers ◾Cursors Usage and Limitations ◾TEMP Tables and Table Variables ◾T-SQL Transactions Concepts & Types ◾Locks and Memory Concepts & Locking Hints ◾Blocking Issues and Open Transactions ◾New Features in SQL Server 2012 All Sessions are Completely Practical and Realtime. Detailed Course Curriculum: http://sqlschool.com/TSQL-Online-Training.html SQL School Training Institute contact@sqlschool.com Office: (+91) 040 64577244 Mobile: (+91) 0 9666440801 Address: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India. http://www.sqlschool.com

Real Time Training Oracle Apps Tech,Oracle Apps Tech elegant it services • What is ERP? • Comparison of Oracle Apps with other ERPS • Types of Roles, Types of projects, AIM documents • Oracle Apps structure, database structure and 3-tier architecture Application Object Library(AOL) • Concurrent program with parameters, Creating Value sets • Menu construction, Defining concurrent program • Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities • Scheduling concurrent program, Creating request group, Creating request set Multi Org Concepts • What is Multi Org and why we need • Multi Org Tables • Multi Org Views Module Overviews • Inventory Module flow with base tables • Accounts Payable module flow with base tables • Accounts Receivable module flow with base tables • Order Management module flow with base tables • Purchasing order module with base table • General Ledger module with base tables • HRMS module with base table Reports • Report development process, Report registration process • Bind parameters, lexical parameters, reports with value set, Building report manually • Using repeating frames, Summary columns, Standard report customization Interfaces • Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package • Inbound Interface process, Working with SQL*Loader tool • Different option in SQL *Loader tool, bad file, discard file • Using Interface table approach • Using API Approach Conversions • Introduction to conversions, Creation of staging table • Developing the validation package, explaining the real time project code. • Completing the conversion task, Differences between Inbound interfaces and Conversions Forms • Form development process using TEMPLATE.FMB, Form registration process • Form personalization • Form Customation Using Custom.pll Workflows • Workflow Customization process steps Alerts • Overview on alerts • Creation of alerts • Types of alerts XML Publisher • Introduction to XML publisher, Report development process • Creating reports for multiple rows, Creating Data definitions, Creating templates, Multi Layout Reports • XML publisher Barcode Report(Advance) • XMLP Bursting Concept (Advance) Flex fields • Creating DFF, Creating KFF Functional Cycles • P2P Cycle(Procure to Pay Cycle) • O2C Cycle(Order to Cash Cycle) Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore -

PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training - l

PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. % satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: rd Floor, Pinnacle Pride S. No. A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - Maharashtra, India. Call Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)-

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)-

SQL SCHOOL is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We are providing SQL server Microsoft classroom trainings and online trainings since the last EIGHT years. All our training sessions are COMPLETELY PRACTICAL. SQL server Microsoft classroom trainings @ SQL School - For Classroom Training: • SQL Server Architecture • SQL Server 2012/2014 - Installation • Service Accounts and Authentication • SQL Server Database Design & Planning • SQL Server Table Design & Pages • Table Compression Techniques • Data Integrity Concepts and Column Value Consistency • PRIMARY KEY, UNIQUE and IDENTITY Constraints • CHECK and DEFAULT Constraints • SQL Server Views and Schema binding of Views • Updatable Views and ALTER consequences • Schema dependency and Encryption s • JOINS, Sub Queries and Nested Queries • Nested and Linking Tables • Uses of Indexes and Performance • Query Execution Plans and QO Components • Stored Procedures and OUTPUT Parameters • Dynamic SQL and Usage • User Defined Functions, Table Return Values and Parameters • Table Valued Parameters and Variables • DDL Triggers and DML Triggers • Cursors Usage and Limitations • TEMP Tables and Table Variables • T-SQL Transactions Concepts & Types • Locks and Memory Concepts & Locking Hints • Blocking Issues and Open Transactions • New Features in SQL Server 2012/2014 All Sessions are Completely Practical and Real time. One Real-time Project for every course. Contact us today for SQL server classroom trainers SQL School Training Institute Schedules for SQL SERVER PRACTICAL ONLINE TRAINING: India: Office: +91 (0) 40 64577244 Mobile: +91 (0) 9666440801 USA: Office: +1 (510) 400-4845 Address: 108/2RT, Road No 1, SR Nagar, Land Mark: Beside Bus Stop, Hyderabad, India.

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here 1.Oracle real application (RAC)- 2.Oracle 11g/12c database administration (DBA) training - 3.Oracle golden gate training- 4. ASP.Net MVC Training -

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC.

Oracle Real Application Clusters is high availability solution provided by oracle which also enhance and help with scalability, load balancing agility for any application. Real Application Clusters (Oracle RAC) contains multiple nodes which allows several nodes in a system to accesses the database stored on shared disk storage. If any node fails or goes down then, the database and service will be still available through other nodes. Igniter InfoTech is one of the expert and leading oracle real application (oracle RAC) training provider with proven track record of high quality training. This course has been designed to provide to give practical training with various hands on tutorials and exercise. Igniter have highly qualified, expert and industrial experienced team of Oracle RAC Certified trainers, who have 7 to 10 years of experience. In this course candidate will learn basics of RAC architecture, GRID database administration and management, command line utilities and basic commands like SRVCTL, CRSCTL. You will learn RAC network connection and backup and recovery along with node management and online migration. PREMIUM COURSE BENEFITS 1.8+ years experienced and Certified Expert trainers. 2.High training quality at affordable cost 3.Complete support and all assistance for certification and in-depth training. 4.Hands-on practical labs various exercise. 5.100% satisfaction guaranteed Igniter Infotech Deccan Pune Office Address: 301, 3rd Floor, Pinnacle Pride S. No. 1544/45 A, Sadashiv Peth, Near Hotel Durvankur, Tilak Road, Pune - 411 030 Maharashtra, India. Call 9175269538 Our Other Courses 1.Training provider in 11g/12c Oracle database administration. 2.Oracle golden gate 3.Oracle Performance Tuning. 4.Oracle real application Cluster (RAC). Oracle 11g R2 Grid Infrastructure Concepts •What is a Cluster •Grid Foundation Components •Oracle Clusterware Architecture •Oracle Clusterware Software and Storage •Describe ASM Architecture •Creating and Managing ASM Disk Groups •Creating and Managing ASM Cluster File systems •Administering Oracle Clusterware •Troubleshooting Oracle Clusterware Grid Infrastructure Installation and Configuration •Hardware Requirements •Network Requirements •Software Requirements •DNS and DHCP Configuration •Grid Plug and Play Considerations •Single Client Access Names •Post installation tasks Oracle Automatic Storage Management concepts •ASM Instance •ASM Disks •ASM Disk Groups •ASM Redundancy Cluster installation Prerequisite for Oracle 11g R2 RAC •Linux OS Software Installation •Create OS Group and User Accounts •Networking •Synchronizing the Time on ALL Nodes •Configuring Kernel Parameters •Set shell limits for the oracle & grid user •Create the Oracle Inventory Directory •Creating the Oracle Grid Infrastructure Home Directory •Creating the Oracle Base Directory •Creating the Oracle RDBMS Home Directory •Stage the Oracle Software •Check OS Software Requirements •Cluster Verification Utility Shared Storage Configuration •Types of Shared Storage •Partition the Shared Disks •Installing and Configuring ASMLib •Using ASMLib to Mark the Shared Disks as Candidate Disks Oracle 11g Grid Infrastructure Installation •Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)… •Grid Infrastructure Home Patching •RDBMS Software Install •Run ASMCA to create diskgroups Oracle 11g R2 RAC Database Software Installation •Installing The Oracle Database Software •Creating A Cluster Database •Post database Creation Tasks Administering Oracle Clusterware •Managing Clusterware with Enterprise Manager •Determining the Location of the Oracle Clusterware Configuration Files •Backing Up and Recovering the Voting Disk •Adding, Deleting, or Migrating Voting Disks •Locating the OCR Automatic Backups •Oracle Local Registry •Migrating OCR Locations to ASM •Managing Network Settings •Managing Oracle Clusterware Administering ASM Instances •ASM Initialization Parameters •Adjusting ASM Instance Parameters in SPFILEs •Starting and Stopping ASM Instances Using srvctl •Starting and Stopping ASM Instances Using ASMCA and ASMCMD •Starting and Stopping ASM Instances Containing Cluster Files •Starting and Stopping the ASM Listener •Administering ASM Disk Groups •Creating and Deleting ASM Disk Groups •ASM Disk Group Attributes •ASM Disk Group Maintenance Tasks •Viewing ASM Disk Statistics Prerequisite Steps for Extending a Cluster •Using addNode.sh to add a Node to a Cluster •Rolling Patches and Rolling Upgrades •Installing a Patchset with the OUI Utility •Installing a Patch With The opatch Utility Cluster Node Management •Add/Deleting the instance •Add the Node •Remove the Node •Single-Instance Conversion Using rconfig •Single-Instance Conversion Using DBCA Troubleshooting Oracle Clusterware •Oracle Clusterware Log Files •Gathering Log Files Using diagcollection.pl •Component-level Debugging •RAC-Specific Wait Events, Global Enqueues, and System Statistic •Implementing the Most Common RAC Tuning Tips •Using the Cluster Database Performance Pages •Using the Automatic Workload Repository in RAC •Using Automatic Database Diagnostic Monitor in RAC. For More Information: Click here

SequelGate is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Classroom and Classroom Trainings and Corporate training. All our training sessions are COMPLETELY PRACTICAL. SQL SERVER & T-SQL COURSE DETAILS - FOR Classroom TRAINING: SQL Server Design Architecture SQL Server 2012 - Installation SQL Server 2014 - Installation Service Accounts and Authentication SQL Server Database Design & Planning SQL Server Table Design & Pages Table Compression Techniques Data Integrity Concepts and  Column Value Consistency PRIMARY KEY, UNIQUE and IDENTITY Constraints CHECK and DEFAULT Constraints SQL Server Views and Schemabinding of Views Updatable Vies adn ALTER consequences Schema depedancy and Encryptions JOINS, Sub Queries and Nested Queries Nested and Linking Tables Uses of Indexes and Performance Query Execution Plans and QO Components Stored Procedures and OUTPUT Parameters Dynamic SQL and Usage User Defined Functions, Table Return Values and Parameters Table Valued Parameters and Variables DDL Triggers and DML Triggers Cursors Usage and Limitations TEMP Tables and Table Variables T-SQL Transactions Concepts & Types Locks and Memory Concepts & Locking Hints Blocking Issues and Open Transactions New Features in SQL Server 2012 Duration: 6 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course. All Sessions are Completely Practical and Realtime. For free SQL Server Classroom Demo, please visit Schedules for PRACTICAL SQL 2012 & 2014 DBA Classroom TRAINING Contact us today for practical SQL 2012 & 2014 DBA Classroom training SequelGate Training Institute  Office: (+91) 040 65358866 Mobile: (+91) 0 9030040801  Sai Anu Avenue, Street Number 3, Patrika Nagar, HITEC City, Hyderabad - 81 (India).

SequelGate is one of the best training institutes for SQL Server Developer Training, SQL DBA Training and MSBI Training. We have been providing Classroom and Classroom Trainings and Corporate training. All our training sessions are COMPLETELY PRACTICAL. SQL SERVER & T-SQL COURSE DETAILS - FOR Classroom TRAINING: SQL Server Design Architecture SQL Server 2014- Installation SQL Server 2016- Installation Service Accounts and Authentication SQL Server Database Design & Planning SQL Server Table Design & Pages Table Compression Techniques Data Integrity Concepts and  Column Value Consistency PRIMARY KEY, UNIQUE and IDENTITY Constraints CHECK and DEFAULT Constraints SQL Server Views and Schemabinding of Views Updatable Vies adn ALTER consequences Schema depedancy and Encryptions JOINS, Sub Queries and Nested Queries Nested and Linking Tables Uses of Indexes and Performance Query Execution Plans and QO Components Stored Procedures and OUTPUT Parameters Dynamic SQL and Usage User Defined Functions, Table Return Values and Parameters Table Valued Parameters and Variables DDL Triggers and DML Triggers Cursors Usage and Limitations TEMP Tables and Table Variables T-SQL Transactions Concepts & Types Locks and Memory Concepts & Locking Hints Blocking Issues and Open Transactions New Features in SQL Server 2016 Duration: 4 weeks, every day for 1.5 hours and all sessions are completely practical. One Real-time Project included in the course. All Sessions are Completely Practical and Realtime. For free SQL Server Classroom Demo, please visit: & 2016 Classroom training SequelGate Training Institute  Office: (+91) 040 65358866 Mobile: (+91) 0 9030040801  Sai Anu Avenue, Street Number 3, Patrika Nagar, HITEC City, Hyderabad - 81 (India).

BluePrism RPA Delivery Process Road Map Templates Initial Process Analysis (IPA) Process Definition Document (PDD) Functional Requirement Questionnaire(FRQ) Solution Design Document (SDD) Operational Impact Document (OID) Process Design Instruction (PDI) Object Design Instruction (ODI BluePrism RPA Delivery Process Road Map Stages Process Management Define Design Develop Test Process Studio • Running a Process • Basic Skills • Process Validation • Decision Stage • Calculation Stage • Data Items • Review Expected Questions in the Interview Process Flow • Decisions • Circular Paths • Controlling Play • Set Next Stage • Breakpoints • Collections and Loops • Layers of Logic • Pages for Organization • Review Expected Questions in the Interview Inputs and Outputs • Input Parameters • Stepping and Pages • Data Item Visibility • Data Types • Output Parameters • Start-up Parameters • Control Room • Process Outputs • Review Expected Questions in the Interview Business Objects • Object Studio • Business Objects • Blue Prism Content • Action Stage • Inputs and Outputs • The Process Layer • Review Expected Questions in the Interview Object Studio • Creating a Business Object • Application Modeler • Spying Elements • Attributes • Attribute Selection • Launch • Wait • Timeouts • Terminate • Write • Press • Attach and Detach • Read • Actions • Action Inputs and Outputs • Data Items as Inputs • Review Expected Questions in the Interview Error Management • Exception Handling • Recover and Resume • Throwing Exceptions • Preserving the Current Exception • Exception Bubbling • Exception Blocks • Exception Handling in Practice • Review Expected Questions in the Interview Case Management • Queue Items Commercial in Confidence • Blue Prism Content • Work Queue Configuration • Defer • Attempts • Pause and Resume • Filters • Reports • Review Expected Questions in the Interview Additional Features • Safe Stop • Collection Actions • Choice Stage • Logging • Log Viewer • System Manager • Process/Business Object Grouping • Process and Object References • Export and Import • Release Manager – Packages and Releases Expected Questions in the Interview Consolidation Exercise • Order System Process • Consolidation Exercise Checklist • Submitting Your Completed Solution Expected Questions in the Interview Advanced Features • Undefined Collections • Data Item Initialization • Data Item Exposure • Casting • Code Stage • Run Mode • Initialize and Cleanup • Attribute Match Types • Dynamic Attributes • Active Accessibility • Application Manager Mode • Global Clicks and Keys • Blue Prism Content • Credentials • Environment Locking • Command Line • Resource PC Expected Questions in the Interview Surface Automation Expected Questions in the Interview

Softgen Infotech located in BTM Layout, Bangalore is a leading training institute providing real-time and placement oriented Informatica Training Courses in bangalore. Our Informatica training course includes basic to advanced levels. we have a team of certified trainers who are working professionals with hands on real time Informatica projects knowledge which will provide you an edge over other training institutes. Our Informatica training centre is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Informatica Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our team of experts at Softgen Infotech Training Institute, Bangalore have designed our Informatica Training course content and syllabus based on students requirements to achieve everyone's career goal. Our Informatica Training course fee is economical and tailor-made based on training requirement. We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Informatica Training in our centres located across bangalore. We also provide Online Training Classes for Informatica Training Course. Contact us today to schedule a free demo and complete course details on Informatica Training Course. What is Informatica Training ? Informatica Training Objectives Completeness- data missing or unusable?Confirmity- data stored in a non standard format?Consistency, Accuracy, Duplicates, Integrity.Leverage Informatica s expertise in metadata reporting planning and deployment.Understand the optimal Informatica architecture for your metadata needs.Preview custom metadata reports and dashboards based on your project objectives and Informaticas best practice.Metadata Reporting Enablement Strategy.Metadata reporting standards.Demonstration of Informaticas out-of-the-box and customized reports and dashboards based on your metadata requirements. Training Prerequesites Basics of data ware housingGood to have an idea about sql and pl/sqlGood to have a knowledge on Oracle database and its functionality Course Outline INTRODUCTION TO DATA WAREHOUSING Data warehouse concept Differences between Online Transaction Processing and data warehouse Types of Data Warehouse Data warehouse Architecture Difference between Data warehouse & Data mart Data Warehouse Approaches Data Warehouse Components Logical & physical Design* Operational data sources(ODS) OLAP and its types: ROLAP, MOLAP, HOLAP, DOLAP TOOL KNOWLEDGE Informatica PowerCenter Product Overview Power Center Domain Administration Console PowerCenter Repository PowerCenter Client Repository Service INTEGRATION SERVICE WEB SERVICES HUB MODELLING FOR DATA WAREHOUSE Defining Fact, Dimension, Attributes, Hierarchies, Grain and Granularity Grain and Granularity of Data Fact Table Dimension tables and types* Data Warehouse Schemas*: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema REPOSITORY MANAGER Adding a Repository to the Navigator Configuring a Domain Connection Connecting to a Repository Viewing Object Dependencies Validating Multiple Objects Comparing Repository Objects Truncating Workflow and Session Log Entries Managing User Connections and Locks Managing Users and Groups Working with Folders POWERCENTER DESIGNER Source Analyzer Working with Relational Sources Working with Flat Files Target Designer Mappings Transformations Working with Ports Using Default Values for Ports User-Defined Default Values Tracing Levels Basic First Mapping Expression Transformation Filter Transformation Router Transformation Union Transformation Sorter Transformation Rank Transformation Aggregator Transformation Joiner Transformation Source Qualifier Lookup Transformation Lookup Types Lookup Transformation Components Connected Lookup Transformation Unconnected Lookup Transformation Lookup Cache Types: Dynamic, Static, Persistent, Shared Update Strategy Dynamic Lookup Cache Use Lookup Query Lookup and Update Strategy Examples Stored Procedure Transformation Connected Stored Procedure Transformation Unconnected Stored Procedure Transformation Sequence Generator Transformation Mapplets: Mapplet Input and Mapplet Output Transformations Normalizer Transformation XML Sources Import and usage Mapping Wizards Getting Started Slowly Changing Dimensions Mapping Parameters and Variables Parameter File Indirect Flat File Loading WORKFLOW MANAGER Working with Workflows Assigning an Integration Service Working with Links Workflow Variables Session Parameters Working with Tasks Session Task Email Task Command Task Working with Event Tasks Timer Task Decision Task Control Task Assignment Task Schedulers Worklets Partitioning Partitioning Attributes Partitioning Types Session Properties Workflow Properties ADVANCED TOPICS Push down Optimization Technique Unit Testing Version Control Real time Scenario on Dynamic Lookup Cache Real time Scenario on Unconnected Stored procedure and lookup transformation Constraint Based Load Ordering Target Load Plan Order. Informatica Training Course Details Duration:45 Hours Version:latest Version Regular: 1 Hour per day Fast Track: 2 - 3 Hours per day: 10 days Weekdays:Monday - Friday Weekend:Saturday and Sunday Online Training:Available Class Room Training: Available Course Fee: Talk to our Customer Support Mode of Payment:Talk to our Customer Support

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