Getting Started with Teradata

Explore Teradata's massively parallel architecture with nodes, parsing engine, and amps. See how queries are parsed, privilege checks pass, and execution plans reach amps across storage and retrieval architectures.

Learn relational concepts in an rdbms, including sql interactions with tables, rows, and columns, and how primary and foreign keys define table relationships.

Explore Teradata datatypes, including integers, 64-bit integers, numeric, decimal, float, real, and double precision. Also cover character, date, time, and timestamp formats.

Explore Teradata table types: permanent tables that store data, and temporary types such as global temporary tables for session-scoped data, plus set versus multiset handling of duplicates.

Learn to create Teradata tables with proper table options, definitions, and indexes, including primary indexes and fallbacks, by building a sample database named company and an employee table.

Learn how to alter a Teradata table by adding and dropping columns, such as replacing date of birth with birth date, and verify changes.

Learn how to use the drop table command in Teradata to delete a table, see the syntax, and understand errors when the table does not exist.

Insert records into Dagget by listing columns and values. Insert from another table using a select statement; follow rules that column counts match values and non-null columns have values.

Learn how to update records in Teradata by running update statements to modify values in a table. Use where conditions to limit affected rows and verify changes with select queries.

Learn how to delete records in Teradata with the delete from statement, and verify by selecting the affected employee 2101 from company.employees.

Explore the basic select statement to fetch specific columns like first name and last name from a table, and use select * to retrieve all columns.

Learn how the where clause filters records in a select statement by applying conditions to return only matching rows, illustrated with an employee number example.

Learn the order by clause in Teradata, sorting results in ascending or descending order and using examples that order by a column such as first name or numeric values.

Learn how the group by clause works with a select statement to group similar records, using department number as the grouping key.

Explore how logical and conditional operators function in Teradata, including between, in, not in, and is null or is not, with practical range and set examples.

Explore set operators with union to combine results from multiple select statements in Teradata, ensuring compatible columns and deduplicated rows, illustrated by a two-table example.

Combine values from multiple tables using union all, preserving duplicates, and follow the union-like syntax to switch from union to union all in Teradata.

Explore how intersect combines results from two select statements to return rows that exist in both tables, with practical examples in Teradata.

Explore the minus and except operators in Teradata, showcasing syntax with multiple selects and a hands-on query that selects the employee number to illustrate differences.

Explore string manipulation in Teradata by using functions like concatenation, substring, and position to extract, join, and locate characters, while applying upper and lower transformations and removing blanks.

Explore Teradata date and time functions to extract year, month, day, and time from current date or timestamp, and perform interval arithmetic by adding days, months, and more.

Explore built in functions in Teradata, including date and time selections, current time, and database login, through hands-on demonstrations of selecting values and querying the system.

Review aggregate functions in Teradata and show how to compute count, max, min, average, and sum on salary data with example queries.

Explore case expressions, coalesce, and nullif in Teradata, with practical examples showing first non-null value selection and conditional results in SQL queries.

Discover how primary indexes specify data location and enable fast access in Teradata, with unique primary index enforcing uniqueness and non-unique primary index allowing duplicates, including syntax notes.

Explore how to join data across tables in Teradata using inner, left outer, right outer, and full outer joins, plus cross joins, with practical examples on employee and salary tables.

Explain how subqueries retrieve data from one table using values from another. Show how an inner select computes max net pay and lets the outer query identify the top earner.

Explain table types in Teradata, including session-scoped and intermediate result tables, created via gui, with global temperature tables whose definitions live in the data dictionary and are reusable in queries.

Describe permanent space, spool space, and temp space, including how they define maximum allocations, system storage for intermediate results, and temporary tables in Teradata.

explore secondary indexes in Teradata, their differences from primary indexes, optional nature, storage and maintenance implications, and how to create unique and non-unique secondary indexes with their syntax.

Explore how Teradata's optimizer uses table statistics to shape execution plans, covering information and demographics, and three collection approaches including random and sampling, with syntax and viewing results.

Explore how Teradata compression reduces storage and cost using multi-value compression and dictionary compression, with examples of creating and modifying tables and applying compression.

Explain in Teradata demonstrates how the optimizer uses unique primary and unique secondary indices to access data, shown through explain plans for select statements.

Explore hashing in Teradata by deriving a hash from the primary index, mapping to a hash map and bucket, and assigning 32-bit unique IDs from row hashes.

Learn how join indexes precompute join results to speed queries by storing columns from multiple tables. Explore single-table and aggregate join indexes and how the parsing engine may use them.

Learn how to create, modify, and drop Teradata views to simplify queries, enforce column-level security, and reference stored definitions without duplicating data.

The video explains creating and executing macros in Teradata, detailing macro statements, parameterized macros, and how create macro and select statements are used within macros.

Explore stored procedures in Teradata, defined as a set of SQL and procedural statements, created with create procedure, parameter handling, and called with execute, illustrated by inserting into a table.

Explore join strategies in Teradata, including primary-key based joins, distribution effects, and redistribution when joining on key columns, with examples using employee numbers and department tables.

This lecture explains the partitioned primary index, an indexing mechanism that enhances insert performance by partitioning data and ordering by partition number, reducing scans by avoiding secondary indexes.

Explore olap functions in Teradata, including partition by, order by, and window frames such as rows between unbounded preceding and following, with rank and cumulative sum examples.

Learn how Teradata protects data from transaction failures by maintaining a journal with before images, creating a second copy on separate disks, and using fallbacks for continuity.

Master Teradata user management by creating users with passwords, assigning accounts, and granting or revoking privileges to control access and security.

Explore performance tuning in Teradata by reading the query plan to understand join strategies, spool file sizes, statistics, and how the optimizer uses primary keys and secondary indexes.

Explore fastload in Teradata, loading records from a text file into an employee table using a two-phase process, including script setup, table definition, and post-load verification.