Course: Teradata 14 Fundamentals
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
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 immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
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
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
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.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.