Welcome To Eazygurus

Teradata Datawarehousing

Course Name        :   TERADATA Data Warehousing
Duration                 :  35 hrs

STUDENTS ENROLLED

    • Teradata Introduction
      • What is Teradata?
      • Teradatav12 & versions
      • Teradata History
      • Teradata users scalability
      • Teradata &other RDBMS
      • Teradata warehouse
      • Teradata in the Enterprise
    • Teradata Architecture & Components
      • Node Architecture(Shared Architecture)
      • SMP Architecture
      • MPP Architecture
      • Parsing engine(PE) Architecture
      • AMP Architecture &uses
      • Bynet Benefits &types
      • Parallel data extension(PDE)
      • Teradata directory program(TDP)
      • Call level interface(CLI)
      • Trusted parallel application(TPA)
      • Virtual processors
      • Bynet 0 &Bynet 1
    • 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
    • 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 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
      • 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 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
    • Teradata Utilities & Tools (Import & Export)
      • Teradata BTeq scripts
      • Overview of BTeq
      • Looping stages
      • Batches scripts
      • Import &export scripts with Examples
      • Error handling
    • Teradata FastLoad
      • Types of phages & how to find it
      • Advantages & its process
      • Limitations of fast load
    • Teradata MultiLoad
      • Overview of Multi load
      • Types of phages in MultiLoad
      • Advantages & its process
      • Limitations of MultiLoad
      • Uses various types of operations
      • Work on Multi tables
    • Teradata Tpump
      • Overview of Tpump
      • Limitations of Tpump
      • Work on Multi tables
    • Teradata Fast Export
      • How to export the data
      • Passing parameters
      • IN/OUT Modes
      • Work on Multi tables
    • Teradata SQL Assistant(Quarryman)
    • Teradata performance tuning on scripts

    Key Benefits:

    • Exposure to real time scenarios.
    • Job oriented training program.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A
    • Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.