teradata online training

1
Teradata online training course


http//www.keentechnologies.com
To request free demo session please mail
us at trainings_at_keentechnologies.com
or call us at  91-9989754807
2

• Introduction
• Teradata is a fully scalable relational
  database management process produced by Teradata
  Corp. It is mostly used to manage large data for
  warehousing operations.
• The Teradata database process is based on
  off-the-shelf symmetric multiprocessing know-how
  combined with communication networking,
  connecting symmetric multiprocessing systems to
  form large parallel processing systems.

3

• Teradata data course content
• What is TeradataTeradata v12 next
  versionsTeradata HistoryTeradata users
  scalabilityTeradata and other R-DBMSsTeradata
  is a warehouseTeradata in the Enterprise
  levelInterview Quotations Answers and
  Certification supportReal time Scenarios
  Problems Solutions

4

• TERADATA ARCHITECTURE ITS COMPONENTS
• Node Architecture (Shared Architecture) SMP
  Architecture MPP Architecture Parsing
  engine(PE) Architecture AMP Architecture
  usage By net Benefits and types Parallel
  data extension-(PDE) Teradata directory
  program(TDP) Call level interface-(CLI)
  Trusted parallel application-(TPA) Virtual
  processors

5

• Teradata Warehouse and competitiveness
• Opportunities of Teradata in the enterprise.
• What is Teradata-rdbms/DWH?
• Teradata 13.10 Other versions(12,v2r7,v2r6).
• Teradata History and Real-time running versions.
• Teradata competitiveness with other RDBMS . Diff
  between them.
• Teradata Warehouse and Usability.
• Teradata single and Multi system Architectures
• Node Architecture
• SMP Architecture
• MPP Architecture
• Discussion on AMPS and NODES

6

• TERADATA INDEXES
• Types of indexes in Teradata Hash index
  Join index Primary index(unique, non- unique)
  Secondary index(unique, non- unique)
  Skewness Keys indexes (How why these used)
• HOW TO STORAGE RETRIEVAL OF DATA
• Hash algorithm hash Hash map Hash
  bucket Receiving VDisc

7

• TERADATA SQL QUARRYMAN
• SQL fundamentalsData types and literalsDDL
  StatementsDML StatementsTeradata naming
  conversing
• TERADATA JOIN STRATEGIES UNIONS
• hash joinmerge joinnested joinproduct
  joininner joinleft right outer joinfull
  outer join

8

• TERADATA BASIC COMMANDS
• Help Show Explain Collect statistics
• TERADATA MEMORY SPACES
• Permanent spaces Temporary spaces
  Spool spaces Users spaces PWD

9

• Performance Tunning and Explain utility
• Explain request Modifier
• Collect Statics,Confidence Levels
• Tunning SQL Queries and Utilities
• Usage of PMON, Index Statistics Wizards
• Various Indexes
• Skew factor, Skewness, Remeddies Spool Space
  Issues
• LOAD AND UNLOAD UTILITIES(20 hrs)
• Teradata SQL Assistant(SQLA)
• Teradata BTEQ
• Teradata FASTLOAD? Teradata MULTILOAD
• Teradata FASTEXPORT
• Teradata TPUMP

10

• TERADATA TRANSACTION MODES
• Batch modeBTET modeANSI modeHow Converted into
  others
• TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE
• Usage of PMONExplain usageCollecting
  statisticsSQL tuningVarious SQL statementsReal
  time Issues resolving

11

• Teradata Pratical (DBA Related concepts)
• Teradata server starting/stopping
• Working with Teradata sql Assistant and BTEQ
• Creating Database and Manipulation
• Creating User and Manipulation
• Managing Databases and users
• Data Dictionary and Views
• Working with Teradata Administration Tool

12

• if you require any further information please do
  not hesitate to contact us
  please feel free to mail us for demo session or
  call _at_919989754807 contact
  trainings_at_keentechnologies.com
  website url http//www.keentechnologies.com 

13

• THANK YOU