Teradata Certification Training

Develop large-scale data warehousing solutions easily

Enroll Now View Curriculum

Key Highlights

  • 24 Hours of Live Instructor-led Classes
  • 8 sessions of 3 hours each on Weekends
  • Live Project on Real-life Case Studies
  • Practical Assignments
  • Lifetime Access to Learning Management System
  • 24x7 Expert Support
  • Course Completion Certificate
  • Online Forum for Discussions

Course Price

$349.00 $700.00

Contact Us

1866-216-7898

(Toll Free)

Available Courses Delivery

This course is available in the following formats:

Course Overview

Teradata is an application suite used to develop large-scale data warehousing solutions. This certification training will teach the learner in detail about the Teradata architecture, data storage, data retrieval, and indexing. The course covers the fundamentals of SQL as well as the advanced concepts in Teradata. Trainees will also learn about the various utilities provided by Teradata for data procession, export, and import. This training will prepare you for TEO-141 and TEO-142 certifications.

Course Objectives

  • Learn about the advantages Teradata provides over other database systems
  • Understand the Teradata architecture and how indexing works
  • Process data stored in the Teradata tables using SQL
  • Optimize SQL queries on Teradata tables using various techniques
  • Import and export data using Teradata application utilities

Career Benefits

  • Learn to use the market?s leading data and analytics platform that uses parallelism
  • Better remuneration
  • Since the system is open-source, it allows easier integration of newer elements that saves a lot of time and capital in the process for your business
  • Ensure smooth workflow by applying it to multiple processes in the organization, such as data warehousing and customer relationship management
  • Become a highly marketable Teradata Specialist

Prerequisites

  • Basic knowledge of SQL and fundamental Unix commands

Who should take up?

  • Software developers interested in database management
  • Subject matter experts and Analytics Managers who are leading teams
  • Database administrators/designers who want to boost their careers
  • Enterprise Business Intelligence contributors

Course Content

  • Basic Relational Concepts
  • What is Teradata
  • Competitive advantages over other RDBMS
  • Teradata Architecture
  • Teradata Components
  • How components Interact with each other
  • How Data is stored and Retrieved
  • Connectivity with Mainframe and Network Applications
  • Tools & Utilities
  • Teradata Unified Data Architecture
  • Difference between Primary Key and Primary Index
  • Primary Index and types
  • How primary index is used in data distribution and retrieval
  • Secondary index and its types
  • Data retrieval using secondary Index
  • Partition primary index and its types
  • Advantage of PPI
  • Join strategies
  • How data is redistributed for Join processing
  • Data types
  • DDL Statements (CREATE, ALTER, DROP)
  • DML Statements (Insert, Delete, Update)
  • DCL Statements (Grant, Revoke)
  • Order by, Group by, Distinct, SET Operators
  • Logical & Conditional Operators
  • String functions
  • Cast & Format functions
  • HELP and Show Functions
  • Date Functions
  • Built-In Functions
  • Aggregation
  • Joins (INNER and OUTER)
  • Transaction locks
  • Fallback tables
  • Clusters
  • Permanent Journal
  • Down AMP Recovery Journal
  • Transient Journal
  • Cliques
  • Hot Standby nodes
  • RAID 1 & RAID 5
  • Data Dictionary
  • Sub queries
  • Upsert, Case
  • Coalesce
  • Nullif
  • OLAP Functions
  • Rank & Row Number
  • Transaction Modes
  • Temporary Tables (Derived, Volatile and Global Temporary)
  • Explain
  • Collect Statistics
  • Views
  • Macros
  • Stored Procedure
  • Join Index
  • Performance Tuning tips
  • What is FastLoad
  • How FastLoad loads data
  • How to restart failed FastLoad jobs
  • What is MultiLoad and how MultiLoad works
  • Using MultiLoad to insert/update/delete data from Teradata tables
  • Using BTEQ to import/export data
  • FastExport Exporting data from Teradata
  • TPT overview
  • TPT Export
  • TPT SQL Selector
  • TPT Load
  • TPT Update Comparison of Load/Unload Utilities

SEARCHING FOR THE RIGHT COURSE?

Upskill counselors can help you pick the suitable program

CALL US NOW 1866-216-7898

Schedule a call.


IN DEMAND & POPULAR TRAINING COURSES

Popular Courses