Courses
SAP
- SAP ABAP
- SAP BASIS
- SAP SECURITY
- SAP NETWEAVER
- SAP XI
- SAP FICO
- SAP FSCM
- SAP MM
- SAP WM
- SAP PP
- SAP SRM
- SAP BW
- SAP BI
- SAP BPC
- SAP MDM
- SAP SD
- SAP CRM
- SAP BO
- SAP HR
- SAP HR-ABAP
- SAP GRC
- SAP HCM
- SAP APO
- SAP EP ADMIN
- SAP IS UTILITIES
- SAP PLM
- SAP SCM
- SAP PC
- SAP QM
- SAP IS RETAIL
- SAP EP JAVA WEBDYNPRO
- SAP HANA
- SAP PS
- SAP PI
- SAP IS OIL & GAS
- SAP CS
Oracle
- ORACLE 10 g
- ORACLE APPS DBA
- ORACLE APPS FINANCIALS
- ORACLE APPS TECHNICAL
- ORACLE BPEL
- ORACLE OAF
- ORACLE APPS FINANCE FUNCTIONAL R12
- OBIEE
- ORACLE 11G
- ORACLE DBA
- PL-SQL
- ORACLE HRMS
- ORACLE ADF
Other Technologies
- MS.NET
- SHARE POINT
- JAVA
- SAS
- SAS BI
- SAS OC
- QA TESTING
- SQL SERVER
- TIBCO
- SIEBEL CRM
- SIEBEL ANALYTICS
- UNIX SHELL
- BIZTALK SERVER
- CCNA
- SAS FINANCIAL MANAGEMENT
- AJAX
- LINUX
- SALES FORCE
- CCNP
- MCSE
- VMWARE
- PEOPLESOFT HRMS TECHNICAL
- CRYSTAL-REPORTS
- PMP
- TERA DATA
- WEBSPHERE
- ANDROID
- HADOOP
Data Warehousing
- INFORMATICA
- COGNOS
- DATA STAGE
- BUSINESS OBJECTS
- BUSINESS ANALYST
- COGNOS TM1
- AB INITIO
- MICROSTRATEGY
- COGNOS PLANNING AND BUDGETING
- HYPERION ESSBASE
- HYPERION DATA RELATIONSHIP MANAGEMENT
- HYPERION FINANCIAL MANAGEMENT
- HYPERION INTERACTIVE REPORT
- HYPERION FINANCIAL DATA QUALITY MANAGEMENT
- HYPERION PLANNING
- HYPERION FINANCIAL REPORT
Tera Data - Course Content
Teradata Architecture and Components
- PDE(Parallel Data Extension)
- Vprocs (virtual processors)
- PE (Parsing Engine)
- AMP (Access Module processing)
- Board less Bynet
- TDP (Teradata Directory Program)
- CLI (Call Level Interface)
- TPA (Trusted parallel Application)
- Going in depth by explaining the process of SQL statement execution
Various Architecture
- Node Architecture (shared nothing)
- SMP Architecture
- MPP Architecture
- Parallelism Architecture
- Benefit & types
Data Recovery and Protection
- Object Locks-Various locks for simultaneous access
- RAIDI
- RAIDI5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Journals
Teradata Storage and Retrieval Architecture
- Request processing
- a. Syntaxer
- b. Resolver
- c. Security Module
- d. Optimizer
- e.Step Generator
- f. GNC Apply
- g. Dispatcher
Primary index
- 1.Hash algorithm
- 2. Row hash
- 3. DSW
- 4. Hash Map
- 5. Hash Bucket
- 6. Reaching Vdisk
Teradata Indexes
- Primary Index
- Unique
- Non unique
- Partitioned
- Secondary Index
- Unique
- Non unique
- Hash, Join, Value Ordered
- Skewness
- Secondary Index Sub table
- Accessing Records via primary index
- Accessing records via Secondary index
- Keys vs indexes
Teradata Sql Reference
- Fundamentals
- Data Types and Literals
- Data Definition Statements
- Data manipulation statements
Teradata Functions and Operators
- String functions
- Format functions
- Cast functions
- Group & Aggregate functions
- With & with by clauses
Teradata Transactions
- Implicit Transaction
- Explicit Transaction
Performance Tuning and Explain Utility
- Explain Usage
- Collection Statistics
- Tuning SQL Performance
- Usage of PMON
Joints & Unions
- Inner Join
- Left Outer Join
- Right Outer join
- Full Outer Join
Teradata Basic Commands
- HELP
- SHOW
- EXPLAIN
- COLLECT STATISTICS
Teradata objects
- Tables
- 1. SET table
- 2. Multi Set table
- 3. Volatile tables
- 4. Global Temporary tables
- 5. Derived tables
- Views
- Macros
- Stored procedures
- Triggers
Teradata spaces
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata user and managing.
Teradata Transaction Modes
- BTET
- ANSI
- Interactive
- Batch
Load and Unload Utilities & Tools
- Teradata Sql Assistant (Queryman)
- Teradata Performance Monitor
- Teradata BTEQ
- a. Batch Scripts with samples
- b. Branching and Looping
- c. Importing data through scripts
- d. Exporting data through scripts
- e. Session Control Command Set
- f. Error handling.
- Teradata Fast load
- a. Various Phases of Fast Load
- b. Advantages and Process
- c. Limitations of Fast Load
- d. Sample scripts
- Teradata Multi Load
- a. Various Phases of Multi load
- b. Limitations of Multi Load
- c. Working with multiple tables
- d. Applying various operations
- e. Sample Scripts