Teradata Administration

Teradata Administration

0 STUDENTS ENROLLED

    Introduction

    Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that is Teradata is an open-system, operating on the UNIX MP-RAS or Windows machine platform. Teradata is of assisting several concurrent users from various customer systems capable. Teradata is suitable for market specifications. Teradata is totally developed over a parallel architecture.

    COURSE SUMMARY

    Course Name Teradata Development Online Training
    Contents Fundamentals, Architecture and Components of Teradata etc.
    Duration 30 Hours with Flexible timings
    Delivery Instructor Led-Live Online Training
    Eligibility Any Graduate
    Ideal For Freshers, aspirants seeking to learn the Teradata Development
    Next Batch Please visit the schedule section

    Course Objectives

    • Learn the basic concepts of Teradata.
    • Know the Architecture and Indexing mechanism of Teradata.
    • How to process the data using SQL in Teradata tables.
    • How to import or export data using Teradata application utilities.
    • How to implement different performance turning methods.

    PR-EREQUISITES: 

    • Basic Knowledge of SQL is mandatory.

    Course Curriculum

    MODULE 1: INTRODUCTION

    • Overview of Teradata
    • Teradata versions
    • Teradata warehouse
    • Teradata Users and Scalability
    • Teradata in the Enterprise

    MODULE 2: ARCHITECTURE AND COMPONENTS OF TERADATA

    • Teradata Architecture
    • MPP Architecture
    • SMP Architecture
    • AMP, TDP, CLI, TPA
    • Parallelism Architecture

    MODULE 3: DATA RECOVERY AND SECURITY

    • locks
    • Different locks
    • RAID 1 and RAID 5
    • Fall Back
    • Disk Arrays
    • Clique
    • Types of Journals
    • AMP Clustering

    MODULE 4: TERADATA INDEXES

    • Unique
    • Primary Index
    • Non unique
    • Secondary Index
    • Partitioned
    • Hash, Join, Value Ordered
    • Secondary Index Sub table
    • Skewness
    • Keys Vs Indexes

    MODULE 5: TERADATA SQL REFERENCE

    • SQL Fundamentals
    • Data Definition Statements(DDL)
    • Data Types and Literals
    • Data Manipulation Statements(DML)

    MODULE 6: TERADATA FUNCTIONS AND OPERATORS

    • Format Function
    • String Functions
    • Cast Functions
    • With & with by clauses
    • Group & Aggregate Functions

    MODULE 7: TERADATA TRANSACTIONS

    • Explicit Transaction
    • Implicit Transaction
    • Collecting Statistics
    • Performance Tuning and Explain Utility
    • Tuning SQL Performance
    • Usage of PMON
    • Joins and Unions
    • Inner Join
    • Right Outer Join
    • Left Outer Join
    • Full Outer Join
    • Product Join
    • Join Strategies
    • Merge Join
    • Nested Join
    • Hash Join

    MODULE 8: TERADATA BASIC COMMANDS

    • Show
    • Help
    • Collect Statistics
    • Explain

    MODULE 9: TERADATA OBJECTS

    • Tables
    • Multi Set table
    • SET table
    • Global Temporary tables
    • Volatile tables
    • Views
    • Derived tables
    • Macros
    • Triggers
    • Stored Procedures

    MODULE 10: TERADATA SQL ASSISTANT (QUERYMAN)

    • Teradata BTEQ
    • Teradata Performance Monitor
    • Branching and Looping
    • Batch Scripts with samples
    • Importing and Exporting data through scripts
    • Error handling
    • Teradata Fast Load
    • Advantages and Process
    • Sample Scripts
    • Limitations of Fast Load

    MODULE 11: REAL TIME ISSUES

    • Teradata Multi Load
    • Limitations of Multi Load
    • Working with multiple tables
    • Sample Scripts
    • Limitations of TPump
    • Sample Scripts
    • Exporting Data
    • OUTMODS
    • Utility Vs Parallelism

    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
    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