Informatica 9.x., Oracle 11G(Sql/plsql) -Online 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[b]Oracle 11G (SQL & PLSQL).[/b][/font][/color]


[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]

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



[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]

[color=#282828][font=helvetica, arial, sans-serif][center][b][i][u]INFORMATICA 9.X COURSE CONTENT[/u][/i][/b][/center][/font][/color]


[b]DATA WAREHOUSING CONCEPTS:[/b]

[list]
[*][b]Definitions[/b]
[*][b]Characteristics of Data Warehouse[/b].
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Time Variant Database.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Non Volatile Database.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Subject Oriented Database.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Integrated Database.[/font][/color][/indent][list]
[*][b]Data warehouse Architecture.[/b]
[*][b]Data Acquisition Concept[/b].
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Data Extraction.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Data Transformation.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Data Cleansing.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Data Scrubbing.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]3. Data Merging.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Data Aggregation[b].[/b][/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Data Loading.[/font][/color][/indent][list]
[*]Rules To Maintain Historical Data.
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Initial Extraction.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]5. [/b]Delta Extraction.[/font][/color][/indent][list]
[*]SCD-1.
[*]SCD-2
[*]SCD-3.
[*]ER-Modeling.
[*]Dimensional Modeling.
[*]Data Warehousing Schemas:
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Star Schema.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Snow Flake Star Schema.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Integrated Star Schema.[/font][/color][/indent][list]
[*]Facts.
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Additive Fact.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Semi Additive Fact.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Non Additive Fact.[/font][/color][/indent][list]
[*]Data Marts:
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Top to Bottom Approach.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Bottom to Top Approach.[/font][/color][/indent][list]
[*]Difference between OLTP & OLAP.
[/list]



[color=#282828][font=helvetica, arial, sans-serif][center][b]INFORMATICA 9.X TOOL[/b][/center][/font][/color][list]
[*][b]Informatica Software Installation.[/b]
[/list][list]
[*][b]Informatica Architecture.[/b]
[/list][list]
[*][b]Informatica Power Center Repository Manager.[/b]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]55]3.1.Folder Management.[/font][/color][/indent][list]
[*][b]Informatica Power Center Designer.[/b]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Source Analyzer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Target Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]3. Transformation Developer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]4. Mapplet Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]5. Mapping Designer.[/font][/color][/indent][list]
[*][b]Relational Tables.[/b]
[*][b]Flat Files.[/b]
[*][b]XML Files.[/b]
[*][b]All Transformations:[/b]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Source Qualifier.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Expression[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]3. Aggregator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]4. Filter.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]5. Lookup.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]6. Update Strategy.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]7. Sequence Generator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]8. Stored Procedure.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]9. Joiner.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]10. Rank.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]11. Normalizer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]12. Router.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]13. Sorter.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]14. Transaction Control Transformation.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]15. Union.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]16. XML Parser.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]17. XML Generator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]18. XML Source Qualifier.[/font][/color][/indent][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]
[/list][list]
[*][b]Informatica Power Center Workflow Manager:[/b]
[/list][list]
[*][b]Tools:[/b]
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Task Developer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Work let Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]3. Workflow Designer.[/font][/color][/indent][list]
[*][b]All Tasks[/b].
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Session.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Command.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]3. Decision.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]4. Event Wait.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]5. Event Raise.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]6. Email.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]7. Timer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]8. Assignment.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]9. Work let.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]10. Link.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]11. Control.[/font][/color][/indent][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]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Partitioning Concept.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Bottle Necks.[/font][/color][/indent]
[list]
[*][b]Informatica Power Center Workflow Monitor[/b].
[/list]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]1. Session Run Properties.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1]2. Session Log.[/font][/color][/indent]




















[color=#282828][font=helvetica, arial, sans-serif][center][b][u]Oracle 11G (SQL & PLSQL)[/u][/b][/center][/font][/color]

[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]