Informatica 9.x, Oracle 11G( Sql & Plsql ) - Training & Job Support

[InfPrasad]

[color=#282828][font=helvetica, arial, sans-serif]Hi All,[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]We are providing [/font][/color][b]Online Training[/b][color=#282828][font=helvetica, arial, sans-serif] and [/font][/color][b]Job Support[/b][color=#282828][font=helvetica, arial, sans-serif] on [/font][/color][b]Informatica Power Center 9.x[/b][color=#282828][font=helvetica, arial, sans-serif]. and [/font][/color][b]Oracle 11G (SQL & PLSQL).[/b]


[color=#282828][font=helvetica, arial, sans-serif]If anybody interested to take Online Training and Job Support please contact me soon.[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]You can reach me at --->[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]E-Mail:- [/font][/color][b][email protected][/b]

[color=#282828][font=helvetica, arial, sans-serif]Voice:- [/font][/color][b]+91 929 122 7040, +91 99494 89441.[/b]

[url="http://www.andhrafriends.com/topic/334254-informatica-oracle-sql-server-dot-net-msbi-training-support/"][b]http://www.andhrafri...aining-support/[/b][/url]



[url="http://www.indianclicks.com/DurgaPrasad/DurgaPrasad.html"]http://www.indiancli...urgaPrasad.html[/url]










[color=#282828][font=helvetica, arial, sans-serif]Course Content:-[/font][/color]



[b][i]INFORMATICA 9.X COURSE CONTENT[/i][/b]



[b]DATA WAREHOUSING CONCEPTS:[/b][list]
[*][b]Definitions[/b]
[*][b]Characteristics of Data Warehouse[/b].
[list]
[*]Time Variant Database.
[*]Non Volatile Database.
[*]Subject Oriented Database.
[*]Integrated Database.
[/list][*][b]Data warehouse Architecture.[/b]
[*][b]Data Acquisition Concept[/b].
[list]
[*]Data Extraction.
[*]Data Transformation.
[/list][*]Data Cleansing.
[*]Data Scrubbing.
[*]Data Merging.
[*]Data Aggregation[b].[/b]
[list]
[*]Data Loading.
[/list][*]Rules To Maintain Historical Data.
[*]Initial Extraction.
[*]Delta Extraction.
[*]SCD-1.
[*]SCD-2
[*]SCD-3.
[*]ER-Modeling.
[*]Dimensional Modeling.
[*]Data Warehousing Schemas:
[list]
[*]Star Schema.
[*]Snow Flake Star Schema.
[*]Integrated Star Schema.
[/list][*]Facts.
[list]
[*]Additive Fact.
[*]Semi Additive Fact.
[*]Non Additive Fact.
[/list][*]Data Marts:
[list]
[*]Top to Bottom Approach.
[*]Bottom to Top Approach.
[/list][*]Difference between OLTP & OLAP.
[*][b]INFORMATICA 9.X TOOL[/b]
[*][b]Informatica Software Installation.[/b]
[*][b]Informatica Architecture.[/b]
[*][b]Informatica Power Center Repository Manager.[/b]
[*]55]3.1.Folder Management.
[*][b]Informatica Power Center Designer.[/b]
[list]
[*]Source Analyzer.
[*]Target Designer.
[*]Transformation Developer.
[*]Mapplet Designer.
[*]Mapping Designer.
[/list][*][b]Relational Tables.[/b]
[*][b]Flat Files.[/b]
[*][b]XML Files.[/b]
[*][b]All Transformations:[/b]
[list]
[*]Source Qualifier.
[*]Expression
[*]Aggregator.
[*]Filter.
[*]Lookup.
[*]Update Strategy.
[*]Sequence Generator.
[*]Stored Procedure.
[*]Joiner.
[*]Rank.
[*]Normalizer.
[*]Router.
[*]Sorter.
[*]Transaction Control Transformation.
[*]Union.
[*]XML Parser.
[*]XML Generator.
[*]XML Source Qualifier.
[/list][*][b]Mapping Parameters & Variables.[/b]
[*][b]Look Up Cache.[/b]
[*][b]Target Load Plan.[/b]
[*][b]Wizards.[/b]
[*][b]Debugging Concept.[/b]
[*][b]Version Controlling.[/b]
[*][b]Informatica Power Center Workflow Manager:[/b]
[*][b]Tools:[/b]
[list]
[*]Task Developer.
[*]Work let Designer.
[*]Workflow Designer.
[/list][*][b]All Tasks[/b].
[list]
[*]Session.
[*]Command.
[*]Decision.
[*]Event Wait.
[*]Event Raise.
[*]Email.
[*]Timer.
[*]Assignment.
[*]Work let.
[*]Link.
[*]Control.
[/list][*][b]Workflow Properties.[/b]
[*][b]Scheduler.[/b]
[*][b]Variables.[/b]
[*][b]Parameter Files.[/b]
[*][b]Events.[/b]
[*][b]Session Properties.[/b]
[*][b]Session Config Objects.[/b]
[*][b]Session Mapping Connections.[/b]
[*][b]Parallel Data Loading.[/b]
[*][b]Sequential Data Loading.[/b]
[*][b]Workflow Dependencies.[/b]
[*][b]Push Down Optimization.[/b]
[*][b]Incremental Aggregation.[/b]
[*][b]Performance Tuning[/b].
[list]
[*]Partitioning Concept.
[*]Bottle Necks.
[/list][*][b]Informatica Power Center Workflow Monitor[/b].
[list]
[*]Session Run Properties.
[*]Session Log.
[/list]
[/list]




















[b]Oracle 11G (SQL & PLSQL)[/b]


[b]Course Topics [/b]

[b]PART I: Structured Query Language – SQL [/b]

[b]Introduction to Relational databases [/b]
[color=#282828][font=helvetica, arial, sans-serif]1.1. Relational Database Concepts[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]1.2. Entity Relationship Diagrams[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]1.3. Data Models[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]1.4. Role of SQL in RDBMS[/font][/color]
[b]Simple SQL statements [/b]
[color=#282828][font=helvetica, arial, sans-serif]2.1. Basic SQL construct[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.2. Column naming conventions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.3. Importance of NULL[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.4. Concatenation operator[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.5. Arithmetic operators and expressions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.6. Operator precedence and Parenthesis[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]2.7. Character strings[/font][/color]
[b]Tables and Table Joins [/b]
[color=#282828][font=helvetica, arial, sans-serif]3.1. Need for joins[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]3.2. Cartesian products[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]3.3. Column aliases[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]3.4. Types of joins[/font][/color]
[b]Filtering and Sorting data [/b]
[color=#282828][font=helvetica, arial, sans-serif]4.1. Limiting rows retrieved[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4.2. Using LIKE for pattern matching[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4.3. Using logical operators AND, OR & NOT[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4.4. Using BETWEEN & IN operators[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4.5. Sorting data using ORDER BY clause[/font][/color]
[b]Oracle SQL Functions part 1 [/b]
[color=#282828][font=helvetica, arial, sans-serif]5.1. SQL Functions overview[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.2. What are single row functions?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.3. Using Character functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.4. Using Number functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.5. Using Date functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.6. Using CASE and DECODE[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.7. Nested functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]5.8. Data type conversion functions[/font][/color]
[b]Oracle SQL Functions part 2 [/b]
[color=#282828][font=helvetica, arial, sans-serif]6.1. What are multi row functions?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]6.2. Various multi row functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]6.3. Grouping data with GROUP BY clause[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]6.4. Using the HAVING clause[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]6.5. Sorting GROUP BY data[/font][/color]


[b]SQLPlus – queries, formatting and reports [/b]
[color=#282828][font=helvetica, arial, sans-serif]7.1. Logging into SQLPlus[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7.2. Writing queries in SQLPlus[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7.3. Substitution variables using ‘&’ and ‘&&’[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7.4. Using DEFINE & UNDEFINE commands[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7.5. Using SET command[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7.6. Setting COLUMN format[/font][/color]
[b]Nested SQL queries [/b]
[color=#282828][font=helvetica, arial, sans-serif]8.1. Need for nested queries[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]8.2. Types of nested queries[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]8.3. USING EXISTS, ALL & ANY operators[/font][/color]
[b]Database Definition Language – DDL [/b]
[color=#282828][font=helvetica, arial, sans-serif]9.1. Creating tables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.2. Modifying tables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.3. Dropping tables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.4. Partitioned tables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.5. Creating Range and Hash partitions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.6. Creating and replacing views[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.7. Creating and dropping synonyms[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]9.8. Creating modifying and dropping sequences[/font][/color]
[b]Database Manipulation Language – DML [/b]
[color=#282828][font=helvetica, arial, sans-serif]10.1. What is data manipulation in a database[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10.2. Need for data manipulation[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10.3. INSERT statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10.4. UPDATE statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10.5. DELETE statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10.6. MERGE statement[/font][/color]
[b]Database Control Language – DCL [/b]
[color=#282828][font=helvetica, arial, sans-serif]11.1. Definition of Transaction[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]11.2. COMMIT & ROLLBACK statements[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]11.3. Using the SAVEPOINT statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]11.4. Automatic COMMIT[/font][/color]
[b]Indexes and Index types [/b]
[color=#282828][font=helvetica, arial, sans-serif]12.1. What are Indexes?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12.2. Need for Indexes[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12.3. Simple Indexes[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12.4. Complex Indexes[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12.5. Function based Indexes[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12.6. Analyzing and rebuilding Indexes[/font][/color]
[b]Privileges, Users, Roles & Grants [/b]
[color=#282828][font=helvetica, arial, sans-serif]13.1. System privileges[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]13.2. Object privileges[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]13.3. Creating and managing users[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]13.4. Creating and assigning roles[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]13.5. Granting Roles[/font][/color]

[b][i]Last but not the least… [/i][/b]
[color=#282828][font=helvetica, arial, sans-serif]14.1. Regular expressions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]14.2. Set operators in SQL[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]14.3. RANK() function[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]14.4. ROWID & ROWNUM[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]14.5. Analytic functions[/font][/color]


[b]PART II: Procedural Language/ Structured Query Language – PLSQL [/b]

[b]Introduction to PLSQL [/b]
[color=#282828][font=helvetica, arial, sans-serif]15.1. Anonymous PLSQL block[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.2. Variables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.3. Data types[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.4. Bind variables[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.5. PLSQL operators[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.6. Nested blocks[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.7. Implicit data conversion[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.8. SELECT … INTO statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15.9. DBMS_OUTPUT.PUT_LINE[/font][/color]
[b]Control structures [/b]
[color=#282828][font=helvetica, arial, sans-serif]16.1. IF-THEN-ELSE statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]16.2. CASE statement[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]16.3. Basic and FOR Loops[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]16.4. WHILE Loop[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]16.5. Nested loops[/font][/color]
[b]Composite data types [/b]
[color=#282828][font=helvetica, arial, sans-serif]17.1. Using %ROWTYPE[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]17.2. PLSQL Records[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]17.3. PLSQL Table of Records[/font][/color]
[b]Creating Functions [/b]
[color=#282828][font=helvetica, arial, sans-serif]18.1. Syntax of CREATE FUNCTION[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]18.2. Benefits of user defined functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]18.3. Executing user defined functions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]18.4. Restrictions on function calls[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]18.5. Dropping functions[/font][/color]
[b]Exceptions and Exception handling [/b]
[color=#282828][font=helvetica, arial, sans-serif]19.1. What are Exceptions?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.2. Need for handling exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.3. Predefined exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.4. User defined exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.5. Non predefined exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.6. Raising Exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.7. Trapping Exceptions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]19.8. Exception propagation in nested calls[/font][/color]
[b]Creating Procedures [/b]
[color=#282828][font=helvetica, arial, sans-serif]20.1. What are Procedures?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.2. Need for Procedures[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.3. Syntax of CREATE PROCEDURE[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.4. Parameter dispositions[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.5. Parameter passing methods[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.6. Executing procedures[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]20.7. Exceptions in procedures[/font][/color]


[b]Explicit Cursors and REF Cursors. [/b]
[color=#282828][font=helvetica, arial, sans-serif]21.1. What is a cursor?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21.2. Implicit and explicit cursors[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21.3. Creating cursors[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21.4. Using cursors in procedures[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21.5. OPEN..FETCH CLOSE construct[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21.6. FOR UPDATE cursors[/font][/color]
[b]Creating Packages [/b]
[color=#282828][font=helvetica, arial, sans-serif]22.1. What are packages?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.2. Need for packages[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.3. Package Specification[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.4. Package Body[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.5. Private and Public components[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.6. Calling package functions, procedures[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]22.7. Referencing package constants and variables[/font][/color]
[b]Creating Triggers [/b]
[color=#282828][font=helvetica, arial, sans-serif]23.1. What are triggers?[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.2. Use cases of triggers[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.3. Database triggers[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.4. DML Table triggers[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.5. INSTEAD OF triggers[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.6. Create Trigger syntax[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.7. Enabling & Disabling triggers[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23.8. Row vs. Statement triggers [/font][/color]