Course Details: Introduction: 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 Teradata Sql Reference SQL Fundamentals Data Types and Literals Data Definition Statements(DDL) Data Manipulation Statements(DML) Explaining with proper examples Teradata Functions and Operators String Functions Format Function Cast Functions Group & Aggregate Functions With & with by clauses Practices of this section Teradata Transactions Implicit Transaction 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 Commands 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 spaces PERM space SPOOL space TEMPORARY space Teradata User and managing Practical Examples Teradata Transaction Modes BTET ANSI Interactive Batch Teradata Sql Assistant(Queryman) Teradata Performance Monitor Teradata BTEQ Batch Scripts with samples Branching and Looping Importing data through scripts Exporting data through scripts Error handling Explanation with proper debugging Teradata Fast Load Various Phases of Fast Load Advantages and Process Limitations of Fast Load Sample Scripts Real time Issues and resolving it Teradata Multi Load Various Phases of Multi Load Limitations of Multi Load Working with multiple tables Applying various operations Sample Scripts Real time Issues and solving it Teradata Parallel Data Pump Limitations of TPump Overview of TPump Sample Scripts Teradata Fast Export Exporting Data Passing Parameters OUTMODS Sample Scripts Utility Vs Parallelism
SBR Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
SBR trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.
SBRTrainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. SBR come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.
1. The classes can be attended to at any place and any time as per your choice Use your laptop, desktop, Android and iOS App to learn on the go 2. Choose from a number of batches as per your convenience If you got something urgent to do, reschedule your batch for a later time if you want fast rack also arrange 1:1 3. Live screen sharing, step-by-step live demonstrations and live Q&A led by real time industry experts. If you are busy so not joined class it means Missed a class? Not an issue. We record the classes and send to your email id 4. Share your learning objectives and get oriented with our web and mobile platform. Talk to your personal learning manager to clarify your doubts 5. We have pre-populated your learning platform with previous class recordings and presentations. 6. We have in-house expert Teaching Assistants to resolve all your queries. Reach out to us by raising a ticket from your learning platform. sbrtrainings provides life time learning assistance. 7. Have a problem? Our Support Ninjas Are There to Help You 24 X 7