*Location : Boston MA* *6+months*
** *Knowledge of ETL tool is must (datastage preferable**)* *ORACLE Data Architect/Consultant* ------------- "• Exposure to Basic Relational Database Concepts - basic types of databases,data integrity, the relational model,etc • Ability to understand basics of DBDesign , Logical modeling , Normalization & De-Normalization Techniques • SQLConstructs Ablility to understand and implement Data Types, Basic SQL SELECTStatements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic AccessMethods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics,Optimizer Hints Basics, Gathering Statistics Basics • Adv SQL Basics: Able tounderstand and implement Datetime Functions, Advanced Subqueries, HierarchicalQueries,DDL & DML Extensions, Transaction Management • Tools Level 1 usage •Database Programming Basics: Ability to understand and implement DeclaringVariables, Executable Statements, Control Structures, Composite Data Types,Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions,Creating Database Triggers • Adv Database Programming: Ability to understandand implement Collections, Multilevel collections, Ref Cursors, BulkProcessing, Bulk Bind and Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performanceaspects in PL./SQL • Exposure to Basic Relational Database Concepts - basictypes of databases, data integrity, the relational model,etc • Ability tounderstand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques • Woking knowledge of DB Design/Modelingtechniques(Logical and Physical DB modeling) •SQL Constructs Ablility tounderstand and implement Data Types, Basic SQL SELECT Statements, Restrictingand Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions,Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML),Constraints, Views • SQL Query Tuning Basics: Understanding of SQL Tuningconcepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Traceand TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to theOptimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, GatheringStatistics Basics • Adv SQL Basics: Able to understand and implement DatetimeFunctions, Advanced Subqueries, Hierarchical Queries,DDL & DML Extensions,Transaction Management • Tools Level 1 usage • Adv SQL & SQL Tuning Techniques:Ability to implement Tunning Concepts/Techniques like Explain Plan, Accessmethod, Generate SQL Trace and TKPROF report, Forcing Index Hints, GatherStatistics, Managing Optimizer Statistics, Using Indexes, Using Plan Stability,Using Application Tracing Tools, SQL Access Advisor • Database ProgrammingBasics: Ability to understand and implement Declaring Variables, ExecutableStatements, Control Structures, Composite Data Types, Explicit Cursors,Handling Exceptions, Creating Procedures, Creating Functions, Creating DatabaseTriggers • Adv Database Programming: Ability to understand and implementCollections, Multilevel collections, Ref Cursors, Bulk Processing, Bulk Bindand Bulk Collect, DBMS_OUTPUT, UTL_FILE, Performance aspects in PL./SQL • AdvDatabase Programming: Ability to understand and implement Advanced ExplicitCursors, Managing Subprograms, Creating Packages, Oracle Supplied Packages,Adv. Triggers, Managing Dependencies • SQL Developer Tool for DatabaseProgramming • Tools Level 1 Usage • Able to use TOAD for Database Development•SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins,Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects,Manipulating Data (DML), Constraints, Views • SQL Query Tuning Basics:Understanding of SQL Tuning concepts like SQL Statement Processing Basics,Explain Plan Basics, SQL Trace and TKPROF Basi Thanking you, Mamatha 630 364 1907 [email protected] -- You received this message because you are subscribed to the Google Groups "Business Objects User Group" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/businessobjects?hl=en.
