TeraData with SQL

DASVM’s Teradata with SQL Training will help you become an expert in developing Data Warehousing applications using Teradata while working on real time use cases and projects. In this training, you will gain in-depth knowledge of the concepts such as Teradata Architecture, Teradata Components, Data storing and retrieval process, Teradata Unified Data Architecture, Tools & Utilities, Integration of mainframe and network applications, etc. This training will also prepare you for clearing the TEO-141 and TEO-142 Teradata certification exam.

img
request

Can’t find a batch you were looking for?

 

DASVM's Teradata with SQL Training will help you become an expert in developing Data Warehousing applications using Teradata while working on real time use cases and projects. In this training, you will gain in-depth knowledge of the concepts such as Teradata Architecture, Teradata Components, Data storing and retrieval process, Teradata Unified Data Architecture, Tools & Utilities, Integration of mainframe and network applications, etc. This training will also prepare you for clearing the  TEO-141 and TEO-142 Teradata certification exam.

 
Course Objectives:

 

After completing this course attendees should be able to:

  • Understand Teradata's competitive advantage over other RDBMSs.
  • Understand Teradata Architecture and Indexing mechanism.
  • Use SQL to process data stored in Teradata tables.
  • Use Teradata application utilities to import/export data.
  • Apply various performance turning techniques to optimize the queries.
 

Course content

 

Teradata Overview
  • What is Teradata
  • Basic Relational Concepts
  • Competitive advantages over other RDBMS
  • Teradata Components
  • Components interaction
  • Data storage and retrieval process
  • Integration between Mainframe and Network Applications
  • Teradata Unified Data Architecture
Teradata Indexes and Join Strategies
  • Overview of Indexing
  • Difference between Primary Key and Primary Index
  • The primary index for data retrieval and data distribution
  • Secondary index and its types
  • Data retrieval with secondary Index
  • Partition Primary index types
  • PPI advantages
  • Join strategies and data redistribution for join process
Teradata SQL
  • Data types,DML Statements (Insert, Remove, Update)
  • DDL Statements
  • DCL Statements (Grant, Revoke)
  • Group by
  • Order by
  • Distinct
  • Logical & Conditional Operators
  • SET Operators and String functions
  • Date Functions, Built-In Functions, HELP and Show Functions
  • Joins (INNER and OUTER)
  • Built-In Functions
  • Aggregation
Data Protection
  • Transaction locks
  • Permanent Journal
  • Fallback tables
  • Clusters
  • Transient Journal
  • Cliques
  • Down AMP Recovery Journal
  • Hot Standby nodes and Cliques
  • Overview of RAID 1 & RAID 5
  • Data Dictionary
SQL Advanced
  • Subqueries
  • Upsert
  • Case
  • OLAP Functions
  • Nullify
  • Transaction Modes
  • Rank & Row Number
  • Temporary Tables
  • Collect and Explain Statistics
Advanced Database objects and performance optimization
  • Stored Procedure
  • Views
  • Macros
  • Performance Tuning tips
  • Join Index
Teradata Utilities – FastLoad, MultiLoad, BTEQ
  • What is Fast
  • LoadThe process to restart failed FastLoad jobs
  • How FastLoad loads data
  • Introduction to MultiLoad and how it works
  • Using MuliLoad to perform various data related functions Teradata tables
Teradata Utilities – FastExport,TPT
  • Exporting data from Teradata using FastExport
  • TPT Export
  • TPT SQL Selector
  • TPT overview
  • TPT Load
  • TPT Update
  • Difference between Load/Unload Utilities

 

To see the full course content Download now

Course Prerequisites

 
  • Prerequisites for this course include basic SQL knowledge, Linux fundamentals, and relational database commands.

Who can attend

 
  • Analytics Managers
  • Developers/Designers who want to accelerate their careers as a Teradata Developer/Designer.
  • Enterprise Business Intelligence Professionals

Number of Hours: 40hrs

Certification

TEO-141 & TEO-142

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses