Teradata Development

Teradata Development

0 STUDENTS ENROLLED

    Teradata Development Course Content

    What Is Teradata Why For It Is What For It Is

    • 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

    Teradata Architecture & It’s 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
    • 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 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 Objects

    • Types of 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 FastLoad
      • Types of phages & how to find it
      • Advantages & its process
      • Limitations of fast load
      • Real time scripts
    • 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
      • 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

    Write a Review

    Your email address will not be published.

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month, 1 week
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details


      * Required

      Job Support

        Your Details


        * Required

        Course Features

        Live Instructor-led Classes

        This isn't canned learning. Its dynamic, its interactive, its effective

        Expert Educators

        Only the best or they're out. We are constantly evaluating our trainers

        24&7 Support

        We never sleep. Need something answered at 3 am? No Problem

        Flexible Schedule

        You don't learn as per our calendar. We work according to yours.

        Customized Training's

        The most part self-managed and adaptable to suit a person's particular adapting technology needs

        Priority Based Training's

        Real-time Scenario based Assignments and Case Studies

        COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED