Teradata SQL: DDL, DML, and SQL Optimization

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
Teradata supports the use of SQLs data definition language to create and manage objects within the database. It also supports the use of SQLs data manipulation language to query and perform operations on the data. Teradata supports the use of temporal tables as well and contains temporal forms of DDL and DML for use within a temporal database. This course will demonstrate and describe performing DDL and DML operations within a database and temporal database.

Target Audience
Individuals looking to learn SQL basics to query Teradata databases

Prerequisites
None

Expected Duration (hours)
2.8

Lesson Objectives

Teradata SQL: DDL, DML, and SQL Optimization

start the course

create and alter a database in Teradata

create and manage database users for Teradata

create a table in Teradata using the CREATE TABLE statement

create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options

alter, manage, and drop tables in Teradata

create and alter indexes in Teradata

create and alter views in Teradata

create recursive views in Teradata

create macros in Teradata

create triggers in Teradata

create procedures in Teradata

alter, rename, and drop functions and stored procedures in Teradata

use the QUALIFY clause in Teradata

use NORMALIZED in a SELECT statement in Teradata

use the EXPAND ON clause in a SELECT statement in Teradata

use the INSERT statement to insert data into Teradata

use the UPDATE statement to update data in Teradata

use the DELETE statement to remove data from Teradata

use MERGE to merge data into a table in Teradata

identify how to optimize query design in Teradata

identify how to improve the performance of merge joins in Teradata

describe the basic temporal concepts in Teradata

create temporal tables in Teradata

load data into temporal tables in Teradata

perform DDL operations using their temporal form in Teradata

perform DML operations using their temporal form in Teradata

perform DDL and DML operations on regular and temporal tables in Teradata

Course Number:
df_tesq_a03_it_enus

Expertise Level
Beginner