[go: up one dir, main page]
Scribd
Upload
37 views4 pages

Developer Learning

The document outlines an Oracle developer learning plan that includes: - SQL and PL/SQL concepts covered in 1-5 days, including joins, subqueries, unions, procedures, functions and aggregate functions. - Understanding the first module schema (purchasing and inventory) over 1-5 days, which involves tables, business flows, queries and item/inventory organization. - Query optimization techniques covered over 2 days such as avoiding distinct, using WITH clauses, EXISTS instead of IN and UNION ALL instead of UNION. - Report development over 7 days using Oracle Report Builder and Microsoft Word/BI Publisher, including connecting reports to databases, adding queries, parameters and repeating frames.

Uploaded by

Amir Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
37 views4 pages

Developer Learning

The document outlines an Oracle developer learning plan that includes: - SQL and PL/SQL concepts covered in 1-5 days, including joins, subqueries, unions, procedures, functions and aggregate functions. - Understanding the first module schema (purchasing and inventory) over 1-5 days, which involves tables, business flows, queries and item/inventory organization. - Query optimization techniques covered over 2 days such as avoiding distinct, using WITH clauses, EXISTS instead of IN and UNION ALL instead of UNION. - Report development over 7 days using Oracle Report Builder and Microsoft Word/BI Publisher, including connecting reports to databases, adding queries, parameters and repeating frames.

Uploaded by

Amir Ali
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Oracle Developer Learning

 SQL/PLSQL Concepts: 1 to 5 days.


 Joins.
 Sub-Query.
 Unions.
 Procedure & Functions.
 Aggregate Functions.

 Oracle Schema (1st Module): (Purchasing +Inventory) (1-5 Days)


 Understanding Schema.
 Understanding of Business Flow.
 Table joins.
 PR, PO relations.
 GRN Process and its relations.
 Item codes understanding.
 Inventory Organization understanding.
 Sub inventory and locator understanding and their relations.
 Item codes relations.
 Query Writing.

 Query Optimization: 2 days.


 Avoid Distinct.
 Use of with clause.
 Use Exist instead of In.
 Use of Union All instead of Union
 Avoid Using OR in joins.
 Use exact joins.
 Use Case & Decode.
 Report Development: 7 days.
 PDF Report.
 Excel Report.
 Matrix Report.
 Report Triggers.
 Report Parameters.
1) Oracle Report Builder
 How to connect report builder with database.
 How to add query in report builder.
 Data model.
 Formula Column.
 Summary Column (Inside and outside data model).
 Paper layout.
 Parameters (Bind, Lexical on Query Level as well as on Report Level).
 Repeating Frame.
 Main Frame.
 RDF.
2) MS Word & Bi Publisher
 RTF How to use Bi Publisher to design RTF report in MS Word.
 Application configuration (Report): 1 day.
 How to register report in application.
 Define.
 Executable.
 Responsibility.
 Request Group.
 How to Define Parameters.
 How to add RDF and RTF template.
 Creating and understanding of value sets.
 Multiple reports (User Issue Handling) :
Start from 21 days of joining.
 Handle user issues and enhanced its query writing techniques onward.

After 30 days.

 Other Module Schemas :


 Payables
 Receivables 30 days each
 Fixed Asset
 Work in Process

and at least one report for each module.

 Personalization: 10 days.
 Triggers Understanding.
 Actions understanding.
 Conditions.
 Forms & Customized Schema creating: 30 days.
 Formula Column.
 Summary Column.
 Triggers Understanding.
 Forms Schema creations.
 Normalization.
 Keys understandings.
 Table Links.
 Parent Child Relation.
 Table Synonyms.
 Grants,
 Triggers/ Validation.
 Forms Windows.
 Form LOV’s.
 Program Units.
 Form Blocks.
 Canvas Types.
 Application configuration (Forms): 1 day.
 Application developer responsibility understanding.
 Forms name creating.
 Functions creating.
 Responsibility selection.
 Menu Entry.

 Workflow creating: 30 days.


 Workflow builder understanding.
 Processes.
 Functions.
 Messages.
 Attributes.
 Notifications/events.
 Workflow Layout.
 Workflow configuration.
 Workflow monitoring in system administration.
 Workflow Monitoring Issues.
DBA Learning

 SQL/PLSQL Concepts: 5 days.


 Understanding of database queries, design and theories:
15 days.
 Understanding of server installation / Maintenance:
2 days.
 OS understanding & software installation: 10 days.
 Patch applying: 5 days
 Cloning of database: 7 days
 Database Scripting: 2 days
 Daily performance insurance: 2 days
 Extracting and /or loading data:
3 days (control file, Web Adi).
 API, Configuration and interface management

You might also like