TERADATA

 

  • Overview of the TERADATA
  • What is Teradata?
  • Teradatav12 & versions
  • Teradata History
  • Teradata users scalability
  • Teradata &other RDBMS
  • Teradata warehouse
  • Teradata in the Enterprise
  • Interview Q&A and Certification queries
  • Real time Issues & resolving
  • TERADATA ARCHITECTURE & TERADATA ARECHITECTURE COMPONENTS
  • Real time Issues & resolving
  • Node Architecture(Shared Architecture)
  • SMP Architecture
  • MPP Architecture
  • Parsing engine(PE) Architecture
  • AMP Architecture &uses
  • By net Benefits &types
  • Parallel data extension(PDE)
  • Teradata directory program(TDP)
  • Call level interface(CLI)
  • Trusted parallel application(TPA)
  • Virtual processors
  • By net 0 &By net 1
  • Parallelism 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
  • Hash algorithm
  • hash
  • Hash map
  • Hash bucket
  • Receiving VDisc
  • 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
  • product join
  • inner join
  • left & right outer join
  • full outer join
  • TERADATA BASIC COMMANDS
  • Help
  • Show
  • Explain
  • Collect statistics
  • TERADATA OBJECTS
  • Types of tables
  • Set tables
  • Multi tables
  • Volatile tables
  • Global temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored procedures
  • Triggers
  • TERADATA MEMORY SPACES
  • Permanent spaces
  • Temporary spaces
  • Spool spaces
  • Users spaces & PWD
  • TERADATA TRANSACTION MODES
  • Batch mode
  • BTET mode
  • ANSI mode
  • How Converted into others
  • TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE
  • Usage of PMON
  • Explain usage
  • Collecting statistics
  • SQL tuning
  • Various SQL statements
  • Real time Issues & resolving
  • TERADATA UTILITIES & TOOLS (IMPORT & EXPORT)
  • Teradata BTeq scripts
  • Overview of BTeq
  • Looping stages
  • Batches scripts
  • Import &export scripts with Examples
  • Error handling
  • Real time scripts
  • Teradata Fast Load
  • Types of phages & how to find it
  • Advantages & its process
  • Limitations of fast load
  • Real time scripts
  • Teradata Multi Load
  • Overview of Multi load
  • Types of phages in Multi Load
  • Advantages & its process
  • Limitations of Multi Load
  • Uses various types of operations
  • Work on Multi tables
  • Real time scripts
  • Sample scripts
  • Teradata Tpump
  • Overview of Tpump
  • Limitations of Tpump
  • Work on Multi tables
  • Real time scripts
  • Sample scripts
  • Teradata Fast Export
  • How to export the data
  • Passing parameters
  • IN/OUT Modes
  • Work on Multi tables
  • Real time scripts
  • Sample scripts
  • Teradata SQL Assistant(Quarryman)
  • Teradata performance tuning on scripts

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.