mobileNavlogo
headerlogo

Blog

Teradata Administrator Tool

15 October, 2020

Related Blogs

Navigation

a) Start run

b) Start programs Teradata administrator Select TD Admin2click ok

i)Database creation:- click2yellow box

ii)Creating user click

iii)privileges

Teradata Administrator

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 a set of other languages for its operations

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore 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 a 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 require 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 the 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..,

Teradata Interview Questions

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 allows 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

Data block size

For In-depth knowledge on Teradata click on:

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .