Teradata

TERADATA V14 What is TeraData? TeraData architecture & it’s components Recovery&protection of Data TeraData indexes How to storage & retrieval of data TeraData SQL Quarryman TeraData SQL Functions & operations TeraData join strategies & unions TeraData basic commands TeraData objects TeraData memory spaces TeraData transaction modes TeraData performance tuning on SQL Assistance TeraData Utilities & Tools (Import & Export) TeraData Advance Topics •TeraData SQL Assistant(Quarryman) TeraData performance monitor •Database Move space •TeraData Administrator usage •TeraData performance tuning on scripts

Teradata Quality training && coaching in elegent it services 1)Introduction to Teradata Warehount it se Basics Parallel Design and Architecture 2)Data Distribution in Teradata Primary Index and its Types Secondary Index and its Types Partition Primary Index and its Types No Primary Index 3)Teradata Space Perm Space, Spool Space and Temp Space 4)Teradata Data Protection Concept of Transient Journal FALLBACK Clusters Down AMP Recovery Journal (DARJ) RAID CLIQUES 5)Teradata Locks Different Types of Locks and their Compatibility 6)Teradata Utilities Fast Export Fast Load TPUMP Multiload TPT 7)Teradata Utilities Commands SHOW HELP 8)Teradata-Basic SQL SELECT Command Usage of NULL in Comparison Operator Usage of IS NULL and IS NOT NULL Usage of IN and NOT IN Range search – BETWEEN Operator Creating Aliases Derived Columns Usage of GROUP BY, ORDER BY and HAVING CLAUSE 9)Teradata SQL – Five Aggregate Functions Usage of SUM function Usage of AVG function Usage of MIN function Usage of MAX function Usage of COUNT function 10)Teradata SQL – Interrogating Data / Data Transformations Data Formatting CAST NULLIFZERO, ZEROIFNULL and NULLIF COALESCE function CASE function 11)Formatting Date and Time Display Current Date, Time and Timestamp Extract function 12)Teradata SQL – String Manipulation TRIM function SUBSTRING function POSITION function INDEX function Concatenation function 13)Teradata OLAP functions CUMULATIVE function MOVING AVERAGE function Usage of OVER/Partition BY Clause RANK function SAMPLE function RANDOM function 14)Teradata DDL, DML, DCL CREATE TABLE – SET and MULTISET Constraint – UNIQUE and CHECK Data Compression CREATE Table with existing table ALTER, DROP, RENAME a table INSERT, UPDATE, DELETE command 15)Temporary Tables – Volatile and Global Volatile Temporary Table with example Global Temporary Table with example 16)Teradata – View, MACROS and Stored Procedures 17)Displaying TOTALS and SUBTOTALS in Reports Totals and SubTotals Total using WITH Subtotals using WITH BY clause 18)Teradata JOINS Why Joins ? LEFT OUTER JOIN RIGHT OUTER JOIN INNER JOIN CROSS JOIN SELF JOIN Join Strategies: •Duplication – Big Table Small Table •Redistribution – Big Table Small Table •Same AMP Join 19)Join Index – Denormalization in Teradata Single Table Join Index Multi-Table Join Index Aggregate Join Index Sparse Join Index Global Join Index Hash Index 20)Collect Statistics and Explain Collect Statistics Sample Collect Statistics Usage of Diagnostic HELP ON Explain – Decrypting the Optimizer Plan 21)Performance Tuning in Teradata – ‘TIPS and TECHNIQUES’ Elegant IT Services, #nd Floor, Aswath Nagar,Varthur main road, Opp Safal Fresh,Near Railway Fly Over Maratha halli,Bangalore - .Ph:-/87

