Teradata Certification Training

Access Duration - 365 Days
4.5( 2 REVIEWS )
2 STUDENTS
£.00
 

What Will I Learn?

Understand the competitive advantage of Teradata over RDBMSs
Understand the architecture and indexing mechanism of Teradata
Process data stored in Teradata tables using SQL
Import and export data using Teradata application
Optimise queries using performance turning techniques

Overview

If you wish to become a developer or designer, the Teradata Certification Training is designed to provide individuals in-detail information on Teradata architecture, and how to store and retrieve data. The course features basic to advance features of SQL operations using Teradata. Warehousing applications are developed using Teradata. The course will enable learners to apply your skills in real-life projects and acquire work and industry exposure.

The Teradata Fundamentals Certification Training will cover key topics that will get learners up to date on the role of Teradata in processing, and importing and exporting data. It is a comprehensive guide that will give you an understanding on database function and components, factors impacting data storage and administrative tools.

The Teradata Fundamentals Certification Training will help you master the skills required to efficiently use Teradata in your design and development projects. Qualifying in this course will set you in the right direction, giving you the opportunity to open the door to new and exciting job roles in design and development.

Why You Should Consider Taking this Course at Global Edulink?

Global Edulink is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive course awarded by CPD. At Global Edulink, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course.  Learners who register will be given excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.

  • Access Duration
  • Who is this Course for?
  • Entry Requirement
  • Method of Assessment
  • Certification
  • Awarding Body
  • Career Path & Progression
The course will be delivered directly to you, and from the date you joined the course you have 12 months of access to the online learning platform. The course is self-paced, and you can complete it in stages at any time.
This course is recommended for,
  • Developers
  • Designers
  • Analytics Managers
  • Individuals contributors employed in Enterprise Business Intelligence
  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • A sound educational background is recommended
  • Basic knowledge of SQL is recommended
In order to qualify in the course ‘Teradata Fundamentals Certification Training’ successfully, learners will take an online test with each module being rounded off with multiple-choice questions. This online test is marked automatically, so you will receive an instant grade and know whether you have passed the course.
Upon the successful completion of the course, you will be awarded the Teradata Fundamentals Certification Training by CPD.
CPD is a leading awarding body in the United Kingdom that meets an excellent standard of high quality education. CPD is committed towards the enhancement of proficiency and personal skills in order to develop learners’ skills and abilities. CPD ensures that both practical and academic qualifications assist individuals to re-skill or up-skill and maintain a competitive advantage in their chosen industry.
Teradata Fundamentals Certification Training will improve your candidature for a number of jobs in design and development.  You can study further courses in the same field and enhance your academic expertise in Teradata architecture, and add this as a valuable skillset on your resume. Your skills will be recognised by leading organisations that give you the opportunity to land a well-paying job. Given below are job titles you can compete for, along with the average UK salary per annum according to https://www.glassdoor.com.
  • Developer - £69,000 (Approximately)
  • Designer - £45,000 (Approximately)

Key Features

Gain an Accredited UK Qualification
Access to Excellent Quality Study Materials
Personalised Learning Experience
Support by Phone, Live Chat, and Email
Eligible for TOTUM Discount Card
UK Register of Learning Providers Reg No : 10053842

Course Curriculum

1: Teradata - An Overview
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
2: Teradata Indexes and Join Strategies
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
3: Teradata SQL
 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)
4: Data Protection
Transaction locks
Fallback tables
Clusters
Permanent Journal
 Down AMP Recovery Journal
Transient Journal
Cliques
Hot Standby nodes
RAID 1 & RAID 5
Data Dictionary
5: SQL Advanced
Sub queries
Upsert
 Case
Coalesce
Nullif
OLAP Functions
Rank & Row Number
Transaction Modes
Temporary Tables (Derived, Volatile and Global Temporary)
Explain
Collect Statistics
6: Advanced Database objects and performance optimization
Views
Macros
Stored Procedure
Join Index
Performance Tuning tips
7: Teradata Utilities - FastLoad, MultiLoad, BTEQ
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
8: Teradata Utilities - FastExport,TPT
 FastExport Exporting data from Teradata
 TPT overview
TPT Export
TPT SQL Selector
TPT Load
TPT Update Comparison of Load/Unload Utilities

Students feedback

4.5

Average rating (2)
4.5
5 Star
4 Star
3 Star
2 Star
1 Star
    S M

    Steff Mason

    January 13, 2021
    Key course

    The course explained the features and functions of Teradata. I gained extensive expertise and knowledge through this course.

    S H

    Skyler Hopkins

    December 27, 2020
    Great!

    Superb course! Thank you

£.00
WhatsApp chat