TERADATA DBA ONLINE TRAINING

For more details Please contact LEARNCHASE
www.learnchase.com
Whatsapp: +918123930940
E-mail Id: [email protected]
E-mail id: [email protected]

TERADATA DBA ONLINE TRAINING

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

For more details Please contact LEARNCHASE
www.learnchase.com
Whatsapp: +918123930940
E-mail Id: [email protected]
E-mail id: [email protected]