Teradata DBA Training IN Chennai With Placement Peridot Systems we are offering best software training and placement in evergreen technologies like Oracle SQL PlSQL, PHP, Java, IBM Mainframe, .NET, Software Testing, Informatica, Web Designing, Android, Sharepoint, Microsoft BI, UNIX, C and C++, SHELL Scripting and more to the students. Limited Batch Strength Real Time Training Flexible Timinings Affordable Price Latest versions Free Softwares One Year Technical Support Teradata DBA Course Syllabus TERADATA Architecture TERADATA Database Space DBC Dictionary Tables TD Manager Monitoring tools TD Remote Console Utilities Archiving Data Restoring data Please DO CONTACT 9790855020 – for free demo classes Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - 600020.

Teradata DBA Training IN Chennai With Placement Peridot Systems we are offering best software training and placement in evergreen technologies like Oracle SQL PlSQL, PHP, Java, IBM Mainframe,.NET, Software Testing, Informatica, Web Designing, Android, Sharepoint, Microsoft BI, UNIX, C and C++, SHELL Scripting and more to the students. Limited Batch Strength Real Time Training Flexible Timinings Affordable Price Latest versions Free Softwares One Year Technical Support Teradata DBA Course Syllabus TERADATA Architecture TERADATA Database Space DBC Dictionary Tables TD Manager Monitoring tools TD Remote Console Utilities Archiving Data Restoring data Please DO CONTACT – for free demo classes Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - .

Teradata Developer training and tradata dba training offered in chennai. Fee for Teradata developer 5k. 40 days. Fee for Teradata DBA 5K 30 days. Normal track Daily 2 hours. Fast track full days in week ends.

Teradata Online Training at Online IT Guru with 9+ years of hands on exp. trainer,Join free demo on Online Teradata Training with 100% Live Projects.

WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS What is Teradata? Teradatav12 &versions Teradata History Teradata users scalability Teradata &other RDBMS Teradata warehouse Teradata in the Enterprise Interview Q&A and Certification queries Real time Issues & resolving TERADATA ARCHITECTURE & IT'S COMPONENTS Node Architecture(Shared Architecture) SMP Architecture MPP Architecture Parsing engine(PE) Architecture AMP Architecture &uses Bynet Benefits &types Parallel data extension(PDE) Teradata directory program(TDP) Call level interface(CLI) Trusted parallel application(TPA) Virtual processors Bynet 0 &Bynet 1 Parallism Architecture RECOVERY &PROTECTION OF DATA What is fall back &where it used Why for fall back What is Clique AMP Clustering Locks & types for simultaneous Access Why for locks &how to release RAID 1 &RAID 5 Journals &types Virtual Disk Array How & where is used journals Q & A about data recovery TERADATA INDEXES Types of indexes in Teradata Hash index Join index Primary index Secondary index Skewness Keys & indexes HOW TO STORAGE & RETRIEVAL OF DATA Hash algorithm Row hash Hash map Hash bucket Receiving VDisc TERADATA SQL QUARRYMAN SQL fundamentals Data types and literals DDL Statements DML Statements Teradata naming conversing TERADATA SQL FUNCTIONS & OPERATIONS String functions Format functions Cast functions Cast functions Group & Aggregation functions Logical operations Arithmetic operations set operations join operations conditional expressions TERADATA JOIN STRATEGIES & UNIONS hash join merge join nested join product join inner join left & right outer join full outer join TERADATA BASIC COMMANDS Help Show Explain Collect statistics TERADATA OBJECTS Types of tables Set tables Multi tables Volatile tables Global temporary tables Derived tables > Views Macros Stored procedures Triggers TERADATA MEMORY SPACES Permanent spaces Temporary spaces Spool spaces Users spaces & PWD TERADATA TRANSACTION MODES Batch mode BTET mode ANSI mode How Converted into others TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE Usage of PMON Explain usage Collecting statistics SQL tuning Various SQL statements Real time Issues & resolving TERADATA UTILITIES & TOOLS (IMPORT & EXPORT) TERADATA BTEQ SCRIPTS Overview of BTeq Looping stages Batches scripts Import &export scripts with Examples Error handling Real time scripts TERADATA FASTLOAD Types of phages & how to find it Advantages & its process Limitations of fast load Real time scripts TERADATA MULTILOAD Overview of Multi load Types of phages in MultiLoad Advantages & its process Limitations of MultiLoad Uses various types of operations Work on Multi tables Real time scripts Sample scripts TERADATA TPUMP Overview of Tpump Limitations of Tpump Work on Multi tables Real time scripts Sample scripts TERADATA FAST EXPORT How to export the data Passing parameters IN/OUT Modes Work on Multi tables Real time scripts Sample scripts Teradata SQL Assistant Teradata performance monitor Teradata Administrator usage Teradata performance tuning on scripts OTHER FEATURES: FAQS Covering DBA concepts Concentration on performance tuning Real time scenarios Certification guidance Resume preparation Sample resumes Interview & certification FAQS How to face the interview Class notes which is useful for who is trying for job Project preparation

