Name Of The Training Institute : Axiom Semantics Technology Services ( axiomsemantics.com )
Location Of The Training Institute : Chennai
Training Offered : Teradata Developer Training
Website : axiomsemantics.com/course-offered.php?p_id=courses-offered/oracle-developer-training.php
Teradata Developer Training :
Course Overview :
The first database built for Data Warehouse applications. This training covers Teradata basics, architecture, DDL, DML and tools. All SQL statements are explained with sample data stored in the database. Developers new to Teradata can benefit from the topics which cover the basic functionalities of the database with suitable examples.
Duration : 40 hours
Course Content :
TERADATA INTRODUCTION :
Teradata 13.x training TeraData 13.x training in Chennai TeraData 13.x online training TeraData 13.x online training in Chennai
** What is Teradata?
** Teradata &other RDBMS
** Teradata warehouse
** Teradata in the Enterprise
TERADATA ARCHITECTURE :
** 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 & 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(unique, non- unique)
** Secondary index(unique, non- unique)
** Skewness
** Keys & indexes (How & why these used)
Course Highlights :
** Trainers with 6 – 10 years relevant experience in the industry.
** Hands on sessions with real time scenarios after each lesson.
** Sample database to practice SQL statements.
Oracle Developer Corporate Training :
The most popular RDBMS is Oracle which is used by many applications as data storage. Database development using SQL and PL/SQL is covered in this course. Topics covered in detail are: Introduction to Oracle, Database Objects, SQL Statements, Sub-query, Functions, SET operators, Expressions, Partitioning, PL/SQL Programming Basics, Exception Handling, Cursors, Collections, Records, PL/SQL Sub Programs, Query Optimization and Tuning.
Duration : 40 Hours
Course Highlights :
** Trainers with 5 – 8 years experience in the industry
** Extensive coverage with examples
** All sessions are with hands on lab timings
Address Of The Training Institute :
Axiom Semantics Technology Services
14 Lattice Bridge (L.B) Road
First Floor (Opp. Arihant E Park)
Adyar, Chennai 600020, India