Teradata SQL

Catalog Home Databases, Business Intelligence & Data Science Teradata

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.

5 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 © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media