Teradata is a database, which is planned to manage logical queries. Teradata is basically a relational database management system that is Teradata is an open-system, operating on the UNIX MP-RAS or Windows machine platform. Teradata is of assisting several concurrent users from various customer systems capable. Teradata is suitable for market specifications. Teradata is totally developed over a parallel architecture.
|Course Name||Teradata Development Online Training|
|Contents||Fundamentals, Architecture and Components of Teradata etc.|
|Duration||30 Hours with Flexible timings|
|Delivery||Instructor Led-Live Online Training|
|Ideal For||Freshers, aspirants seeking to learn the Teradata Development|
|Next Batch||Please visit the schedule section|
- Learn the basic concepts of Teradata.
- Know the Architecture and Indexing mechanism of Teradata.
- How to process the data using SQL in Teradata tables.
- How to import or export data using Teradata application utilities.
- How to implement different performance turning methods.
- Basic Knowledge of SQL is mandatory.
MODULE 1: INTRODUCTION
- Overview of Teradata
- Teradata versions
- Teradata warehouse
- Teradata Users and Scalability
- Teradata in the Enterprise
MODULE 2: ARCHITECTURE AND COMPONENTS OF TERADATA
- Teradata Architecture
- MPP Architecture
- SMP Architecture
- AMP, TDP, CLI, TPA
- Parallelism Architecture
MODULE 3: DATA RECOVERY AND SECURITY
- Different locks
- RAID 1 and RAID 5
- Fall Back
- Disk Arrays
- Types of Journals
- AMP Clustering
MODULE 4: TERADATA INDEXES
- Primary Index
- Non unique
- Secondary Index
- Hash, Join, Value Ordered
- Secondary Index Sub table
- Keys Vs Indexes
MODULE 5: TERADATA SQL REFERENCE
- SQL Fundamentals
- Data Definition Statements(DDL)
- Data Types and Literals
- Data Manipulation Statements(DML)
MODULE 6: TERADATA FUNCTIONS AND OPERATORS
- Format Function
- String Functions
- Cast Functions
- With & with by clauses
- Group & Aggregate Functions
MODULE 7: TERADATA TRANSACTIONS
- Explicit Transaction
- Implicit Transaction
- Collecting Statistics
- Performance Tuning and Explain Utility
- Tuning SQL Performance
- Usage of PMON
- Joins and Unions
- Inner Join
- Right Outer Join
- Left Outer Join
- Full Outer Join
- Product Join
- Join Strategies
- Merge Join
- Nested Join
- Hash Join
MODULE 8: TERADATA BASIC COMMANDS
- Collect Statistics
MODULE 9: TERADATA OBJECTS
- Multi Set table
- SET table
- Global Temporary tables
- Volatile tables
- Derived tables
- Stored Procedures
MODULE 10: TERADATA SQL ASSISTANT (QUERYMAN)
- Teradata BTEQ
- Teradata Performance Monitor
- Branching and Looping
- Batch Scripts with samples
- Importing and Exporting data through scripts
- Error handling
- Teradata Fast Load
- Advantages and Process
- Sample Scripts
- Limitations of Fast Load
MODULE 11: REAL TIME ISSUES
- Teradata Multi Load
- Limitations of Multi Load
- Working with multiple tables
- Sample Scripts
- Limitations of TPump
- Sample Scripts
- Exporting Data
- Utility Vs Parallelism
keen Technologies basically offers the online instructor-led training. Apart from that we also provide corporate training for enterprises.
Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. keen Technologies also verifies their technical background and expertise.
We record each LIVE class session you undergo through and we will share the recordings of each session/class.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers.
You will work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready.
Our Trainers will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.
The Training itself is Real-time Project Oriented.
Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.
There are some Group discounts available if the participants are more than 2.
As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, India and other parts of the world.
No Reviews found for this course.