Teradata

0 STUDENTS ENROLLED

    Introduction

    Teradata is one of the most emerging technologies in market. As more and more organization are moving their data warehouse in Teradata database, so the demand of Teradata Professionals are high. People who are interested in learning the basics and advance features of Teradata Development can benefit from this training.

     Teradata Course Content:

    1.Teradata Warehouse and competitiveness

    • Opportunities of Teradata in the enterprise.
    • What is Teradata-rdbms/DWH?
    • Teradata 13.10 & Other versions(12,v2r7,v2r6).
    • Teradata History and Realtime running versions.
    • Teradata competitiveness with other RDBMS . Diff between them.
    • Teradata Warehouse and Usability.

    2.Teradata single and Multi system Architectures

    • Node Architecture
    • SMP Architecture
    • MPP Architecture
    • Discussion on AMPS and NODES

    3.Teradata Components and Explanation

    • VPROCS
    • BYNETS

    4.Teradata Pratical(DBA Related concepts)

    • Teradata server starting/stopping
    • Working with Teradata sql Assistant and BTEQ
    • Creating Database and Manipulation
    • Creating User and Manipulation
    • Managing Databases and users
    • Data Dictionary and Views
    • Working with Teradata Administration Tool

    5.Memory Management Spaces

    6.Teradata SQL

    • Stored Procedure Language
    • Teradata Extensions(HELP,SHOW,EXPLAIN,COLLECT STATISTICS)

    7.Data Definition Language

    • Creating Table
    • Types of tables
    • Altering and Modifying Tables
    • Dropping

    8.DML

    9.DCL

    10.Locks, Data Recovery and Protection

    11.Other Components of table

    • Datatypes (ANSI,Teradata)
    • Column Storage Attributes
    • Constraints

    12.Teradata Transactions

    13.Teradata Storage and Retrival Architecture

    14.Teradata Indexes

    • Primary Index
    • Secondary Index

    15.Teradata SQL References

    • Condition Expressions
    • Arithmetic, Logical, Conditional Operators
    • Normal Functions
    • Advanced OLAP Functions

    16.Sub Queries, Set Operations, Joins

    17.Teradata Other Objects

    • Views
    • Macros
    • Triggers
    • Cursors

    18.Join Strategies

    19.Performance Tunning and Explain utility

    • Explain request Modifier
    • Collect Statics,Confidence Levels
    • Tunning SQL Queries and Utilities
    • Usage of PMON, Index & Statistics Wizards
    • Various Indexes
    • Skew factor, Skewness, Remeddies Spool Space Issues

    20.Load and Unload Utilities(20 hrs)

    • Teradata SQL Assistant(SQLA)
    • Teradata BTEQ
    • Teradata FASTLOAD
    • Teradata MULTILOAD
    • Teradata FASTEXPORT
    • Teradata TPUMP

    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, 1 week

    Drop us a query

    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 © 2019 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED
    X