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. Required fields are marked *

    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

    Drop us a query

    Job Support

    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

    Disclaimer

    This web site or keentechnologies.com team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information

    475-212-0075

    +91 9989754807

    trainings@keentechnologies.com


    ONLINE MEETING PARTNERS

    top
    COPYRIGHT © 2019 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    X