• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

BISPtrainings provides online Teradata classes And training Course details Admin Track, Developer Track video tutorial and Job Support.


Duration : 30 hours


Fee: 319


Job Trends


Who Should Learn?

This tutorial is designed for software professionals who are willing to learn Teradata concepts and become a Teradata developer.

Prerequisite

You should have a basic understanding of Relational concepts and basic SQL. It will be good if you have worked with any other RDBMS product.

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
19th October 2019 8:00 AM   IST Demo
22nd October 2019 8:00 AM   IST Regular
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Teradata Dev Track

History and Architecture

 

Introduction to TERADATA - Watch Preview
OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS
Teradata Architecture
Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc.

Database structure

Data distribution
Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index )
Data Protection
Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and JORNALS)
Spaces and types of tables
Different levels of accessing the objects granting the Privileges and locking mechanism

SQL

ASNI SQL
Brief introduction of Relational concepts, understanding users, databases, tables, vies, index, macro etc. Sub query, corelated query, Data types, Joins, Arthimatic functions
Teradata SQL
Explore teradata specifc SQL statements such as show, help,explain.
.SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the
datatypes.
Advanced Teradata SQL
Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking,
Qualify, CSUM, MSUM, WITH, WITH BY.

Client utilities

SQL Assistant
Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT
BTEQ
Functinality,operations, exectuion and limitations
FAST LOAD
Functinality, Different phases, exectuion, restartability and limitations
FAST EXPORT
Functinality, Different phases, exectuion, restartability and limitations
MULTI LOAD
Functinality, Different phases, exectuion, restartability and limitations

Performance tuning

Explain plan & Statistics & Understanding Explain plan and recommandations. Significance of collecting statistics
Other techniques
Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress

Others (Optional)

Unix
Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects
General phases of a Development project. Documents required in each phase
 

Use Case

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Reviews

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?