Jump to content

Obiee11G/10G,oracle11G,oracle Dba Online Training At Vkkstechnologies


vkks

Recommended Posts

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


CONTACT VENKAT :7411248012(INDIA)

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...