We are providing the Best TeraData online training from India. Teradata is the world's leading provider of analytical solutions backed by the industry's best database. Introduction: Teradata Architecture and Components Data Recovery and Security Teradata Indexes Teradata Sql Reference Teradata Functions and Operators Explicit Transaction Teradata Basic Commands Teradata Objects Teradata spaces Teradata Transaction Modes Teradata Sql Assistant (Queryman) Real time Issues and resolving it Real time Issues and solving it. Keywords; Teradata online training from Hyderabad, Teradata online training classes, Teradata free Demo session online @ +91 . What is Teradata ? How Teradata work on Teradata. Contact Information; Contact: +91

We 4bs solutions are committed to provide high quality training and below are highlights of our curriculum >>Excellent Training. >>Reputed and well known for Placements history. >>Project Oriented Training. Real-time / Live Project scenarios will be provided during the training. Batches with limited number. >>Will assist you with Technical screening, Resume guidance,interview orientation sessions and mock-interviews. >>100% success rate for motivated and hard-working trainees. >>We get most of our candidates through referrals by satisfied candidates from previous batches. For more details ring @9515931938 or mail us Batches will be scheduled as per the convenience of the students.We also support Weekend batches. TERADATA V14 What is TeraData? TeraData architecture & it’s components Recovery&protection of Data TeraData indexes How to storage & retrieval of data TeraData SQL Quarryman TeraData SQL Functions & operations TeraData join strategies & unions TeraData basic commands TeraData objects TeraData memory spaces TeraData transaction modes TeraData performance tuning on SQL Assistance TeraData Utilities & Tools (Import & Export) TeraData Advance Topics •TeraData SQL Assistant(Quarryman) TeraData performance monitor •Database Move space •TeraData Administrator usage •TeraData performance tuning on scripts

Peridot Systems – The No.1 Training Institute for all the Software Related Courses. Best Real Time DATASTAGE Training in Chennai provides by Well Experience Professionals. We Provides Classroom Training // Online Training //Corporate Training with real time Scnarios and Sample Projects…. Why We Are No.1: • Faculties are Well Experienced Proessionals • Real Time Training • Placemen Assurance Datastage Online Training Course Contents : TERADATA V13.10  TERADATA  TERADATA ARCHITECTURE  OBJECTS OF TERADATA  RECOVERY & PROTECTION OF DATA  INDEXES OF TERADATA  STORAGE & RETRIEVAL OF DATA  TERADATA SQL’s  TERADATA SQL FUNCTIONS & OPERATIONS  TERADATA JOIN STRATEGIES  TERADATA JOINS and SET OPERATORS  TERADATA EXTENSIONS  TERADATA MEMORY SPACES  TERADATA TRANSACTION MODES  TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE  TERADATA UTILITIES (IMPORT & EXPORT)  BTEQ  FastLoad  MultiLoad  Tpump  Fast Export  Teradata TPT  Teradata performance tuning on scripts  Explanation of explain plan  Real Time Interview Questions  Teradata Advanced Concepts For Full Syllabus Contact Us at 9952010141 (Reuben )

