TERA DATA TRAINING

  • 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
  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher
  • Primary index
  • Hash algorithm
  • Row hash
  • DSW
  • Hash Map
  • Hash Bucket
  • 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
  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data manipulation statements
  • String functions
  • Format functions
  • Cast functions
  • Group & Aggregate functions
  • With & with by clauses
  • Implicit Transaction
  • Explicit Transaction
  • Explain Usage
  • Collection Statistics
  • Tuning SQL Performance
  • Usage of PMON
  • Inner Join
  • Left Outer Join
  • Right Outer join
  • Full Outer Join
  • Product join
  • Merge Join
  • Hash Join
  • Nested join
  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS
  • Tables
  • SET table
  • Multi Set table
  • Volatile tables
  • Global Temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored procedures
  • Triggers
  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata user and managing.
  • BTET
  • ANSI
  • Interactive
  • Batch
  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts
  • Session Control Command Set
  • Error handling.
  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample scripts
  • Various Phases of Multi load
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts
  • Teradata Sql Reference
  • Teradata Functions and
  • Operators
  • Teradata Transactions
  • Performance Tuning and Explain Utility
  • Joints & Unions
  • Join strategies
  • Teradata Basic Commands
  • Teradata objects
  • Teradata spaces
  • Teradata Transaction Modes
  • Load and Unload Utilities & Tools
  • Teradata Sql Assistant (Queryman)
  • Teradata Performance Monitor
  • Teradata BTEQTeradata Fast loadTeradata Multi Load

Need Creative Consulting Solutions to improve your business Presence ?

Propel Solutions provides customized consulting and support services to the clients across the globe. Our highly experienced team enables us to provide 24/7 support services to the clients. Our consulting and support services are 100% focused and secured.

Contact Us