Teradata Training and Certification Course In Pune

Teradata
Duration of course: 40 hrs

Best Blended Syllabus for Teradata Training in Pune by a 100% Placement-Oriented Training Institute

Instructor-led Teradata Live Online Training

Don’t Wait for IT!

Let's Build a Great Career in IT!

Our Candidate’s Placement Record!

Book Your Seat Now ! At just ₹2000!

No Cost Two Easy Installments!
Can’t find a batch you were looking for?

Teradata Training Course​

Best Blended Syllabus for Teradata Training in Pune by a 100% Placement-Oriented Training Institute

  • The Teradata Architecture
  • The Parsing Engine
  • The AMPs
  • Born to be parallel
  • The BYNET
  • Watch the Tera-Tom Video on Architecture
  • Collecting Statistics
  • Parsing Engine uses Statistics for the Plan
  • Columns and Indexes to Collect Statistics On
  • A Scalable Architecture
  • VProcs
  • Nodes and MPP
  • Watch the Tera-Tom Video on How AMPS store and process rows in Parallel

Download Curriculum

  • Logical Modeling – Primary and Foreign Keys
  • A Normalized Data Warehouse
  • Normalization
  • Dimensional Modeling also called Star Schema 

Download Curriculum

  • Physical Modeling – The Primary Index
  • Two Types of Primary Indexes (UPI or NUPI)
  • Unique Primary Index (UPI)
  • Non-Unique Primary Index (NUPI)
  • Multi-Column Primary Indexes
  • When do you define the Primary Index?
  • Watch the Tera-Tom Video on Primary Indexes

Download Curriculum

  • How Teradata Distributes and Retrieves Rows
  • Hashing the Primary Index Value
  • The Hash Map
  • Laying a Row onto the Proper AMP
  • Retrieving a Row by way of the Primary Index
  • Placing Non-Unique Primary Indexes (NUPI) Rows
  • Non-Unique Primary Indexes Continued
  • Placing (NUPI) Rows Continued
  • Retrieving (NUPI) Rows
  • Even Distribution with an UPI
  • Uneven Distribution with a NUPI
  • Unacceptable Distribution with a NUPI
  • Big Trouble – A Picture of a Full Table Scan
  • A Visual for Data Layout
  • Watch the Tera-Tom Video on Data Placement
  • Bonus Video – Tera-Tom Video on the Row-ID
  • Test your Teradata Primary Index Knowledge

Download Curriculum

  • Secondary Indexes
  • The Secondary Index Subtable
  • USI – Always a Two-AMP Operation
  • USI Summary
  • Watch the Tera-Tom Video on Unique Secondary Indexes (USI)
  • NUSI Sub table is AMP-Local
  • NUSI Recap
  • Secondary Index Summary
  • Watch the Tera-Tom Video on Non-Unique Secondary Indexes (NUSI)

Download Curriculum

  • A Table used for our Partitioning Example
    Range Queries
  • Why we had to perform a Full Table Scan
  • A Partitioned Table
  • One Year of Orders Partitioned
  • Fundamentals of Partitioning
  • Add the Partition to the Row-ID for the Row Key
  • Multi-Level Partitioning
  • Partitioning Rules
  • Watch the Tera-Tom Video on Partitioning

Download Curriculum

  • The most Powerful USER
  • DBC owns all the Disk Space
  • DBC Example of 1000 GBs
  • DBC will first CREATE a USER or a DATABASE
  • Teradata is Hierarchical
    Only two Objects can Receive PERM Space
  • PERM, SPOOL and TEMP Space
  • Spool is like a Speed Limit
  • All Space is calculated on a Per AMP Basis
  • Watch the Tera-Tom Video on Space

Download Curriculum

  • Introduction to a Join Index
  • Join Index Fundamentals
  • A Multi-Table Join
  • Index Example
  • Multi-Table Join Index Picture
  • Single-Table Join Index
  • Aggregate Join Index
  • Join Index Details to Remember
  • Watch the Tera-Tom Video on the Parody Teradata Query Search-Off

