Teradata SQL

Catalog Home Databases, Business Intelligence & Data Science Teradata
Your Training Location:  

Teradata SQL

  Add Course To Watch List
  View Full Course Outline
  Request A Public Course
         In Your Area

  Request A Quote For A
        Private Class

Delivery Options & Status:
Instructor Led
Loading Course Dates...
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
ViewHide Additional Dates

In this course, students will learn SQL starting at the most basic level and going to the most advanced level with many examples.

There are no prerequisites for this course.

3 Days/Lecture & Lab

This course is designed for anyone who has a desire to learn Teradata SQL from beginners to an advanced audience.

  • 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
  • Top SQL Commands Cheat Sheet

< >

Copyright © 2021 ProTech. All Rights Reserved.

Sign In Create Account


Social Media