Teradata development Online Training:
Overview:
Teradata development
Concepts:
TERADATA R13
What is Teradata why for it is what for it is
1.What is Teradata?
2.Teradatav12 &versions
3.Teradata History
4.Teradata users scalability
5.Teradata &other RDBMS
6.Teradata warehouse
7.Teradata in the Enterprise
Teradata architecture & it’s components
1.Node Architecture(Shared Architecture)
2.SMP Architecture
3.MPP Architecture
4.Parsing engine(PE) Architecture
5.AMP Architecture &uses
6.Bynet Benefits &types
7.Parallel data extension(PDE)
8.Teradata directory program(TDP)
9.Call level interface(CLI)
10.Trusted parallel application(TPA)
11.Virtual processors
12.Bynet 0 &Bynet 1
13.Parallism Architecture
14.Recovery &protection of Data
15.What is fall back &where it used
16.Why for fall back
17.What is Clique
18.AMP Clustering
19.Locks & types for simultaneous Access
20.Why for locks &how to release
21.RAID 1 &RAID 5
22.Journals &types
23.Virtual Disk Array
24.How & where is used journals
25.Q & A about data recovery
26.Teradata indexes
27.Types of indexes in Teradata
28.Hash index
29.Join index
30.Primary index(unique, non- unique)
31.Secondary index(unique, non- unique)
32.Skewness
33.Keys & indexes (How & why these used)
34.How to storage & retrieval of data
35. Hash algorithm
36. Row hash
37.Hash map
38.Hash bucket
39.Receiving VDisc
40.Teradata SQL Queryman
41.SQL fundamentals
42.Data types and literals
43.DDL Statements
44.DML Statements
45.Teradata naming conversing
46.Teradata join strategies & unions
47.hash join
48.merge join
49.nested join
50.product join
51.inner join
52.left & right outer join
53.full outer join
54.Teradata basic commands
55.Help
56.Show
57.Explain
58.Collect statistics
59.Teradata objects
60.Types of tables
61.Set tables
62.Multi tables
63.Volatile tables
64.Global temporary tables
65.Derived tables
66.Views
67.Macros
68.Stored procedures
69.Teradata memory spaces
70.Permanent spaces
71.Temporary spaces
72.Spool spaces
73.Users spaces & PWD
Teradata performance tuning on SQL Assistance
1.Explain usage
2.Collecting statistics
3.SQL tuning
4.Various SQL statements
5.Real time Issues & resolving
Teradata Utilities & Tools (Import & Export)
1.Teradata BTeq scripts
2.Overview of BTeq
3.Looping stages
4.Batches scripts
5.Import &export scripts with Examples
Error handling
Real time scripts
1.Teradata FastLoad
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
1.Teradata MultiLoad
Overview of Multi load
Types of phases in MultiLoad
Advantages & its process
Limitations of MultiLoad
Uses various types of operations
Work on Multi tables
Real time scripts
Sample scripts
1.Teradata Tpump
Overview of Tpump
Limitations of Tpump
Work on Multi tables
Real time scripts
Sample scripts
1.Teradata Fast Export
How to export the data
Passing parameters
Work on Multi tables
Real time scripts
Sample scripts
1.Teradata SQL Assistant(Queryman)