Register for Demo Class

For Online Training

We are the No1 Leading Provider for Online Training

Video Reviews

Reviews

Besant Technologies
5 Star Rating: Recommended 4.9 out of 5 based on 3802 reviews.

Review Source:









Bangalore Support

E : traininginblr[at]gmail.com

BTM Layout :
+(91) 762 494 1772
+(91) 762 494 1774


Marathahalli :
+(91) 910 812 6341
+(91) 910 812 6342


Rajaji Nagar :
+(91) 734 915 0004
+(91) 734 916 0004
+(91) 755 011 2282 | +(91) 755 023 5062|traininginblr[at]gmail.com

Teradata DBA Training in BTM Layout

Home/Teradata DBA Training in BTM Layout
Teradata DBA Training in BTM Layout 2018-04-26T17:40:02+00:00

Session : 1 – TERADATA Architecture

  • Parsing Engine(PE)
  • Request and Response Parcel
  • Access Module Processors (AMPs)
  • Bynet
  • Data access Handling
  • TD Config Utilities
  • Config and Reconfig

Session : 2 – TERADATA Database Space

  • Permanent Space
  • Spool Space
  • Temp Space
  • Indexes

Session : 3 – DBC Dictionary Tables

  • Data dictionary
  • Parsing Engine
  • System Views
  • Database Views
  • DBC Users View
  • Indices View
  • All Temp Tables View
  • Using DBC AMP Usage
  • Using DBC Table Size
  • Logon and Logoff Tracking.

Session : 4 – Access Rights, Roles, Profiles

  • Access rights (Auto,implicit,Explicit Rights)
  • Roles and Profiles
  • Creating Roles and Profiles
  • DBC.RoleInfo and DBC.ProfileInfo

Query analysis and Tools

  • Database Query Log (DBQL)
  • DBQL Tables and Views
  • Access Logging

Session : 5 – System Access Control Level

  • TD Password Encryption
  • Password Security Features
  • Host Logon Processing
  • GRANT/REVOKE LOGON
  • Session Related Views
  • DBC.sessionInfo Info View
  • Data Access Info Views
  • Access LogRules Views
  • Access Log Views

Session : 6 – TD Manager

  • TD Manager Apps
  • TD Dashboard
  • Priority Scheduler Admin
  • TD Manager Service
  • Starting TD Manager

Session : 7 – Monitoring tools

  • Performance Monitor
  • PMON Main window
  • PMON sessions Screen
  • TD Administrator
  • TD manager Dynamic Utilization Charting
  • Locking Logger

Session : 8 – TD Remote Console Utilities

  • Starting DB Window
  • QRYCONFIG
  • QRYSESSN
  • RCVMANAGER
  • SHOWLOCKS
  • VPROCMANAGER
  • SHOWSPACE
  • SHOWBLOCKS
  • PACKDISK
  • SCANDISK

Session : 9 – Archiving Data

  • Archive and Recovery Statements
  • Recovery vs. FastLoad
  • Invoking Archive
  • Restart Log
  • ANALYZE Statement
  • Archive
  • Database DBC Archive
  • Indexes option
  • Database DBC Archive
  • Archive and Recovery (ARC) Examples

Session : 10 – Restoring data

  • Restore
  • COPY
  • Copying Tables
  • BUILD

Weekdays Batch

Starts Duration Days Time (IST)
11th Sept 4 Weeks Mon – Fri 07:30AM – 09:00AM
13th Sept 4 Weeks Mon – Fri 09:00AM – 10:30AM
18th Sept 4 Weeks Mon – Fri 07:00PM – 08:30PM
20th Sept 4 Weeks Mon – Fri 07:30AM – 09:00AM
25th Sept 4 Weeks Mon – Fri 09:00AM – 10:30AM
27th Sept 4 Weeks Mon – Fri 07:00PM – 08:30PM
Schedule does not suit you, contact us @7550112282 | Want to take one-on-one training, contact us now!

Weekend Batch

Starts Duration Days Time (IST)
09th Sept 6 Weeks Sat & Sun 10:30AM – 01:00PM
16th Sept 6 Weeks Sat & Sun 09:00AM – 11:00AM
23rd Sept 6 Weeks Sat & Sun 11:00AM – 01:30PM
30th Sept 6 Weeks Sat & Sun 02:00PM – 04:30PM
Schedule does not suit you, contact us @7550112282 | Want to take one-on-one training, contact us now!

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya

Quick Enquiry