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.
Learning Objectives
Data Definition Language
- 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
Data Manipulation Language
- 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
SQL Optimization
- identify how to optimize query design in Teradata
- identify how to improve the performance of merge joins in Teradata
Temporal Concepts
- 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
Practice: Use DDL, DML, and Temporal Tables
- perform DDL and DML operations on regular and temporal tables in Teradata
Framework Connections
Specialty Areas
- Data Administration
- Systems Administration
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.