Download Curriculum

  • Data Protection
  • Transaction Concept
  • Transient Journal
    RAID 1 – Mirroring
    Cliques
  • VProcs Migrate when a Node Fails
  • Cliques – An 8-Node Example
  • Hot Standby Nodes
  • Hot Standby Nodes in Action
  • FALLBACK Protection
  • How Fallback Works
  • Fallback Clusters Exercise
  • Fallback Clusters
  • The Six Rules of Fallback
  • Down AMP Recovery Journal (DARJ)
  • Permanent Journal
  • Permanent Journal Rules

Download Curriculum

  • The Four Locks of Teradata
  • Teradata has 3 levels of Locking
  • Locking Modifiers – The Access Lock
  • Locks and their compatibility 

Download Curriculum

  • Fundamental Structured
  • Query Language (SQL)
  • Basic SELECT Command
  • WHERE Clause
    Compound
  • Comparisons (AND / OR)
  • Impact of NULL on Compound
  • Comparisons
    Using NOT in SQL
  • Comparisons
    Multiple Value Search (IN)
  • Using NOT IN
  • Using Quantifiers Versus IN
  • Multiple Value Range Search (BETWEEN)
  • Character String Search (LIKE)
  • Derived Columns
  • Creating a Column Alias Name
  • AS
  • NAMED
  • Naming conventions
  • Breaking Conventions
  • ORDER BY
  • TOP Rows Option
  • DISTINCT Function

Download Curriculum

  • HELP commands
  • SET SESSION command
  • SHOW commands
  • EXPLAIN
  • Adding Comments
  • ANSI Comment
  • Teradata Comment
  • User Information Functions
  • ACCOUNT Function
  • DATABASE Function
  • SESSION Function

Download Curriculum

  • Data Conversions
  • Data Types
  • CAST
  • Implied CAST
  • Formatted Data
  • Formatted Data for Day-Month-Year
  • Tricking the ODBC to Allow Formatted Data
  • TITLE Attribute for Data Columns
  • Transaction Modes
  • Case Sensitivity of Data
  • CASESPECIFIC
  • LOWER Function
  • UPPER Function

Download Curriculum

  • Aggregate Processing
  • Math Aggregates
  • The SUM Function
  • The AVG Function
  • The MIN Function
  • The MAX Function
  • The COUNT Function
  • Aggregates
  • Use of HAVING
  • Using the DISTINCT Function with Ao Performance Opportunities

Download Curriculum

  • Subquery
  • Using NOT IN
  • Using Quantifiers
  • Qualifying Table Names and Creating a Table Alias
  • Qualifying Column Names
  • Creating an Alias for a Table
  • Correlated Subquery Processing
  • Correlated Subquery To Find Duplicate Values
  • EXISTS

Download Curriculum

  • Join Processing
  • Original Join Syntax
  • Product Join
  • Newer ANSI Join Syntax
  • INNER JOIN
  • OUTER JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
  • CROSS JOIN
  • Self Join
  • Alternative JOIN / ON Coding
  • Adding Residual Conditions to a Join
  • INNER JOIN
  • OUTER JOIN
  • OUTER JOIN Hints
  • Parallel Join Processing
  • Join Index Processing

Download Curriculum

  • ANSI Standard DATE Reference
  • INTEGERDATE
  • ANSIDATE
  • DATEFORM
  • System Level Definition
  • User Level Definition
  • Session Level Declaration
  • DATE Processing
  • ADD_MONTHS
  • ANSI TIME
  • EXTRACT
  • Implied Extract of Day, Month and Year
  • ANSI TIMESTAMP
  • TIME ZONES
  • Setting TIME ZONES
  • Using TIME ZONES
  • Normalizing TIME ZONES
  • DATE and TIME Intervals
  • Using Intervals
  • INTERVAL Arithmetic with DATE and TIME
  • CAST Using Intervals
  • OVERLAPS
  • System Calendar

