TERADATA - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)8885575549, 040-42627705 | USA: +1 973-619-0109 | UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

TERADATA ONLINE TRAINING

TERADATA ONLINE TRAINING IN INDIA, USA & UK

TERADATA ONLINE TRAINING IN CANADA

TERADATA ONLINE TRAINING IN AUSTRALIA

TERADATA ONLINE TRAINING

TERADATA COURSE CURRICULUM

Download [PDF]

  • Overview of the TERADATA
      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
      Real time Issues & resolving
      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)
  • HOW TO STORAGE & RETRIEVAL OF DATA
      Hash algorithm
      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(Quarryman)
      Teradata performance tuning on scripts

TERADATA

Teradata Database is an information repository supported by tools and utilities that make it a complete and active relational database management system.

Teradata developers designed Teradata Database from mostly off-the-shelf hardware components. The result was an inexpensive, high-quality system that exceeded the performance of conventional relational database management systems. The hardware components of Teradata Database evolved from those of a simple parallel database computer into those of a general-purpose, massively parallel computer running the database.

The architecture supports both single-node, Symmetric Multiprocessing (SMP) systems and multinode, Massively Parallel Processing (MPP) systems in which the distributed functions communicate by means of a fast interconnect structure. The interconnect structure is the BYNET for MPP systems and the boardless BYNET for SMP systems.

The Teradata RDBMS was developed to allow users to view and manage large amounts of data as a collection of related tables. The goal of the Teradata RDBMS is to provide the benefits of a flexible relational database to its users.

Teradata RDBMS is a complete relational database management system. The system is based on off-the-shelf Symmetric Multiprocessing (SMP) technology combined with a communication network connecting the SMP systems to form a Massively Parallel Processing (MMP) system.

BYNET is a hardware inter-processor network to link SMP nodes. All processors in a same SMP node are connected by a virtual BYNET

A design goal of Teradata Database was to provide a single data store for a variety of client architectures. This approach greatly reduces data duplication and inaccuracies that can creep into data that is maintained in multiple stores.

This approach to data storage is known as the single version of the business, and Teradata Database implements this through heterogeneous client access. Clients can access a single copy of enterprise data and Teradata Database takes care of such things as data type translation, connections, concurrency, and workload management

Teradata RDBMS supports the UCS Transformation Format 8-bit form (UTF-8) UNICODE client character set on Teradata clients on a per session basis. One- to three-byte UTF-8 UNICODE characters from the client are stored on Teradata RDBMS as two-byte UNICODE characters. By supporting UNICODE, the Teradata RDMBS can:

  • Support data in multiple languages in the same session
  • Support non-Latin data, for example, Japanese, Chinese, and so forth, on all systems

Teradata RDBMS supports running with or without a channel or network attached client. The following table describes the available client software, recognizing that the “client” may be the system running the Teradata RDBMS

DEMO VIDEOS

UPCOMING DEMOS

For updated Schedules please contact
calls