Obiee11G,oracle11G,oracle Dba Online Training At Vkks Technologies

[vkks]

[center][b][u]VKKS TECHNOLOGIES ONLINE TRAINING[/u][/b].[/center]
[b]OBIEE 11G/10G[/b]


[b]Course Duration : 30 Hours[/b]





[indent=1][b]Course Outline: RPD Development[/b][/indent]
[indent=1][b]Repository Basics[/b][/indent]
[indent=1]• Oracle BI architecture components
• Repository structure, features, and functions
• Using the OracleBI Administration Tool
• Creating a repository
• Loading a repository into Oracle BI Server memory[/indent]
[indent=1][b]Building the Physical Layer of a Repository[/b][/indent]
[indent=1]• Importing data sources
• Setting up connection pool properties
• Defining keys and joins
• Examining physical layer object properties
• Creating alias and select tables[/indent]
[indent=1][b]Building the Business Model and Mapping Layer of a Repository[/b][/indent]
[indent=1]• Building a business model
• Building logical tables, columns, and sources
• Defining logical joins
• Building measures
• Examining business model object properties[/indent]
[indent=1][b]Building the Presentation Layer of a Repository[/b][/indent]
[indent=1]• Exploring Presentation layer objects
• Creating Presentation layer objects
• Modifying Presentation layer objects
• Examining Presentation layer object properties[/indent]
[indent=1][b]Testing and Validating a Repository[/b][/indent]
[indent=1]• Checking repository consistency
• Turning on logging
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
• Inspecting the query log[/indent]
[indent=1][b]Adding Multiple Logical Table Sources[/b][/indent]
[indent=1]• Adding multiple logical table sources to a logical table
• Specifying logical content[/indent]
[indent=1][b]Adding Calculations to a Fact Table[/b][/indent]
[indent=1]• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard[/indent]
[indent=1][b]Creating Dimension Hierarchies and Level-Based Measures[/b][/indent]
[indent=1]• Creating dimension hierarchies
• Creating level-based measures
• Creating share measures
• Creating rank measures[/indent]
[indent=1][b]Using Aggregates[/b][/indent]
[indent=1]• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
• Using the Aggregate Persistence Wizard[/indent]
[indent=1][b]Using Partitions and Fragments[/b][/indent]
[indent=1]• Purpose for segmenting data into partitions and fragments
• Partition types
• Modeling partitions in an Oracle BI repository[/indent]
[indent=1][b]Using Repository Variables[/b][/indent]
[indent=1]• Session variables
• Repository variables
• Initialization blocks
• Using the Variable Manager
• Using dynamic repository variables as filters[/indent]
[indent=1][b]Modeling Time Series Data[/b][/indent]
[indent=1]• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data[/indent]
[indent=1][b]Security[/b][/indent]
[indent=1]• Creating users and groups
• Setting permissions for users and groups
• Authenticating using a external database
• Authenticating using database authentication
• Setting query limits and timing restrictions
• Setting filters to personalize information[/indent]
[indent=1][b]Cache Management[/b][/indent]
[indent=1]• Restricting tables as non-cacheable
• Using Cache Manager
• Inspecting cache reports
• Purging cache entries
• Modifying cache parameters and options
• Seeding the cache[/indent]
[indent=1][b]Setting Up and Administering Usage Tracking[/b][/indent]
[indent=1]• Tracking and storing Oracle BI Server usage at the detailed query level
• Using usage tracking statistics to optimize query performance and aggregation strategies
• Analyzing usage results using Oracle BI Answers and other reporting tools[/indent]
[indent=1][b]Multi-user Development[/b][/indent]
[indent=1]• Setting up a multi-user development environment
• Developing a repository using multiple developers
• Tracking development project history[/indent]
[indent=1][b]Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories[/b][/indent]
[indent=1]• Employing techniques to optimize Oracle BI query performance
• Applying Oracle BI repository design principles[/indent]
[indent=1][b]Course Topics: ANSWERS & DASHBOARDS[/b][/indent]
[indent=1][b]Working with Oracle Business Intelligence Answers[/b][/indent]
[indent=1]• Introduction to OracleBI Answers
• Working with requests in OracleBI Answers[/indent]
[indent=1][b]Filtering Requests in Oracle Business Intelligence Answers[/b][/indent]
[indent=1]• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters[/indent]
[indent=1][b]Views and Charts in Requests[/b][/indent]
[indent=1]• Introduction to Answers views and charts
• Creating a column selector view[/indent]
[indent=1][b]Showing Results with Pivot tables[/b][/indent]
[indent=1]• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building formulas[/indent]
[indent=1][b]Creating Interactive Dashboards[/b][/indent]
[indent=1]• Introduction to Dashboards and pages
• Dashboard Editor UI elements
• Composing Dashboard elements[/indent]
[indent=1][b]Configuring Interactive Dashboards[/b][/indent]
[indent=1]• Types of Dashboard content
• Embedding content in Dashboards[/indent]
[indent=1][b]Customizing the Oracle Business Intelligence User Interface[/b][/indent]
[indent=1]• Modifying cascading style sheets
• Modifying XML message files[/indent]
[indent=1][b]Configuring Guided Navigation Links[/b][/indent]
[indent=1]• Building guided navigation with static links
• Building guided navigation with conditional links and sections[/indent]
[indent=1][b]Administering Oracle Business Intelligence Presentation Catalog[/b][/indent]
[indent=1]• Maintaining the OracleBI Presentation Catalog
• Maintaining security
• Understanding security inheritance[/indent]
[indent=1][b]Using Oracle Business Intelligence Delivers[/b][/indent]
[indent=1]• Building alerts
• Building iBots
• Introduction to OracleBI Scheduler[/indent]