Peridot Systems – The No.1 Training Institute for all the Software Related Courses. Best Real Time DATASTAGE Training in Chennai provides by Well Experience Professionals. We Provides Classroom Training // Online Training //Corporate Training with real time Scnarios and Sample Projects…. Why We Are No.1: •Faculties are Well Experienced Proessionals •Real Time Training •Placemen Assurance Datastage Online Training Course Contents: TERADATA V TERADATA TERADATA ARCHITECTURE OBJECTS OF TERADATA RECOVERY & PROTECTION OF DATA INDEXES OF TERADATA STORAGE & RETRIEVAL OF DATA TERADATA SQL’s TERADATA SQL FUNCTIONS & OPERATIONS TERADATA JOIN STRATEGIES TERADATA JOINS and SET OPERATORS TERADATA EXTENSIONS TERADATA MEMORY SPACES TERADATA TRANSACTION MODES TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE TERADATA UTILITIES (IMPORT & EXPORT) BTEQ FastLoad MultiLoad Tpump Fast Export Teradata TPT Teradata performance tuning on scripts Explanation of explain plan Real Time Interview Questions Teradata Advanced Concepts For Full Syllabus Contact Us at (Reuben)

Iq online training provide the most popular teradata online training & tutorials that are present online. iq online training provides best teradata online training classes in usa, canada, uk, singapore etc. teradata online training with an excellent and real time faculty. learners can attend the teradata training through online classes as per their convenient timings. as all our faculty is real time professionals our trainer will cover all the real time scenarios. enroll the teradata online training course with us and make yourself teradata professional on teradata. Teradata development Online Training Course Concepts: 1.What is Teradata why for it is what for it is 2.Teradata in the Enterprise 3.Teradata architecture & it’s components 4.Node Architecture(Shared Architecture) 5.Teradata Utilities & Tools (Import & Export) 6.Import &export scripts with Examples 7.Real time scripts 8.Real time scripts 9.Sample scripts 10.Teradata Fast Export Please call us for the demo classes we have regular batches and weekend batches. Contact Numbers: INDIA: + USA:

Learn Teradata from the experts for Best Teradata Training in Bangalore. Teradata Training comes with complete package of both practical and interview oriented processes. Teradata is a computer corporation located in US. They are concentrating on selling database software for IT Companies in India. Teradata is commonly used for data warehousing and Analytic applications. Now-a-days companies need to maintained five to seven year history data for their depth analysis. In this type of reports we need an efficient database to store and retrieve data’s. Lot of projects is getting migrated from Oracle to Teradata database. It show’s in the profit of Teradata in NASDAQ stock Market in 2005. Teradata is now led by Mike Koehler who is the former senior vice president of NCR. Mainly Teradata® hit based on ‘Shared Nothing Architecture’, Separate memory for each server node concept. It increase the performance when compare to other architecture. Teradata is parallel processing system. JN Global Solutions provide on job training for Teradata® with 100% placement assurance. Our Trainers are coming from various MNC’S like Verizon, IBM, Infosys, TCS, and CTS. To become an Teradata® Certified Professional, you will need to learn all the Teradata certification test objectives. Please find course content for four days training. In this, 80% are theory and 20% of practical.

Adithyaelearning is a leading online Training Institute in India we provide service to which is mainly targeted for freshers, Working professional and corporate training with certified real time tutor from online. Adithyaelearning is an unique online Instructor led training company... We teach Teradata online training classes, You can attend free live Teradata demo video online. we provide you all the Teradata PDF Study Material online for free... Adithyaelearning teach you, how to attend Teradata Interview with Online Training Teradata Interview Questions...

As it forms the fundamental foundation of your future profession in Teradata Certification Online Course, Viswa Online Trainings is aware of the requirement for a high-quality training curriculum along with real-time application exposure. For both novices and experts, our Best Teradata Training from Hyderabad offers in-depth Teradata Online Training. You may quickly clear your doubts and receive the precise assistance that is required from Teradata Online Training from India thanks to the availa...

