Course Curriculum

No curriculum found !

Curriculum

Teradata Introduction

  • Teradata Introduction
  • Teradata Advantages
  • RDBMS vs Data warehouse
  • Teradata Tools & Utilities
  • Teradata Installation

Teradata Architecture

  • Teradata Components
  • Storage & Retrieval architecture
  • System architecture
  • How parallelism works

Basic SQL

  • Data types
  • DDL statements(CREATE,DROP,ALTER)
  • DML statements (SELECT, INSERT,UPDATE,DELETE)
  • DCL statements (Grant, Revoke)
  • SET Operators
  • Logical & Conditional Operators
  • String Manipulation
  • Date & Time Manipulation
  • Joins
  • Built-in functions
  • Aggregates

Indexes

  • Primary Index
  • Secondary Index
  • Partition Primary Index

Teradata Objects

  • Tables and its types
  • Space concepts
  • Views
  • Macros
  • Stored Procedures
  • Join Index

Advanced SQL

  • Sub queries
  • Coalesce
  • OLAP Functions
  • Compression
  • Collect Statistics
  • DBC tables
  • Explain plan
Utilities
  • FastLoad
  • MultiLoad
  • BTEQ
  • FastExport
  • TPT
Data Protection
  • Fallback
  • Clusters
  • Clique
  • Permanent Journals
  • Hot Standby Nodes
  • RAID
Performance Optimization
  • Join Strategies
  • Confidence levels
  • Statistics collection process
  • Performance tuning techniques
Optional
  • Real time projects
  • Interview questions

Teradata Training
Teradata Online Training

Course Reviews

3.7

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

No Reviews found for this course.

PRIVATE COURSE
  • 10 Hours
0 STUDENTS ENROLLED




    Looking for:
    ClassroomOnline

    Key Features

    We provide Job Oriented hands on practical training by real time working professional. its suitable for fresher and professional.

    We provide hard copy for classroom students / soft copy for online students.

    You will get lifetime video access - Online Students

    we provide 24/7 support by any type of issues regarding classes and accessing.

    You will get course completion certificate when you finished the course.

    QEdge provides you job assistance, we have 150+ clients across the globe. We don’t charge any extra fees for this.

    All rights reserved - © QEdge Technologies