[b] Oracle 11g (SQL,PL/SQL) [/b]




[b]Course Duration : 30 Hours[/b]
[b]SQL[/b]



[indent=1]· [b]The Oracle database environment [/b]
Reviewing basic architecture concepts, Oracle 10g Architecture,Main features of 9i and 10g[/indent]

[indent=1]· [b]Basic SELECT Statement[/b]
Writing the statement in sqlplus, Running the SELECT statement[/indent]

[indent=1]· [b]Ordering the output[/b]
Single Column, Descending order, Multiple column sort[/indent]

[indent=1]· [b]Conditional retrieval of data [/b]
Working with complex conditions, AND OR NOT ,,,, LIKE BETWEEN[/indent]

[indent=1]· [b]Pseudo columns and functions[/b]
Pseudo Columns, Rownum, Sysdate, User & UID, the Dual Table[/indent]

[indent=1]· Working with character functions
UPPER, LOWER, INITCAP, RPAD(), TRIM(), SUBSTR(), INSTR(), TRANSLATE(), REPLACE(), GREATEST(), LEAST(),[/indent]

[indent=1]· Working with date functions
TO_CHAR(), TO_DATE(), MONTHS_BETWEEN(), ADD_MONTHS(), LAST_DAY(), NEXT_DAY()[/indent]

[indent=1]· [b]Using non-character function[/b]
ROUND(), TRUNC(), SIGN(), Working with multiple tables,
Different type of Joins, Writing Outer Joins[/indent]

[indent=1]· [b]Using the SET operators[/b]
Union, Intersect, Minus[/indent]

[indent=1]· [b]Aggregating data using group functions[/b]
GROUP BY, HAVING[/indent]

[indent=1]· [b]Creating Subqueries[/b]
Single Row subqueries, Multiple row Subqueries [/indent]

[indent=1]· [b]Enhancing groups function [/b]
ROLLUP, CUBE[/indent]

[indent=1]· [b]Transaction Control Language[/b]
Rollback, Commit, Savepoint[/indent]

[indent=1]· [b]Processing hierarchies [/b]
Creating the Tree structure, LEVEL, CONNECT BY[/indent]