IQ Online Training provide online training and trainers to students and employees located overseas (USA,UK, Canada, Australia and many more countries). We have the latest screen and voice sharing software /applications through which the trainees can communicate with the trainer. We have 600 + trainers database, where all the trainers are certified professionals in their respective disciplines with world class experience. We have adopted a process where in we take feedback's in regular intervals from the trainees and coordinate with them to provide better experience with our services. We also provide training and support on proprietary or new software/ applications as per trainee's request. Teradata administration Online Training Concepts: 1:TERADATA Architecture 2:TERADATA Database Space 3:DBC Dictionary Tables 4:Access Rights, Roles, Profiles 5:Query analysis and Tools 6:System Access Control Levels 7:TD Manager 8:Monitoring tools 9:TD Remote Console Utilities 10:Archiving Data Please call us for the demo classes we have regular batches and weekend batches. Contact Numbers: INDIA: + USA:

Type Computer "WEBACHARYA" The Teradata product is referred to as a "data warehouse system" and stores and manages data. The data warehouses use a "shared nothing" architecture which means that each server node has its own memory and processing power PH: , 040-

ONLINEITGURU offers Online TERADATA DBA Certification Training with 14+years Expert, Free DEMO's, 100% Live Projects USA,UK,Canada, Australia, India, ...

RVH Technologies is a Brand of Online trainings… Honest,Dedication,Hard work..Is the secret of success for our Institute…. Believe us ,Join Us..We will make You Experts…. We are concentrating mainly in Online Trainings.... All the courses are conducted in the latest versions. We will Provide the online training based on the User Requirement (This May be Full fledged Course,Some Modules of the course based on the User Need) Please Request for a FREE DEMO,Check the Out the standards, Then Choose the best Training Center. We are 100% sure ,you will reach to us after the demo class……… For Further Queries Please contact us on 91 8790137293 Email:info@rvhtech.com Web:www.rvhtech.com Exclusive Offer: If you come up with one more referral,You will get the discount of 20%, If it is two referrals ..you will get discount of 30% And more than that you will get 40% discount. Tags:Teradata online trainings

RVH Technologies is a Brand of Online trainings… Honest,Dedication,Hard work..Is the secret of success for our Institute…. Believe us ,Join Us..We will make You Experts…. We are concentrating mainly in Online Trainings.... All the courses are conducted in the latest versions. We will Provide the online training based on the User Requirement (This May be Full fledged Course,Some Modules of the course based on the User Need) Please Request for a FREE DEMO,Check the Out the standards, Then Choose the best Training Center. We are 100% sure ,you will reach to us after the demo class……… For Further Queries Please contact us on 91 8790137293 Email:info@rvhtech.com Web:www.rvhtech.com Exclusive Offer: If you come up with one more referral,You will get the discount of 20%, If it is two referrals ..you will get discount of 30% And more than that you will get 40% discount. Tags:Teradata online trainings from USA.

Go IT Soft is a Leading IT Online Training for the Testing tools is a Load Runner, Selenium,QTP Testing, Manual Testing, Quality Center,Class Room and Live Training and also for the Other IT Courses. Selenium Course Details: Q T P Course Details: Data Stage Course Details: SALESFORCE Course Details: Please contact us for the further details and for the course enrollment. Thanks & Regards, GOIT SOFT Mobile: (+91)- 7259833301

JSE SoftTech lead by experts with expertise in Online Training's and Delivery of Quality Technology Solutions has achieved the height of worldwide attention privileged in IT Training& Services. We will Deliver the online training based on the User Requirement (This May be Full-fledged Course, Some Modules of the course based on the User Need) Please Request for a FREE DEMO, Check the Out the standards, Then Choose the best Training Center. We are 100% sure, you will reach to us after the demo class……… For Further Queries Please contact us on 91 9951600025

