Learn Teradata from Scratch- A Basic to Advanced Overview

Explore Teradata data types, including byte int, small int, integer, big int, decimal, numeric, float, char, varchar, date, time, and timestamp. Understand ranges and formats.

Learn about Teradata tables, including permanent, volatile, global temporary, and derived tables, and how set and multiset classifications handle duplicates.

Learn the create table command in Teradata, covering table options such as journal and fallback, column definitions, and index options including primary index, secondary index, and partition.

Learn how to alter a table in Teradata by adding or dropping columns and modifying attributes, using the alter table syntax and validating changes with show table.

Master dropping a table in teradata with the drop table command, including syntax, executing it, and verifying deletion with show table and the table does not exist error.

Learn to insert records in Teradata using insert into statements with column lists and values, and insert from another table via insert select, demonstrated on the company.employee table.

Learn how to update records in Teradata using the update statement to set column values with where filters, as demonstrated on employee data and verified with a select.

Learn how to delete records in Teradata using the delete from statement, review its syntax, and follow an example that removes employee 101 from the employee table.

Filter records in Teradata using the where clause with a select statement, applying a condition to return only matching rows, as shown with employee number 101.

Sort query results in Teradata with the order by clause, arranging records in ascending or descending order by columns such as first name or employee number.

Master the Teradata group by clause in select statements to group similar records into categories. See how department numbers are grouped and counts totaled per group with practical syntax examples.

Explore Teradata's logical and conditional operators, including between, in, not in, is null, is not null, and, or, not, with hands-on examples like employee number between 101 and 103.

Explore Teradata set operators and the union concept, learning how to combine results from multiple select statements, ensure column count and data type compatibility, and ignore duplicates.

Explore the union all operator in Teradata, which combines results from multiple tables and includes duplicate rows, with a hands-on example using employee and salary tables.

Master the intersect command in Teradata to return rows common to two select statements, using syntax with the first and second tables, as shown in an employee vs salary example.

Explore Teradata built-in functions that extend SQL, including date, current date, time, current time, current timestamp, and database, with hands-on demonstrations.

Explore aggregate functions in Teradata, including count, sum, max, min, and avg, and learn how to apply them in select queries on the salary table.

Explore case expressions in Teradata, using when, then, and else to map department numbers. Learn coalesce and null if, returning the first non-null value or null if equal.

Understand how primary indexes in Teradata determine data residency and which amp handles each row, defined at table creation, with unique primary index and non-unique primary index options.

Explore joins in Teradata, including inner, outer (left, right, full, self), cross, and Cartesian production, with syntax and examples on employee and salary tables.

Learn Teradata table types by exploring derived tables, volatile tables, and global temporary tables, including their creation, usage within queries, and session-level or data dictionary behavior.

Learn how the Teradata optimizer uses table statistics to craft query execution plans, and how environment information and data demographics guide statistics collection and viewing.

Discover how Teradata compression reduces storage and input/output by using multi-value compression and dictionary-based techniques, with block-level options, value limits, and table-level applicability.

Explore the explain command in teradata, which reveals the parsing engine's execution plan in english and shows full table scan, unique primary index, and unique secondary index through hands-on examples.

Teradata uses a hashing algorithm to map a row to an amp via primary index, producing a 32-bit row hash; a hash map entry and uniqueness id form row id.

Explore Teradata join indexes that prejoin columns from multiple tables to speed frequent joins, including single, multi, and aggregated types, with create join index syntax and engine-driven access.

Explore Teradata stored procedures, covering definition, data dictionary parameters, creation and execution, and benefits like reduced network load, better security, and easier maintenance, with a salary insertion example.

Explore Teradata join strategies, including merge join, nested join, and product join, and learn redistribution and primary index concepts with practical employee, department, and salary table examples.

Explore olap functions in Teradata, which return individual rows, unlike aggregates; use over with partition by and order by to compute rank and running totals on net pay and salary.

Protect data with Teradata's transient journal, storing before images until transactions succeed or roll back. Guard against failures with fallback amp and down amp recovery journal.

Learn Teradata user management by creating users with permanent space and password, assigning accounts, and using grant and revoke commands for privileges such as select, insert, update, and references.

Master teradata tuning by using explain plans to inspect the optimizer execution, assess join strategy, spool usage, and redistribution, and optimize statistics, data types, and indexing to reduce pool space.

Explore Teradata fast load to quickly load data into empty tables using a two-phase process with amps redistributing and sorting records, under constraints like no secondary index or foreign keys.