[indent=1]· [b]Data Manipulation Language[/b]
INSERT, UPDATE, DELETE[/indent]

[indent=1]· [b]Data Definition Language[/b]
CREATE, TRUNCATE, ALTER, DROP, RENAME, DESCRIBE[/indent]

[indent=1]· [b]Using Declarative Constraints[/b]
Not Null Constraint, Check Constraint, Unique Constraint, Primary Key Constraint, References Constraint, On Delete Cascade, On Delete Set Null[/indent]

[indent=1]· [b]Other Database Objects[/b]
Views, Sequences, Synonyms, Indexes
USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS[/indent]


[indent=1]· [b]Database Security[/b]
Object Privileges, Granting access to objects[/indent]

[b]PL -SQL[/b]
[indent=1]· [b]Blocks[/b]
Structure, Writing Anoyomous Blocks[/indent]

[indent=1]· [b]Variables[/b]
Oracle Datatypes, TYPE and ROWTYPE declarations, Value assignments[/indent]

[indent=1]· [b]Control structures[/b]
IF ELSE ENDIF statement, IF ELSIF ELSE ENDIF statement, LOOP END , LOOP statement, WHILE condition, FOR condition[/indent]

[indent=1]· [b]Cursors[/b]
Implicit and Explicit Cursors, Cursor Manipulation statements, OPEN FETCH CLOSE EXIT WHEN[/indent]

[indent=1]· [b]Error Handling[/b]
Predefined Exceptions, Non-Predefined Excecptions, User Defined Exceptions[/indent]

[indent=1]· [b]Procedures[/b]
Creating and Calling Procedures[/indent]

[indent=1]· [b]Functions[/b]
Creating and Calling Functions[/indent]

[indent=1]· [b]Packages[/b]
Package Header, Package Body[/indent]

[indent=1]· [b]Design Tips and Techniques[/b]
Format of standard packages in an application, Spec and Body, NOCOPY hint ------------- thoery[/indent]

[indent=1]· [b]Triggers[/b]
Database triggers, CALLing procedures from triggers[/indent]

[indent=1]· [b]Dynamic SQL[/b]
EXECUTE IMMEDIATE, DBMS_SQL package[/indent]

[indent=1]· [b]Oracle Supplied packages[/b]
DBMS_OUTPUT, UTL_FILE[/indent]

[indent=1]· [b]Collection datatypes[/b]
Associative Arrays, Nested tables, VARRAYs[/indent]



[b] Oracle 11g DBA[/b]

[b]Course Duration : 30 Hours[/b]
[b] INTRODUCTION TO ORACLE DBA[/b]

[indent=1]· What is DBA ?[/indent]

[indent=1]· Why a Company needs a DBA?[/indent]

[indent=1]· Roles & Responsibilities of DBA[/indent]

[indent=1]· Oracle Architecture[/indent]

[indent=1]· Physical and Logical Phase of Database[/indent]

[indent=1]· Types of files(Control file, Redolog file and Datafile)[/indent]

[indent=1]· Different types of Datafiles[/indent]

[indent=1]· Instance[/indent]

[indent=1]· SGA(System Global Area) and Background Process[/indent]

[b] DATABASE CREATION[/b]

[b] TABLESPACE MANAGEMENT[/b]


[b] MISCELLANEOUS[/b]

[b] FLASHBACK FEATURES[/b]


[b] AUDITING[/b]


[b] SQL-LOADER[/b]


[b] ADVANCED SQL Topics[/b]


[b] AVAILABILITY[/b]


[b] PEFORMANCE TUNING[/b]


[b] PHYSICAL BACKUP[/b]


[b] LOGICAL BACKUP[/b]


[b] REDO-LOG & CONTROLFILE MANAGEMENT[/b]


[b] NETWORKING IN ORACLE[/b]


[b] SPFILE & OMF[/b]


[b] UNDO MANAGEMENT[/b]


[b] USER MANAGEMENT[/b]


[b] STORAGE PARAMETERS[/b]