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 and link a profile to multiple Teradata users, configure password expiry, account, database, and pool space settings, and apply profile level parameters over user level settings.

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 Teradata fundamentals by using the select statement to display all records or specific columns from a table, and apply the where clause to filter results by criteria.

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.

learn to use the between operator in Teradata to filter numbers, text, and dates by specifying inclusive ranges, with examples for salary, names, and date fields.

Explore how the in operator enables multiple value conditions in SQL queries by matching any of several salaries or names, returning rows that meet at least one value.

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.

Explain the difference between non correlated and correlated subqueries: non correlated subqueries run once and are evaluated independently, while correlated subqueries depend on the outer query and re-execute per row.

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 self join by joining an employee table to itself to map bosses using aliases. See inner self join results, left outer join with nulls, and cross self join counts.

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.