Download Curriculum

  • Transforming Character Data
  • CHARACTERS Function
  • CHARACTER_LENGTH Function
  • OCTET_LENGTH Function
  • TRIM
  • SUBSTRING
  • SUBSTR
  • SUBSTRING and Numeric Data
  • POSITION
  • INDEX
  • SUBSTRING and POSITION or INDEX Used Together
  • Concatenation of Character Strings

Download Curriculum

  • Set Operators
  • Considerations for Using Set Operators
  • INTERSECT
  • UNION
  • EXCEPT
  • MINUS
  • Using Multiple Set Operators in a Single Request

Download Curriculum

  • Data Maintenance
  • Considerations for Data Maintenance
  • Safeguards
  • INSERT Command
  • Using Null for DEFAULT VALUES
  • INSERT / SELECT Command
  • Fast Path INSERT / SELECT
  • UPDATE Command
  • Fast Path UPDATE
  • DELETE Command
  • Fast Path DELETE
  • UPSERT
  • MERGE
  • ANSI Vs Teradata Transactions
  • Performance Issues with Data Maintenance
  • Impact of FALLBACK on Row Modification
  • Impact of PERMANENT JOURNAL Logging on Row Modification
  • Impact of Primary Index on Row Modification
  • Impact of Secondary Indices on Row Modification

Download Curriculum

  • Data Interrogation
  • NULLIFZERO
  • NULLIF
  • ZEROIFNULL
  • COALESCE
  • CASE
  • Flexible Comparisons within CASE
  • Comparison Operators within CASE
  • CASE for Horizontal Reporting
  • Nested CASE Expressions
  • CASE used with the other DML
  • Using CASE to avoid a join

Download Curriculum

  • Views
  • Reasons to Use Views
  • Considerations for Creating Views
  • Creating and Using VIEWS
  • TOP Command allows ORDER BY in the View
  • Deleting Views
  • Modifying Views
  • Modifying Rows Using Views
  • DML Restrictions when using Views
  • INSERT using Views
  • UPDATE or DELETE using Views
  • WITH CHECK OPTION
  • Locking and Views

Download Curriculum

  • Creating Tables
  • Table Considerations
  • Maximum Columns per Table
  • Table Naming Conventions
  • CREATE TABLE
  • Column Data Types
  • Specifying the Database in a CREATE TABLE Statement
  • PRIMARY INDEX considerations
  • CREATE TABLE AS
  • Table Type Specifications of SET VS MULTISET
  • SET and MULTISET Tables
  • Protection Features
  • FALLBACK
  • Permanent Journal
  • BEFORE Journal
  • AFTER Journal
  • Internal Storage Options
  • DATABLOCKSIZE
  • FREESPACE PERCENTAGE
  • QUEUE Tables
  • Partitioned Primary Index (PPI)
  • SQL for Partitioned Primary Index (PPI)
  • Adding and Dropping Partitions
  • Column Attributes
  • Constraints
  • UNIQUE Constraint
  • CHECK Constraint
  • Referential Integrity (RI) Constraint
  • Defining Constraints at the Column level
  • Defining Constraints at the Table Level
  • Utilizing Default Values for a Table
  • Secondary Indices
  • CREATE TABLE to Copy an existing table
  • Altering a Table
  • Modifying the Primary Index Partitioning
  • Revalidating the Primary Index
  • Dropping a Table
  • Dropping a Table versus Deleting Rows
  • Renaming a Table
  • Creating Secondary via CREATE INDEX
  • Join Index
  • Collecting Statistics
  • Hashing Functions
  • HASHROW
  • HASHBUCKET
  • HASHAMP
  • HASHBAKAMP

Download Curriculum

  • Temporary Tables
  • Temporary Table Choices
  • Derived Tables
  • Derived Tables Using a Non-Recursive WITH
  • Derived Tables Using a Recursive WITH
  • Volatile Temporary Tables
  • Global Temporary Tables
  • GLOBAL Temporary Table Examples
  • General Practices for Temporary use Tables

