Hash training

We at # Analytics, taken the responsibility of educating professionals and campus students, with our expertise and vast experience, to grow them as future leaders in analytics space.

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

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

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training . Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java, .net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems.  Preferable Timinings  Free Software Installation  One Year Tech Support  Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact 9790855020 Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - 600020.

DATA STAGE TRAINING IN CHENNAI FOR MNC PROFESSIONALS Peridot Systems is only Data stage training In Chennai delivering the best training for students and also a carrier oriented training. Peridot Systems is a pioneer name in Training, Development, and provides one stop IT professional trainings. We provide trainings in ERP, Java,.net, SQT, SharePoint, Linux, Ms-BI, Cloud computing and all other latest technologies. Peridot Systems aspires to facilitate the creation of a network of IT Training Institutes worldwide to empower the workforce with job oriented skills. Selected Individuals and companies that share the passion and vision of Peridot Systems. Preferable Timinings Free Software Installation One Year Tech Support Real Time Trainers Data Stage Course Content Data ware housing concepts v About data warehousing v History of data warehousing v Data warehousing architecture v Different Data marts v Advantages of DWH v Properties of DWH v OLTP VS OLAP v DWH Approaches v Data Modeling v Star, Snowflake & Galaxy Schemas v Dimension tables v Fact Tables Data Stage Contents Introduction about Data Stage IBM Information server overview IBM Web sphere Data stage and information Analyzer IBM Web sphere Quality stage Difference between Server Jobs and Parallel Jobs Difference between Pipeline and partitioning Parallelisms Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) Configuration File Difference between SMP, MPP, Cluster architecture Data Stage Components (Server components/Client Components) Package Installer 1.Data Stage Administrator • 2.Data stage director 3.Designer 4.Processing stages For Further Details Please Contact Venue Details: Peridot Systems Kamatchi Krupa Apts, No: 84/8, Ground Floor, Venkatarathinam main street, Venkatarathinam Nagar, LB Road, Adyar, Chennai. Tamil Nadu - .

Nakshatra Software Training is a vast experienced online training center in Hyderabad, India, with highly qualified and real time experienced faculties,offers Perl Scripting online training with real time project scenarios. We stand unique in training the shell scripting and Perl scripting by providing real time CASE STUDIES with FORWARD and REVERSE Engineering techniques of the cases and codes which helps you in understanding the roles and responsibilities of a TEAM MEMBER in real time environment. We provide training in Perl scripting by covering the installation of Perl, scalar variables($), Array variables, Hash array variables(%), Regular expressions, subroutines etc.. with real time scenarios depending upon the requirement of the role, like wise real time scenarios in Development, CGI PERL, System Administration, Automation, Testing Perl and DBA etc. In addition to that we make you understand the real time CASE studies by using Forward Engineering and REVERSE Engineering techniques.

Revanth Technologies which is a high profiled online training institute in India offers Perl Scripting online training with real time experts and with real time concepts. We provide training in Perl scripting by covering the installation of Perl, scalar variables($), Array variables, Hash array variables(%), Regular expressions, subroutines etc.. with real time scenarios depending upon the requirement of the role, like wise real time scenarios in Development, CGI PERL, System Administration, Automation, Testing Perl and DBA etc. In addition to that we make you understand the real time CASE studies by using Forward Engineering and REVERSE Engineering techniques.

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering, Grouping…. • Data types, Operators….. • Joins, Groups…. • Sample programs in HIVE II. PIG • Basics • Installation and Configurations • Commands….

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering,

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau  1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering, Grouping…. • Data types, Operators….. • Joins, Groups…. • Sample programs in

​ HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool Tableau 1. Virtualbox/VM Ware Basics • Installations • Backups • Snapshots 2. Linux Basics • Installations • Commands 3. Hadoop Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs Map-side join • Reduce-Side join 9. Map reduce – customization Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering, Grouping…. • Data types, Operators….. • Joins, Groups…...

