Close
Contact Us info@learnquest.com

??WelcomeName??
??WelcomeName??
« Important Announcement » Contact Us 877-206-0106 | USA Flag
Close
Close
Close
photo

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

photo

Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.

Close
photo

Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.

title

Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Teradata Database Administration

Price
2,295 USD
3 Days
CFLQ-125
Classroom Training, Online Training
Teradata

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.
 

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run

Modality

Location

Language

Date

    Sorry, there are no public classes currently scheduled in your country.

    Please complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

View Global Schedule

Course Description

Overview

This Teradata Database Administration course is designed to provide students with in-depth knowledge of system administration for the Teradata database. Students will learn how to run a Teradata warehouse on a daily basis from the ground up.

This course can be taught using Version 12, 13, or 14. Please inform your sales representative of which version you are currently using.
 

Objectives

Upon completion of the Teradata Database Administration course, students will be able to:
  • Set up the Teradata database
  • Create databases and users
  • Allocate perm and spool space
  • Apply data protection including Transient Journal, Fallback and RAID
  • Grant and revoke security privileges
  • Load, archive and restore data
  • Implement Teradata protection features

Audience

  • IT Professionals

Prerequisites

    • None

Topics

  • The Rules of Data Warehousing
    • Teradata facts and certification
    • Teradata: brilliant by design
    • The Teradata parallel architecture
    • A logical view of the Teradata architecture
    • The Parsing Engine (PE)
    • The Parsing Engine in detail
    • The request and respond parcel
    • The Parsing Engine knows all
    • The Access Module Processors (AMPs)
    • The BYNET
    • A visual for data layout
    • Teradata is a shared nothing architecture
    • Teradata has linear scalability
    • How Teradata handles data access
    • The PE uses statistics to come up with the plan
    • When there are no statistics collected on a table
    • Teradata cabinets, nodes, VPROCs, and disks
    • A Node and its memory allocations
    • Each PE has a plan library called RTS cache
    • LAN connection for network attached clients
    • Mainframe connection to Teradata
    • Sessions and session pools
    • Teradata configuration utilities
    • Config and reconfig
  • Teradata Space
    • How permanent space is calculated
    • How permanent space is given
    • The Teradata hierarchy
    • How spool space is calculated
    • A spool space example
    • PERM, SPOOL and TEMP space
    • Space allocation review
    • AMP disks have cylinders and data blocks
    • Full cylinder read
    • Table header
    • Each table is given a table ID
    • How data blocks are dynamically built
    • Data blocks
    • How Teradata finds a row of data
    • The master index
    • The cylinder index
    • Cylinder index changes
    • How Teradata writes to an AMP
    • Writing to data blocks of equal length
    • When a data block is not big enough for a write
    • How Teradata allocates blocks
    • Block and row definitions
    • Large row versus oversized row
    • Defragmentation
    • When a cylinder becomes full
    • Another quiz on perm and spool space
  • DBC Data Dictionary Tables
    • Data dictionary directory
    • The parsing engine has data dictionary cache
    • Data dictionary directory tables
    • System views
    • Accessing restricted views
    • Selecting information about created objects
    • Children view
    • Databases view
    • DBC.Users view
    • Indices view
    • AllTempTables view
    • Finding table names using the LIKE command
    • Finding table names in a particular database
    • Using the keyword USER on DBC views
    • Using DBC.AMPUsage
    • Using DBC.TableSize
    • Keeping track of logons and logoffs
  • Access Rights, Roles and Profiles
    • Access rights
    • Automatic, implicit, and explicit rights
    • Tools for finding access rights
    • The REVOKE statement
    • Roles
    • Creating roles
    • Setting and modifying roles
    • DBC.RoleInfo and DBC.RoleInfoX
    • Profiles
    • Creating profiles
    • Modifying profiles
    • DBC.ProfileInfo and DBC.ProfileInfoX
  • DBS Control
    • DBS control record — general fields
    • DBS control record — file system fields
    • DBS control record — performance fields
    • DBS control records you should know about
    • DBSControl — performance columns
  • Query Analysis and Tools
    • Database Query Log (DBQL)
    • DBQL collection options
    • DBQL tables and views
    • How to begin logging for DBQM
    • Access logging
    • Statistics wizard
    • Index wizard
    • TSET
    • Teradata visual explain utility
  • Teradata Protection Features
    • Transaction concept & Transient Journal
    • How the Transient Journal works
    • FALLBACK protection
    • How Fallback works
    • Fallback clusters
    • Down AMP Recovery Journal (DARJ)
    • Redundant Array of Independent Disks (RAID)
    • Cliques
    • Cliques — a two node example
    • Cliques — a four node example
    • Permanent Journal
    • Table create with Fallback and Permanent Journaling
    • TDQM
  • Starting and Stopping Teradata
    • Restarts of the Teradata database
    • Automatic restarts
    • Hardware failures
    • Critical database errors
    • UNIX operating system restarts
    • DBA forced restarts
    • Restarting in UNIX
    • Restarting the DB Window (UNIX Only)
    • Restarting in Windows 2000
    • Startup and recovery
    • Transaction recovery
    • Performing online and offline catch-up
  • Databases, Users and Accounting
    • Creating a database
    • Creating a user
    • Modifying and deleting a user
    • Specifying account priorities
    • System accounting
    • System accounting views
    • DBC.AcountInfo[x] view
    • DBC.AMPUsage view
  • Views and Macros
    • Creating views
    • Creating simple views and views that join tables
    • How to change a view using REPLACE
    • How to drop a view
    • View aggregation
    • Using “Locking for Access” in views
    • You can update tables through views
    • Restricting update rows with check option
    • Creating macros
    • Why the PE loves the macro
    • Creating a macro
    • Macros that use parameters
    • Changing a macro using REPLACE
    • How to execute a macro
    • How to drop a macro
  • System Access Control Levels
    • Teradata password encryption
    • Password security features
    • Host logon processing
    • GRANT/REVOKE LOGON statement
    • Session related views
    • DBC.SessionInfo view
    • DBC
    • Data access information views
    • AccLogRules views
    • AccessLog views
  • Priority Scheduler
    • Priority scheduler partition hierarchy
    • Priority scheduler hierarchy definitions
    • Resource partition example
    • Multiple resource partitions example
    • Scheduling policies
    • Performance periods
  • Teradata Manager
    • Teradata manager applications
    • Teradata dashboard — new feature
    • Workload trend analysis/data collector — new feature
    • Priority scheduler administrator — new feature
    • Teradata manager service
    • Starting teradata manager
    • Enable data collection
  • Monitoring Tools
    • Performance monitor - overview
    • Performance monitor
    • Performance monitor — continued
    • PMON main window
    • PMON sessions screen
    • Viewing session status
    • Monitoring session status
    • Session status report descriptions
    • Teradata administrator (WinDDI)
    • Teradata manager dynamic utilization charting
    • The alert facility and viewer
    • The alert viewer
    • The alert policy editor
    • Locking logger
    • Locking logger functions
    • Xperfstate
    • Teradata manager remote console
  • Teradata Remote Console Utilities
    • Starting the database window (DBW)
    • QRYCONFIG
    • QRYSESSN
    • RCVMANAGER (recovery manager)
    • SHOWLOCKS
    • VPROCMANAGER
    • FERRET UTILITY (file reconfiguration tool)
    • SHOWSPACE
    • SHOWBLOCKS
    • PACKDISK
    • SCANDISK
  • Resource Usage Data
    • ResUsage collection and logging
    • Setting resource logging - DBW
    • Collection costs
    • Resource usage tables
    • ResNode macros
    • ResNode macros - continued
    • RSSMon
  • Loading the Data
    • Fastload
    • FastLoad has some limits
    • Three key requirements for FastLoad to run
    • Maximum of 15 loads
    • FastLoad has two phases
    • PHASE 1: acquisition
    • PHASE 2: application
    • Fastload example
    • Restarting FastLoad
    • How the Checkpoint option works
    • Restarting with Checkpoint
    • MultiLoad
    • Two MultiLoad modes: IMPORT and DELETE
    • Block and tackle approach
    • MultiLoad imposes limits
    • RESTARTing Multiload
    • RELEASE MLOAD: when you don’t want to restart MultiLoad
    • TPump
    • Why it is called “TPump”
    • TPump has many unbelievable abilities
    • TPump has some limits
    • LOAD parameters in common with MultiLoad
    • .BEGIN LOAD parameters unique to TPump
    • A simple TPump script — a look at the basics
    • TPump script with error treatment options
    • RESTARTing TPump
    • TPump and MultiLoad comparison chart
    • Fastexport
    • How FastExport works
    • FastExport fundamentals
    • FastExport supported operating systems
    • Maximum of 15 loads
  • Archiving Data
    • Archive and recovery statements
    • Recovery vs. FastLoad
    • Invoking archive
    • Invoking archive - continued
    • Restart log
    • ANALYZE statement
    • Archive
    • Database DBC archive
    • Indexes option
    • Database DBC archive
    • Archive and Recovery (ARC) examples
  • Restoring Data
    • The RESTORE statement
    • COPY statement
    • Copying tables
    • BUILD statement
    • RELEASE LOCK statement
    2023 Top 20 Training Industry Company - IT Training

    Need Help?

    Call us at 877-206-0106 or e-mail us at info@learnquest.com

    Personalized Solutions

    Need a personalized solution for your Training? Contact us, and one of our training advisors will help you find the best solution.

    Contact Us

    Need Help?

    Do you have a question about the courses, instruction, or materials covered? Do you need help finding which course is best for you? We are here to help!

    Talk to us

    Cybersecurity Awareness Month 2024

    Get Ahead of Online Threats with 20% Off Security Training.

    Use SECURITY20 at checkout. Valid through October 31, 2024.

    Browse Training Courses

    IBM TechXchange Conference 2024

    October 21-24 | Mandalay Bay, Las Vegas

    Join us for four action-packed days to immerse yourself in innovation and learning. Gain practical skills in Generative AI, harness IBM technology, and engage with tech industry experts.

    Self-Paced Training Info

    Learn at your own pace with anytime, anywhere training

    • Same in-demand topics as instructor-led public and private classes.
    • Standalone learning or supplemental reinforcement.
    • e-Learning content varies by course and technology.
    • View the Self-Paced version of this outline and what is included in the SPVC course.
    • Learn more about e-Learning

    Course Added To Shopping Cart

    bla

    bla

    bla

    bla

    bla

    bla

    Self-Paced Training Terms & Conditions

    ??spvc-wbt-warning??

    Exam Terms & Conditions

    ??exam-warning??
    ??group-training-form-area??
    ??how-can-we-help-you-area??
    ??personalized-form-area??
    ??request-quote-area??

    Sorry, there are no classes that meet your criteria.

    Please contact us to schedule a class.
    Close

    self-paced
    STOP! Before You Leave

    Save 0% on this course!

    Take advantage of our online-only offer & save 0% on any course !

    Promo Code skip0 will be applied to your registration

    Close
    Nothing yet
    here's the message from the cart

    To view the cart, you can click "View Cart" on the right side of the heading on each page
    Add to cart clicker.

    Purchase Information

    ??elearning-coursenumber?? ??coursename??
    View Cart

    title

    Date: xxx

    Location: xxx

    Time: xxx

    Price: xxx

    Please take a moment to fill out this form. We will get back to you as soon as possible.

    All fields marked with an asterisk (*) are mandatory.

    If you would like to request a quote for 5 or more students, please contact CustomerService@learnquest.com to be assigned an account representative.

    Need more Information?

    Speak with our training specialists to continue your learning journey.

     

    Delivery Formats

    Close

    By submitting this form, I agree to LearnQuest's Terms and Conditions

    heres the new schedule
    This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
    Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.