Certificate Authentication

Teradata Certificate for Jarosław Zwierzchowski

Add to LinkedIn

Certificate ID: 
586179
Authentication Code: 
4942c
Certified Person Name: 
Jarosław Zwierzchowski
Trainer Name: 
Juan Pablo Maldonado Lopez
Duration Days: 
3
Duration Hours: 
21
Course Name: 
Teradata
Course Date: 
2019-06-26 09:00 to 2019-06-28 16:00
Venue: 
Kraków
Course Outline: 
  1. Teradata Architecture introduction (mpp, amp, bynet, skewness, space/memory )
  2. Teradata physical design:
    1. table types (permanent, volatile, global temporary, set/multiset, columnar,)  
    2. index types (Primary, Secondary, Join, Uniqueness, partitioned, time series)
  3. useful system tables/views
  4. analysis of query plans, SQL tuning, statistics
  5. Teradata load and export utilities – comparison
  6. stored procedures/macros.
  7. regular expressions
  8. correlated subqueries vs joins

    Also additional (depends on time)

  9. user defined types
  10. compression
  11. performance monitoring
  12. recursive query performance
  13. comparison of Teradata with other solutions (for example: Netezza, Exadata, Vertica)
  14. session/logging, etc. statements
  15. permission management
  16. Teradata row and column level security