
Teradata Certification Associate Exam Practice Guide
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Person
Content
- Intro
- Chapter 1 - Database Concepts
- Teradata Certification Exams, Releases, and Websites
- Teradata Database Certification and Exam Path
- Teradata Associate Exam Objectives and Section Weightings
- What is Parallel Processing?
- What is a Database?
- What is SQL?
- How Can You Use a Database?
- There are Two Types of Databases
- Relational Database Model and Mathematical Set Theory Concepts
- Relational Term Review
- Rules for Teradata Databases, Tables, and Columns
- What is a Constraint?
- What is the Difference Between a Primary Key and a Foreign Key?
- Referential Integrity
- Quiz - Logical Model Primary Key Quiz
- Answer - Logical Model Primary Key Quiz
- Quiz - Logical Model Foreign Key Quiz
- Answer - Logical Model Foreign Key Quiz
- Dimensional Model - One Fact Table and Many Dimension Tables
- Quiz - What is the Primary Key of the Fact Table?
- Answer - What is the Primary Key of the Fact Table?
- Quiz - Name the Foreign Keys
- Answer - Name the Foreign Keys
- What is a Star Schema?
- Normalization
- A Denormalized Table
- Getting to First Normal Form
- A Table that is in Second Normal Form
- Tables Reaching Third Normal Form
- Dimensional Modeling
- What are the Advantages of a Normalized vs. Dimensional Model?
- Logical Data Model vs. Physical Data Model
- Logical Data Model vs. Physical Data Model Example
- Data Warehouses are Designed for Analytics
- The Four Stages of Modeling for Teradata
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Chapter 2 - Data Warehouse Architecture
- A Distributed (Federated) Architecture vs. a Centralized Architecture
- What is a Data Mart?
- Independent Data Marts
- Dependent Data Marts
- Logical Data Marts
- Data Warehouse Architecture Layers
- How Data Flows Through a Data Warehouse
- Reasons to Deploy a Data Warehouse
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Chapter 3 - Architecture and Components
- Teradata Everywhere
- The Parsing Engine
- The AMPs Responsibilities
- Two Ways to Connect to Teradata
- Features that are Unique to Teradata
- How is the Teradata Database Used?
- Objects within the Teradata Database
- Set Table vs. Multiset Table
- Data Types
- Partitioned Tables
- Views
- Macro
- Trigger
- Stored Procedures
- Join Index
- Database vs. User
- Metadata - Object Management - Data Dictionary
- The Data Dictionary Resides in User DBC
- BYNET Network is the Communication Glue
- A Node
- Teradata Virtual Storage Tracks Hot, Medium and Cold Data
- Nodes Connect with the BYNET Networks
- Message Passing Layer or Communications Layer
- Parallel Database Extensions (PDE)
- Fallback Protects Against an AMP Failure
- Raid 1 Mirroring Protects Against a Disk Failure
- Cliques Protect Against a Node Failure
- How Cliques are Physically Defined
- Cliques are cabled so Migrating AMPs can access their Disks
- Teradata has Three Types of Space
- All Space is Calculated on a Per AMP Average
- How Spool Works
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Chapter 4 - Data Distribution and Access
- Primary Index Option #1 - Unique Primary Index (UPI)
- Primary Index Option #1 - Unique Primary Index (UPI) Query
- Primary Index Option #2 - Non-Unique Primary Index (NUPI)
- Primary Index Option #2 - Non-Unique Primary Index (NUPI) Query
- Using EXPLAIN in a Primary Index Query
- Primary Index Option #3 - Multi-Column Primary Index
- Primary Index Option #3 - Multi-Column Primary Index Query
- Primary Index Option #4 - No Primary Index Spreads Data Evenly
- Table CREATE Examples with four different Primary Indexes
- Teradata Tables that are Partitioned are called PPI Tables
- Teradata has Columnar Tables
- Unique Secondary Index (USI)
- Non-Unique Secondary Index (NUSI)
- Using a Simple Global Temporary Table
- Review Questions
- Review Questions
- Review Questions
- Chapter 5 - Security and Privacy
- Four Types of Locks in Teradata
- Lock Compatibility
- Lock Chart
- User Security - Password and Role
- Access Rights/Privileges
- Profiles
- Authentication and Middle-Tier Applications
- Privacy Mechanisms via Secure Zones
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Review Questions
- Chapter 6 - Teradata Tools and Utilities
- What is TPT?
- Teradata Parallel Transporter (TPT) Operators
- Teradata Parallel Transporter (TPT) Operators
- Other Important TPT Operators
- Teradata Unity for Managing Multiple Teradata Systems
- TASM - Teradata Active Systems Management
- What is TASM?
- What is the Secret Sauce for TASM?
- Teradata Studio
- Teradata Viewpoint
- The Add Content Menu for Monitoring
- Adding Multiple Portals to a Single Page
- Teradata Listener
- Teradata AppCenter
- Review Questions
- Review Questions
- Review Questions
- Review Questions
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.