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




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



[b]DATA WAREHOUSING CONCEPTS:[/b]


[color=#282828][font=helvetica, arial, sans-serif]1) [/font][/color][b]Definitions[/b]
[color=#282828][font=helvetica, arial, sans-serif]2) [/font][/color][b]Characteristics of Data Warehouse[/b][color=#282828][font=helvetica, arial, sans-serif].[/font][/color]

[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]
[color=#282828][font=helvetica, arial, sans-serif]3) [/font][/color][b]Data warehouse Architecture.[/b]
[color=#282828][font=helvetica, arial, sans-serif]4) [/font][/color][b]Data Acquisition Concept[/b][color=#282828][font=helvetica, arial, sans-serif].[/font][/color]

[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]5) Data Cleansing.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]6) Data Scrubbing.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]7) Data Merging.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]8) Data Aggregation[/font][/color][b].[/b]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Data Loading.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]9) Rules To Maintain Historical Data.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]10) Initial Extraction.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]11) Delta Extraction.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]12) SCD-1.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]13) SCD-2[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]14) SCD-3.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]15) ER-Modeling.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]16) Dimensional Modeling.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]17) Data Warehousing Schemas:[/font][/color]

[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]
[color=#282828][font=helvetica, arial, sans-serif]18) Facts.[/font][/color]

[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]
[color=#282828][font=helvetica, arial, sans-serif]19) Data Marts:[/font][/color]

[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]
[color=#282828][font=helvetica, arial, sans-serif]20) Difference between OLTP & OLAP.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]21) [/font][/color]



[color=#282828][font=helvetica, arial, sans-serif][center]22) [b]INFORMATICA 9.X TOOL[/b][/center][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]23) [/font][/color][b]Informatica Software Installation.[/b]
[color=#282828][font=helvetica, arial, sans-serif]24) [/font][/color][b]Informatica Architecture.[/b]
[color=#282828][font=helvetica, arial, sans-serif]25) [/font][/color][b]Informatica Power Center Repository Manager.[/b]
[color=#282828][font=helvetica, arial, sans-serif]26) 55]3.1.Folder Management.[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]27) [/font][/color][b]Informatica Power Center Designer.[/b]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Source Analyzer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Target Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Transformation Developer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Mapplet Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]5. [/b]Mapping Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]28) [/font][/color][b]Relational Tables.[/b]
[color=#282828][font=helvetica, arial, sans-serif]29) [/font][/color][b]Flat Files.[/b]
[color=#282828][font=helvetica, arial, sans-serif]30) [/font][/color][b]XML Files.[/b]
[color=#282828][font=helvetica, arial, sans-serif]31) [/font][/color][b]All Transformations:[/b]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Source Qualifier.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Expression[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Aggregator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Filter.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]5. [/b]Lookup.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]6. [/b]Update Strategy.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]7. [/b]Sequence Generator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]8. [/b]Stored Procedure.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]9. [/b]Joiner.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]10. [/b]Rank.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]11. [/b]Normalizer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]12. [/b]Router.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]13. [/b]Sorter.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]14. [/b]Transaction Control Transformation.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]15. [/b]Union.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]16. [/b]XML Parser.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]17. [/b]XML Generator.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]18. [/b]XML Source Qualifier.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]32) [/font][/color][b]Mapping Parameters & Variables.[/b]
[color=#282828][font=helvetica, arial, sans-serif]33) [/font][/color][b]Look Up Cache.[/b]
[color=#282828][font=helvetica, arial, sans-serif]34) [/font][/color][b]Target Load Plan.[/b]
[color=#282828][font=helvetica, arial, sans-serif]35) [/font][/color][b]Wizards.[/b]
[color=#282828][font=helvetica, arial, sans-serif]36) [/font][/color][b]Debugging Concept.[/b]
[color=#282828][font=helvetica, arial, sans-serif]37) [/font][/color][b]Version Controlling.[/b]
[color=#282828][font=helvetica, arial, sans-serif]38) [/font][/color][b]Informatica Power Center Workflow Manager:[/b]
[color=#282828][font=helvetica, arial, sans-serif]39) [/font][/color][b]Tools:[/b]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Task Developer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Work let Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Workflow Designer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]40) [/font][/color][b]All Tasks[/b][color=#282828][font=helvetica, arial, sans-serif].[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Session.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Command.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]3. [/b]Decision.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]4. [/b]Event Wait.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]5. [/b]Event Raise.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]6. [/b]Email.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]7. [/b]Timer.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]8. [/b]Assignment.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]9. [/b]Work let.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]10. [/b]Link.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]11. [/b]Control.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]41) [/font][/color][b]Workflow Properties.[/b]
[color=#282828][font=helvetica, arial, sans-serif]42) [/font][/color][b]Scheduler.[/b]
[color=#282828][font=helvetica, arial, sans-serif]43) [/font][/color][b]Variables.[/b]
[color=#282828][font=helvetica, arial, sans-serif]44) [/font][/color][b]Parameter Files.[/b]
[color=#282828][font=helvetica, arial, sans-serif]45) [/font][/color][b]Events.[/b]
[color=#282828][font=helvetica, arial, sans-serif]46) [/font][/color][b]Session Properties.[/b]
[color=#282828][font=helvetica, arial, sans-serif]47) [/font][/color][b]Session Config Objects.[/b]
[color=#282828][font=helvetica, arial, sans-serif]48) [/font][/color][b]Session Mapping Connections.[/b]
[color=#282828][font=helvetica, arial, sans-serif]49) [/font][/color][b]Parallel Data Loading.[/b]
[color=#282828][font=helvetica, arial, sans-serif]50) [/font][/color][b]Sequential Data Loading.[/b]
[color=#282828][font=helvetica, arial, sans-serif]51) [/font][/color][b]Workflow Dependencies.[/b]
[color=#282828][font=helvetica, arial, sans-serif]52) [/font][/color][b]Push Down Optimization.[/b]
[color=#282828][font=helvetica, arial, sans-serif]53) [/font][/color][b]Incremental Aggregation.[/b]
[color=#282828][font=helvetica, arial, sans-serif]54) [/font][/color][b]Performance Tuning[/b][color=#282828][font=helvetica, arial, sans-serif].[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Partitioning Concept.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Bottle Necks.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif]55) [/font][/color][b]Informatica Power Center Workflow Monitor[/b][color=#282828][font=helvetica, arial, sans-serif].[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]1. [/b]Session Run Properties.[/font][/color][/indent]
[color=#282828][font=helvetica, arial, sans-serif][indent=1][b]2. [/b]Session Log.[/font][/color][/indent]





















[color=#282828][font=helvetica, arial, sans-serif][center][b]Oracle 11G (SQL & PLSQL)[/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]