Teradata Administrator Tool

Navigation

a) Start run

b) Start programs Teradata administrator Select TD Admin2click ok

i)Database creation:- click2yellow box

ii)Creating user click

iii)privileges

Screenshot_34

Teradata Sql

Sql2 IBM

PL/Sql2 ORACLE

T-Sql2SQL Server

Tera data sql 2Tera data

Sql is 4th 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

Screenshot_35

For Indepth knowledge on Teradata click on: