Course Details

Previous Page


Teradata SQL: DDL, DML, and SQL Optimization


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



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