Download Curriculum

  • Logging Onto Bteq Interactively
  • Logging Onto Bteq In A Script
  • Using Bteq To Submit Queries In Interactive Mode
  • The Brilliant Bteq With By Statement
  • Bteq Can Provide Grand Totals
  • The Four Types Of Bteq Exports
  • A Bteq Export Script
  • A Bteq Export Script In Report Mode
  • Output For Record Mode And Report Mode
  • Using Report Mode To Export A Csv File
  • Importing From A Csv File
  • Two Ways To Run A Bteq Script
  • Exporting Large Files In A Unix Mp-Ras System
  • Bteq Import Script
  • Importing A Comma Separated Csv File
  • Multiple Sessions In Bteq
  • Fast Path Inserts Using Bteq
  • Cool Commands In Bteq – Sidetitles
  • Using Bteq Conditional Logic With Errorcode
  • Bteq Commands
  • Sequence Control Commands
  • Format Control Commands

Download Curriculum

  • Maximum amount of block utilities has changed!
  • Fastload has two phases
  • Acquisition phase 1
  • Fastload application phase 2
  • A sample fastload script
  • Referential integrity and load utility problems
  • Two ways to execute a fastload script
  • Building, executing or scheduling fastload with nexus
  • Building a fastload with nexus smartscript
  • The smartscript fastload builder
  • Executing fastload from the nexus chameleon
  • Output report from fastload
  • Recovering when fastload fails
  • Valid data types used in fastload
  • Fasload commands

Download Curriculum

  • Maximum amount of block utilities has changed!
  • The five phases of multiload
  • A sample multiload script
  • Referential integrity and multiload problems
  • Supported input formats
  • A multiload that inserts and updates using
  • Two different input files
  • A multiload that inserts and updates using
  • Two different input files continued
  • A multiload that upserts
  • A multiload that upserts continued
  • A multiload that deletes (step 1 of 3)
  • A multiload that deletes (step 2 of 3)
  • A multiload that deletes (step 3 of 3)
  • Multiload imports won‘t work with nopi tables
  • Two easy ways to run a multiload
  • Building, executing or scheduling multiload with nexus
  • Building a multiload with nexus smartscript
  • The smartscript multiload builder

Download Curriculum

Teradata Training Completion Certificate

To Obtain Teradata Course Completion Certification,You Have To Fulfill The Following Criteria

  • Complete the Teradata Course Online/Classroom Training
  • You can attend multiple batches of the same trainer & complete the Teradata Course Training
  • Completion of all exercises, assignments & capstone project.
150+

Batches Completed

Industry Oriented Syllabus

Designed By Expert

2000+

Happy Students

Self Assessments

Quizzes, POC

8+

8+ Years Of Experience

Recorded Sessions

1 Year Of Access

Teradata Training Completion Certificate

GET CERTIFIED ON COURSE COMPLETION

Course Benefits​

  • No prerequisite
  • Cloud based cluster available for hands on practice

  • Course designed for non-IT as well as IT professionals

  • Flexible batch switch is available

  • Placement assistance in MNC

  • Classroom & Online Training – Can switch from online training to classroom training with nominal fee

  • Working professional as instructor

  • Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor

  • 100% placement calls guaranteed till you get placed

  • Interview Preparation Support

  • Resume Building & Mock Interview

  • Evaluation after each Topic completion

  • Hands-on Experience with Real-Time Projects

STAY TUNED WITH US

Let's begin a dialogue with our career concealer!

About Course

Training Projects​

FAQ

Yes, you can attend demo session before you enroll either we can provide you the recorded lecture so that you can watch it as per your schedule or you can attend live demo lecture either online or offline

 

Yes, we do provide the placement assistance in which how we work on real time projects will be taught,resume preparation and Job openings will also be provided.More than 80% of candidates have changed their profile by getting either promotion or getting new job offers on good package.

Checkout our Telegram Channel for Placement Assistance (Open in Mobile Browser): https://t.me/technogeekssolutions

 

If you miss classes, you can get recording sessions of the lectures.

Testimonial Review​

CONTACT US TO DISCUSS HOW WE CAN HELP YOU.

Our candidates are working with