Course: Teradata 14 Fundamentals

$139.00
$168.19 incl. vat

duration: 11 hours |

Language: English (US) |

access duration: 90 days |

Details

In this course you will learn the basics and most common benefits of Teradata including what a data warehouse is along with its architecture and design, an overview of a relational database system and the hardware and software used by Teradata for the database architecture. At the end of this coursre you will learn about security, data storage, features such as RAID, failover, cliques and hot standby.

Result

After completing this course you are familiar with the basics and benefits of Teradata 14.

Prerequisites

You have basic experience with databases.

Target audience

Database Administrators

Content

Teradata 14 Fundamentals

11 hours

Teradata Basics: Relational Database and Data Warehouse Basics

  • start the course
  • identify what Teradata has to offer
  • describe what a data warehouse is and how it is used with Teradata
  • describe an active data warehouse in Teradata
  • describe Teradata active solutions, including
  • describe the concepts of a relational database system and its terminology
  • describe the goals of a Teradata data warehouse and its architecture
  • describe data marts and when they are appropriate to use with Teradata
  • describe the enterprise data model
  • identify the database design life cycle and how logical data modeling is completed
  • describe the three-schema architecture
  • identify the Teradata logical data model frameworks and their pros and cons
  • describe performing entity relationships analysis for semantic data modeling
  • identify entities, attributes, and relationships in a E-R logical model
  • describe the normalization process
  • identify the capabilities of a Teradata database, its software, and tools
  • identify the main components of a Teradata architecture
  • describe the parsing engine in a Teradata database
  • describe the BYNET and how it is used in a Teradata database
  • describe AMPs and how they are used in a Teradata database
  • describe Teradatas virtual storage, its benefits, and considerations
  • identify how Teradata uses intelligent memory
  • describe how Teradata perform request processing using the dispatcher and AMPs
  • identify and describe the Teradata database and architecture concepts

Teradata Basics: Communication and Database Security

  • start the course
  • identify the workstation attachment methods used to connect clients to a Teradata database
  • describe Teradata's mainframe attachment method that provides the interface between applications and TDP on a mainframe client
  • describe how the ODBC driver for Teradata is used for workstation attached systems
  • describe how the JDBC driver for Teradata is used for workstation attached systems
  • describe the OLE DB data provider for Teradata workstation attached systems
  • identify the different objects within a Teradata database
  • describe Teradata databases and users
  • identify the security elements used in a Teradata database
  • identify the different database privileges and roles in Teradata
  • identify the authentication methods, logon format and controls, and password format requirements
  • identify how Teradata protects data in a database
  • create a Teradata database
  • create a user in Teradata
  • create profiles in Teradata
  • create roles in Teradata
  • grant privileges directly to users in Teradata
  • manage Teradata database passwords
  • describe the login techniques and elements for logging into Teradata
  • login to a Teradata database using database authentication and authorization
  • login to a Teradata database using LDAP authentication and authorization
  • login to a Teradata database using single sign-on and sign-on as
  • create and use views to implement security measures in Teradata
  • create and use macros to implement security measures in Teradata
  • create and use UDFs to implement security measures in Teradata
  • describe and implement client communication and database security for a Teradata database

Teradata Basics: Data Storage and Access Methods

  • start the course
  • describe how indexes are defined and used in Teradata
  • identify the different types of indexes that can be used in Teradata
  • describe the different types of primary indexes, UPI, NUPI, used in Teradata and how data is processed with the index
  • describe a NoPI object in Teradata and when it is used, and its benefits
  • describe PPI, and their advantages and disadvantages
  • create the different types of primary indexes in Teradata
  • partition tables using NoPI and PPI in Teradata
  • describe and create column partitioning on Teradata tables
  • describe secondary index use in a Teradata Database
  • describe data accessing using USI and NUSI in Teradata databases
  • create USI and NUSI in Teradata
  • identify the different types of join indexes that can be used in Teradata
  • identify when to use a join index in Teradata and their storage
  • create join indexes in Teradata
  • use the EXPLAIN request modifiers to determine the usefulness of indexes in a Teradata database
  • identify when and how a full-table scan is used to access data in Teradata tables
  • identify SQL queries that will use an index or perform a full-table scan in Teradata
  • describe how Teradata uses locking and the different types of locks
  • identifying the locking considerations in a Teradata database
  • describe how the two-phase locking and serializability works in Teradata
  • use the LOCKING request modifier in a Teradata SQL read operation
  • describe a deadlock and how they are handled in a Teradata database
  • describe how perm, spool, and TEMP are used to manage space for a user
  • estimate space requirements in Teradata
  • describe how fallback and journaling are used for data protection in Teradata
  • describe how cliques, hot standby, and RAID are used for data protection in Teradata
  • describe how RAID is used for data protection in Teradata
  • create the different types of indexes for a Teradata database, use locking, and describe performance availability features

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

read more about the order process

What is included?

Certificate of participation Yes
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact