Teradata is an enterprise software company that develops and sells a relational database management system (RDBMS). Teradata is considered as a “Data ware house system”, which can manage data, store data & BAR (BACKUP, ARCHIVE &RESTORE) data.
Teradata online training shares the knowledge of gathering the data from multiple sources and makes it available for the analysis.
Teradata training online in big classes deals with Teradata 13.10 & Teradata 14.
teradata Course Modules
WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS
- What is Teradata?
- Teradatav12 & versions
- Teradata History
- Real time Issues & resolving
|
- Teradata users scalability
- Teradata &other RDBMS
- Teradata warehouse
|
- Teradata in the Enterprise
- Interview Q&A and Certification queries
|
|
TERADATA ARCHITECTURE & IT’S COMPONENTS
- Node Architecture(Shared Architecture)
- SMP Architecture
- MPP Architecture
- Parsing engine(PE) Architecture
|
- Bynet Benefits &types
- Parallel data extension(PDE)
- Teradata directory program(TDP)
- Call level interface(CLI)
- AMP Architecture &uses
|
- Trusted parallel application(TPA)
- Virtual processors
- Bynet 0 &Bynet 1
- Parallism Architecture
|
|
RECOVERY &PROTECTION OF DATA
- What is fall back &where it used
- Why for fall back
- What is Clique
- AMP Clustering
|
- & types for simultaneous Access
- Why for locks &how to release
- RAID 1 &RAID 5
- Journals &types
|
- Virtual Disk Array
- How & where is used journals
- Q & A about data recovery
|
|
TERADATA INDEXES
- Types of indexes in Teradata
- Hash index
- Join index
|
- Primary index(unique, non- unique)
- Secondary index(unique, non- unique)
|
- Skewness
- Keys & indexes (How & why these used)
|
|
HOW TO STORAGE & RETRIEVAL OF DATA
|
TERADATA SQL QUARRYMAN
- SQL fundamentals
- Data types and literals
|
- DDL Statements
- DML Statements
|
- Teradata naming conversing
|
|
TERADATA SQL QUARRYMAN
- SQL fundamentals
- Data types and literals
|
- DDL Statements
- DML Statements
|
- Teradata naming conversing
|
|
TERADATA SQL FUNCTIONS & OPERATIONS
- String functions
- Format functions
- Cast functions
- Cast functions
|
- Group & Aggregation functions
- Logical operations
- Arithmetic operations
|
- set operations
- join operations
- conditional expressions
|
|
TERADATA JOIN STRATEGIES & UNIONS
- hash join
- merge join
- nested join
|
|
- left & right outer join
- full outer join
|
|
TERADATA BASIC COMMANDS
|
TERADATA OBJECTS
- Set tables
- Multi tables
- Volatile tables
- Global temporary tables
- Views
|
- Macros
- Stored procedures
- Triggers
- TERADATA MEMORY SPACES
|
- Permanent spaces
- Temporary spaces
- Spool spaces
- Users spaces & PWD
|
|