RVH Technologies is a Brand of Online trainings… Honest,Dedication,Hard work..Is the secret of success for our Institute…. Believe us ,Join Us..We will make You Experts…. We are concentrating mainly in Online Trainings.... All the courses are conducted in the latest versions. ,Please Request for a FREE DEMO, Check the Out the standards, Then Choose the best Training Center. We are 100% sure ,you will reach to us after the demo class……… For Further Queries Please contact us on 91 8790137293 Email:info@rvhtech.com Web:www.rvhtech.com

Teradata course Content Foundation •What is Teradata? •Teradatav12 & versions Other versions •Overview OF Teradata •Teradata warehouse •Teradata in the Enterprise •Teradata Users & Scalability •interview Q&A and Certification queries Teradata Architecture and Components •Teradata Architecture •SMP Architecture •MPP Architecture •AMP(Access Module Processing) •TDP(Teradata Directory Program) •CLI(Call Level Interface) •TPA(Trusted Parallel Application) •Parallelism Architecture •Benefits and Types Data Recovery and Security •Why for locks &how to release •Various locks for simultaneous access •RAID 1&RAID 5 •Disk Arrays •Fall Back •Clique •AMP Clustering •Types OF Journals •Recovery Journal •Trasient Journal •Permanent Journal •Before Journal •After Journal •How & where is used journals •Answering various recovery questions Teradata Indexes •Primary Index •Unique •Non unique •Partitioned •Secondary Index •Unique •NonUnique •Hash, Join, Value Ordered •Skewness •Secondary Index Sub table •Accessing Records via Primary Index •Accessing records via Secondary Index •Keys Vs Indexes •Full Real time scenarios and explaining Explicit Transaction •Performance Tuning and Explain Utility •Explain Usage •Collecting Statistics •Tuning SQL Performance •Usage of PMON •Explaining various SQL statements •Joins and Unions •Inner Join •Left Outer Join •Right Outer Join •Full Outer Join •Detailed explanation •Join Strategies •Product Join •Merge Join •Hash Join •Nested Join •Questions of this section Teradata Basic Command •HELP •SHOW •EXPLAIN •COLLECT STATISTICS Teradata Objects •Tables •SET table •Multi Set table •Volatile tables •Global Temporary tables •Derived tables •Views •Macros •Stored Procedures •Triggers •Practices and FAQs of this session Teradata Space •PERM space •SPOOL space •TEMPORARY space •Teradata User and managing •Practical Example Teradata Utilities •Teradata Multi Load •Various Phases of Multi Load •Limitations of Multi Load •Sample Scripts •Teradata Parallel Data Pump •Limitations of TPump •Overview of TPump •Sample Scripts •Teradata Fast Export •Fast Load Contact us for more details ELEGANT IT SERVICES

