Teradata SQL

Teradata SQL

 

Bascom Bridge’s Teradata SQL training course teaches attendees how to write queries to efficiently process and filter massive amounts of data contained in Teradata data warehouses.

 

TERADATA SQL TRAINING OBJECTIVES

All students will learn:

  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs. Group By
  • Aggregation Function
  • Join Functions
  • Date Functions
  • OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Strings
  • Interrogating the Data
  • View Functions
  • Set Operators
  • Data Manipulation Language (DML)
  • Statistical Aggregate Functions

TERADATA SQL TRAINING PREREQUISITES

No prior experience is required.

TERADATA SQL TRAINING MATERIALS

All Teradata training students receive comprehensive courseware.

SOFTWARE NEEDED FOR EACH PC:

We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide.  Please ask us for details.

For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

TERADATA SQL TRAINING OUTLINE

  • Introduction
  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs. Group By
  • The TOP Command
  • Review
  • HELP and SHOW
  • Aggregation Function
  • Join Functions
  • Date Functions
  • Format Functions
  • OLAP Functions
  • The Quantile Function
  • Temporary Tables
  • Sub-query Functions
  • Substrings and Positioning Functions
  • Interrogating the Data
  • View Functions
  • Macro Functions
  • Set Operators Functions
  • Creating Tables, Secondary Indexes, and Join Indexes
  • Data Manipulation Language (DML)
  • Stored Procedure Functions
  • Trigger Functions
  • Math Functions
  • Sample
  • Statistical Aggregate Functions
  • Explain
  • Collect Statistics
  • Hashing Functions
  • BTEQ – Batch Teradata Query
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


Teradata SQL

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : TER-120
  •  Theory : 50%
  •  Lab : 50%
  • Duration : 18 hours
Scroll Up
Skip to toolbar