| |
Topic Outline |
| • |
Relational Database Concepts |
| • |
Introduction to Data Warehouses |
| • |
SQL Syntax, Keywords, Datatypes and Value Expressions |
| • |
Teradata Architecture and Performance Considerations |
| • |
Create, Alter, and Drop Tables and Indexes |
| • |
Insert, Update, and Delete Tables |
| • |
Use of SELECT, FROM, WHERE, HELP, and SHOW |
| • |
VIEW, Subqueries, Aggregations, JOIN, String and Index, INTERSECT, MINUS, and UNION |
| • |
ITEQ and BTEQ |
| • |
Reporting Capabilities |
| • |
Date Calculations |
|
|
Description
This course combines lecture with hands-on exercises to teach the use of SQL to access Teradata databases.
Audience
Users and programmers who process Teradata relational databases using SQL.
Prerequisite
None.
Objectives
Students will be able to:
- understand relational databases
- code SQL calls to create, update, and manipulate relational databases on a Teradata platform
|
