Course Outline
Introduction to Teradata
- Background
- Why use Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
Set Up and Installation
- Installation
- Tools and Utilities like BTEQ
Teradata Architecture
- Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture
- Retrieval Architecture
- Architectural Overview
Teradata Basic Concepts - SQL
- Data Type
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set v/s Multiset Tables
- Playing with Data - CRUD Operations [DDL and DML]
- Logical and Conditional Operators
- SET Operators
- String Manipulation
- Date/Time
- Built in and Aggregate Functions
- Joins and Subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- Case
- Coalesce
- Macros
- Stored Procedures
- Space
- Temp
- Spool
- Permanent
- Join Strategies
- Statistics
- Compression
- Hashing Algorithm
- OLAP Functions
- User Management
Teradata Additional Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Requirements
Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course.
Testimonials
Excercises were good, trainer was helpful. I also assume that trainer adapted a little to our knowledge after first day.
- Capgemini Polska sp. z o.o.
Trainer's enthusiasm and energy
- Capgemini Polska sp. z o.o.
Tips to improve performance
- Capgemini Polska sp. z o.o.
the good energy of the trainer, he explained everything clearly and precisely
MicroStrategy Poland Sp. z o.o.
Materials (code, presentation) were good
MicroStrategy Poland Sp. z o.o.
Nice training, full of interesting topics. After each topic helpful examples were provided.
Pawel Wojcikowski - MicroStrategy Poland Sp. z o.o.
I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.
MicroStrategy Poland Sp. z o.o.
interaction
Maastricht University | UMIO
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
exercises & subquery
Maastricht University | UMIO
I liked the depth of the training. I was able to understand most of it and definitely learned from this training
Maastricht University | UMIO
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
x
Maastricht University | UMIO
New learned skills
Maastricht University | UMIO
The enthusiasm of the trainer
Maastricht University | UMIO
Explaining the step to take when trying to answer a question via the SQL
Maastricht University | UMIO
wide aspect of Teradata knolwedge - starting basic architecture monitoring finishing
MicroStrategy Poland Sp. z o.o.
Related Courses
Advanced Teradata
14 hoursTeradata is a popular Relational Database Management System for building large scale data warehousing applications. Teradata achieves this by way of parallelism. This instructor-led, live training (online or onsite) is aimed at application
Big Data Analytics for Telecom Regulators
14 hoursTo meet compliance of the regulators, CSPs (Communication service providers) can tap into Big Data Analytics which not only help them to meet compliance but within the scope of same project they can increase customer satisfaction and thus
Big Data Architect
35 hoursDay 1 - provides a high-level overview of essential Big Data topic areas. The module is divided into a series of sections, each of which is accompanied by a hands-on exercise. Day 2 - explores a range of topics that relate analysis practices and
Big Data and its Management Process
14 hoursObjective : This training course aims at helping attendees understand why Big Data is changing our lives and how it is altering the way businesses see us as consumers. Indeed, users of big data in businesses find that big data unleashes a
Big Data - Data Science
14 hoursThis classroom based training session will explore Big Data. Delegates will have computer based examples and case study exercises to undertake with relevant big data tools
Vespa: Serving Large-Scale Data in Real-Time
14 hoursVespa is an open-source big data processing and serving engine created by Yahoo. It is used to respond to user queries, make recommendations, and provide personalized content and advertisements in real-time. This instructor-led, live
Big Data Business Intelligence for Govt. Agencies
35 hoursAdvances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of
Big Data Business Intelligence for Criminal Intelligence Analysis
35 hoursAdvances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these
From Data to Decision with Big Data and Predictive Analytics
21 hoursAudience If you try to make sense out of the data you have access to or want to analyse unstructured data available on the net (like Twitter, Linked in, etc...) this course is for you. It is mostly aimed at decision makers and people who need to
Programming with Big Data in R
21 hoursBig Data is a term that refers to solutions destined for storing and processing large data sets. Developed by Google initially, these Big Data solutions have evolved and inspired other similar projects, many of which are available as open-source. R
Big Data Storage Solution - NoSQL
14 hoursWhen traditional storage technologies don't handle the amount of data you need to store there are hundereds of alternatives. This course try to guide the participants what are alternatives for storing and analyzing Big Data and what are theirs
A Practical Introduction to Data Analysis and Big Data
35 hoursParticipants who complete this instructor-led, live training will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools. Participants will have the opportunity to put this knowledge into
SQL For Data Science and Data Analysis
14 hoursThis instructor-led, live training (online or onsite) is aimed at software developers, managers, and business analyst who wish to use big data systems to store and retrieve large amounts of data. By the end of this training,
Big Data & Database Systems Fundamentals
14 hoursThe course is part of the Data Scientist skill set (Domain: Data and Technology).
Data Science for Big Data Analytics
35 hoursBig data is data sets that are so voluminous and complex that traditional data processing application software are inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer,