Navigation

a) Start run

b) Start programs Teradata administrator Select TD Adminclick ok

i)Database creation:- clickyellow box

ii)Creating user click

iii)privileges

Teradata Sql

Sql IBM

PL/Sql ORACLE

T-SqlSQL Server

Tera data sql Tera data

Sql is 4^th Generation language

Fully based on set theory

If contains set of other languages for its operations

Aspired to become a Teradata Developer? Explore the post to discover the know-hows on
 Teradata Training.

a) DDL – Data definition language

USE-For creating, ALTERING and REMOVING Objects

Commands-Creating, ALTERING, DROP

Note- There is no TRUNCATE COMMAND[delete entire at time in oracle]

b) DML-Date Manipulation language

Use- For Manipulation objects data[By selecting, inserting, deleting etc]

COMMAND- SELECT, INSERT,UPDATE, DELETE,MERGE

c) DCL-Date Control language

Use- For providing and revoking privileges for objects

COMMAND- GRANT,REVOKE,GIVE

SPL- Stored procedure language

Use: Creating and calling a stored procedure as procedures requires concept c (or) c++ compilers we call this language as SPL

Teradata Extensions to sql

Help

Show

Explain

Collect statistics

Show and Help commands-

Show commands– It shows the DDL of the object

Syntax- Show object<object name>

Example- Show table<table name>

Show view<view name >

Show macro< macro name > etc…

Help command- It describes the objects by getting from data dictionary

Syntax:- Help object<object name>

Help table< table name>

Help view < view name>

Help macro < macro name>

Help Procedure < Procedure name>

Help session To see session information etc..,

Learn more about Teradata Interview Questions in this blog post.

Teradata objects-

a) Table

b)Views

c)Macros

d)Triggers

e)Cursory

f)Procedure[Normal procedure(or) embedded (or) extended procedure]

CREATING Table

Create [SET/MULTISET][GLOBABL TEMPORARY/VOLATILE]

TABLE< TABLE  NAME>

<DATA OPTIONS>

<COLUMN DEFINITIONS>

<CONSTRAINTS>

<INDEXES>

SET TABLE- It does not allow complete row duplicate

FREE SPACE- The percentage of free memory Assigned from the cylindrical memory

MULTISET- It allow complete row duplicate

DATA BLOCK SIZE-The maximum data block size specified to the table at the time input, output of file system

DATA OPTIONS- FALL BACK, NO FALL BACK BEFORE JOURNAL, NO BEFORE JOURNAL AFTER JOURNAL, NO AFTER JOURNAL

For Indepth knowledge on Teradata click on:

• BTEQ Features in Teradata
• Secondary Index in TeraData
• Memory Management in TeraData
• Types of OLAP’s in TeraData
• TPUMP Structure and Process In TeraData