Teradata
dbmstutorials.com
Pradeep
Teradata Introduction:
Teradata Architecture
Teradata Primary Index(PI)
Teradata Spaces
Teradata Table Types
Teradata NoPI Tables
Teradata Table Properties
Teradata Datatypes
Teradata Locks
Teradata Join Strategies
Teradata Procedures
Teradata Macros
Teradata Period Datatype
Teradata Secure Transactions
Teradata Terminal Commands
Teradata System Table Queries
Teradata System Table Queries Part2
Teradata Functions:
Teradata String Functions Part 1
Teradata String Functions Part 2
Teradata Regexp Functions
Teradata Numeric Functions
Number Formatting
Teradata Date Functions
Teradata Calendar Functions
Teradata Analytical Functions
Teradata Analytical Functions Part 2
Teradata Misc. Functions
Transpose Columns to Rows
Transpose Rows to Columns
Convert String to Table
Convert String to Columns
Convert String For In-Clause
First & Last Days
Multi Column Split to Rows
Teradata Datetime Operation:
Group Consecutive Dates
Merge Rows on Date / Timestamp
Breaking Timestamp Range
Epoch Time To Timestamp
Subtract Timestamps
Date/Timestamp Formatting
String to Date/Timestamp
Hour to Hour Range
Timestamp(6) To Timestamp(0)
Teradata Indexes & Performance:
Teradata Collect Statistics
Teradata Partitioned PI
Teradata Secondary Index
Teradata Join Index
Teradata Hash Index
Teradata Compression(MVC)
Hash Index Vs Join Index
Teradata Random:
Group By Vs Distinct
Left Outer Vs Right Outer Join
Count(*) Vs Count(1)
Cumulative Distinct Count
Querying Byte Column
Implicit Datatype Conversion
Find Prime Numbers
AlphaNumeric Data Operation
Run Commands as Daemon
Teradata DMLs & DDLs:
Removing Duplicates
Teradata Upsert / Merge
Update Using Other Table
Delete Using Other Table
Alter tables
Ansi Mode vs Teradata Mode
Teradata Secure Transactions
Duplicates in SET Table
Teradata Extra:
Teradata 15 New Features
Teradata 16 New Features
Teradata Subqueries
Dynamic SQL Statements
Teradata SAMPLE Clause
Teradata TOP n Operator
Teradata SET Operators
Recursive Queries
Teradata Setup on Mac
Teradata User Creation
Surrogate key
Identity Column
Referential Integrity
Teradata Load/Unload Utilities:
Teradata TPT Introduction
Teradata TPT Execute & Debug
Teradata TPT Export
Teradata TPT Export-Template
Teradata TPT Load
Teradata TPT Load-Template
Teradata TPT Stream
Teradata TPT Update Operator
Teradata TPT Inserter Operator
Teradata TPT Selector Operator
Teradata TPT DDL Operator
Teradata TPT OS Operator
Teradata to Teradata Load