Course content: "Teradata Admin Track" Teradata Architecture and other essentials Introduction What is Teradata and role of Teradata in Data Ware housing industry, Evolution of Teradata DW, Significant characteristics of Teradata, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc...). Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations. (CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Advanced Teradata SQL HELP, SHOW, EXPLAIN, Define and execution of Macros, Date calculations, data type conversion, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, MDIFF, MAVG, WITH, WITH BY. Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase DBA Teradata DBA basics and responsibilities Initial Teradata Databases Administrative User Owners, Parents and Children Creating New Users and Databases Transfer of Ownership DELETE/DROP Statements User and Security Management Understand the Heirarchy,Teradata Administrator tool usage to perform creation of users, databases, Identify spaces, skew of databases, Moving spaces and accesses, And all the practicals to perform of all coming up topics. The Data Dictionary Updating Data Dictionary Tables Supplied Data Dictionary Views Restricted Views Suffix Options with Views Selecting Information about Created Object Children View, Databases View, Users View, Tables View Columns View, Indices View Capacity management and planning Spaces and types of tables - PERM, SPOOL, TEMP space terminology, Derived,Volatile, Global temporary tables. Identify current space usage and estimate the space requirments for the applications. Users, Accounts, and Accounting Creating and Using Account IDs Using Account IDs with Logon Dynamically Changing an Account ID Account Priorities Account String Expansion Access Rights Privileges/Access Rights Implicit, Automatic, and Explicit Rights GRAND and REVOKE accesses, GIVE command System Views for Access Rights Inheriting Access Rights, Transfer access rights, Delete or Drop / user or database Roles and Profiles What is a role, Advantages of Roles, Access Rights Using a Role, Implementing Roles, Nesting of roles, views for roles, Profiles, implementing Profiles, Teradata password control Work load management and Priority scheduler Levels of Workload Management, Priority Scheduler Architecture, and concepts Access logging and Query logging Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Setting up Access Logging, AccLogRules View, Query Logging (DBQL) Concepts, Objects used in Defining Rules for DBQL, DBQLRules View Performance monitoring (PMON) Resource usage, Session Management User session Info, SQL & Explain Steps Archive and Restore and copy Archive and restore data using ARCMAIN utility, Different levels of archiving and restoration, HUT locks, Revalidate references after restoration View point The Demo of view point portlets (which is new tool for DBAs having the features of PMON, TDMANAGER and TASM Performance tuning Explain plan, Statistics and Join strategies Explain plan and recommandations. Significance of collecting statistics Other indexes, and techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress. Course Content: Teradata Dev Track History and Architecture Introduction OLTP, OLAP systems, Dataware house and Data Marts, Dimenssion modeling, Schemas, What is Teradata and role of Teradata in DW, Evolution of Teradata DW, Advantages of Teradata over other RDBMS Teradata Architecture Understanding H/W and S/W components, involved in Architecture of Terdata(vdisks, AMP, PE Vprocs, BYNET etc…). Database structure Data distribution Understanding significance of Index in teradata(UPI, NUPI, SI, NUSI, Partitioned index) Data Protection Different levels of failures that could happen and fault tolarance of Teradata in that situations.(CLIQUE, CLUSTER, RAID, LOCKS and JORNALS) Spaces and types of tables Different levels of accessing the objects granting the Privileges and locking mechanism SQL ASNI SQL Brief introduction of Relational concepts, understanding users, databases, tables, vies, index, macro etc. Sub query, corelated query, Data types, Joins, Arthimatic functions Teradata SQL Explore teradata specifc SQL statements such as show, help,explain..SET operations, Aggregate functions, Sring functions, Aliasing,FORMAT, conversion of the datatypes. Advanced Teradata SQL Define and execution of Macros, Date calculations, Case, COALESCE, sample, Ranking, Qualify, CSUM, MSUM, WITH, WITH BY. Client utilities SQL Assistant Settup ODBC for connecting through SQL assistant, options menu and EXPORT/IMPORT BTEQ Functinality,operations, exectuion and limitations FAST LOAD Functinality, Different phases, exectuion, restartability and limitations FAST EXPORT Functinality, Different phases, exectuion, restartability and limitations MULTI LOAD Functinality, Different phases, exectuion, restartability and limitations Performance tuning Explain plan & Statistics & Understanding Explain plan and recommandations. Significance of collecting statistics Other techniques Determine the proper join columns, Join index, Spars index, Aggregate index, SET / MULTSET with UPI and NUPI combinations, compress Others (Optional) Unix Role of Unix in executing Teradata utility scripts and Basic commands used General Lifecycle of the projects General phases of a Development project. Documents required in each phase

Perpetro Technologies provides the Best Teradata Training in chennai. Our trainer is an working professional with more than 8Yrs of DW experience. Please call us for a free demo class. Overview Teradata Architecture & It’s Components Recovery &Protection Of Data Teradata Indexes How To Storage & Retrieval Of Data Teradata Sql Quarryman Teradata Sql Functions & Operations Teradata Join Strategies & Unions Teradata Objects Teradata Memory Spaces Teradata Transaction Modes Teradata Performance Tuning On Sql Assistance Teradata Utilities & Tools (Import & Export) • Teradata BTeq scripts • Teradata FastLoad • Teradata MultiLoad • Teradata Tpump • Teradata Fast Export • Teradata SQL Assistant(Quarryman) • Teradata performance tuning on scripts

Best TERADATA Training with placements in Chennai- Peridot Systems is the one of the best IT training institute in Chennai. Our training reflects the latest techniques and technologies and that are developed from practical knowledge gathered from years of experience. Learning from the real time working professionals is the only way to gain knowledge thatr how actually happens in the real IT world. Beneficiary •We get the job referral information from various industries •We have tie ups with India’s leading consultancies and companies who recruit fresher and laterals. •Free Demo sessions •Free of software installation •Full-fledged Lab facility •Technical support till one year by our faculty Teradata Course Details •Architecture •Comparative Study between Teradata an Other RDBMS •Database Components and function •Parallel Architecture and processing the table •Factor affecting data storage and distribution •RDBMS & Normalization { 1st – 3rd Normal form } •Data-warehouse Concepts { Surrogate Keys, SCD etc} •Administrative tools TERADATA SQL •Data Dictionary •Primary keys, Foreign keys, Primary Indexes, and Secondary Indexes in a Teradata system •Advance SQL •SQL Performance Tuning TERADATA APPLICATION UTILITIES •BTEQ (Export/Import), Fast Export, Fast Load, MultiLoad and Tpump for batch processing •Internal working of above utilities •Using utilities – Choose above utilities when and why •TPT and its advantage over traditional utilities like Fast Load, MultiLoad etc. Contact Details: Contact Person-Sinduja Contact Number- Venue: No-84/8 venkatarathinam nagar, LB road, Adyar, Chennai- Tags: Best Teradata Training with placements in Chennai || Best Teradata Training instititue in Chennai || Best Teradata training course in chennai

Go IT Soft is a Leading IT Online Training for the Testing tools is a Load Runner, Selenium,QTP Testing, Manual Testing, Quality Center,Class Room and Live Training and also for the Other IT Courses. Selenium Course Details: http://www.goitsoft.com/selenium/ Q T P Course Details: http://www.goitsoft.com/qtp-testing/ Data Stage Course Details: http://www.goitsoft.com/datastage/ TeraData Course Details: http://www.goitsoft.com/teradata/ SALESFORCE Course Details: http://www.goitsoft.com/salesforce-dev-admin/ INFORMATICA Course Details: http://www.goitsoft.com/informatica/ Please contact us for the further details and for the course enrollment. Thanks & Regards, GOIT SOFT Mobile: (+91)- 7259833301 Email:info@goitsoft.com Website:http://www.goitsoft.com

In this eBook, {TDBL1-16.20 Teradata Vantage Associate Exam} Video Learning Resume Publishing Guide you will be getting the already prepared resume template of fresher (for 0-2 Years’ Experience), Mid-experience (2-5 Years’ Experience) & Advance level Experience (5+ Years’ Experience) of aspirants. /nApart from this you will be able to learn about an attractive professional resume publishing features like Resume overview (Resume outline & basic contents). Objective Statements (purpose, traps to avoid, writing formula, & examples), Marketing Your Education (Examples of coursework, projects, & educational skills/knowledge), Marketing Your Experiences (Purpose, writing format, & developing descriptions Action verbs & experience examples Condensing experiences & examples), Closing the Resume - Reference Statements, Resume Critique (General resume guidelines & criteria for critiques), Technology and Resumes (Scanning, emailing, & databases), References (Reference sheet & developing/maintaining references), Cover Letters & Email (Cover letter outline, emailing, & examples). /nMultiple resume examples will be included in this eBook, which are going to help you out in building your professional resume as per your experience, after going through this eBook you won’t require any body help to build and publish your best resume according to your need.

Go IT Soft is a Leading IT Online Training for the SEO & PPC,PHP Development Testing tools Load Runner, Selenium,QTP Testing, Manual Testing, Quality Center,Class Room and Live Training and also for the Other IT Courses. Courses Details: Mobile: (+91)- 7259833301