We provide training in Perl scripting by covering the installation of Perl, scalar variables($), Array variables, Hash array variables(%), Regular expressions, subroutines etc.. with real time scenarios depending upon the requirement of the role, like wise real time scenarios in Development, CGI PERL, System Administration, Automation, Testing Perl and DBA etc. In addition to that we make you understand the real time CASE studies by using Forward Engineering and REVERSE Engineering techniques.

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

Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes (NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages:- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering, Grouping…. • Data types, Operators….. • Joins, Groups…. • Sample

The Topics covered in the C Programming Language: C 1 Introduction to C 2 Decision and Loops 3 Functions 4 Arrays and Strings 5 C pointers 6 Structure and Union 7 C files 8 Enumerations 9 Preprocessors 10 Library Functions The Topics covered in the DataStructures: Data Structure 1 Pointers, Nesting structures 2 Memory allocation 3 Stack Data Structure 4 The Queue Data Structure 5 List 6 Double linked List 7 Heaps 8 Hash Tables 9 Graphs in computer science 10 Two-three trees The Topics covered in the C++: C++ 1 Datatype 2 Variables 3 Keywords 4 Objects and Classes 5 Inheretance 6 Friend Function 7 Loops 8 Abstract, Encapsulation, Polymorphism 9 Virtual table 10 File handling Contact us for more details ELEGANT IT SERVICES

The Topics covered in the C Programming Language: C 1 Introduction to C 2 Decision and Loops 3 Functions 4 Arrays and Strings 5 C pointers 6 Structure and Union 7 C files 8 Enumerations 9 Preprocessors 10 Library Functions The Topics covered in the DataStructures: Data Structure 1 Pointers, Nesting structures 2 Memory allocation 3 Stack Data Structure 4 The Queue Data Structure 5 List 6 Double linked List 7 Heaps 8 Hash Tables 9 Graphs in computer science 10 Two-three trees The Topics covered in the C++: C++ 1 Datatype 2 Variables 3 Keywords 4 Objects and Classes 5 Inheretance 6 Friend Function 7 Loops 8 Abstract, Encapsulation, Polymorphism 9 Virtual table 10 File handling Contact us for more details ELEGANT IT SERVICES 9 8 8 6 5 4 1264

ORACLE DATABASE ADMIN COURSE CONTENT Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in ORACLE DATABASE ADMIN COURSE CONTENT 1: Creating the Database 2: Starting Up and Shutting Down • Viewing the Quiesce State of an Instance • Suspending and Resuming a Database 3: Managing Oracle Database Processes • Terminating Sessions • Identifying Which Session to Terminate • Terminating an Active Session • Terminating an Inactive Session 4: Monitoring the Operation of Your Database • Server-Generated Alerts • Monitoring the Database Using Trace Files and the Alert Log • Monitoring Locks • Monitoring Wait Events • Process and Session Views 5: Oracle Database Structure and Storage • Managing Control Files • Managing the Redo Log • Managing Archived Redo Logs 6: Managing Table spaces Transportable Table spaces 7: Managing Data files and Temp files 8: Managing the Undo Table space undo retention, switching undo table space 9: User management creation of users and roles, assign privileges 10:Automatic Storage Management create ASM instance, create disk groups 11:Managing Schema Objects • Tables, indexes, views, synonyms and sequence generator • Space management • Managing resumable space allocation, reclaiming wasted space • Managing Tables • adding, renaming and dropping of table columns • Managing Indexes • B*tree, bitmap • Managing Partitioned Tables and Indexes • Range, hash,list and composit partitioning • Managing Clusters • creation and altering of clusters • Managing Views, Sequences, and Synonyms • Oracle Network • Listener and tnsnames • Distributed Database Concepts • Utilities • Data pump , SQL*Loader • Backup and Recovery • Rman • Performance Tuning • Data Guard • configuring physical standby database • Miscellaneous Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support

Data Stage Course Content at Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Data Stage Data Stage Course Content at Learning Hub Contents • Introduction about Data Stage • Difference between Server Jobs and Parallel Jobs • Difference between Pipeline Parallelisms • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto) • Configuration File • Difference between SMP/MPD architecture • Data Stage Components (Server components/Client Components) • Package Installer Data Stage Administrator • Creating project, Editing project and Deleting project • Permissions to user • .Apt Config file • Environment variable creation, permission Data stage director • Introduction to Data stage Director • Job status View • View logs • Scheduling • Batches Creation Designer • Introduction about Designer • Repository • Palatte • Types of Links • File Stages • Sequential File • Data set File • Lookup file set • Difference between Sequential file/Dataset/File set • Database stages • Dynamic RDBMS • Oracle Enterprise • ODBC Enterprise • Stored Procedure Processing stages • Change Capture (Caption) • Compare stage • Difference Stage • Aggregate Stage • Transformer Stage • Surrogate Generator Stage • Join Generator Stage • Merge Generator Stage • Lookup Generator Stage • Difference between join/Lookup/Merge • Difference between join/Lookup • Remove Duplicates • Switch • Pivot • Modify • Funnel Debugging stage • Head • Tail • Pea • Row Generator • Column Generator • Sample • Job Parameters Manager • Introduction About Data stage Manager • Importing the Job • Exporting the Job • Importing Table Definition • Importing Flat File Definition • Routines Containers • Difference between Local Container and Shared Container • Local Container • Shared Container Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in Data Stage Online Training, Data Stage Class Room Training, Data Stage Training in Magarpatta City, Data Stage Jobs and Placement, Data Stage Remote Support, Data Stage Online Help,Data Stage Videos training, Data Stage training by Learning Hub, Fast track classes in Data Stage, Best Data Stage training institutes in Pune, Best Faculty in Data Stage, Best online Faculty in Data Stage, Professional classroom training in Data Stage, Professional online training in Data Stage,Data Stage Certification, Data Stage training in Dubai, Data StageTraining in Melbourne, Data Stage Training in Dubai, Data Stage Training, Data Stage Training,Data Stage Training, Data StageOnline Training, Data Stage certfication and suppor

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE • Map Reduce Programs through HIVE • HIVE Commands • Loading, Filtering, Grouping…. • Data types, Operators….. • Joins, Groups…. • Sample programs in HIVE

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class 10. Hadoop Programming Languages :- I.HIVE • Introduction • Installation and Configuration • Interacting HDFS using HIVE

