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 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
For Indepth knowledge on Teradata click on:
0 Responses on Teradata Administrator Tool"