Get Latest De

Email:info@onlinetrainings.in

DBA- Teradata

Course

DBA- TERADATA

Category

Software Training

Eligibility

All Job Seekers

Mode

Online and Offline Classes

Batches

Week Days and Week Ends

Duration :

30 to 45 days

Azure Cloud Objectives

•How to work with DBA- Teradata Tool.
•Students will learn widely used DBA- Teradata concepts
•Learn how to write high-quality code using DBA- Teradata.
•Different DBA- Teradata practical questions asked during real time interviews .
•Understand when and how to use DBA- Teradata elements variables.
•Learn DBA- Teradata from Scratch, Start from basic to advanced level
•Understand and make use the new Features and Concepts in DBA- Teradata
•The students get hands on experience of how things happen in DBA- Teradata?
•Learn the fundamentals of the DBA- Teradata using both a theoretical and practical approach

DBA- Teradata Course Features

•You Get Real Time Project to practice
•Basic Training starting with fundamentals
•Software & others tools installation Guidance
•Immersive hands-on training on Python Programming
•We hire Top Technical Trainers for Quality Sessions
•Courseware includes reference material to maximize learning.
•We provide one to one mentorship for the students and Working Professionals
•This Instructor-led classroom course is designed with an aim to build theoretical knowledge supplemented by ample hands-on lab exercises

Who are eligible for DBA- Teradata

•Cloud Computing, Information Security, Network Security, Windows System Administration, Windows Server
•Informatica MDM, Siperian, Informatica PowerCenter, Oracle EBS Tech./Functional, ETL, Siebel UCM, Siebel CRM, Oracle Sales Cloud, VMware, CRM, Power
•java, php, .net, 3dmodelling, unitydeveloper, androiddeveloper, gamedeveloper, Software Developer, Php, Java, Photoshop
•Security Associate, Security Monitor, Security Analyst, senior security operations analyst, Software Engineer, Software Developer, Java Developer, DevopsSenior web designer, senior web developer, Ui Designer, Ui Programmer, php, mysql, smarty, jquery, Javascript, ajax, bootstrap, html 5, css 3, android, ios

DBA- TERADATA Topics

Teradata Overview


&#10004Why Teradata?
✔What is Teradata?
✔Scalability in a Production Environment
✔Teradata Competitive Advantages
✔Teradata – A Brief History
✔The Value of Teradata
✔Designed for Today’s Business
✔Teradata Manageability
✔What is a Teradata Database?
✔Review Questions

Components and Architecture


&#10004What is a Node?
✔MPP System
✔Cliques
✔Major Components of a Teradata System
✔BYNET
✔The Parsing Engine
✔The Teradata Optimizer
✔Access Module Processor (AMP)
✔Teradata Parallelism
✔Linear Growth and Expandability

Accessing a Teradata Database


&#10004BTEQ – SQL
✔Fast Export
✔Fast Load
✔Multi Load
✔Teradata Parallel Transporter (TPT)
✔UNICODE support

: Creating a Teradata Database


&#10004A Teradata Database
✔A Teradata User
✔Initial Teradata System
✔Teradata Space Management
✔Creating Tables
✔Access Rights
✔Review Questions

Storing and Accessing Rows


&#10004How Does Teradata Store Rows?
✔How Do Other Databases Store Rows?
✔Primary Indexes
✔Creating a Primary Index
✔Primary Index Values
✔Accessing Via a Unique Primary Index
✔Accessing Via a Non-Unique Primary Index
✔Primary Keys and Primary Indexes
✔Row Distribution Using a UPI
✔Row Distribution Using a NUPI

Secondary Index and Table Scans


&#10004Secondary Indexes
✔Choosing a Secondary Index
✔Unique Secondary Index (USI) Access
✔Non-Unique Secondary Index (NUSI) Access
✔Comparison of Primary and Secondary Access
✔Full-Table Scans

Data Protection


&#10004Locks
✔Access Locks
✔Fallback
✔Transient Journal
✔Permanent Journal

Teradata Tools


&#10004Query Submitting Tools
✔FASTLOAD Utility
✔MULTILOAD Utility
✔FASTEXPORT Utility
✔TPump
✔Administrative Tools

Teradata Installation


&#10004Teradata Installation and Configuration