Teradata Fundamentals - Comprehensive SQL course on Teradata

Open the Teradata administrator, establish a connection, and create a work database for the dbc user with allocated space and backup snapshots; then create tables in the worker database.

Create a new Teradata user in the administrator tool, set a password and space types (permanent, pool, temporary), configure profile and default database, then grant or revoke object rights.

Create tables with the create command, define columns and a primary index in Teradata, then insert values, delete rows, and drop tables, noting unique versus non unique primary indexes.

Explore alter and update commands in Teradata to add, drop, modify, or rename columns, adjust data types, and increment salaries. See practical examples demonstrating table changes and salary updates.

Learn how to use the concatenate function in Teradata to combine strings, such as first name and last name, and build phrases like 'my name is' with aliases.

Teradata fundamentals show how the upper and lower functions convert strings to uppercase or lowercase, with a sample query applying upper and lower to a table column.

Explore arithmetic operators in Teradata SQL, including addition, subtraction, multiplication, and division, with real-world salary examples and basic comparison and logical operator usage.

Explore the is null operator in Teradata, checking for null values (represented by a question mark) in a salary column to identify salary is null and salary is not null.

Explore how aggregate functions like count, sum, average, maximum, and minimum compute a single value from grouped data, ignoring nulls, using the group by clause to summarize salary by designation.

Practice aggregate functions with SQL queries to compute max, min, avg, sum, and count across departments, including department seven and IT, using group by.

Explore how to use subqueries with insert, update, and delete commands to manipulate employee data: filter by salary, update names, delete records, and insert results into another table.

Explore inner joins, outer joins (left, right, full), cartesian product, and self joins to combine records across tables, using on conditions and handling nulls for unmatched rows.

Explore the row_number analytic function in Teradata, showing how order by and optional partition by divide data into groups, assign sequential numbers, and support filtering with qualify.

learn how rank and dense_rank work in teradata, see how rank skips ranks on duplicates while dense_rank preserves consecutive rankings using a salary-based example ordered by salary.

Teradata fundamentals explain the difference between where, having, and qualify, showing how to use having with aggregate functions to filter groups, and how qualify filters analytic results.

Explore cumulative sales, moving average, and moving count calculations using window functions in Teradata. Compute per store and per month with unbounded preceding and partition by store number and month.