Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course. This Teradata course will assist them in developing data warehousing applications using Teradata while working on use cases and projects. After completing this Teradata training, participants will be able to build business-led data strategies, architect and implement varied analytic ecosystems, and operate effectively with Teradata. Participants will become familiar with Teradata’s advanced principles during this training. Starting with Teradata’s basic relational ideas, our professional trainers will teach advanced topics such as SQL advanced, DML statements, fallback tables, and database objects. It also includes Teradata utilities – FastExport, TPT, and more to assist their importation and exportation of data.
TERADATA TRAINING
Instructor
admin
- Description
- Curriculum
- FAQ
- Reviews
Prerequisites
- There are no prerequisites to enroll in this course.
- To attend this session, participants should have a basic understanding of SQL and standard relational databases and fundamental UNIX commands.
What will you gain after this course
- Learn how to use logical and conditional operators.
- Learn how to use mainframe and network apps together.
- Recognize the distinction between a primary key and a primary index.
Jobs you can get
with a Teradata Qualification
- File System Software Engineer
- Data Scientist
- DevOps Engineer
- Information Technology Process Lead
- ServiceNow Lead Developer
- Workday Architect
Select your preferred training delivery mode
[sg_popup id=”1145″ event=”click”][/sg_popup]
[sg_popup id=”1145″ event=”click”][/sg_popup]
[sg_popup id=”1145″ event=”click”][/sg_popup]
[sg_popup id=”1145″ event=”click”][/sg_popup]
[sg_popup id=”1145″ event=”click”][/sg_popup]
Teradata Architecture
<ul>
<li> Parsing Engine (PE)</li>
<li> Request and Response Parcel</li>
<li> Access Module Processors (AMPs)</li>
<li> Bynet</li>
<li> Data access Handling</li>
<li> TD Config Utilities</li>
<li> Config and Reconfig</li>
</ul>
<li> Parsing Engine (PE)</li>
<li> Request and Response Parcel</li>
<li> Access Module Processors (AMPs)</li>
<li> Bynet</li>
<li> Data access Handling</li>
<li> TD Config Utilities</li>
<li> Config and Reconfig</li>
</ul>
Teradata Database Space
<ul>
<li> Permanent Space</li>
<li> Spool Space</li>
<li> Temp Space</li>
<li> Indexes</li>
</ul>
<li> Permanent Space</li>
<li> Spool Space</li>
<li> Temp Space</li>
<li> Indexes</li>
</ul>
DBC Dictionary Tables
<ul>
<li> Data dictionary</li>
<li> Parsing Engine</li>
<li> System Views</li>
<li> Database Views</li>
<li> DBC Users View</li>
<li> Indices View</li>
<li> All Temp Tables View</li>
<li> Using DBC AMP Usage</li>
<li> Using DBC Table Size</li>
<li> Logon and Logoff Tracking</li>
</ul>
<li> Data dictionary</li>
<li> Parsing Engine</li>
<li> System Views</li>
<li> Database Views</li>
<li> DBC Users View</li>
<li> Indices View</li>
<li> All Temp Tables View</li>
<li> Using DBC AMP Usage</li>
<li> Using DBC Table Size</li>
<li> Logon and Logoff Tracking</li>
</ul>
Access Rights, Roles, Profiles
<ul>
<li> Access rights (Auto, Implicit, Explicit Rights)</li>
<li> Roles and Profiles</li>
<li> Creating Roles and Profiles</li>
</ul>
<li> Access rights (Auto, Implicit, Explicit Rights)</li>
<li> Roles and Profiles</li>
<li> Creating Roles and Profiles</li>
</ul>
Query Analysis and Tools
<ul>
<li> Database Query Log (DBQL)</li>
<li> DBQL Tables and Views</li>
<li> Access Logging</li>
</ul>
<li> Database Query Log (DBQL)</li>
<li> DBQL Tables and Views</li>
<li> Access Logging</li>
</ul>
System Access Control Level
<ul>
<li> TD Password Encryption</li>
<li> Password Security Features</li>
<li> Host Logon Processing</li>
<li> GRANT/REVOKE LOGON</li>
<li> Session Related Views</li>
<li> DBC.sessionInfo Info View</li>
<li> Data Access Info Views</li>
<li> Access LogRules Views</li>
<li> Access Log Views</li>
</ul>
<li> TD Password Encryption</li>
<li> Password Security Features</li>
<li> Host Logon Processing</li>
<li> GRANT/REVOKE LOGON</li>
<li> Session Related Views</li>
<li> DBC.sessionInfo Info View</li>
<li> Data Access Info Views</li>
<li> Access LogRules Views</li>
<li> Access Log Views</li>
</ul>
TD Manager
<ul>
<li> TD Manager Apps</li>
<li> TD Dashboard</li>
<li> Priority Scheduler Admin</li>
<li> TD Manager Service</li>
<li> Starting TD Manager</li>
</ul>
<li> TD Manager Apps</li>
<li> TD Dashboard</li>
<li> Priority Scheduler Admin</li>
<li> TD Manager Service</li>
<li> Starting TD Manager</li>
</ul>
Monitoring Tools
<ul>
<li> Performance Monitor</li>
<li> PMON Main window</li>
<li> PMON sessions Screen</li>
<li> TD Administrator</li>
<li> TD manager Dynamic Utilization Charting</li>
<li> Locking Logger</li>
</ul>
<li> Performance Monitor</li>
<li> PMON Main window</li>
<li> PMON sessions Screen</li>
<li> TD Administrator</li>
<li> TD manager Dynamic Utilization Charting</li>
<li> Locking Logger</li>
</ul>
Archiving and Restoring Data
<ul>
<li> Archive and Recovery Statements</li>
<li> Recovery vs. FastLoad</li>
<li> Invoking Archive</li>
<li> Restart Log</li>
<li> ANALYZE Statement</li>
<li> Archive</li>
<li> Database DBC Archive</li>
<li> Indexes option</li>
<li> Database DBC Archive</li>
<li> Archive and Recovery (ARC) Examples</li>
<li> Restore</li>
<li> COPY</li>
<li> Copying Tables</li>
<li> BUILD</li>
</ul>
<li> Archive and Recovery Statements</li>
<li> Recovery vs. FastLoad</li>
<li> Invoking Archive</li>
<li> Restart Log</li>
<li> ANALYZE Statement</li>
<li> Archive</li>
<li> Database DBC Archive</li>
<li> Indexes option</li>
<li> Database DBC Archive</li>
<li> Archive and Recovery (ARC) Examples</li>
<li> Restore</li>
<li> COPY</li>
<li> Copying Tables</li>
<li> BUILD</li>
</ul>
Please, login to leave a review
Course details
Duration
Full time, Part-time, Evening and Weekends, Virtual online
Video
London, Flexible online
Popular courses
