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
RIZE 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. RIZE 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.
RIZE 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.
The course begins in a few days, and I still do not have my login information. What do I do? Once your registration for a course is completed, we will send activation link to start your sessions. What happens if I miss my training date, do I have any options? In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch. How does the online training work? All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class. How do I receive the course materials? You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc; Will I be able to view the sessions again at a later time? Yes, We provide recorded sessions. Who are your trainers? All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience. Can I get the same in-class experience at home or work? Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications. What should I bring to class? You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course. Where can I get more information? If you need more information, please call us at +91-970 39 767 53 or send mail to firstname.lastname@example.org . Rize Trainings Advisors will be happy to assist you. Do you offer placements? We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project. What happens if I have technical problems during my class? If you have technical difficulties, you call us at +91-970 39 767 53 . Our support team will resolve any issues you might encounter.