1 / 13

teradata online training

Keentechnologies provides the best online training. All the software courses such as sap, oracle, dataware house, java, testing tools etc will be provided by the real time experts with practical knowledge.

srinivas
Download Presentation

teradata online training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Teradata online training course http://www.keentechnologies.com To request free demo session please mail us at trainings@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 Teradata…Teradata v12 & next versionsTeradata HistoryTeradata users scalabilityTeradata and other R-DBMS’sTeradata is a warehouseTeradata in the Enterprise levelInterview Quotations & Answers and Certification supportReal time Scenarios & Problems – Solutions

  4. TERADATA ARCHITECTURE & IT’S 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 @91+9989754807 contact: trainings@keentechnologies.com website url: http://www.keentechnologies.com

  13. THANK YOU

More Related