Teradata development Online Training
Pin It

Teradata development Online Training:

Overview:

teradata works Teradata development Online Training

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)