|
|
|
NAIPUNYA
|
|
Number of Views: |
137 |
| Contact Person |
Yogendra |
| Trainings Offered |
TIBCO, SAS, Informatica, Oracle Apps, SQL Server, Data Warehousing, SYBASE, Business Analyst, QA, VB DOT Net, Others, Load Runner, PEGA |
| About Institute |
TERADATA
Module 1:
- Understand the Teradata Scalable Architecture
- Understand how data is stored in Teradata
- Describe how data gets into/out the system
- Describe what the main components of Teradata are
- Overview of Teradata Utilities & Tools
- Use Teradata HASH functions for analyzing data placement
– Primary & Secondary Indexes (Fundamentals)
- Identify Primary Index Choice criteria
- Describe uniqueness and how it affects space utilization
- Explain row access, selection and selectivity
- Choose between single and multi -column Primary Indexes
- Describe single Nun -Unique Secondary Index (NUSI) access.
- Descript Dual NUSI Access
- Explain NUSI and Aggregate Processing
- Compare NUSI vs. Full Table Scan (FTS)
- Access Considerations & Locking Mechanisms
- Analyze Optimizer Access scenarios
- Explain partial value searches and data conversions
- Identify the effects of conflicting data types
- Describe different LOCK scenarios
Module 2:
- Explain the Explain
- Secondary Index Usage
- Fundamental Tools
- Join Optimization
- Collecting Statistics
- ETL Denormalization
- Enhanced Indexing
- Aggregation
- CASE Statement
- Between dates comparison
- Upsert
- Count & Distinct
- Show
- Drop / Create vs. Delete All
- Derived, Volatile, Global
- Referential Integrity processing
- Qualification
- CASTING For better JOINS
Naipunya,
Behind Venkatadhri Theater,
Dillsukhnagar,
Hyderabad
Andhra Pradesh-500 036
9573488558
|
| Address / Colony |
Naipunya,
Behind Venkatadhri Theater,
Dillsukhnagar,
Hyderabad
Andhra Pradesh-500 036
8106596438
/
Dillsukhnagar |
| City |
Hyderabad |
| Phone |
8106596438 |
| Mobile Number |
8106596438 |
| Website |
|
| Trainings Center Ratings |
Not Yet Rated. Please Add your Review and help people |
| View Postings by this Trainer |
|
Contact Training Center
|
|