• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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:

Summary
Review Date
Reviewed Item
Teradata Administrator Tool
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Teradata Administrator Tool"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.