HADOOP Training in Hyderabad @Sadguru Technologies Course Objective Summary During this course, you will learn: • Introduction to Big Data and Analytics • Introduction to Hadoop • Hadoop ecosystem - Concepts • Hadoop Map-reduce concepts and features • Developing the map-reduce Applications • Pig concepts • Hive concepts • Sqoop concepts • Flume Concepts • Oozie workflow concepts • Impala Concepts • Hue Concepts • HBASE Concepts • ZooKeeper Concepts • Real Life Use Cases Reporting Tool • Tableau 1. Virtualbox/VM Ware • Basics • Installations • Backups • Snapshots 2. Linux • Basics • Installations • Commands 3. Hadoop • Why Hadoop? • Scaling • Distributed Framework • Hadoop v/s RDBMS • Brief history of hadoop 4. Setup hadoop • Pseudo mode • Cluster mode • Ipv6 • Ssh • Installation of java, hadoop • Configurations of hadoop • Hadoop Processes ( NN, SNN, JT, DN, TT) • Temporary directory • UI • Common errors when running hadoop cluster, solutions 5. HDFS- Hadoop distributed File System • HDFS Design and Architecture • HDFS Concepts • Interacting HDFS using command line • Interacting HDFS using Java APIs • Dataflow • Blocks • Replica 6. Hadoop Processes • Name node • Secondary name node • Job tracker • Task tracker • Data node 7. Map Reduce • Developing Map Reduce Application • Phases in Map Reduce Framework • Map Reduce Input and Output Formats • Advanced Concepts • Sample Applications • Combiner 8. Joining datasets in Mapreduce jobs • Map-side join • Reduce-Side join 9. Map reduce – customization • Custom Input format class • Hash Partitioner • Custom Partitioner • Sorting techniques • Custom Output format class.,,..