Teradata

TERADATA COURSE CONTENT

Introduction to DBMS and RDBMS

  • File and File system
  • Database Models
  • Hierarchal Model
  • Network Model
  • Relational Model
  • Disadvantages of DBMS
  • Advantages of RDBMS
  • EF Codd Rules and ACID Properties
  • Normalization Methods(1st,2nd ,3rd )
  • Integrity Constraints (P.K, FK, Check, Not null)
  1. Introduction to Teradata
  • What is Teradata?
  • History of Teradata
  • Versions of Teradata
  • Teradata and other RDBMS technologies
  • Advantages of Teradata
  1. Introduction to Data warehousing
  • What is Data warehousing?
  • Definition of Data warehouse
  • Who needs Data warehouse?
  • Advantages of Data warehouse
  • Architecture of Data warehouse
  • Types of Systems(OLTP, OLAP, DSS, ODS)
  1. Logical data warehouse modeling
  • Dimension, Fact, Fact less Fact tables
  • Star Schema Model
  • Snow flake Schema Model
  • Slowly changing dimension (SCD1, SCD2, SCD3)
  • ETL Process diagram
  • Interview Questions on DW
  1. Teradata Architecture and Components
  • Parallel data Extension (PDE)
  • Virtual Processor (V Procs)
  • Parsing Engine (PE), AMP, MPP, Node, Clique, CLI
  • AMP, MPP Architecture, Shared Nothing Architecture
  • Trusted Parallel Application (TPA)
  • Parsing Engine Parts, ByNet
  • Fault tolerance
  1. Teradata Indexes
  • Differences between Primary Key and Primary Indexes
  • Primary Index (UPI,NUPI)
  • Secondary Index (USI, NUSI)
  • Partitioned Primary Index (PPI)
  • Join Index, Hash Index
  • Accessing records through indexes
  • Secondary Index and Full table Scan
  • Full real time scenarios and FAQs
  1. Teradata Data distribution and Access
  • Teradata data distribution Process
  • Primary Key and Primary Indexes
  • Data distribution through Hashing
  • Row Hash, Hasp map and hashing algorithm
  • Hash bucket, DSW(destination selection word)
  1. Data protection and Recovery Methods
  • Locks(Read, Write, Access, Exclusive locks)
  • Fall back Protection levels (AMP, Node, Clique)
  • Journals (Transient, Permanent)
  • Raids( Raid1,Raid5,Raid S)
  1. Introduction to Teradata SQL
  • SQL Fundamentals, Data types
  • Data definition language(DDL)
  • Data manipulation Language(DML)
  • Teradata exclusive Commands(Help, Show)
  • Teradata SQL Assistant
  1. SQL Operators and Functions
  • Arithmetic functions
  • String manipulation functions
  • Caste functions
  • Aggregating functions
  • Set operators and other operators
  • Interview Questions SQL
  1. Teradata joins and join strategies
  • Cross join, Self join, Inner Join
  • Outer join(left, Right, Full outer)
  • Join Strategies
  • Product, Nested, Hash, Merge join strategies
  • Excellent examples and FAQs on Joins
  1. Teradata objects
  • Normal tables (Set, Multi set)
  • Derived tables, Volatile tables
  • Global temporary tables
  • Views, Macros, Stored procedures, Triggers
  1. Teradata database space and Users
  • Defining user and database
  • Teradata database space
  • Permanent space
  • Temporary space
  • Spool space
  1. Performance Tuning Concepts
  • Why we need to Tune the query?
  • What is Tuning?
  • Explain plan
  • Confidence levels
  • Collect statistics
  1. Teradata client tools an utilities
  • Teradata query submitting tolls
  • SQL assistant, BTEQ (basic teradata query)
  • Difference between BTEQ and SQL assistant
  1. Teradata data loading utilities
  • BTEQ, Fast load, Multiload, TPUMP
  • Comparison of all utilities
  • Fast load Phases
  • Multi load Phases
  • Limitations of utilities
  • Creation of error and work tables
  • Advantages of error and work tables
  • Debugging of error tables
  • Sample scripts of al utilities
  1. Teradata unloading utilities
  • BTEQ and Fast export
  • Differences of BTEQ, Fast export, SQL assistant
  • Sample scripts