Locking & Data Protection

Teradata 14
  • 11 Videos | 1h 2m 53s
  • Includes Assessment
  • Earns a Badge
Likes 2 Likes 2
To control concurrency, Teradata uses different locking mechanisms. Discover the different locking mechanisms and performance availability features, such as RAID, failover, cliques, and hot standby.

WHAT YOU WILL LEARN

  • describe how Teradata uses locking and the different types of locks
    identifying the locking conderations 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

IN THIS COURSE

  • Playable
    1. 
    Overview of Locking
    4m 57s
    UP NEXT
  • Playable
    2. 
    Locking Considerations
    5m 22s
  • Locked
    3. 
    Two-Phasing Locking and Serializability
    6m 12s
  • Locked
    4. 
    Using the LOCKING Request Modifier
    5m 10s
  • Locked
    5. 
    Understanding Deadlocks
    5m 1s
  • Locked
    6. 
    Managing Space
    7m 18s
  • Locked
    7. 
    Estimating Space Requirements
    4m 28s
  • Locked
    8. 
    Overview of Fallback and Journals
    4m 41s
  • Locked
    9. 
    Overview of Cliques and Hot Standby Nodes
    3m 5s
  • Locked
    10. 
    Overview RAID
    6m 31s
  • Locked
    11. 
    Exercise: Create Indexes and Use locking
    5m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  
Likes 0 Likes 0  
COURSE Clustering
Likes 4 Likes 4