Teradata is a relational database management system (RDBMS) that is capable of supporting many concurrent users from various client platforms. Teradata Database can scale from 100 gigabytes to over 100+ petabytes of data on a single system without losing any performance .This is called Scalability. Provides a parallel-aware Optimizer that makes query tuning unnecessary to get a query to run. Automatic and even data distribution eliminates complex indexing schemes or time-consuming reorganizations. Teradata Database can handle the most concurrent users, who are often running multiple, complex queries. Designed and built with parallelism. Supports ad-hoc queries using SQL. Single point of control for the DBA (Teradata Manager). Unconditional parallelism (parallel architecture). Teradata provides the lowest total cost (TCO) of ownership. High availability of data because there is no single point of failure – fault tolerance is built-in to the system. Teradata Database can be used as Enterprise data warehousing, Active data warehousing, Customer relationship management , Internet and E¬Business and Data marts.
Learning outcomes of this training:
- Real time project application development.
- Hands on practice data modeling with star schema (link table) and snowflake schema.
- Script level functions and chart level functions knowledge.
- Design techniques and shortcuts about the less time.
- Publishing the document in server and access over web.
This course is recommended for:
- Power end-users
Basic sql knowledge