Jump to content

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


InfPrasad

Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...