Learn Teradata Course

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

Course Reviews

3.7

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





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.

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

Copyright © 2018 Greens Technology Velachery. All rights reserved.